*modules/database_pydal*
def database():
    from pydal import DAL
    DB_URI = "sqlite://test.sqlite"
    db = DAL(DB_URI, pool_size = 1, migrate = True, 
             fake_migrate = False)
    return db

def table_customer():
    from pydal import Field
    from pydal.validators import IS_NOT_EMPTY
    db = database()
    db.define_table('customer', 
        Field('name', requires = IS_NOT_EMPTY() ), 
        Field('address', requires = IS_NOT_EMPTY() ) 
        )
    db.customer._enable_record_versioning()
    return db

def table_sales():
    from pydal import Field
    from pydal.validators import IS_NOT_EMPTY
    db = database()
    db.define_table('sales', 
        Field('sales_date', requires = IS_NOT_EMPTY() ), 
        Field('sales_no', requires = IS_NOT_EMPTY() ) 
        )
    db.sales._enable_record_versioning()
    return db

def tables_sales():
    db = database()
    db = table_customer()
    db = table_sales()
    return db

*controllers/default.py*
def tables_sales():
    from database_pydal import tables_sales
    query = (db['customer']['id'] > 0)
    rows = db(query).select().as_json()
    return rows

*objective*
modules tables_sales can load both table customer and table sales (similar 
to response.models_to_run)

*question*
how can achieve it using web2py way ?

thanks and best regards,
stifan

-- 
Resources:
- http://web2py.com
- http://web2py.com/book (Documentation)
- http://github.com/web2py/web2py (Source code)
- https://code.google.com/p/web2py/issues/list (Report Issues)
--- 
You received this message because you are subscribed to the Google Groups 
"web2py-users" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to web2py+unsubscr...@googlegroups.com.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/web2py/ec242f01-dee7-49d0-9447-070d83f97574n%40googlegroups.com.

Reply via email to