Re: [web2py] fabric app

2015-09-04 Thread Massimo Di Pierro
I can confirm Niphlod was the first to deliver. Anyway, I will take a look at yours in the next few days. Meanwhile could you explain what yours does exactly? There is lots of code in there. Massimo On Friday, 4 September 2015 08:06:34 UTC-5, Carlos Cesar Caballero wrote: > > Well not so much,

[web2py] Re: An error occured, please reload the page

2015-09-04 Thread Annet
Hi Anthony, Anyway, this message should probably be optional or configurable -- maybe >> submit a github issue requesting that. >> > The message "An error occured, please reload the page" is a bit confusing, clicking reload the page doesn't resolve the error. When I go to http://127.0.0.1:8000

[web2py] Re: Web2py-Heroku: Relation "my_table" already exists

2015-09-04 Thread Massimo Di Pierro
You have to use get_db. Heroku has a non-reliable file system. It can be be reset at any time. By default web2py stores metadata about tables on the filesystem so if it is reset the information is lost and web2py thinks your table do not exist. get_db configures DAL for you to store all metadat

[web2py] Re: IS_IN_DB table in other database

2015-09-04 Thread Annet
Hi Anthony, Thanks for your reply. Did you try it and have a problem? Yes, I did. From your reply I concluded that I must have done something wrong. It took some time to figure out what the problem was, but it's all working fine now. Kind regards, Annet -- Resources: - http://web2py.com

[web2py] appconfig.ini

2015-09-04 Thread Annet
In appconfig.ini I have the following settings: ; db configuration [db] uri = postgres://:r@localhost:5432/database_name migrate = False migrate_enabled = False pool_size = 1 lazy_tables = True ignore_field_case = True and in db.py: myconf = AppConfig(reload=True) db = D

[web2py] Re: Web2py Restfull API Token authentication

2015-09-04 Thread Dave S
On Wednesday, September 2, 2015 at 1:15:48 AM UTC-7, Niphlod wrote: > > I'm back from holidays, JWT support is on the way to master repo. Stay > tuned, also because I have some experience with js frameworks but not with > Angular. We may tune the code for JWT to make Angular integration easy. If

Re: [web2py] SQL query equivalent in DAL

2015-09-04 Thread Dave S
On Friday, September 4, 2015 at 1:37:07 PM UTC-7, Anthony wrote: > > > (see, no "Field('name', 'reference othertable', ...)") >> > > Field('computer', db.pc) > > This is a reference to the "pc" table. > > Ooops! /dps "Location, location, location" -- Resources: - http://web2py.com - htt

[web2py] Re: Display value from reference fields and not ids in SQLFORM.grid

2015-09-04 Thread LoveWeb2py
And of course I find it within a minute of posting... lol Here is my solution: in model: db.define_table('table2', Field('field1','reference table1'), Field('field2','reference table1', requires=IS_IN_DB(db, db.table1.id, '%(field2)s')), migrate=False) in controller:

[web2py] Display value from reference fields and not ids in SQLFORM.grid

2015-09-04 Thread LoveWeb2py
I've been struggling with this for hours! db.define_table('table1', Field('field1', 'string'), Field('field2','date'), format='%(field1)s %(field2)s', migrate=False) db.define_table('table2', Field('field1','reference table1'), Field('field2','refe

Re: [web2py] SQL query equivalent in DAL

2015-09-04 Thread P T
Got it. I need to remove the initial db to make that into a query (~db.pc.id.belongs(db(db.assigned.id > 0)._select(db.assigned.id)) On Friday, September 4, 2015 at 3:37:50 PM UTC-5, P T wrote: > > Thank you Richard, your expression returns ROWS and can't be used in > SQLFORM.grid. When I rem

Re: [web2py] SQL query equivalent in DAL

2015-09-04 Thread P T
Thank you Richard, your expression returns ROWS and can't be used in SQLFORM.grid. When I removed the last select db(~db.pc.id.belongs(db(db.assigned.id > 0)._select(db.assigned.id)) then I get File "E:\web2py 2.9.12\gluon\sqlhtml.py", line 2139, in grid field_id = tables[0]._id IndexError:

Re: [web2py] SQL query equivalent in DAL

2015-09-04 Thread Anthony
> (see, no "Field('name', 'reference othertable', ...)") > Field('computer', db.pc) This is a reference to the "pc" table. Anthony -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) - http://github.com/web2py/web2py (Source code) - https://code.google.com/p/web2py/i

Re: [web2py] SQL query equivalent in DAL

2015-09-04 Thread Dave S
I'm puzzled about the why ... On Friday, September 4, 2015 at 12:42:32 PM UTC-7, Richard wrote: > > db(~db.pc.id.belongs(db(db.assigned.id > 0)._select(db.assigned.id > )).select(db.pc.ALL) > > Richard > > > > On Fri, Sep 4, 2015 at 3:35 PM, P T > > wrote: > >> >> Hello Forum, >> >> Please help m

Re: [web2py] SQL query equivalent in DAL

2015-09-04 Thread Richard Vézina
db(~db.pc.id.belongs(db(db.assigned.id > 0)._select(db.assigned.id )).select(db.pc.ALL) Richard On Fri, Sep 4, 2015 at 3:35 PM, P T wrote: > > Hello Forum, > > Please help me in getting the equivalent DAL query for the following SQL > query. I intend to pass this on to SQLFORM.grid > > Select

[web2py] SQL query equivalent in DAL

2015-09-04 Thread P T
Hello Forum, Please help me in getting the equivalent DAL query for the following SQL query. I intend to pass this on to SQLFORM.grid Select * from db.pc where db.pc.id not in (select unique db.assigned.computer from db.assigned) Web2Py Version 2.9.12-stable+timestamp.2015.02.15.23.04.25 (Run

Re: [web2py] Action when file streaming finishes

2015-09-04 Thread Niphlod
the problem with any approach is that the http hasn't really an event that signals that the file has been downloaded (and completed) successfully. The usual workaround is to put the location of the file on some list and remove it later by cycling the aforementioned list (say, every day or so).

Re: [web2py] 'module' object has no attribute 'startswith'

2015-09-04 Thread Richard Vézina
Could it be possible that you upgrade web2py but not the appadmin controller? Richard On Thu, Sep 3, 2015 at 3:01 AM, Johann Spies wrote: > We have an app working with a database on another server through an > ssh-tunnel. > > The app is working. But the admin app which worked previously sudden

Re: [web2py] fabric app

2015-09-04 Thread Carlos Cesar Caballero Díaz
Well not so much, I just join some snippets in my free time... I known fabric and is great, but I was looking for something more server-independent, it's slower than the Massimo request, but can work independently of the server configuration or OS. El 03/09/15 a las 14:50, Richard Vézina escr

Re: [web2py] Action when file streaming finishes

2015-09-04 Thread desta
Thank you for the reply. I learned something new today! os.tmpfile() seems very useful but I don't think I can apply it in my situation. The controller creates the file through an API call to a different server running on the system. As a response, the controller gets the file location. So it

Re: [web2py] Action when file streaming finishes

2015-09-04 Thread Yoel Benitez Fonseca
if it a temporary file create by os.tmpfile() you don't need to care about deleting it, the system will take care of everything for you. -- Yoel 2015-09-04 8:32 GMT-04:00, desta : > Hello, > > When the client clicks on a specific link, a temporary file is created by a > > controller which is then

[web2py] Action when file streaming finishes

2015-09-04 Thread desta
Hello, When the client clicks on a specific link, a temporary file is created by a controller which is then downloaded (using the `response.stream`). I want to delete the file after the download finishes. Could you please share any suggestions? Thank you. -- Resources: - http://web2py.com -