#!/usr/bin/python import sys, os sys.path.append(os.path.join(sys.path[0], '..')) from libs.db_sqlite import SqliteDatabase from termcolor import colored if __name__ == '__main__': db = SqliteDatabase() row = db.executeOne("SELECT 2+3 as x;") assert row[0] == 5, "failed simple sql execution" print ' * %s' % colored('ok', 'green')
#!/usr/bin/python import argparse import sys from libs.db_sqlite import SqliteDatabase from termcolor import colored from argparse import RawTextHelpFormatter if __name__ == '__main__': parser = argparse.ArgumentParser(formatter_class=RawTextHelpFormatter) parser.add_argument('-q', '--query', nargs='?') args = parser.parse_args() if not args.query: parser.print_help() sys.exit(0) db = SqliteDatabase() row = db.executeOne(args.query) print(row)