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})
