sG5VTq1m

1import sqlite3
2import pymysql
3
4
5def make(op_id):
6    conn = pymysql.connect(host='mysq3333ru', charset="utf8", port=3306, user='h3333all',
7                           passwd='T3333H', db='host1629500')
8    myCursor = conn.cursor()
9
10    # создание таблицы
11    myCursor.execute(""" CREATE TABLE IF NOT EXISTS payment
12       (
13       id int primary key,
14       op_id varchar(40),
15       user_id varchar(40),
16       task_id varchar(40),
17       cost varchar(40),
18       date varchar(40)
19       )
20       """)
21
22    myCursor.execute('SELECT COUNT(*) FROM payment where (op_id) VALUES (?)', op_id)
23
24    a = myCursor.fetchone()
25    aa = a[0]
26
27    if aa < 1:
28        myCursor.execute("INSERT OR REPLACE  INTO payment (op_id) VALUES (?)", op_id)
29        conn.commit()
30        conn.close()
31    else:
32        print("line exist")
33
34
35make("123456")
36
37
38
39
40
41 Warning: (1050, "Table 'payment' already exists")
42  result = self._query(query)
43Traceback (most recent call last):
44  , line 35, in <module>
45    make("123456")
46 line 22, in make
47    myCursor.execute('SELECT COUNT(*) FROM payment where (op_id) VALUES (?)', op_id)
48  line 163, in execute
49    query = self.mogrify(query, args)
50  line 142, in mogrify
51    query = query % self._escape_args(args, conn)
52TypeError: not all arguments converted during string formatting