Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- from sqlite3 import *
- conn = connect('todo.db')
- c = conn.cursor()
- create_table_query = '''
- CREATE TABLE 'Tasks' (
- ID INTEGER UNIQUE PRIMARY KEY AUTOINCREMENT NOT NULL,
- name TEXT NOT NULL,
- desc TEXT,
- date TEXT default CURRENT_TIMESTAMP
- )
- '''
- select_query = '''
- SELECT * FROM Tasks
- '''
- insest_query = '''
- INSERT INTO Tasks ('name', 'desc') VALUES('Iznesi smece ')
- '''
- try:
- c.execute(create_table_query)
- conn.commit()
- except OperationalError:
- print ('Table allready exist')
- c.execute(insest_query)
- conn.commit
- c.execute(select_query)
- print ('c.fetchall()')
- conn.close()
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement