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

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

class DatabaseEngine(object):
	def sync(self):
		self.engine = create_engine('sqlite:///database.db')
		
		self.metadata = MetaData()
		product_table = Table('product', self.metadata,
			Column('name', String(30), primary_key = True),
			Column('category', String(30)),
			Column('fat', Integer),
			Column('protein', Integer),
			Column('carbo', Integer)
		)
		self.metadata.create_all(self.engine)
		mapper(Product, product_table)
	def createSession(self):
		Session = sessionmaker(bind = self.engine)
		session = Session()
		return session	

class Product(object):
	def __init__(self, name, category, fat, protein, carbo):
		self.name = name
		self.category = category
		self.fat = fat
		self.protein = protein
		self.carbo = carbo		
	def __repr__(self):
		return "<Product(%s, %s, %s, %s, %s)>"%(self.name, self.category, self.fat, self.protein, self.carbo)

class ProductManager(object):
	def __init__(self, engine):
		self.engine = engine
	def appendProduct(self, product):
	        session = self.engine.createSession()
		session.save(product)
		session.commit()
	def printProductList(self):
		session = self.engine.createSession()
		for each_product in session.query(Product):
			print each_product.name
	

engine = DatabaseEngine()
engine.sync()    # вызывать один раз при старте программы
manager = ProductManager(engine)
manager.appendProduct(Product('Mill', 1, 2, 3, 4))
manager.printProductList()

from sqlalchemy import MetaData, Table, Column, String, Integer, 
meta = MetaData() 
products = Table('products', meta,
            Column('name', String(30), primary_key = True),
            Column('category', String(30)),
            Column('fat', Integer),
            Column('protein', Integer),
            Column('carbo', Integer)
        )

from yourapp import schema
import sqlalchemy.orm as orm

Session = orm.scoped_session(orm.sessionmaker(autoflush=False))

class Base(object):
    def __init__(self, **kwargs):
        for key, value in kwargs.items():
            setattr(self, key, value)

class Product(Base):
    pass

Session.mapper(Product, schema.products)

import sqlalchemy as sa
from yourapp.mappings import Session, Product
from yourapp.schema import meta

def print_products(products):
    for p in products:
        print p

def bind_engine(engine):
    meta.bind = engine
    Session.configure(bind=engine)

def main(dburi):
    engine = sa.create_engine(dburi)
    bind_engine(engine)
    print_products(Product.query.all())

if __name__ == '__main__':
    main('sqlite:///yourapp.db')

class Some(object):
    def __init__(self, var1, attr2):
        self.var1 = var1
        self.attr2 = attr2

demas@laptop:~/sources/study/python/modules$ cat m1.py
print "1"

demas@laptop:~/sources/study/python/modules$ cat m2.py
import m1
print "2"

demas@laptop:~/sources/study/python/modules$ cat m3.py 
import m1
import m2
print "3"

demas@laptop:~/sources/study/python/modules$ python m3.py 
1
2
3