#!/usr/bin/python

from sqlalchemy import create_engine
from sqlalchemy import Table, Column, Integer, String, MetaData, ForeignKey
from sqlalchemy import Sequence
from sqlalchemy.databases import mysql
from sqlalchemy.orm import mapper
from sqlalchemy.ext.declarative import declarative_base
from sqlalchemy.orm import sessionmaker


engine = create_engine('mysql://mschoechlin_test:schnappi@localhost/mschoechlin_test')
metadata = MetaData()


Base = declarative_base()
class User(Base):
    __tablename__ = 'users'
    id =  Column('id', Integer, Sequence('user_id_seq'), primary_key=True)
    name = Column('name', String(32))
    fullname = Column('fullname', String(32))
    password = Column('password', String(32))

    def __init__(self, name, fullname, password):
        self.name = name
        self.fullname = fullname
        self.password = password

    def __repr__(self):
       return "<User('%s','%s', '%s')>" % (self.name, self.fullname, self.password)

users_table = User.__table__
metadata = Base.metadata
metadata.create_all(engine)

Session = sessionmaker(bind=engine)
session = Session()

ed_user = User('ed', 'Ed Jones', 'edspassword')
session.add(ed_user)

our_user = session.query(User).filter_by(name='ed').first()
our_user.name = "babane"

print our_user

session.commit()