Benjamin Roth apneadiving

apneadiving / 00-setup.sql

Created October 16, 2015 07:20 — forked from michaeldelorenzo/00-setup.sql

Tree structure query with PostgreSQL

	-- Create tables
	CREATE TABLE groups (id serial NOT NULL, name character varying NOT NULL);
	CREATE TABLE network_group_members (pid integer, cid integer NOT NULL);

	-- Insert the groups
	INSERT INTO groups (name) VALUES ('GROUP 1'),('GROUP 2'),('GROUP 3'),('GROUP 4'),('GROUP 5'),('GROUP 6'),('GROUP 7'),('GROUP 8'),('GROUP 9'),('GROUP 10'),('GROUP 11'),('GROUP 12'),('GROUP 13');
	-- Build the "Network"
	INSERT INTO network_group_members(pid,cid) VALUES (1,2),(1,3),(1,4),(2,5),(5,6),(5,7),(7,8),(3,9),(4,10),(4,11),(11,12),(12,13);

apneadiving / tire-parent-child-example.rb

Created September 25, 2013 08:14 — forked from demirhanaydin/tire-parent-child-example.rb

	require 'rubygems'
	require 'tire'

	Tire.configure { logger 'elasticsearch.log', :level => 'debug' }

	class Document
	attr_accessor :title, :content
	include Tire::Model::Persistence
	include Tire::Model::Search
	include Tire::Model::Callbacks