let say i have table that will create a new table base on user input on
that table
*e.g.*
*models/db_schema_1_chart_of_account.py*
def __after_insert_chart_of_account(f, id):
name = f['name']
table_name = name.replace(' ','_').lower()
filename = os.path.join(request.folder, 'models', 'db_schema_3_%s.py') %
(table_name)
if not os.path.exists(filename):
define_table = "db.define_table('%s', detail_coa)" % (table_name)
file = open(filename, "w")
file.write('# -*- coding: utf-8 -*-')
file.write('\n')
file.write(define_table)
file.close()
*models/db_schema_2_account.py*
def __after_insert_account(f, id):
name = f['name']
query_ar = (db.chart_of_account.classification == 'Account Receivable')
row_ar = db(query_ar).select().last()
code_ar = int(row_ar.code) + 1
db.chart_of_account.insert(code = code_ar, name = 'Account Receivable %s' %
(name),
classification = 'Account Receivable')
query_ap = (db.chart_of_account.classification == 'Account Payable')
row_ap = db(query_ap).select().last()
code_ap = int(row_ap.code) + 1
db.chart_of_account.insert(code = code_ap, name = 'Account Payable %s' %
(name),
classification = 'Account Payable')
*controllers/install.py*
def index():
db.chart_of_account.bulk_insert([
{"code" : "110", "name" : "Account Receivable",
"classification" : "Account Receivable"},
{"code" : "200", "name" : "Account Payable",
"classification" : "Account Payable"},
] )
db.account.bulk_insert([
{"name" : "Account0"},
{"name" : "Account1"}, ] )
*Question :*
- is it best practice to do like example code above? tested it with small
data (install/index) but feel slow respond, because perhaps, the table in
models is load in every request, even the current data is small. any others
ideas?
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.
For more options, visit https://groups.google.com/d/optout.
