|
|
|
|
|
def replace_null_with_empty_string(conn): |
|
|
cursor = conn.cursor() |
|
|
query = """ |
|
|
UPDATE contacts |
|
|
SET |
|
|
name = COALESCE(name, ''), |
|
|
phone = COALESCE(phone, ''), |
|
|
email = COALESCE(email, ''), |
|
|
vk_id = COALESCE(vk_id, ''), |
|
|
chat_id = COALESCE(chat_id, ''), |
|
|
ws_st = COALESCE(ws_st, ''), |
|
|
ws_stop = COALESCE(ws_stop, ''), |
|
|
web_st = COALESCE(web_st, ''), |
|
|
fin_prog = COALESCE(fin_prog, ''), |
|
|
b_city = COALESCE(b_city, ''), |
|
|
b_fin = COALESCE(b_fin, ''), |
|
|
b_ban = COALESCE(b_ban, ''), |
|
|
b_ign = COALESCE(b_ign, ''), |
|
|
b_baners = COALESCE(b_baners, ''), |
|
|
b_butt = COALESCE(b_butt, ''), |
|
|
b_mess = COALESCE(b_mess, ''), |
|
|
shop_st = COALESCE(shop_st, ''), |
|
|
curator = COALESCE(curator, ''), |
|
|
pr1 = COALESCE(pr1, ''), |
|
|
pr2 = COALESCE(pr2, ''), |
|
|
pr3 = COALESCE(pr3, ''), |
|
|
pr4 = COALESCE(pr4, ''), |
|
|
pr5 = COALESCE(pr5, ''), |
|
|
gc_url = COALESCE(gc_url, ''), |
|
|
key_pr = COALESCE(key_pr, ''), |
|
|
n_con = COALESCE(n_con, ''), |
|
|
canal = COALESCE(canal, ''), |
|
|
data_on = COALESCE(data_on, ''), |
|
|
data_t = COALESCE(data_t, ''), |
|
|
utm_source = COALESCE(utm_source, ''), |
|
|
utm_medium = COALESCE(utm_medium, ''), |
|
|
utm_campaign = COALESCE(utm_campaign, ''), |
|
|
utm_term = COALESCE(utm_term, ''), |
|
|
utm_content = COALESCE(utm_content, ''), |
|
|
gcpc = COALESCE(gcpc, '') |
|
|
""" |
|
|
cursor.execute(query) |
|
|
conn.commit() |
|
|
|
