Be careful with legacy databases! You can do involuntary changes by
db.define_table(), to avoid this use migrate=False.
If you're going to read only (i.e. only select-query), connect to DB using
limited user/role account
On Saturday, February 13, 2016 at 1:01:36 AM UTC+3, yarecki wr wrote:
>
> 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 [email protected].
For more options, visit https://groups.google.com/d/optout.
