我们从Python开源项目中，提取了以下11个代码示例，用于说明如何使用sqlalchemy.dialects.postgresql.INTEGER。
def autogen_column_reflect(self, inspector, table, column_info): if column_info.get('default') and \ isinstance(column_info['type'], (INTEGER, BIGINT)): seq_match = re.match( r"nextval\('(.+?)'::regclass\)", column_info['default']) if seq_match: info = inspector.bind.execute(text( "select c.relname, a.attname " "from pg_class as c join pg_depend d on d.objid=c.oid and " "d.classid='pg_class'::regclass and " "d.refclassid='pg_class'::regclass " "join pg_class t on t.oid=d.refobjid " "join pg_attribute a on a.attrelid=t.oid and " "a.attnum=d.refobjsubid " "where c.relkind='S' and c.relname=:seqname" ), seqname=seq_match.group(1)).first() if info: seqname, colname = info if colname == column_info['name']: log.info( "Detected sequence named '%s' as " "owned by integer column '%s(%s)', " "assuming SERIAL and omitting", seqname, table.name, colname) # sequence, and the owner is this column, # its a SERIAL - whack it! del column_info['default']
def autogen_column_reflect(self, inspector, table, column_info): if column_info.get('default') and \ isinstance(column_info['type'], (INTEGER, BIGINT)): seq_match = re.match( r"nextval\('(.+?)'::regclass\)", column_info['default']) if seq_match: info = inspector.bind.execute(text( "select c.relname, a.attname " "from pg_class as c join pg_depend d on d.objid=c.oid and " "d.classid='pg_class'::regclass and " "d.refclassid='pg_class'::regclass " "join pg_class t on t.oid=d.refobjid " "join pg_attribute a on a.attrelid=t.oid and " "a.attnum=d.refobjsubid " "where c.relkind='S' and c.relname=:seqname" ), seqname=seq_match.group(1)).first() if info: seqname, colname = info if colname == column_info['name']: log.info( "Detected sequence named '%s' as " "owned by integer column '%s(%s)', " "assuming SERIAL and omitting" % ( seqname, table.name, colname )) # sequence, and the owner is this column, # its a SERIAL - whack it! del column_info['default']
def test_no_attributes(self): expected = [] result = list(get_type_attributes(INTEGER())) self.assertEqual(expected, result)
