This is a DAL tool for MySQL database users to create applications using schema-free data structure.

1. Install from the pypi index. $ sudo pip install free4my

2. Clone source code from github with the following command:

   $ git clone https://github.com/ipconfiger/free4my.git
   $ sudo python setup.py install
   

1. Import necessary functions and classes:

   from free4my import DbContext, session_maker
   from free4my.Dynamic import DynamicBase, Column, Index, Lt, Gt, Lte, Gte, NotEq
   

2. Create a db context instance binding to a database connection:

   context = DbContext(
    host='127.0.0.1',
    user='db_user',
    password='db_password',
    database='db_name',
    )
   

3. Create a session factory instance binding to a db context:

   Session = session_maker(context)
   

4. Define the model class:

   class Author(DynamicBase):
    name = Column(unicode,max_length=20)
    password = Column(unicode,max_length=46)
    age = Column(int)
    regist_date = Column(datetime.datetime)
    class Meta:
    table_name = "author"
    by_regist = Index('regist_date', table_name="reg_time_idx_author")
    by_age = Index('age', table_name="age_idx_author")
   

5. Initialize database. This code will create tables nedded for structure Author:

   Author.objects.sync_table()
   

6. Open a session and play with it:

   db = Session()
   user = Author.objects.create(
    name=u'Alexander',
    password=u'pass',
    age=31,
    regist_date=datetime.datetime.now(),
    )
   user_list = Author.objects.by_regist.query(
    regist_date=Lte(datetime.datetime.now())
    ).order("-regist_date")
   for user in user_list:
    print user.name
   db.commit()
   

RTFC