[web2py] pyDAL - query records newer than a certain date

2017-09-25 Thread Terrence Brannon
Hello, I have the following query working in pure SQL on SQLite but do not know how to convert it to pyDAL: SELECT * FROM buy WHERE date('now','-2 days') < timestamp; The buy table schema is: CREATE TABLE "buy"( "id" INTEGER PRIMARY KEY AUTOINCREMENT, "order_id" CHAR(512), "market"

[web2py] Re: Insecure string Pickle with web2py 2.15.2

2017-09-25 Thread Mirek Zvolský
2.15.3-2017.08.07 I had same here, with SQLite too. I confirm it can be solved so: 1) rename databases/ to databases_corrupted/ 2) create empty folder databases/ 3) navigate to appadmin or main page -> database is now empty 4) copy databases_corrupted/sqlite.db back to databases/sqlite.db or so:

Re: [web2py] form replacing elements

2017-09-25 Thread Richard Vézina
Set proper validater in your models or create a custom validator or use a javascript plugin that behave has you would your input field to do in the front end as you collect the data in the way you want in the backend... Instead of asking why you try to use don't work, ask us how to do what you try

[web2py] Hiding fields in SQLForm but make them searchable AND usable within "links="

2017-09-25 Thread Francisco Ribeiro
This use case keeps on haunting me... :) Sometimes i want to hide columns from a smartgrid but I still want to be able to search for them AND use it within the SQLFORM links parameter, like the 'fingerprint' parameter in the following example: in model: db.define_table('mytable', Field('nam

[web2py] Broken backwards compatibility: Using a field in multiple tables yields error

2017-09-25 Thread Jordan Myers
I have many tables that share common attributes, so for convenience and ease of refactoring, I decided to define such common fields and then simply reference those fields when defining tables. For example: namefield = Field("name") db.define_table('table1', namefield) db.define_table('table2',

[web2py] JWT with ldap_auth and auth methods

2017-09-25 Thread Francisco García Claramonte
Hello all, I am using logging methods: ldap_auth (in 'ad' mode) and auth. My application logins perfectly from web auth form, validate with both methods, depending the order of them. I am using AuthJWT for remote access, from an Android mobile application. It works fine with local database. My

Re: [web2py] Re: move database to mongodb

2017-09-25 Thread Richard Vézina
Hello Steve, I had read about MongoDB for a project that I had in mind... When I see your thread first question come to mind is why porting relational database to mongo... In mongo you will have to design your database in a much different way then in and relational engine in order to make some ben

Re: [web2py] JWT with ldap_auth and auth methods

2017-09-25 Thread Richard Vézina
I think you can enforce that this way : auth.settings.login_methods = [ldap_auth(...)] as the only method... For instance I have : auth.settings.login_methods = [auth, ldap_auth(...)] So it check the password first in web2py then in Active Directory... I guess by removing the auth ad an authent

Re: [web2py] form replacing elements

2017-09-25 Thread Dave S
On Monday, September 25, 2017 at 9:35:04 AM UTC-7, Richard wrote: > Instead of asking why you try to use don't work, ask us how to do what you > try to achieve, it will be more productive. > > Except when the first response is "well, what did you try?" I think it's useful to say "I'm tyring

[web2py] Re: back button

2017-09-25 Thread Andrea Fae'
Thanks, but why this is working form.components.append(A('Indietro',_class='btn btn-default', _onclick="window.history.back()")) and this is not working? form.append(BUTTON('Indietro', _onclick="window.history.back()")) Il giorno lunedì 11 settembre 2017 01:06:00 UTC+2, Massi

Re: [web2py] form replacing elements

2017-09-25 Thread Dave S
On Monday, September 25, 2017 at 11:37:10 AM UTC-7, Dave S wrote: > > > > On Monday, September 25, 2017 at 9:35:04 AM UTC-7, Richard wrote: > > >> Instead of asking why you try to use don't work, ask us how to do what >> you try to achieve, it will be more productive. >> >> > Except when the f

Re: [web2py] Re: move database to mongodb

2017-09-25 Thread 黄祥
just want to learn about mongodb and how to use it with web2py, the same code is work in all rdms (tested in sqlite, mysql, postgre except change configuration db uri in appconf.ini and the executesql() create index for text field in mysql (minor) ) but when tested with nosql (first try with mo

Re: [web2py] Re: move database to mongodb

2017-09-25 Thread Dave S
On Monday, September 25, 2017 at 2:44:19 PM UTC-7, 黄祥 wrote: > > just want to learn about mongodb and how to use it with web2py, the same > code is work in all rdms (tested in sqlite, mysql, postgre except change > configuration db uri in appconf.ini and the executesql() create index for > tex

[web2py] "object_type" reserved word in web2py?

2017-09-25 Thread Alex Glaros
"object_type" reserved word in web2py? thanks Alex Glaros -- 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 subs

[web2py] directory structure of uploaded file

2017-09-25 Thread Rudy
Hi i am working to build a multi-tenant application which has a company table which stores logo and other data. I defined a company table, added extra fields in auth_user and created an action (simplified version) like below. web2py uploaded the logo image file under myapp/uploads/company.logo/