DeepSource
Dashboard Resources Pricing Discover Directory Log in

Run your first analysis.

Find thousands of code security and quality issues in your codebase, before they end up in production.

Start now

ilyalelechenko / price_bot

Line too long FLK-E501
Style
Minor
a year ago — a year old
line too long (342 > 88 characters)
sql.py
29def get_discount(user_id):
30    cur.execute('SELECT "dicount_on_WB" FROM about WHERE user_id = %s;', (user_id,))
31    discount = cur.fetchone()[0]
32    return discount"""
line too long (120 > 88 characters)
sql.py
16    if cur.fetchone()[0]:
17        cur.execute("UPDATE decrip SET price = %s WHERE user_id = %s AND (ozon = %s AND wb = %s)", (price, user_id, ozon, wb))
18    else:
19        cur.execute("INSERT INTO decrip (user_id, ozon, wb, price) VALUES (%s, %s, %s, %s)", (user_id, ozon, wb, price))20    conn.commit()
21
22"""
line too long (126 > 88 characters)
sql.py
14def add_links(user_id, ozon='', wb='', price=''):
15    cur.execute('SELECT EXISTS(SELECT 1 FROM decrip WHERE user_id = %s AND (ozon = %s AND wb = %s))', (user_id, ozon, wb))
16    if cur.fetchone()[0]:
17        cur.execute("UPDATE decrip SET price = %s WHERE user_id = %s AND (ozon = %s AND wb = %s)", (price, user_id, ozon, wb))18    else:
19        cur.execute("INSERT INTO decrip (user_id, ozon, wb, price) VALUES (%s, %s, %s, %s)", (user_id, ozon, wb, price))
20    conn.commit()
line too long (122 > 88 characters)
sql.py
12
13
14def add_links(user_id, ozon='', wb='', price=''):
15    cur.execute('SELECT EXISTS(SELECT 1 FROM decrip WHERE user_id = %s AND (ozon = %s AND wb = %s))', (user_id, ozon, wb))16    if cur.fetchone()[0]:
17        cur.execute("UPDATE decrip SET price = %s WHERE user_id = %s AND (ozon = %s AND wb = %s)", (price, user_id, ozon, wb))
18    else:
line too long (116 > 88 characters)
sql.py
 4def add_user(first_name, username, user_id):
 5    cur.execute('SELECT EXISTS(SELECT 1 FROM about WHERE user_id = %s)', (user_id,))
 6    if cur.fetchone()[0]:
 7        cur.execute('UPDATE about SET name = %s, username = %s WHERE user_id = %s', (first_name, username, user_id)) 8    else:
 9        cur.execute("INSERT INTO about (user_id, name, username) VALUES (%s, %s, %s)",
10                    (user_id, first_name, username))