def get(self, language_version):
c, conn = connection()
sql = "SELECT * FROM `toilets`"
c.execute(sql, ())
toilets = c.fetchall()
toilets_dict = {}
toilets_dict["toilets"] = []
for toilet in toilets:
toilet_dict = {}
toilet_dict["toilet_id"] = toilet[0]
toilet_dict["price"] = toilet[1]
toilet_dict["open_times"] = get_open_times(c, toilet[0])
latitude = float(escape_item(toilet[2], 'utf8'))
longitude = float(escape_item(toilet[3], 'utf8'))
toilet_dict["coordinates"] = [latitude, longitude]
address_dict = {}
address_dict["main_address"] = toilet[4]
address_dict["sub_address"] = toilet[5]
toilet_dict["address"] = address_dict
toilet_dict["image_count"] = toilet[6]
toilets_dict["toilets"].append(toilet_dict)
conn.close()
return toilets_dict
def escape(self, obj):
""" Escape whatever value you pass to it"""
if isinstance(obj, str):
return "'" + self.escape_string(obj) + "'"
if isinstance(obj, bytes):
return escape_bytes_prefixed(obj)
return escape_item(obj, self._charset)
def escape_local_proxy(val, mapping):
"""Get current object and try to adapt it again."""
return converters.escape_item(
val._get_current_object(),
self.engine.dialect.encoding,
mapping=mapping,
)
def escape_local_proxy(val, mapping):
"""Get current object and try to adapt it again."""
return converters.escape_item(
val._get_current_object(),
self.engine.dialect.encoding,
mapping=mapping,
)
def q(s):
if isinstance(s, str):
return escape_string(s)
elif isinstance(s, unicode):
return escape_string(s).encode('utf-8')
elif isinstance(s, float):
return ('%.15g' % s)
elif isinstance(s, int):
return str(s)
else:
return escape_item(s, charset='utf-8')
def compile_query(query):
dialect = mysql_dialetct.dialect()
statement = query.statement
comp = compiler.SQLCompiler(dialect, statement)
comp.compile()
enc = dialect.encoding
comp_params = comp.params
params = []
for k in comp.positiontup:
v = comp_params[k]
if six.PY2 and isinstance(
v, six.string_types) and not isinstance(v, six.text_type):
v = v.decode("utf8")
v = escape_item(v, conversions, encoders)
params.append(v)
return (comp.string % tuple(params))
def _compile_query(query):
comp = query.statement.compile(dialect=mysql.dialect())
comp_params = comp.params
params = []
for k in comp.positiontup:
v = comp_params[k]
params.append(escape_item(v, conversions, encoders))
comp = comp.string
if "equity_preferred_stock" in comp:
if "equity_prefer_stock" in comp:
comp = comp.replace("fundamental_view.equity_prefer_stock,", "")
comp = comp.replace("equity_preferred_stock", "equity_prefer_stock as equity_preferred_stock")
elif "equity_prefer_stock" in comp:
warnings.warn("'equity_prefer_stock' has been deprecated, please use 'equity_preferred_stock'.")
return comp % tuple(params)
def compile_query(query):
""" 把一个 sqlalchemy query object 编译成mysql风格的 sql 语句 """
from sqlalchemy.sql import compiler
from sqlalchemy.dialects import mysql as mysql_dialetct
from pymysql.converters import conversions, escape_item, encoders
dialect = mysql_dialetct.dialect()
statement = query.statement
comp = compiler.SQLCompiler(dialect, statement)
comp.compile()
enc = dialect.encoding
comp_params = comp.params
params = []
for k in comp.positiontup:
v = comp_params[k]
if six.PY2 and isinstance(v, six.string_types) and not isinstance(v, six.text_type):
v = v.decode("utf8")
v = escape_item(v, conversions, encoders)
params.append(v)
return (comp.string % tuple(params))
def val(self, v, charset='latin1'):
return escape_item(v, charset)
def escape(self, obj, mapping=encoders):
if isinstance(obj, str):
return "'" + escape_string(obj) + "'"
return escape_item(obj, 'utf8mb4', mapping=mapping)
def escape(self, obj):
return escape_item(obj)
def escape(self, obj):
""" Escape whatever value you pass to it"""
if isinstance(obj, str):
return "'" + self.escape_string(obj) + "'"
return escape_item(obj, self._charset)
def escape(self, obj):
return escape_item(obj)
def literal(self, obj):
''' Alias for escape() '''
return escape_item(obj, self.charset)
def escape(self, obj):
''' Escape whatever value you pass to it '''
return escape_item(obj, self.charset)
def escape(obj, mapping=encoders): if isinstance(obj, str): return "'" + escape_string(obj) + "'" elif isinstance(obj, type(None)): return 'None' return escape_item(obj, 'utf8mb4', mapping=mapping)
