[web2py] Re: Can I use SQLFORM for get id row (only read)?

2019-09-11 Thread Константин Комков
It's work: if form.validate(): form.vars.id = db((db.tt_main.MODULE == form.vars.MODULE) & (db.tt_main.GROUP_ID == form.vars.GROUP_ID)).select(db.tt_main.id).first().id -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) - http://github.com/web2py/web2py (Source code)

[web2py] Re: How can I update the record in one table with value entry of another table as soon as the value is entered?

2019-09-11 Thread Dave S
On Tuesday, September 10, 2019 at 2:54:43 AM UTC-7, mostwanted wrote: > > I figured if I could update the amount field in db.product within the buy > functiontion just around the same time i'm saving inside the db.sale table > when purchasing then it should be easy but I am having a really hard

[web2py] Re: PythonAnywhere to AWS

2019-09-11 Thread Dave S
On Tuesday, September 10, 2019 at 12:47:40 AM UTC-7, Ian Ryder wrote: > > Hi all, I asked a question a while back about AWS and Nginx but didn't get > a reply so trying a different path! > > I've got an app I need to move over to AWS - does anyone know the easiest > way to get web2py up and runn

[web2py] Re: How do I solve this error: NameError: name 'person_id' is not defined in KPax2

2019-09-11 Thread Dave S
On Tuesday, September 10, 2019 at 1:31:11 PM UTC-7, Maurice Waka wrote: > > I'm trying out a surveys app from KPax2/surveys/take_survey.. > > > but got this error: > Traceback > > 1. > 2. > 3. > 4. > 5. > 6. > 7. > 8. > 9. > 10. > 11. > 12. > 13. > 14. > > Traceback (most recent call last): > F

[web2py] Re: Display value on a web page

2019-09-11 Thread Dave S
On Friday, September 6, 2019 at 7:17:29 PM UTC-7, Fabio Gubler wrote: > > I've realized the scheduler example shown on Vimeo video by M. Di Pierro > and it works properly. > Now I'd like to show the time value on the web page (with a view). > Could somebody give me an idea about how should I pro

[web2py] Re: 1215 Cannot add foreign key constraint

2019-09-11 Thread Dave S
On Tuesday, September 10, 2019 at 2:58:06 PM UTC-7, Steve wrote: > > Goodevening, > > I am trying to migrate from Sqite to MySQL. > Unfortunatly when restoring the field in the DB tables i get the following > error: > (1215, u'Cannot add > foreign key constraint') > location of issue: Field('

[web2py] Re: Can I use SQLFORM for get id row (only read)?

2019-09-11 Thread Dave S
On Wednesday, September 11, 2019 at 12:04:16 AM UTC-7, Константин Комков wrote: > > It's work: > if form.validate(): > form.vars.id = db((db.tt_main.MODULE == form.vars.MODULE) & (db. > tt_main.GROUP_ID == form.vars.GROUP_ID)).select(db.tt_main.id).first().id > I'm glad you were able to fin

Re: [web2py] Re: How do I solve this error: NameError: name 'person_id' is not defined in KPax2

2019-09-11 Thread Lovedie JC
I got this from web2py appliances apps. Just trying it out. Regards On Wed, 11 Sep 2019, 11:04 Dave S wrote: > > > On Tuesday, September 10, 2019 at 1:31:11 PM UTC-7, Maurice Waka wrote: >> >> I'm trying out a surveys app from KPax2/surveys/take_survey.. >> >> >> but got this error: >> Traceback

[web2py] Re: Whats the best way to create an Android or iOS app for web2py project

2019-09-11 Thread Dave S
On Friday, September 6, 2019 at 4:28:30 AM UTC-7, Rahul wrote: > > Hey Everyone, > I have some interesting questions (It might have been asked before) I > want to know - > > 1) Whats the best way to create an Android or iOS app for web2py project? > What's the goal? Do you want web2py run

[web2py] Re: Overiding the auth table ID fields to allow for release over pillars (Development, Acceptance, Production)

2019-09-11 Thread Davidiam
Thanks for your reply. Maybe override was not the best term. We can create the users using the userid and groupid as the ids in the user, group and membership tables, but as Web2Py out of the box creates an id (sequentially incremented) we are concerned that specifying a different id might hav

[web2py] Re: 1215 Cannot add foreign key constraint

2019-09-11 Thread Steve
Hi Dave, Thanks for your reply. When starting web2py again the DAL tries to create the tables but none of the tables are being created due to this error. Using a clean new version of a web2py app the tables are created and are of type innodb storage engine( as mentioned in the page you sent).

[web2py] Re: 1215 Cannot add foreign key constraint

2019-09-11 Thread Steve
Hi Dave, After performing a Fake_migration_all=True the Db files where created in de app/databases folder. So, in de admin i can see all of the tables. But, unfortunatly the tables where NOT created in the MySQL database. I can't find ou why not or how to fix this. Already went to the docum

[web2py] Re: Whats the best way to create an Android or iOS app for web2py project

2019-09-11 Thread Pbop
Suggest you google NSB/App Studio. A simple easy to use tool to create native iphone/droid apps. Other tools out there of course, but this has a manageable learning curve, Use Web2Py or Py4Web for server side back-end. On Friday, September 6, 2019 at 7:28:30 AM UTC-4, Rahul wrote: > > Hey Every

[web2py] Re: How to stopped redirection to user/login.html

2019-09-11 Thread Patito Feo
Hi, I had done tests using a new empty application and this works. My current application uses a customdb auth table and its using auth.settings.on_failed_authentication = lambda url: redirect(url) but with custom tables settings do not apply. Regards, El jueves, 22 de agosto de 2019, 19

[web2py] Re: How do I solve this error: NameError: name 'person_id' is not defined in KPax2

2019-09-11 Thread Massimo Di Pierro
wow that is a very old app. It has some good ideas but it also has bugs. It was a proof of concept. I believe person_id in that context should be session.person_id or auth.user.id But I cannot promise it will work with this change. On Tuesday, 10 September 2019 13:31:11 UTC-7, Maurice Waka wrot

[web2py] py4web has now a grid ...

2019-09-11 Thread Massimo Di Pierro
... it is incomplete. It is experimental. The API is subject to change. But I could use some community feedback: from py4web.utils.publisher import Publisher, ALLOW_ALL_POLICY # exposes services necessary to access the db via ajax publisher = Publisher(db, policy=ALLOW_ALL_POLICY) # expose a