Python SQLAlchemy MySql Columns
Lets switch to SqlAlchemy to get columns
#!/bin/python27 from sqlalchemy import create_engine, Table from sqlalchemy.orm import scoped_session,sessionmaker from sqlalchemy.ext.declarative import declarative_base import sqlite3 class DBSession1(): def __init__(self): dbhost = "x" dbuser = "x" dbpass = "x" dbdbas = "x" self.engine1= create_engine('mysql://' + dbuser + ":" + dbpass + "@" + dbhost + "/" + dbdbas) self.Base1 = declarative_base() return None if __name__=="__main__": x = DBSession1() customers = Table('customer', x.Base1.metadata, autoload=True, autoload_with=x.engine1) print customers.columns
Once again, we get a list of columns.You will need to put your MySql database credential in for this to work, often times the host is localhost.
Here is a loop to look at even more information on the database columns. You can tack this onto the end of the code segment above.
for col in customers.columns: print col.name,col.type,col.nullable,col.primary_key,col.foreign_keys