#!/usr/pkg/bin/python
import sys, os, re, pwd
if len(sys.argv) < 2:
 sys.stderr.write("Usage: %s %s %s\n" % (sys.argv[0], 'DBNAME', '[DB_DIR]'))
 sys.exit(1)
homedir = pwd.getpwuid(os.geteuid())[5]
try:
 dbdir = sys.argv[2]
except:
 dbdir = os.sep.join([homedir, 'gadfly'])
sys.path.append(os.sep.join([homedir, 'lib', 'python']))
# we had to do the above before we could import gadfly
import gadfly
try:
 connection = gadfly.gadfly(sys.argv[1], dbdir)
except:
 sys.stderr.write("%s: %s\n" % (
  'Could not open database "%s" from "%s"' % (sys.argv[1], dbdir),
  sys.exc_info()[1].args[1]))
 sys.exit(1)
cursor = connection.cursor()
cursor.execute("SELECT table_name FROM __table_names__" + \
 " WHERE is_view = 0")
for table in map(lambda column: column[0], cursor.fetchall()):
 cursor.execute("select * from %s" % table)
 print cursor.pp()