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

from libcommon.sqlcommon import sqlFilter
import psycopg
import globals

print """
mig_comment_one_shot.py
format comments : remove <br> tags
see table var to configure !

"""

table = 'contact'

query = """SELECT uid, commentaire FROM %s""" % table

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, comment) in curs.fetchall():
	if comment != None and comment != '':
		uquery = "UPDATE %s SET commentaire=%s, codemodif='mig_comment_one_shot.py' WHERE uid=%s;" % (
			table, sqlFilter(comment.replace('<br>', '\n')), uid)
		#print uquery
		curs.execute(uquery)
	
uquery = "COMMIT;"
curs.execute(uquery)