Exemple #1
0
def test_drop_table(db):
    tables = db.get_tables()
    print(tables)

    if "test" in tables:
        db.execute("DROP TABLE test")

    tables = db.get_tables()
    print(tables)
Exemple #2
0
def test_create_table(db):
    tables = db.get_tables()
    print(tables)

    if not "test" in tables:
        db.execute("CREATE TABLE test (id TEXT, value TEXT)")

    tables = db.get_tables()
    print(tables)
Exemple #3
0
def test_drop_table(db):
    tables = db.get_tables()
    print tables
    
    if "test" in tables:
        db.execute("DROP TABLE test")
        
    tables = db.get_tables()
    print tables
Exemple #4
0
def test_create_table(db):
    tables = db.get_tables()
    print tables
    
    if not "test" in tables:
        db.execute("CREATE TABLE test (id TEXT, value TEXT)")
        
    tables = db.get_tables()
    print tables
Exemple #5
0
def test_select(db):
    result = db.execute("SELECT id, value FROM test")
    for row in result:
        print("%s: %s" % (row["id"], row["value"]))
Exemple #6
0
def test_insert(db):
    for i in range(0, 1000):
        db.execute("INSERT INTO test VALUES (?,?)",
                   ("key%s" % i, "value%s" % i))
Exemple #7
0
def test_select(db):
    result = db.execute("SELECT id, value FROM test")
    for row in result:
        print "%s: %s" % (row["id"], row["value"])
Exemple #8
0
def test_insert(db):
    for i in range(0, 1000):
        db.execute("INSERT INTO test VALUES (?,?)", ("key%s" % i, "value%s" % i))