Skip to content

Instantly share code, notes, and snippets.

@xib
xib / DAG_MySQL.sql
Created December 23, 2014 08:17
Direct Acyclic Directed Graph in MySQL database
-- Based on the original articel at http://www.codeproject.com/Articles/22824/A-Model-to-Represent-Directed-Acyclic-Graphs-DAG-o
-- Here is a port to MySQL
-- Edge table
DROP TABLE IF EXISTS `Edge`;
CREATE TABLE IF NOT EXISTS `Edge` (
`id` int(11) NOT NULL,
`entry_edge_id` int(11) DEFAULT NULL COMMENT 'The ID of the incoming edge to the start vertex that is the creation reason for this implied edge; direct edges contain the same value as the Id column',
`direct_edge_id` int(11) DEFAULT NULL COMMENT 'The ID of the direct edge that caused the creation of this implied edge; direct edges contain the same value as the Id column',
`exit_edge_id` int(11) DEFAULT NULL COMMENT 'The ID of the outgoing edge from the end vertex that is the creation reason for this implied edge; direct edges contain the same value as the Id column',
<gistThat info="this is a manifest for gistThat VBA code distribution - see ramblings.mcpher.com for details">
<manifest description="cDataset and associated classes and modules" contact="bruce@mcpher.com">
<gists>
<item1 gistid="3414216" version="" filename="cCell.cls" module="cCell" type="class" />
<item2 gistid="3414216" version="" filename="cDataSet.cls" module="cDataSet" type="class" />
<item3 gistid="3414216" version="" filename="cDataSets.cls" module="cDataSets" type="class" />
<item4 gistid="3414216" version="" filename="cDataColumn.cls" module="cDataColumn" type="class" />
<item5 gistid="3414216" version="" filename="cDataRow.cls" module="cDataRow" type="class" />
<item6 gistid="3414216" version="" filename="cHeadingRow.cls" module="cHeadingRow" type="class" />
<item7 gistid="3414346" version="" filename="" module="usefulStuff" type="module" />
@xib
xib / gistThat_.vba
Last active August 29, 2015 14:05 — forked from brucemcpherson/gistThat_.vba
Add basic support to gist from different users
'IMPORTANT - CHANGE gtExampleLoad() to include gtDoit() for each Gist you want to load
' bootstrap code to update VBA modules from gists
' all code is in this module - so no classes etc.
' latebinding is used to avoid need for any references
' can be found at https://gist.github.com/3403537
Option Explicit
' v2.04 - 3403537
' if you are using your own gists - change this
Const gistOwner = "brucemcpherson"
Dim gistOwners As New Collection
@xib
xib / restLibrary.xml
Last active August 29, 2015 14:05 — forked from brucemcpherson/restLibrary.xml
Until gistThat_ can support gist version, now I need only the basic restLibrary modules
<gistThat info="this is a manifest for gistThat VBA code distribution - see ramblings.mcpher.com for details">
<manifest description="restlibrary associated classes and modules" contact="bruce@mcpher.com">
<gists>
<item1 gistid="3423885" version="" filename="restLibrary.vba" module="restLibrary" type="module"/>
<item2 gistid="3423885" version="" filename="cRest.cls" module="cRest" type="class"/>
<item3 gistid="3423912" version="" filename="cBrowser.cls" module="cBrowser" type="class"/>
<item11 gistid="6937529" version="" filename="usefulEncrypt.vba" module="usefulEncrypt" type="module"/>
<item4 guid="{000204EF-0000-0000-C000-000000000046}" name="VBA" major="4" minor="0" description="Visual Basic For Applications" type="reference"/>