dsisnero

How to create a GraphGist

You create a GraphGist by creating a GitHub Gist in AsciiDoc and enter the URL to it in the form on this page. Alternatively, you can put an AsciiDoc document in Dropbox and enter the public URL in the form.

This GraphGist shows the basics of using AsciiDoc syntax and a few additions for GraphGists. The additions are entered as comments on their own line. They are: //console for a query console; //hide, //setup and //output to configure a query; //graph and //table to visualize queries and show a result table.

Click on the Page Source button in the menu to see the source for this GraphGist.

dsisnero

Network Management with Neo4j

Neo4j is often used to model complex graphs in Network Management scenarios. This is a pseudo setup for a network management graph and some sample queries.

CREATE
	(ogd:Repeater {name:"Ogden", locid : "ogd", factype: "rcl"}),
	(qtj:Repeater {name:"Brigham City",locid: "qtj",factype: "rcl"}),
	(qli:Repeater {name:"Promotory",locid: "qli",factype: "rcl"}),

dsisnero

= IKEA GraphGist =

This gist is to complement the http://blog.bruggen.com/2013/09/ikea-wardrobes-and-graphs-perfect-fit.html[more elaborate blogpost] that I wrote about using http://neo4j.org[neo4j] to model the partlist and the assembly process of two IKEA wardrobes.

First, we will create a part of the graph using this model:

image::https://lh4.googleusercontent.com/7XxUuCjnFtDhO-JAI5Ia6tcYZkQoMfcv_1pNE0mTA2cx76vIySrBU0z0tnykAPvqsMrZZD-cca3Q7ca-ERI0f5sDsGAUCEJTIx7wt15mxKhFEXeYFrZD_vEGJQ[]

[source,cypher]
----

dsisnero

Why?

There is a long standing issue in Ruby where the net/http library by default does not check the validity of an SSL certificate during a TLS handshake. Rather than deal with the underlying problem (a missing certificate authority, a self-signed certificate, etc.) one tends to see bad hacks everywhere. This can lead to problems down the road.

From what I can see the OpenSSL library that Rails Installer delivers has no certificate authorities defined. So, let's go fetch some from the curl website. And since this is for ruby, why don't we download and install the file with a ruby script?

Installation

The Ruby Way! (Fun)

dsisnero

2.1.2 :004 > pp Google::Contacts.new(client).contacts

[{:emails=>{:other=>{:address=>"fake@gmail.com", :primary=>true}},
  :phone_numbers=>
   {:main=>"(555) 123-1234", :home=>"123-123-1234", :mobile=>"555-555-5555"},
  :handles=>
   {:home=>{:address=>"something", :protocol=>"AIM"},
    :other=>{:address=>"something-else", :protocol=>"AIM"}},
  :nickname=>nil,
  :websites=>[],

dsisnero

require 'rake/clean'
require 'rubygems/package_task'

$:.unshift 'lib'
require 'pry/version'

CLOBBER.include('**/*~', '**/*#*', '**/*.log')
CLEAN.include('**/*#*', '**/*#*.*', '**/*_flymake*.*', '**/*_flymake', '**/*.rbc', '**/.#*.*')

desc "Set up and run tests"

dsisnero

Open question for the Neo4j.rb community:

ActiveNode models allow for query chaining like so:

object.foo.bar.baz

This is a powerful way to traverse entities which builds Cypher queries under the covers. It is also currently possible to name your variables for later use like so:

object.foo(:f).bar.baz(:b).pluck(:f, 'collect(b)')

dsisnero

git clone git@github.com:YorickPeterse/ruby-ll.git
cd ruby-ll
bundle install
rake clean compile
ruby test.rb # see Ruby script below

dsisnero

#!/usr/bin/env ruby

require 'concurrent'

module ReportCli
  class Runner

    attr_accessor :run_times, :reporter

    # This method will not limit the number of threads in the pool. It will

dsisnero

#! ruby -Ks
# -*- coding: sjis -*-

require 'win32ole'
 
 module Worksheet
   def [] y,x
     cell = self.Cells.Item(y,x)
     if cell.MergeCells
       cell.MergeArea.Item(1,1).Value