| | |
| | 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() |
| |
|
