wUk2niNM

1import sqlite3
2conn = sqlite3.connect('example.db')
3c = conn.cursor()
4c.execute('''CREATE TABLE mytable
5         (start, end, score)''') 
6     
7import sqlite3
8
9def create():
10    try:
11        c.execute("""CREATE TABLE mytable
12                 (start, end, score)""")
13    except:
14        pass
15
16def insert():
17    c.execute("""INSERT INTO mytable (start, end, score)
18              values(1, 99, 123)""")
19
20def select(verbose=True):
21    sql = "SELECT * FROM mytable"
22    recs = c.execute(sql)
23    if verbose:
24        for row in recs:
25            print row
26
27db_path = r'C:UsersProssercDocumentsGeocodingtest.db'
28conn = sqlite3.connect(db_path)
29c = conn.cursor()
30create()
31insert()
32conn.commit() #commit needed
33select()
34c.close() 
35     
36(1, 99, 123) 
37     
38import sqlite3;
39import pandas as pd;
40
41con=None
42
43def getConnection():
44    databaseFile="./test.db"
45    global con
46    if con == None:
47        con=sqlite3.connect(databaseFile)
48    return con
49
50def createTable(con):
51    try:
52        c = con.cursor()
53        c.execute("""CREATE TABLE IF NOT EXISTS Movie
54                 (start, end, score)""")
55    except Exception as e:
56        pass
57
58def insert(con):
59    c = con.cursor()
60c.execute("""INSERT INTO Movie (start, end, score)
61          values(1, 99, 123)""")
62
63def queryExec():
64    con=getConnection()
65    createTable(con)
66    insert(con)
67    # r = con.execute("""SELECT * FROM Movie""")
68    result=pd.read_sql_query("select * from Movie;",con)
69    return result
70
71
72r = queryExec()
73print(r)