def accept(self):
#print '%s %s %s' % (self.field('epon'),self.field('cotyp_id'),self.field('fname'))
fileSql = open('newDb.sql')
script = u''
for lines in fileSql:
script += u'%s' % lines.decode('utf-8')
dbutils.executeScript(script, self.field('fname'))
sqlCo = sqlco.format(self.field('epon'),self.field('onom'),self.field('patr'),self.field('cotyp_id'),
self.field('ame'),self.field('afm'),self.field('doy'),self.field('dra'),
self.field('pol'),self.field('odo'),self.field('num'),self.field('tk'),
self.field('ikac'),self.field('ikap'))
#print sqlCo
dbutils.commitToDb(sqlCo, self.field('fname'))
sqlCoy = u"INSERT INTO m12_coy VALUES (1,1,'Κεντρικό','%s')" % self.field('kad')
dbutils.commitToDb(sqlCoy, self.field('fname'))
etos = datetime.datetime.now().year
dbutils.commitToDb(u"INSERT INTO m12_xrisi (xrisi,xrisip) VALUES ('{0}','Χρήση {0}')".format(etos), self.field('fname'))
eidList = osyk.eid_cad_listFilteredDouble(self.field('kad'))
print eidList
sqleid_ = u"INSERT INTO m12_eid (eidp,keid) VALUES ('{0}','{1}');\n"
sqleid = u''
for el in eidList:
sqleid += sqleid_.format(el[1],el[0])
dbutils.executeScript(sqleid,self.field('fname'))
super(NewDbWizard, self).accept()
def accept(self):
print '%s %s %s' % (self.field('epon'),self.field('coType'),self.field('fname'))
file = open('newDb.sql')
script = u''
for lines in file:
script += '%s' % lines.decode('utf-8')
dbutils.executeScript(script, self.field('fname'))
sqlCo = "INSERT INTO m12_co VALUES (1,'%s','','',1,'','','','','','','','','','')" % self.field('epon')
dbutils.commitToDb(sqlCo, self.field('fname'))
#self.parent.
sqlCoy = u"INSERT INTO m12_coy VALUES (1,1,'Κεντρικό','%s')" % self.field('kad')
dbutils.commitToDb(sqlCoy, self.field('fname'))
