Variables
drop_table Namespace Reference

Variables

string Usage
 
 host = None
 
 port = None
 
 user = None
 
 password = None
 
 detector = None
 
list dbcon = []
 
 opts
 
 args
 
 tname = args[1]
 
 conn = psycopg2.connect("dbname=nova_dev host=ifdbdev.fnal.gov port=5433")
 
 cur = conn.cursor()
 
string SQL = "drop table %s.%s_tag_snapshot; drop table %s.%s_tag cascade; drop table %s.%s_snapshot_data; drop table %s.%s_update; drop table %s.%s_snapshot cascade;"
 

Variable Documentation

drop_table.args

Definition at line 24 of file drop_table.py.

drop_table.conn = psycopg2.connect("dbname=nova_dev host=ifdbdev.fnal.gov port=5433")

Definition at line 46 of file drop_table.py.

drop_table.cur = conn.cursor()

Definition at line 51 of file drop_table.py.

list drop_table.dbcon = []

Definition at line 22 of file drop_table.py.

drop_table.detector = None

Definition at line 20 of file drop_table.py.

drop_table.host = None
drop_table.opts

Definition at line 24 of file drop_table.py.

drop_table.password = None

Definition at line 19 of file drop_table.py.

drop_table.port = None

Definition at line 17 of file drop_table.py.

string drop_table.SQL = "drop table %s.%s_tag_snapshot; drop table %s.%s_tag cascade; drop table %s.%s_snapshot_data; drop table %s.%s_update; drop table %s.%s_snapshot cascade;"

Definition at line 55 of file drop_table.py.

drop_table.tname = args[1]

Definition at line 38 of file drop_table.py.

string drop_table.Usage
Initial value:
1 = """
2 python drop_table.py [options] <database name> <table_name>
3 options:
4  -h <host>
5  -p <port>
6  -U <user>
7  -w <password>
8  -d <detector>
9 
10 """

Definition at line 5 of file drop_table.py.

drop_table.user = None