Python-сообщество

#! /usr/bin/python
# -*- coding: utf-8 -*-

import sqlalchemy
from sqlalchemy import create_engine
from sqlalchemy import Table, Column, Integer, String, MetaData, ForeignKey
from sqlalchemy.orm import mapper
from sqlalchemy.orm import sessionmaker
from sqlalchemy import ForeignKey
from sqlalchemy.orm import relation

class User(object):
      def __init__(self, name, fullname):
            self.name = name
            self.fullname = fullname

engine = create_engine('sqlite:///tutorial.db', echo = True)
Session = sessionmaker(bind = engine, autoflush=True, transactional = True)
metadata = MetaData()

users_table = Table('users', metadata,
      Column('name', String(40), primary_key = True),
      Column('fullname', String(100)))

metadata.create_all(engine)
mapper(User, users_table)
session = Session()

print "=========== Insert =============="

ed_user = User('ed', 'Ed Jones')
session.save(ed_user)
session.commit()

print "=========== Select =============="
new_user = session.query(User).filter_by(name='ed').first()
print new_user.name

print "=========== Strange Delete ============="
session = Session()
newUser = User('ed', 'Ed Jones')
session.query(User).filter_by(name = newUser.name).delete()
session.flush()
session.commit()