Телеграмм чат группы ru_flask страница 3574

Size: a a a

Python Flask

2020 November 14

it works, but there is a more simple way to do that?

def functionr(live, y=None):
    if y:
        versione=" AND y = %s"
    else:
        versione = ""

    sql = """
    SELECT ...
    WHERE live=%s AND ban = 0%s
    GROUP BY seller) AS tmp

    """ % ('%s', versione)
    if y:
        x = query_select(sql, live, y)
    else:
        x = query_select(sql, live)   
    return x

Probably the best solution for this case to use any query builder

источник

14:34пожаловаться #1

Alexander in Python Flask

Simo [ADAGO Stake Pool]

it works, but there is a more simple way to do that?

def functionr(live, y=None):
    if y:
        versione=" AND y = %s"
    else:
        versione = ""

    sql = """
    SELECT ...
    WHERE live=%s AND ban = 0%s
    GROUP BY seller) AS tmp

    """ % ('%s', versione)
    if y:
        x = query_select(sql, live, y)
    else:
        x = query_select(sql, live)   
    return x

Firstly:

if x: #x is treated True except for all empty data types [],{},(),'',0 False, and None

if x is not None # which works only on None

источник

14:43пожаловаться #2

Alexander in Python Flask

Secondly:
if you use last python

sql = f"""
    SELECT ...
    WHERE live={live} AND ban = 0 {f"AND y = {y}" if y is not None else ''}
    GROUP BY seller) AS tmp"""

x = query_select(sql)

источник

14:45пожаловаться #3

Tishka17 in Python Flask

Alexander

Secondly:
if you use last python

sql = f"""
    SELECT ...
    WHERE live={live} AND ban = 0 {f"AND y = {y}" if y is not None else ''}
    GROUP BY seller) AS tmp"""

x = query_select(sql)

Что за хуйня?

источник

14:45пожаловаться #4

Tishka17 in Python Flask

Alexander

Secondly:
if you use last python

sql = f"""
    SELECT ...
    WHERE live={live} AND ban = 0 {f"AND y = {y}" if y is not None else ''}
    GROUP BY seller) AS tmp"""

x = query_select(sql)

What the fuck is this?

источник

14:45пожаловаться #5

Alexander in Python Flask

Подставка в f-строку

источник

14:46пожаловаться #6

Vladi in Python Flask

Alexander

Подставка в f-строку

инъекции тебе неведомы кажись

источник