Skip to content

Instantly share code, notes, and snippets.

View tearf001's full-sized avatar
🎯
Focusing

Tiffiny Jenis tearf001

🎯
Focusing
View GitHub Profile
@INF800
INF800 / __init__.py
Last active November 15, 2021 23:44
FASTAPI Boilerplate
# empty
@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);
@curlup
curlup / gist:3175629
Created July 25, 2012 11:25
sql pyparsing
"""
Temporal Proxy
(c) Looking Glass Solutions 2007
Licensed under GPL v2
"""
## SQL COMMANDS: http://www.postgresql.org/docs/8.3/interactive/sql-commands.html
## USE PSYCO
# Importing the required modules