def main(argv = sys.argv[1:]): #usage, option_list, option_class, version, conflict_handler, description, formatter, add_help_option, prog, epilog) parser = OptionParser(version = '%prog 0.0.1b', description= u''' Generador de reportes Generador de reportes del sistema de semaforizacion Avrak. El rpoerte es generado en PDF en un archivo temporal y este debe ser guardado o impreso. El sistema operativo se deshará del archivo si este no es guardado. ''', prog="print_dlg", epilog = u"""Este software se encuentra bajo la licencia GPL v.3 Nahuel Defossé © 2009""") parser.add_option('-c', '--config', default = '../config.cfg', type=str, help = "Archivo de configuracion", dest = "config_file") opts, args = parser.parse_args(argv) cfg = Config(opts.config_file) from PyQt4.QtGui import QApplication QApplication(argv) from pyscada.gui.qt_dbhelp import dburl_to_qsqldb log.startLogging(sys.stdout, setStdout = False) #db = dburl_to_qsqldb('mysql://*****:*****@localhost:3306/dsem') db = dburl_to_qsqldb(**dict(cfg.scada)) log.msg("DB OK? %s" % db.isValid()) win = PrintDialog() win.template = '../templates/report.html' win.exec_()
query.exec_("create table person(id int primary key, " "firstname varchar(20), lastname varchar(20))") query.exec_("insert into person values(102, 'Christine', 'Holand')") query.exec_("insert into person values(103, 'Lars', 'Gordon')") query.exec_("insert into person values(104, 'Roberto', 'Robitaille')") query.exec_("insert into person values(105, 'Maria', 'Papadopoulos')") query.exec_("select id, firstname from person") return query #query = setup_db_sqlite() from pyscada.gui.qt_dbhelp import dburl_to_qsqldb try: # Se lo chantamos así nomás qApp.db_con = dburl_to_qsqldb( 'mysql://*****:*****@localhost:3306/dsem') q = QSqlQuery("SET NAMES 'utf8'", qApp.db_con) print q.exec_() except Exception, e: import traceback QMessageBox.critical( None, "Error", u"<h2>%s</h2></pre>%s</pre>" % (type(e), traceback.format_exc())) sys.exit() query = QSqlQuery(''' SELECT CONCAT(UC.nombre_uc, '(' ,UC.id_UC,')'), UC.id FROM UC WHERE UC.co_id = %(co_id)d ''' % {'co_id': 1})
"firstname varchar(20), lastname varchar(20))") query.exec_("insert into person values(102, 'Christine', 'Holand')") query.exec_("insert into person values(103, 'Lars', 'Gordon')") query.exec_("insert into person values(104, 'Roberto', 'Robitaille')") query.exec_("insert into person values(105, 'Maria', 'Papadopoulos')") query.exec_("select id, firstname from person") return query #query = setup_db_sqlite() from pyscada.gui.qt_dbhelp import dburl_to_qsqldb try: # Se lo chantamos así nomás qApp.db_con = dburl_to_qsqldb('mysql://*****:*****@localhost:3306/dsem') q = QSqlQuery("SET NAMES 'utf8'", qApp.db_con) print q.exec_() except Exception, e: import traceback QMessageBox.critical(None, "Error", u"<h2>%s</h2></pre>%s</pre>" % (type(e), traceback.format_exc())) sys.exit() query = QSqlQuery(''' SELECT CONCAT(UC.nombre_uc, '(' ,UC.id_UC,')'), UC.id FROM UC WHERE UC.co_id = %(co_id)d ''' % {'co_id':1})