summaryrefslogtreecommitdiff
path: root/plac/doc/dbcli.py
diff options
context:
space:
mode:
Diffstat (limited to 'plac/doc/dbcli.py')
-rw-r--r--plac/doc/dbcli.py29
1 files changed, 0 insertions, 29 deletions
diff --git a/plac/doc/dbcli.py b/plac/doc/dbcli.py
deleted file mode 100644
index d5db392..0000000
--- a/plac/doc/dbcli.py
+++ /dev/null
@@ -1,29 +0,0 @@
-# dbcli.py
-import plac
-from sqlalchemy.ext.sqlsoup import SqlSoup
-
-@plac.annotations(
- db=("Connection string", 'positional', None, SqlSoup),
- header=("Header", 'flag', 'H'),
- sqlcmd=("SQL command", 'option', 'c', str, None, "SQL"),
- delimiter=("Column separator", 'option', 'd'),
- scripts="SQL scripts",
- )
-def main(db, header, sqlcmd, delimiter="|", *scripts):
- "A script to run queries and SQL scripts on a database"
- yield 'Working on %s' % db.bind.url
-
- if sqlcmd:
- result = db.bind.execute(sqlcmd)
- if header: # print the header
- yield delimiter.join(result.keys())
- for row in result: # print the rows
- yield delimiter.join(map(str, row))
-
- for script in scripts:
- db.bind.execute(file(script).read())
- yield 'executed %s' % script
-
-if __name__ == '__main__':
- for output in plac.call(main):
- print(output)