#!/usr/bin/env python
# -*- coding: utf-8 -*-

from libcommon.common import format_sql_phone
from dbutils.sqlcommon import sqlFilter
import psycopg
import globals
import sys

print """
mig_phone_societe.py
format phone numbers to sql style (strip)

"""
	
query = """
SELECT uid, tel, tel2, fax
FROM societe
"""

conn = psycopg.connect("dbname=%s user=%s password=%s host=%s port=%s" %
					  (globals.DBNAME, globals.DBUSER, globals.DBPWD, globals.DBHOST, globals.DBPORT))
conn.autocommit()

curs = conn.cursor()
uquery = 'BEGIN;\n'
curs.execute(uquery)

curs.execute(query)

for (uid, tel, tel2, fax,) in curs.fetchall():
	uquery = """UPDATE societe
SET
tel='%s',
tel2='%s',
fax='%s',
codemodif='mig_phone_societe.py'
WHERE uid = %s;\n""" % (
		format_sql_phone(tel), format_sql_phone(tel2), format_sql_phone(fax), uid)
	#print uquery
	curs.execute(uquery)

uquery = "COMMIT;"
curs.execute(uquery)