#!/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:
