[web2py] Re: auth tables not visible in appadmin

2015-11-15 Thread Red Beard
le and that > overrides the db variable from db.py > > On Wednesday, 4 November 2015 08:19:41 UTC-6, Red Beard wrote: >> >> Hi, >> >> My problem is that the auth tables do not appear in appadmin, though the >> system allows me to register users, and it seems to rem

[web2py] update_or_insert - Calculation when updating

2015-11-15 Thread Red Beard
Hi, I have only just started learning python and web2py so please bear with me. When a user inserts an item and amount in tr_items, I am trying to have the system check whether the item exists in products_summary, if it does, update the amount by the amount input by the user into tr_items - if

[web2py] Re: getting confused when running select on joined tables

2015-11-16 Thread Red Beard
Hey, My answer won't answer your question directly - but Massimo made some amazing videos which I came across the other day: https://vimeo.com/album/3016728 - check out no.10 and 11 for details on the DAL he goes into detail about queries etc. Being a complete beginner they have really helped

[web2py] Re: appadmin not updating: update=request.utcnow

2015-11-16 Thread Red Beard
Hey, I'm only just learning so this response may not be helpful?! The way I understand, appadmin is just a GUI for the database tables you have, so I don't think that is the problem.. The auth tables can keep track of: - created_on - created_by - modified_on - modified_by Add a

[web2py] auth tables not visible in appadmin

2015-11-04 Thread Red Beard
Hi, My problem is that the auth tables do not appear in appadmin, though the system allows me to register users, and it seems to remember them. I am following the example in the book (chapter 3, overview: http://www.web2py.com/books/default/chapter/29/03/overview) I have left the model db.py