report, photcs, dbEntries = get_report(g, csvFile)
print report
try:
ans = raw_input(
"Do you want to merge PHOTC data from the file into the database? "
)
if ans in ('y', 'Y', 'yes', 'YES'):
start = time.time()
g.begin()
g.setTableName('youpi_image')
try:
update = 0
for e in dbEntries:
g.update(photc=photcs[e[0]], wheres={'name': e[0]})
update += 1
g.con.commit()
except:
g.con.rollback()
print "Error:", e
sys.exit(1)
print "Done. %d PHOTC fields merged." % update
print "Time elapsed: %.02f sec" % (time.time() - start)
else:
print "Nothing merged."
sys.exit(0)
except KeyboardInterrupt:
print "\nExiting... nothing merged."
sys.exit(0)
g = DBGeneric(db.con)
report, photcs, dbEntries = get_report(g, csvFile)
print report
try:
ans = raw_input("Do you want to merge PHOTC data from the file into the database? ")
if ans in ("y", "Y", "yes", "YES"):
start = time.time()
g.begin()
g.setTableName("youpi_image")
try:
update = 0
for e in dbEntries:
g.update(photc=photcs[e[0]], wheres={"name": e[0]})
update += 1
g.con.commit()
except:
g.con.rollback()
print "Error:", e
sys.exit(1)
print "Done. %d PHOTC fields merged." % update
print "Time elapsed: %.02f sec" % (time.time() - start)
else:
print "Nothing merged."
sys.exit(0)
except KeyboardInterrupt:
print "\nExiting... nothing merged."
sys.exit(0)
