Advertisement
Guest User

Untitled

a guest
Dec 6th, 2019
123
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.66 KB | None | 0 0
  1. import sqlite3
  2.  
  3. def create_table(db_name, table_name, columns):
  4. connection = sqlite3.connect(db_name)
  5. cursor = connection.cursor()
  6. query = f'CREATE TABLE IF NOT EXISTS {table_name} ('
  7. query += ', '.join(' '.join(i) for i in columns) + ')'
  8. cursor.execute(query)
  9. cursor.execute(f'SELECT * FROM {table_name}')
  10. print(cursor.fetchall())
  11. connection.close()
  12.  
  13. col = [('id', 'INTEGER', 'PRIMARY KEY'),
  14. ('login', 'VARCHAR(25)', 'UNIQUE', 'NOT NULL'),
  15. ('password', 'VARCHAR(50)', 'NOT NULL'),
  16. ('email', 'VARCHAR(40)', 'UNIQUE', 'NOT NULL'),
  17. ('about', 'TEXT')]
  18.  
  19. create_table('users.sqlite', 'Users2', col)
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement