def execute(dbopt, q, data):
conn = MySQLdb.connect(host=dbopt.host, port=dbopt.port, user=dbopt.username, passwd=dbopt.password, db=dbopt.database, charset='utf8', use_unicode = True)
cur = conn.cursor()
query = fillquery(q, data)
print query
cur.execute(query)
cur.execute("COMMIT")
cur.close()
conn.close()
def execute(dbopt, q, data):
conn = psycopg2.connect(
"host="
+ dbopt.host
+ " port="
+ str(dbopt.port)
+ " dbname="
+ dbopt.database
+ " user="******" password="
+ dbopt.password
)
cur = conn.cursor()
query = dbopt.update
query = fillquery(q, data)
cur.execute(query)
cur.close()
conn.close()
