b
@PythonBible здесь можешь посмотреть по поиску PyQt5
Size: a a a
b
E
$
R
БХ
ᅠ
ᅠ
<Ч
ᅠ
ᅠ
БХ
БХ
S
f"""
WITH clients_insert AS (
INSERT INTO clients (firstname, lastname, middlename, email, phone, gender, birthday)
VALUES ('{row['First Name']}','{row['Last Name']}','{row['Middle Name']}','{row['E-Mail']}','{row['Phone No_']}', '{row['Sex']}', '{row['Birth Date']}')
ON CONFLICT (phone) DO
(UPDATE SET firstname = EXCLUDED.firstname WHERE firstname IS NULL OR firstname = '',
UPDATE SET lastname = EXCLUDED.lastname WHERE lastname IS NULL OR lastname = '',
UPDATE SET middlename = EXCLUDED.middlename WHERE middlename IS NULL OR middlename = '',
UPDATE SET email = EXCLUDED.email WHERE email IS NULL OR email = '',
UPDATE SET gender = EXCLUDED.gender WHERE gender IS NULL OR gender = '',
UPDATE SET birthday = EXCLUDED.birthday WHERE birthday IS NULL OR birthday = '')
RETURNING client_id, email, phone
"""
E
БГ
f"""
WITH clients_insert AS (
INSERT INTO clients (firstname, lastname, middlename, email, phone, gender, birthday)
VALUES ('{row['First Name']}','{row['Last Name']}','{row['Middle Name']}','{row['E-Mail']}','{row['Phone No_']}', '{row['Sex']}', '{row['Birth Date']}')
ON CONFLICT (phone) DO
(UPDATE SET firstname = EXCLUDED.firstname WHERE firstname IS NULL OR firstname = '',
UPDATE SET lastname = EXCLUDED.lastname WHERE lastname IS NULL OR lastname = '',
UPDATE SET middlename = EXCLUDED.middlename WHERE middlename IS NULL OR middlename = '',
UPDATE SET email = EXCLUDED.email WHERE email IS NULL OR email = '',
UPDATE SET gender = EXCLUDED.gender WHERE gender IS NULL OR gender = '',
UPDATE SET birthday = EXCLUDED.birthday WHERE birthday IS NULL OR birthday = '')
RETURNING client_id, email, phone
"""
S
<Ч
ivan'; DROP TABLE clients; --
S
ivan'; DROP TABLE clients; --