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 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 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)