Python escape_string示例

示例#1

def getUserPIDs(conn, ignoreList):
    """dont count ourselves"""
    sql = """SELECT pid FROM pg_stat_activity WHERE pid != pg_backend_pid()"""
    if ignoreList:
        ignoreStr = ', '.join("'" + pg.escape_string(i) + "'"
                              for i in ignoreList)
        sql = sql + ' and application_name not in (' + ignoreStr + ')'

    return basicSQLExec(conn, sql)

示例#2

文件： backup_utils.py 项目： asimrp/gpdb

def check_schema_exists(schema_name, dbname):
    schemaname = pg.escape_string(schema_name)
    schema_check_sql = "select * from pg_catalog.pg_namespace where nspname='%s';" % schemaname
    if len(getRows(dbname, schema_check_sql)) < 1:
        return False
    return True

示例#3

文件： backup_utils.py 项目： asimrp/gpdb

def list_to_quoted_string(filter_tables):
    filter_string = "'" + "', '".join([pg.escape_string(t) for t in filter_tables]) + "'"
    return filter_string

示例#4

def list_to_quoted_string(filter_tables):
    filter_string = "'" + "', '".join(
        [pg.escape_string(t) for t in filter_tables]) + "'"
    return filter_string

示例#5

def check_schema_exists(schema_name, dbname):
    schemaname = pg.escape_string(schema_name)
    schema_check_sql = "select * from pg_catalog.pg_namespace where nspname='%s';" % schemaname
    if len(getRows(dbname, schema_check_sql)) < 1:
        return False
    return True