I'm quite new to Python and web2py hence when I started a little project for displaying some stats on a website I quickly got to points where I just got stack. I'll describe one hopefully someone would help with and provide some explanations. Basically it work but for the moment mostly manual which isn't that great. I define my table
db.define_table('table_1', Field('name',length=20,label='Name')... ... format='%(Name)s' ) ### then in Controler def stats(): db.table_1.id.readable = False db.table_1.stat1.represent = lambda value, row: stat(value)... ... return dict(stattable=SQLFORM.grid(db.table_1, .... This gives me a nice web page where I can display all my stats and modify them as needed. Then the need came to automate it somehow so I created a simple mySQL db where I feed my stats. New to databases so that was another challenge but I found a YT the basics of mySQL in 30 minutes :) Now I'd like to get the data from the external db to replace the values in w2p internal db where a row with the same name exists and add new rows where it doesn't. import mySQLdb def stat_db(): statdb = MySQLdb.connect(host=.... cur = statdb.cursor() ### I goggled this bit :) ### here are my internal db fields fields = db(db.table_1.id>0).select(db.tabela_1.name, distinct=True, orderby=db.table_1.name) ### and the external db rows cur.execute("select * from statdb") rows= cur.fetchall() So I suppose this gets all the rows from my external db but no idea how I would look for the right row in the internal db to replace the values. The common field in both db's is the 'name'. -- 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.