def formatValue(self, type_, v, upper):
util = FLUtil()
s = None
if v is None:
v = ""
# TODO: psycopg2.mogrify ???
if type_ == "bool" or type_ == "unlock":
s = text2bool(v)
elif type_ == "date":
s = "'%s'" % util.dateDMAtoAMD(v)
elif type_ == "time":
s = "'%s'" % v
elif type_ == "uint" or type_ == "int" or type_ == "double" or type_ == "serial":
s = v
else:
v = auto_qt_translate_text(v)
if upper and type_ == "string":
v = v.upper()
s = "'%s'" % v
# print ("PNSqlDriver(%s).formatValue(%s, %s) = %s" % (self.name_, type_, v, s))
return s
def formatValueLike(self, type_, v, upper):
res = "IS NULL"
if type_ == "bool":
s = str(v[0]).upper()
if s == str(QApplication.tr("Sí")[0]).upper():
res = "=1"
elif str(QApplication.tr("No")[0]).upper():
res = "=0"
elif type_ == "date":
util = FLUtil()
res = "LIKE '%%" + util.dateDMAtoAMD(str(v)) + "'"
elif type_ == "time":
t = v.toTime()
res = "LIKE '" + t.toString(QtCore.Qt.ISODate) + "%%'"
else:
res = str(v)
if upper:
res = "%s" % res.upper()
res = "LIKE '" + res + "%%'"
return res
def formatValue(self, type_, v, upper):
util = FLUtil()
s = None
#if v == None:
# v = ""
# TODO: psycopg2.mogrify ???
if type_ == "bool" or type_ == "unlock":
s = text2bool(v)
elif type_ == "date":
s = "'%s'" % util.dateDMAtoAMD(v)
elif type_ == "time":
s = "'%s'" % v
elif type_ in ("uint", "int", "double", "serial"):
if v == None:
s = 0
else:
s = v
else:
v = auto_qt_translate_text(v)
if upper == True and type_ == "string":
v = v.upper()
s = "'%s'" % v
#qWarning ("PNSqlDriver(%s).formatValue(%s, %s) = %s" % (self.name_, type_, v, s))
return s
def formatValue(self, type_, v, upper):
util = FLUtil()
s = None
# if v == None:
# v = ""
# TODO: psycopg2.mogrify ???
if v is None:
s = "Null"
elif type_ == "bool" or type_ == "unlock":
s = text2bool(v)
elif type_ == "date":
val = util.dateDMAtoAMD(v)
if val is None:
s = "Null"
else:
s = "'%s'" % val
elif type_ == "time":
s = "'%s'" % v
elif type_ in ("uint", "int", "double", "serial"):
s = v
elif type_ in ("string", "stringlist"):
if v == "":
s = "Null"
else:
if type_ == "string":
v = auto_qt_translate_text(v)
if upper and type_ == "string":
v = v.upper()
s = "'%s'" % v
elif type_ == "pixmap":
if v.find("'") > -1:
v = self.normalizeValue(v)
s = "'%s'" % v
else:
s = v
# print ("PNSqlDriver(%s).formatValue(%s, %s) = %s" % (self.name_, type_, v, s))
return s
def formatValue(self, type_, v, upper):
util = FLUtil()
s = None
# if v == None:
# v = ""
# TODO: psycopg2.mogrify ???
if v is None:
s = "Null"
elif type_ == "bool" or type_ == "unlock":
s = text2bool(v)
elif type_ == "date":
val = util.dateDMAtoAMD(v)
if val is None:
s = "Null"
else:
s = "'%s'" % val
elif type_ == "time":
s = "'%s'" % v
elif type_ in ("uint", "int", "double", "serial"):
s = v
elif type_ in ("string", "stringlist"):
if v == "":
s = "Null"
else:
if type_ == "string":
v = auto_qt_translate_text(v)
if upper and type_ == "string":
v = v.upper()
s = "'%s'" % v
elif type_ == "pixmap":
if v.find("'") > -1:
v = self.normalizeValue(v)
s = "'%s'" % v
else:
s = v
# print ("PNSqlDriver(%s).formatValue(%s, %s) = %s" % (self.name_, type_, v, s))
return s
def formatValue(self, type_, v, upper):
util = FLUtil()
s = None
# TODO: psycopg2.mogrify ???
if type_ == "pixmap" and v.find("'") > -1:
v = self.normalizeValue(v)
if type_ == "bool" or type_ == "unlock":
if isinstance(v, str):
if v[0].lower() == "t":
s = 1
else:
s = 0
elif isinstance(v, bool):
if v:
s = 1
else:
s = 0
elif type_ == "date":
s = "'%s'" % util.dateDMAtoAMD(v)
elif type_ == "time":
if v:
s = "'%s'" % v
else:
s = ""
elif type_ in ("uint", "int", "double", "serial"):
if v is None:
s = 0
else:
s = v
else:
if type_ == "string":
v = auto_qt_translate_text(v)
if upper and type_ == "string":
v = v.upper()
# v = v.encode("UTF-8")
s = "'%s'" % v
# print ("PNSqlDriver(%s).formatValue(%s, %s) = %s" % (self.name_, type_, v, s))
return s
def formatValue(self, type_, v, upper):
util = FLUtil()
s = None
# TODO: psycopg2.mogrify ???
if type_ == "pixmap" and v.find("'") > -1:
v = self.normalizeValue(v)
if type_ == "bool" or type_ == "unlock":
if isinstance(v, str):
if v[0].lower() == "t":
s = 1
else:
s = 0
elif isinstance(v, bool):
if v:
s = 1
else:
s = 0
elif type_ == "date":
s = "'%s'" % util.dateDMAtoAMD(v)
elif type_ == "time":
if v:
s = "'%s'" % v
else:
s = ""
elif type_ in ("uint", "int", "double", "serial"):
if v:
s = 0
else:
s = v
else:
v = auto_qt_translate_text(v)
if upper and type_ == "string":
v = v.upper()
# v = v.encode("UTF-8")
s = "'%s'" % v
# print ("PNSqlDriver(%s).formatValue(%s, %s) = %s" % (self.name_, type_, v, s))
return s
