PYTHON & SQLITE3 & PANDAS SESION 2

 

import sqlite3;

import pandas as pd;

con=None

def getConnection():

    databaseFile="test.db"

    global con

    if con == None:

        con=sqlite3.connect(databaseFile)

    return con

def createTable(con):

    try:

        c = con.cursor()

        c.execute("""CREATE TABLE IF NOT EXISTS Movie

                 (start, end, score)""")

    except Exception as e:

        pass

def insert(con):

    c = con.cursor()

    c.execute("""INSERT INTO Movie (start, end, score)

              values(1, 99, 123)""")

def queryExec():

    con=getConnection()

    createTable(con)

    insert(con)

    # r = con.execute("""SELECT * FROM Movie""")

    result=pd.read_sql_query("select * from Movie;",con)

    return result

r = queryExec()

print(r)