[web2py] Re: How to sort a join by count

2020-11-20 Thread Alex Glaros
Thanks for detailed responses Val, I appreciate it. On Saturday, November 14, 2020 at 4:51:06 PM UTC-8 valq...@gmail.com wrote: > I made even CTE+recursive: > https://github.com/web2py/pydal/issues/627 > > But have no time to make a PR > > воскресенье, 15 ноября 2020 г. в 03:41:24 UTC+3,

Re: [web2py] Re: Push Notifications

2020-11-20 Thread António Ramos
Yes you make an app in web2py that subscribes to one or many pusher notification channels. That channels are created by you in your html of your web2py app. your web2py server sends notifications to pusher.com using python code ,and your webpages subscribes the same notifications using

[web2py] Cron instead of Scheduler

2020-11-20 Thread Gaël Princivalle
Hi. I'm still having troubles to start a worker on Opalstack for my schedulers. I've this error: -- [myuser web2pyfolder]$ nohup env/bin/python web2py/web2py.py -K myapp & [1] 21916 [ myuser web2pyfolder ]$ nohup: ignoring input and appending output to ‘nohup.out’ [1]+ Exit 1

Re: [web2py] Re: Push Notifications

2020-11-20 Thread Christian Varas
Hi! I need to implement this and receive the notifications in the phone android/iOS. For this do I need to make my own app? Or do you use an app who can subscribe to push notifications in pusher.com ? This is off topic but any recommendation is appreciated Cheers. Chris El El vie, 20 de nov. de

Re: [web2py] Re: Push Notifications

2020-11-20 Thread mostwanted
Gratitude On Friday, November 20, 2020 at 10:33:10 AM UTC+2 Ramos wrote: > create a module inside web2py > API_Pusher.py > > import pusher > > def pusher_client(): > return pusher.Pusher( > app_id='yourid', > key='yourkey', >

Re: [web2py] How to pass variables to db.executesql?

2020-11-20 Thread Carlos Correia
On 20/11/20 04:56, Alex Glaros wrote: for example     where mytable.id = someWeb2PyVariable thanks, Alex Glaros -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) - http://github.com/web2py/web2py

[web2py] Re: How to pass variables to db.executesql?

2020-11-20 Thread Alex Beskopilny
myid = 10L sql_str = "xxx where id=%s;" % (str(myid)) db.executesql( sql_str ) examples: https://web2py.wordpress.com/tag/db-executesql/ On Friday, November 20, 2020 at 7:56:07 AM UTC+3 alexg...@gmail.com wrote: > for example > > where mytable.id = someWeb2PyVariable > > thanks, > >

[web2py] Re: Update dropdown list in SQLFORM.grid based on selection in another dropdown list

2020-11-20 Thread Tom Clerckx
OK, I was able to do it with SQLFORM.grid(), using jQuery by: * registering a change function on the #shelves_genre field * execute an XMLHttpRequest upon a change of #shelves_genre that updates the innerHTML of #shelves_shelve_items It would be nice however if something similar (registering

Re: [web2py] Re: Push Notifications

2020-11-20 Thread António Ramos
create a module inside web2py API_Pusher.py import pusher def pusher_client(): return pusher.Pusher( app_id='yourid', key='yourkey', secret='yoursecret', cluster='eu',