当前位置: 首页>>代码示例>>Python>>正文


Python cx_Oracle.paramstyle方法代码示例

本文整理汇总了Python中cx_Oracle.paramstyle方法的典型用法代码示例。如果您正苦于以下问题:Python cx_Oracle.paramstyle方法的具体用法?Python cx_Oracle.paramstyle怎么用?Python cx_Oracle.paramstyle使用的例子?那么, 这里精选的方法代码示例或许可以为您提供帮助。您也可以进一步了解该方法所在cx_Oracle的用法示例。


在下文中一共展示了cx_Oracle.paramstyle方法的9个代码示例,这些例子默认根据受欢迎程度排序。您可以为喜欢或者感觉有用的代码点赞,您的评价将有助于系统推荐出更棒的Python代码示例。

示例1: query

# 需要导入模块: import cx_Oracle [as 别名]
# 或者: from cx_Oracle import paramstyle [as 别名]
def query(self, paramstyle=None):
        """
        Returns the query part of the sql query.
            >>> q = SQLQuery(["SELECT * FROM test WHERE name=", SQLParam('joe')])
            >>> q.query()
            'SELECT * FROM test WHERE name=%s'
            >>> q.query(paramstyle='qmark')
            'SELECT * FROM test WHERE name=?'
        """
        s = []
        for x in self.items:
            if isinstance(x, SQLParam):
                x = x.get_marker(paramstyle)
                s.append(safestr(x))
            else:
                x = safestr(x)
                # automatically escape % characters in the query
                # For backward compatability, ignore escaping when the query looks already escaped
                if paramstyle in ['format', 'pyformat']:
                    if '%' in x and '%%' not in x:
                        x = x.replace('%', '%%')
                s.append(x)
        return "".join(s) 
开发者ID:mqingyn,项目名称:torngas,代码行数:25,代码来源:basedb.py

示例2: __init__

# 需要导入模块: import cx_Oracle [as 别名]
# 或者: from cx_Oracle import paramstyle [as 别名]
def __init__(self, **keywords):
        if 'pw' in keywords:
            keywords['password'] = keywords.pop('pw')

        db_module = import_driver(["psycopg2", "psycopg", "pgdb"], preferred=keywords.pop('driver', None))
        if db_module.__name__ == "psycopg2":
            import psycopg2.extensions

            psycopg2.extensions.register_type(psycopg2.extensions.UNICODE)
        if db_module.__name__ == "pgdb" and 'port' in keywords:
            keywords["host"] += ":" + str(keywords.pop('port'))

        # if db is not provided postgres driver will take it from PGDATABASE environment variable
        if 'db' in keywords:
            keywords['database'] = keywords.pop('db')

        self.dbname = "postgres"
        self.paramstyle = db_module.paramstyle
        DB.__init__(self, db_module, keywords)
        self.supports_multiple_insert = True
        self._sequences = None 
开发者ID:mqingyn,项目名称:torngas,代码行数:23,代码来源:basedb.py

示例3: __init__

# 需要导入模块: import cx_Oracle [as 别名]
# 或者: from cx_Oracle import paramstyle [as 别名]
def __init__(self, **keywords):
        if 'pw' in keywords:
            keywords['password'] = keywords.pop('pw')
            
        db_module = import_driver(["psycopg2", "psycopg", "pgdb"], preferred=keywords.pop('driver', None))
        if db_module.__name__ == "psycopg2":
            import psycopg2.extensions
            psycopg2.extensions.register_type(psycopg2.extensions.UNICODE)

        # if db is not provided postgres driver will take it from PGDATABASE environment variable
        if 'db' in keywords:
            keywords['database'] = keywords.pop('db')
        
        self.dbname = "postgres"
        self.paramstyle = db_module.paramstyle
        DB.__init__(self, db_module, keywords)
        self.supports_multiple_insert = True
        self._sequences = None 
开发者ID:joxeankoret,项目名称:nightmare,代码行数:20,代码来源:db.py

示例4: __init__

# 需要导入模块: import cx_Oracle [as 别名]
# 或者: from cx_Oracle import paramstyle [as 别名]
def __init__(self, **keywords):
        if 'pw' in keywords:
            keywords['password'] = keywords.pop('pw')
            
        db_module = import_driver(["psycopg2", "psycopg", "pgdb"], preferred=keywords.pop('driver', None))
        if db_module.__name__ == "psycopg2":
            import psycopg2.extensions
            psycopg2.extensions.register_type(psycopg2.extensions.UNICODE)
        if db_module.__name__ == "pgdb" and 'port' in keywords:
            keywords["host"] += ":" + str(keywords.pop('port'))

        # if db is not provided postgres driver will take it from PGDATABASE environment variable
        if 'db' in keywords:
            keywords['database'] = keywords.pop('db')
        
        self.dbname = "postgres"
        self.paramstyle = db_module.paramstyle
        DB.__init__(self, db_module, keywords)
        self.supports_multiple_insert = True
        self._sequences = None 
开发者ID:Naayouu,项目名称:Hatkey,代码行数:22,代码来源:db.py

示例5: get_marker

# 需要导入模块: import cx_Oracle [as 别名]
# 或者: from cx_Oracle import paramstyle [as 别名]
def get_marker(self, paramstyle='pyformat'):
        if paramstyle == 'qmark':
            return '?'
        elif paramstyle == 'numeric':
            return ':1'
        elif paramstyle is None or paramstyle in ['format', 'pyformat']:
            return '%s'
        raise UnknownParamstyle, paramstyle 
开发者ID:mqingyn,项目名称:torngas,代码行数:10,代码来源:basedb.py

示例6: _param_marker

# 需要导入模块: import cx_Oracle [as 别名]
# 或者: from cx_Oracle import paramstyle [as 别名]
def _param_marker(self):
        """Returns parameter marker based on paramstyle attribute if this database."""
        style = getattr(self, 'paramstyle', 'pyformat')

        if style == 'qmark':
            return '?'
        elif style == 'numeric':
            return ':1'
        elif style in ['format', 'pyformat']:
            return '%s'
        raise UnknownParamstyle, style 
开发者ID:mqingyn,项目名称:torngas,代码行数:13,代码来源:basedb.py

示例7: _process_query

# 需要导入模块: import cx_Oracle [as 别名]
# 或者: from cx_Oracle import paramstyle [as 别名]
def _process_query(self, sql_query):
        """Takes the SQLQuery object and returns query string and parameters.
        """
        paramstyle = getattr(self, 'paramstyle', 'pyformat')
        query = sql_query.query(paramstyle)
        params = sql_query.values()
        return query, params 
开发者ID:mqingyn,项目名称:torngas,代码行数:9,代码来源:basedb.py

示例8: get_marker

# 需要导入模块: import cx_Oracle [as 别名]
# 或者: from cx_Oracle import paramstyle [as 别名]
def get_marker(self, paramstyle='pyformat'):
        if paramstyle == 'qmark':
            return '?'
        elif paramstyle == 'numeric':
            return ':1'
        elif paramstyle is None or paramstyle in ['format', 'pyformat']:
            return '%s'
        raise UnknownParamstyle(paramstyle) 
开发者ID:Naayouu,项目名称:Hatkey,代码行数:10,代码来源:db.py

示例9: _param_marker

# 需要导入模块: import cx_Oracle [as 别名]
# 或者: from cx_Oracle import paramstyle [as 别名]
def _param_marker(self):
        """Returns parameter marker based on paramstyle attribute if this database."""
        style = getattr(self, 'paramstyle', 'pyformat')

        if style == 'qmark':
            return '?'
        elif style == 'numeric':
            return ':1'
        elif style in ['format', 'pyformat']:
            return '%s'
        raise UnknownParamstyle(style) 
开发者ID:Naayouu,项目名称:Hatkey,代码行数:13,代码来源:db.py


注:本文中的cx_Oracle.paramstyle方法示例由纯净天空整理自Github/MSDocs等开源代码及文档管理平台,相关代码片段筛选自各路编程大神贡献的开源项目,源码版权归原作者所有,传播和使用请参考对应项目的License;未经允许,请勿转载。