python sqlite3

[myaws010010]

import sqlite3
conn = sqlite3.connect('example.db')
c = conn.cursor()

c.execute('''CREATE TABLE execsucceed              (execarn text, succ int)''')
c.execute('''CREATE TABLE execresult              (execarn text, data text)''')             
conn.commit()
c.execute('''insert into  execresult  values (1,1)
            ;''') 
c.execute('''insert into  execsucceed  values (1,1)
            ;''')             
conn.commit() 
c.execute('''select * from  execresult
            ;''') 
print (c.fetchall())            
c.execute('''select * from  execsucceed
            ;''') 
print (c.fetchall())  
c.execute('''delete  from  execresult
            ;''') 
c.execute('''delete  from  execsucceed
            ;''')             
conn.commit()             

conn.close()

[myaws010010]

import sqlite3
import fuckit
conn = sqlite3.connect('example.db')
c = conn.cursor()
# Create table
with fuckit:
    c.execute('''DROP TABLE execsucceed   ''')
with fuckit:
    c.execute('''DROP TABLE execresult          ''')  
conn.commit()
c.execute('''CREATE TABLE execsucceed              (execarn text, succ int,tsexec int, tsaws int)''')
c.execute('''CREATE TABLE execresult              (execarn text, data text,tsexec int, tsaws int)''')             
conn.commit()
c.execute('''insert into  execresult  values (1,1,1,1)
            ;''') 
c.execute('''insert into  execsucceed  values (1,1,1,1)
            ;''')             
conn.commit() 
c.execute('''select * from  execresult
            ;''') 
print (c.fetchall())            
c.execute('''select * from  execsucceed
            ;''') 
print (c.fetchall())  
c.execute('''delete  from  execresult
            ;''') 
c.execute('''delete  from  execsucceed
            ;''')             
conn.commit()             

conn.close()