L1DraNra

1connect_vk_1 = "12"
2connect_vk_2 = "31321"
3connect_vk_3 = "2141"
4connect_vk_4 = "2342"
5
6connection = pymysql.connect(host=connect_host,
7                             user=connect_user,
8                             password=connect_pass,
9                             db=connect_db,
10                             charset=connect_charset,
11                             cursorclass=pymysql.cursors.DictCursor)
12print("База данных подключена успешно.")
13cursor = connection.cursor()
14cursor.execute("DROP TABLE IF EXISTS ACCOUNT")
15sql = """CREATE TABLE ACCOUNT (
16         LOGIN  CHAR(13) NOT NULL,
17         PASS  CHAR(13),
18         ID CHAR(15),  
19         ID_APP CHAR(10));
20         
21         INSERT INTO ACCOUNT VALUES("%s", "%s", "%s", "%s") % \
22                                   (connect_vk_1, connect_vk_2, connect_vk_3, connect_vk_4));"""
23cursor.execute("SELECT VERSION()")
24data = cursor.fetchone()
25print (f'Версия базы данных: {data} ')
26try:
27   connection.execute(sql, (connect_vk_1, connect_vk_2, connect_vk_3, connect_vk_4))
28   connection.commit()
29except:
30    connection.rollback()