sfrechette

== Astérix - Les personnages
=== Asterix the Gaul - Characters

by [@sfrechette] (https://twitter.com/sfrechette)

This is a sample subset for you to explore. +
For the complete model (Cypher Query) and Graph Database with all characters, nodes and relationships: +
https://github.com/neo4j-contrib/graphgist/wiki/Asterix-Dataset

Source data: http://www.asterix.com/asterix-de-a-a-z/les-personnages/ +

sfrechette

set nocount on
declare @TableViewName	nvarchar(128),
        @Columns        nvarchar(max),
        @Columns_       nvarchar(max),
        @ColumnName     nvarchar(max),
        @SQLColumns     nvarchar(max),
        @SQLQuery       nvarchar(max),
        @SQLString      nvarchar(max),
        @LastRecord     int,
        @StartPos       int,

sfrechette

create table dbo.DimDate 
(
    DateKey                 int not null,
    FullDate                date not null,
    DayNumberOfWeek         tinyint not null,
    DayNameOfWeek           nvarchar(10) not null,
    WeekDayType             nvarchar(7) not null,
    DayNumberOfMonth        tinyint not null,
    DayNumberOfYear         smallint not null,
    WeekNumberOfYear        tinyint not null,

sfrechette

WITH 
  L0 AS (SELECT 0 AS C UNION ALL SELECT 0),
  L1 AS (SELECT 0 AS C FROM L0 AS A
    CROSS JOIN L0 AS B),
  L2 AS (SELECT 0 AS C FROM L1 AS A
    CROSS JOIN L1 AS B),
  L3 AS (SELECT 0 AS C FROM L2 AS A
    CROSS JOIN L2 AS B),
  Nums AS (SELECT TOP(49) ROW_NUMBER()
     OVER(ORDER BY (SELECT 0)) AS n

sfrechette

//How to get the IP address used by a Parallels VM from the host?

prlctl exec "VM Name goes here" ipconfig | grep "IPv4" | grep -o '\d\{1,3\}\.\d\{1,3\}\.\d\{1,3\}\.\d\{1,3\}'

prlctl exec "VM Name goes here" ifconfig eth1 | grep "inet " | grep -o 'addr:\d\{1,3\}\.\d\{1,3\}\.\d\{1,3\}\.\d\{1,3\}' | grep -o '\d\{1,3\}\.\d\{1,3\}\.\d\{1,3\}\.\d\{1,3\}'

sfrechette

while true; do kill $(ps -ef | grep -i SyncServices | grep -v grep | awk '{print $2} '); done

sfrechette

sfrechette

library(weatherData)
library(dplyr)
library(ggplot2)
library(gridExtra)

# Ottawa International Airport (YOW) weather data
getWeatherForYear = function(year) {
    getWeatherForDate('YOW', 
                      start_date= paste(sep='', year, '-01-01'),
                      end_date = paste(sep='', year, '-12-31'),

sfrechette

# Add following line to neo4j-wrapper.conf file, section JVM Parameters
wrapper.java.additional=-Dfile.encoding=UTF-8

sfrechette

// Model - Meetup
create (n1:Member {id:1, name: 'Daniel'})
create (n2:Member {id:2, name: 'Stephane'})
create (n3:Member {id:3, name: 'John'})
create (n4:Member {id:4, name: 'Randy'})
create (n5:Meetup {id:5, name: 'Ottawa SQL Server User Group'})
create (n6:Meetup {id:6, name: 'Ottawa JavaScript'})
create (n7:Meetup {id:7, name: 'Ottawa Visio User Group'})
create (n8:Meetup {id:8, name: 'Ottawa Tableau User Group'})
create (n9:Meetup {id:9, name: 'Dirty Dancing Ottawa'})