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
