#!/usr/bin/env python # -*- coding: utf-8 -*- from common import db_connection import sys if len(sys.argv) != 3: print >> sys.stderr, "Usage: %s <PROJECT-ID> <USER-ID>" % (sys.argv[0],) sys.exit(1) project_id = int(sys.argv[1]) user_id = int(sys.argv[2]) c = db_connection.cursor() c.execute("SELECT id FROM relation WHERE project_id = %s AND relation_name='part_of'", (project_id,)) part_of_id = c.fetchone()[0] for direction in ('pre', 'post'): query = ''' SELECT cit.id, cis.id FROM class_instance cit, class_instance cis, class cs, class ct, treenode_class_instance tcit, treenode_class_instance tcis WHERE ct.class_name = '{direction}synaptic terminal' AND cit.class_id = ct.id AND cs.class_name = 'skeleton' AND cis.class_id = cs.id AND tcit.class_instance_id = cit.id AND
# -*- coding: utf-8 -*- from __future__ import print_function, unicode_literals from common import db_connection import sys limit = 50 if len(sys.argv) != 2: print("Usage: describe-concept.py <CONCEPT-ID>", file=sys.stderr) sys.exit(1) cid = int(sys.argv[1]) c = db_connection.cursor() # Find which table the concept is really in, and also the project_id: select = 'SELECT p.relname, t.project_id, t.user_id, u.name ' select += 'FROM concept t, pg_class p, "user" u ' select += 'WHERE t.id = %s AND t.tableoid = p.oid AND t.user_id = u.id' c.execute(select,(cid,)) row = c.fetchone() if not row: print("No concept with id {0} was found".format(cid), file=sys.stderr) sys.exit(1) table_name, pid, user_id, user_name = row # Find all the relations in that project: