Python SqliteDatabase.executeOne Examples

Example #1

File: sqlite.py Project: hmishra2020/https-github.com-yoyonel-audio-fingerprint-identifying-python

#!/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')

Example #2

File: sql-execute.py Project: norendas/shazamfrompy2topy3

#!/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)