def save(self, **kwargs): update = False if kwargs.get(self.get_pk_field(), False) == False: sqlQuery = "INSERT INTO " + str(self.__class__.__name__).lower() + " (" else: sqlQuery = "UPDATE " + str(self.__class__.__name__).lower() + " SET " update = True values = "" params = [] # Build up the values of the SQL Query for key in kwargs: if hasattr(self, key) == False: raise ModelException('Property: ' + key + ' does not exist') if key != self.get_pk_field(): if update == False: sqlQuery += key + "," values += "?," else: sqlQuery += "`" + key + "` = ?," params.append(kwargs[key]) # Join the query segments together if update == False: sqlQuery = sqlQuery[:-1] + ") VALUES (" + values[:-1] + ")" else: sqlQuery = sqlQuery[:-1] + " WHERE `" + self.get_pk_field() + "` = ?" params.append(kwargs[self.get_pk_field()]) query.query(sqlQuery, params) return True
def main(photo : bytes): # photo type must be base64 if type(photo) != bytes or len(photo) == 0: return {"status":"failed","details":"RequestTypeError"} # photo recognize result = recognize(photo) # query database details = query(result) return details # # 本地模拟检测 # import base64 # def readima(): # image = r'D:\Desktop\鹦鹉图谱 - 副本\山扇尾鹦鹉\山扇尾鹦鹉.jpg' # with open(image, 'rb') as f: # image = f.read() # return base64.b64encode(image) # a = main(readima()) # # print(json.loads(a)) # # print(type(a))
def make_file(filename, fields, fn): sss = "\\begin{table}[!hbt]\n\\centering\n\\begin{tabular}{|l|l|l|l|l|}" sss += "\hline\n & & $sunzd > 1.69$ & $1.69 < sunzd \\le 1.88$ & $sunzd > 1.88$ \\\\\n\hline\n" for d in dates: print d ss = d[2] for exp in [8, 40, None]: if exp == None: s = " & Any" else: s = " & " + str(exp) for condition in conditions: condition += " and time(image.time) != '23:48:00'" result = query(fields, cam="sky", exp=exp, dates=d[:2], condition=condition) a, b = fn(result) if b: percentage = 100*float(a)/b else: percentage = 0 s += " & %d/%d = %2.1f\\%%" % (a, b, percentage) if exp is None: s += "\\\\\n\hline\n" else: s += "\\\\\n\cline{2-5}\n" ss += s sss += ss f = open("/home/timl/thesis/" + filename, "w") f.write(sss) f.close() print sss
def query(self, fields, filter, image_id=None, star_id=None, condition=None): if filter: cam, exp, dates, zframes, cond, filts = self.parent.get_filters() else: cam, exp, dates, zframes, cond, filts = None, None, None, None, None, None if filts is None: filts = [] filts = " and ".join(filts) print "filts = ", filts if zframes == "No z-frames": z_cond = "time(image.time) != '23:48:00'" elif zframes == "only z-frames": z_cond = "time(image.time) = '23:48:00'" else: z_cond = "" condition = " and ".join([s for s in [cond, condition, filts, z_cond] if s]) if condition == "": condition = None print "condition here =", condition if image_id: image_id = self.get_image_id() if star_id: star_id = self.get_star_id() all_fields = [] for f in fields: all_fields += f.get_fields() return query(all_fields, cam=cam, exp=exp, dates=dates, condition=condition, image_id=image_id, star_id=star_id)
def get_password(request): if request.method == 'POST': user_name = request.POST.get('username') pw = request.POST.get('password') password = query(user_name) if pw == password: return HttpResponse('OK') return HttpResponse('0')
def save(self, **kwargs): update = False if kwargs.get(self.get_pk_field(), False) == False: sqlQuery = "INSERT INTO " + str( self.__class__.__name__).lower() + " (" else: sqlQuery = "UPDATE " + str( self.__class__.__name__).lower() + " SET " update = True values = "" params = [] # Build up the values of the SQL Query for key in kwargs: if hasattr(self, key) == False: raise ModelException('Property: ' + key + ' does not exist') if key != self.get_pk_field(): if update == False: sqlQuery += key + "," values += "?," else: sqlQuery += "`" + key + "` = ?," params.append(kwargs[key]) # Join the query segments together if update == False: sqlQuery = sqlQuery[:-1] + ") VALUES (" + values[:-1] + ")" else: sqlQuery = sqlQuery[:-1] + " WHERE `" + self.get_pk_field( ) + "` = ?" params.append(kwargs[self.get_pk_field()]) query.query(sqlQuery, params) return True
def make_file(filename, fields, fn): sss = "\\begin{table}[!hbt]\n\\centering\n\\begin{tabular}{|l|l|l|l|l|}" sss += "\hline\n & & $sunzd > 1.69$ & $1.69 < sunzd \\le 1.88$ & $sunzd > 1.88$ \\\\\n\hline\n" for d in dates: print d ss = d[2] for exp in [8, 40, None]: if exp == None: s = " & Any" else: s = " & " + str(exp) for condition in conditions: condition += " and time(image.time) != '23:48:00'" result = query(fields, cam="sky", exp=exp, dates=d[:2], condition=condition) a, b = fn(result) if b: percentage = 100 * float(a) / b else: percentage = 0 s += " & %d/%d = %2.1f\\%%" % (a, b, percentage) if exp is None: s += "\\\\\n\hline\n" else: s += "\\\\\n\cline{2-5}\n" ss += s sss += ss f = open("/home/timl/thesis/" + filename, "w") f.write(sss) f.close() print sss
def delete(self, id): query.query("DELETE FROM " + str(self.__class__.__name__).lower() + " WHERE " + self.get_pk_field() + " = ?", [id]) return True
def delete(self, id): query.query( "DELETE FROM " + str(self.__class__.__name__).lower() + " WHERE " + self.get_pk_field() + " = ?", [id]) return True