#!/usr/bin/python

# This is a small helper script to remove all annotations from a
# project.

# You may need to install psycopg2, e.g. with:
#   sudo apt-get install python-psycopg2

import sys
import psycopg2
import os
from common import db_connection, conf

if len(sys.argv) != 1:
    print >> sys.stderr, "Usage:", sys.argv[0]
    sys.exit(1)

c = db_connection.cursor()

print """Warning: this script removes all annotations from all projects
in the database '%s'""" % (conf['database'],)
print "To continue, type 'Yes' followed by Enter."
reply = raw_input()
if reply != 'Yes':
    sys.exit(2)

tables_to_truncate = (
    'treenode_class_instance',
    'connector_class_instance',
    'treenode_connector',
    'class_instance_class_instance',
    'class_instance',
    'treenode',
    'connector'
)

c.execute('TRUNCATE '+', '.join(tables_to_truncate))

db_connection.commit()
c.close()
db_connection.close()

Add a brutal (but fast) script for clearing *all* annotations from all projects
Add a brutal (but fast) script for clearing *all* annotations from all projects
