#!/usr/bin/python
 
# very simple example of how to start using SQL Alchemy
 
from sqlalchemy import create_engine, Table, Column, Integer, String, MetaData
 
# sets up database connection pools
engine = create_engine('[insert SQL flavor here]://[db username]:[db password]@[ip address]/[db name]')
 
# bind the metadata to the connection
metadata = MetaData(engine)
 
# define table
books = Table('books', metadata,
	Column('id', Integer, primary_key=True),
	Column('title', String(255)),
	Column('author', String(255)))
 
# create table
books.create(bind=engine)
 
# if you're just testing and later want to drop the table
# books.drop(bind=engine)