SQL Alchemy makes it easy to get types out of the database:<\/p>\n
\nfrom sqlalchemy import *\nengine = create_engine(\n \"postgresql+pg8000:\/\/postgres:postgres@localhost\/postgres\",\n isolation_level=\"READ UNCOMMITTED\"\n )\nc = engine.connect()\n \nmeta = MetaData()\n \nt = Table('table', meta, autoload=True, autoload_with=engine, schema='test')\n\ncolumns = [col for col in t.columns]\n<\/pre>\nAnd then from there, you can filter the column list down to things you want. <\/p>\n
\n\nimport sqlalchemy.sql.sqltypes\n\ndef useColumn(c):\n if (type(c.type) is TIMESTAMP):\n return False\n\n if (type(c.type) is VARCHAR):\n if (c.type.length == 24):\n return False\n\n if (type(c.type) is DATE):\n return False\n\n if (c.name.startswith(\"internal_\")):\n return False\n\n if (c.name == \"dont_use_me\"): \n return False\n\n return True\n<\/pre>\nFor certain columns, SQL Alchemy will give you an object that is a database specific type (e.g. there is a Postgres namespace), but you can find the exact class name:<\/p>\n
\ncolumns[0].type.__class__\n\n...sqlalchemy.sql.sqltypes.INTEGER\n<\/pre>\n","protected":false},"excerpt":{"rendered":"SQL Alchemy makes it easy to get types out of the database: from sqlalchemy import * engine = create_engine( “postgresql+pg8000:\/\/postgres:postgres@localhost\/postgres”, isolation_level=”READ UNCOMMITTED” ) c = engine.connect() meta = MetaData() t = Table(‘table’, meta, autoload=True, autoload_with=engine, schema=’test’) columns = [col for col in t.columns] And then from there, you can filter the column list down to … <\/p>\n