def main(argv):
"""Main entry function for CLI script, should be
passed CLI args tuple, normally from sys.argv
"""
# Get CLI options
try:
opts, args = getopt.getopt(
argv,
"d:",
[
"dsn=",
]
)
except getopt.GetoptError:
error("Unknown options", True, USAGE_MESSAGE)
if not opts:
usage(USAGE_MESSAGE)
sys.exit(0)
dsn = None
# Parse CLI options
for opt, arg in opts:
if opt in ("-d", "--dsn"):
dsn = arg
if not dsn:
error("Please provide a DSN", True, USAGE_MESSAGE)
# Setup cursor
conn = pyodbc.connect(dsn)
u = ODBCUtility()
u.cursor = u.system_cursor = conn.cursor()
u.cmdloop()
def main(argv):
"""Main entry function for CLI script, should be
passed CLI args tuple, normally from sys.argv
"""
# Get CLI options
try:
opts, args = getopt.getopt(
argv,
"f:",
[
"file=",
]
)
except getopt.GetoptError:
error("Unknown options", True, USAGE_MESSAGE)
if not opts:
usage(USAGE_MESSAGE)
sys.exit(0)
filepath = None
# Parse CLI options
for opt, arg in opts:
if opt in ("-f", "--file"):
filepath = arg
if not filepath:
error("Please provide a DB filepath", True, USAGE_MESSAGE)
# Setup cursor
conn = sqlite3.connect(filepath)
u = LiteUtility()
u.cursor = u.system_cursor = conn.cursor()
u.cmdloop()
