sdfasdf

import sqlite3


def create_table(db_name, table_name, colums):
  with sqlite3.connect(db_name) as connection:
    cursor = connection.cursor()
    query = f'CREATE TABLE IF NOT EXISTS {table_name} ('
    query += ', '.join(' '.join(i) for i in colums) + ')'
    cursor.execute(query)
    cursor.execute(f'SELECT * FROM {table_name}')
    print(cursor.fetchall())

col = [('id', 'INTEGER', 'PRIMARY KEY'),
      ('login', 'VARCHAR(25)', 'UNIQUE', 'NOT NULL'),
      ('password', 'VARCHAR(50)', 'NOT NULL'),
      ('email', 'VARCHAR(40)', 'UNIQUE', 'NOT NULL'),
      ('about', 'TEXT')]

#create_table('users.sqlite', 'Users3', col)
def insert_data(db_name, table_name, data):
  with sqlite3.connect(db_name) as connection:
      cursor = connection.cursor()
      query = f"INSERT INTO {table_name} VALUES "
      query += data
      cursor.execute(query)
      cursor.execute(f'SELECT * FROM {table_name}')
      print(cursor.fetchall())

row = (3, 'egodr', '4355234', 'adasd@mail.ru', '54')
#print(str(row))
insert_data('users.sqlite', 'Users3', str(row))