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