[web2py] db.Table no longer available in recent modularised DAL update

2014-10-07 Thread Calvin
Hi With the current version of Web2py (Version 2.10.0-beta+timestamp.2014.09.24.13.35.58), the following code standard_fields = db.Table(db, 'standard_fields', Field('created_on', 'datetime', default=request.now)) results in the following error being thrown: *** AttributeError: 'DAL' ob

[web2py] as

2014-10-07 Thread Ben Stuart
adasd -- 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 subscribed to the Google Groups "web2py-users" group. To

[web2py] mobile-menu nav is not is not working up on tablet

2014-10-07 Thread Joe
I am having a great time using web2py. I am grateful to all of you who created and contributed to this amazing framework. I just created my first app, I am learning as fast as I can! I hope someone can help me with this issue about the mobile navbar. The mobile-menu nav is not appearing in hori

[web2py] Re: mobile and tablet version responisive issues

2014-10-07 Thread Joe
Hi Leonel, thanks very much for your reply! I appreciate it. 1. I removed all my added CSS from the web2py.css, just kept the original, default web2py CSS and the horizontal view on the 7 inch Samsung is still the same, In any case, I have to work on the CSS and try to fix it, I will work it ou

[web2py] Passing variables from tables to JavaScript

2014-10-07 Thread Ben Stuart
Hi, I hope you're having a good one ;). I've some code; *db.py* *db.define_table('Customers',Field('customer_number','integer',unique=True,notnull=True,required=True),Field('first_name','string'),Field('family_name','string'),Field('flat_number','integer'),Field('street_number','inte

Re: [web2py] Re: Limit SQLFORM.grid results

2014-10-07 Thread Narūnas Krasauskas
Hi, Thanks for the reply. I just tested my notorious 38 sec query directly on the MySQL, and it also took nearly 40 sec to complete, so after all it was not web2py's fault :-) Further I also tested *cache_count* option, and indeed like you said, it does something very similar to what I need, t

[web2py] Re: SQLFORM.factory deletable field

2014-10-07 Thread José Eloy
Thanks Leonel. That's is working well. Regards El martes, 7 de octubre de 2014 16:50:27 UTC-5, José Eloy escribió: > > Hello! > > Is it possible to implement a SQLFORM.factory deletable field? I can't to > use the normal SQLFORM because I'm using keyed tables. > > The SQLFORM.factory I'm using

[web2py] Re: SQLFORM.factory deletable field

2014-10-07 Thread Leonel Câmara
You could add this to the factory Field('eliminar', 'boolean', default=False), -- 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 b

[web2py] SQLFORM.factory deletable field

2014-10-07 Thread José Eloy
Hello! Is it possible to implement a SQLFORM.factory deletable field? I can't to use the normal SQLFORM because I'm using keyed tables. The SQLFORM.factory I'm using is: form= SQLFORM.factory( Field('nombre', requires=[IS_NOT_EMPTY(), IS_UPPER(), IS_NOT_IN_DB(db2, 'unidades.nombre')

[web2py] Re: Sending very large forms....

2014-10-07 Thread Niphlod
web2py doesn't impose any limits ... you can have a "hosting" app that needs to receive 1GB file and you can have a data-entry app that needs 150 fields to be sent over the wire. Usually web2py is behind a webserver that has "sane" defaults that, in any case, NEED tuning on a per-app base. Miti

[web2py] Re: Web2py, Apache and Ubuntu 14.04

2014-10-07 Thread Brian M
Glad you got it working. The main developers should probably weigh in on whether or not the change to force SSL was intentional or if that just happens to have been in the last patch that Ivan submitted because he needed it for his own use. On Monday, October 6, 2014 12:19:41 AM UTC-5, mweissen

[web2py] Re: SQLFORM uploads with uploadfs and Amazon S3

2014-10-07 Thread Leonel Câmara
I think Mark has a point. The way Set.delete_uploaded_files is defined right now forces you to implement a custom_delete if you want to do this, I think it should use the field's uploadfs.remove if autodelete=True and you have set the field's uploadfs. We could put something like this in Set.de

[web2py] Sending very large forms....

2014-10-07 Thread Jason (spot) Brower
So in another framework I learned of a feature to limit that size of form submittions to stop DOS attacks. Is this something that web2py could/should worry about? There is the size of uploads and there is the number of form items. BR, Jason Brower -- Resources: - http://web2py.com - http://web2

Re: [web2py] Re: SQLFORM uploads with uploadfs and Amazon S3

2014-10-07 Thread Mark Graves
Hey Massimo, Yes, I was expecting it to delete the old files similar to a normal SQLFORM update for an upload field. Then, the new blob would be stored with the obfuscated file name. For example in the admin app, when you upload a new file, the old file is gone after the update completes. I'v

[web2py] Re: mobile and tablet version responisive issues

2014-10-07 Thread Leonel Câmara
1. What tablet are you testing this on, unless it's an old ipad, are you sure it only has 1024px? 3. Does your video tag has this controls="controls" in its attributes? Anyway these aren't really web2py problems, they're CSS problems. -- Resources: - http://web2py.com - http://web2py.com/book

[web2py] Re: Manual reset password link

2014-10-07 Thread Leonel Câmara
I canceled the previous pull request and made a cleaner one: https://github.com/web2py/web2py/pull/516 -- 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

[web2py] Re: Again: no module named ...

2014-10-07 Thread Leonel Câmara
This should be enough: from pretty import * -- 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 subscribed to the Go

[web2py] Again: no module named ...

2014-10-07 Thread Johann Spies
>From time to time this happens: python web2py.py -M -S akb2 web2py Web Framework Created by Massimo Di Pierro, Copyright 2007-2014 Version 2.10.0-beta+timestamp.2014.09.24.13.35.58 Database drivers available: SQLite(sqlite3), MySQL(pymysql), MySQL(MySQLdb), PostgreSQL(psycopg2), PostgreSQL(pg8000

[web2py] Re: Add Fields to tables using loops

2014-10-07 Thread Leonel Câmara
I urge you to follow Niphlod's advice. -- 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 subscribed to the Google

[web2py] Re: Add Fields to tables using loops

2014-10-07 Thread Niphlod
I'd urge you to consider a table with 2 fields, "date" and "user" instead. On Sunday, October 5, 2014 1:11:22 AM UTC+2, Nurendra Choudhary wrote: > > A calendar with flag for each user > > -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) - http://github.com/web2py/web2

Re: [web2py] Re: Limit SQLFORM.grid results

2014-10-07 Thread Niphlod
Those are not identical queries (constraints DO change, not only pagination). Again, select a from table limit 10 offset 0 and select a from table limit 10 offset 10 SHOULD DEFINITIVELY NOT have different execution times. And again, if you want 10 pages of 50 records, just pass paginate=50,

[web2py] Re: Scheduler always QUEUED and no record in scheduler_worker and scheduler_run data table

2014-10-07 Thread Niphlod
if ou delete the scheduler_task record, the corresponding records from scheduler_run will be deleted by the Foreign key constraint between scheduler_run and scheduler_task. You can verify it counting how many records are actually deleted by your deletion of scheduler_run: they should amount to

[web2py] Re: web2py resources

2014-10-07 Thread Gael Princivalle
Got it: http://vimeo.com/27478796 Il giorno lunedì 6 ottobre 2014 10:35:18 UTC+2, Gael Princivalle ha scritto: > > Hello. > > Is there a video tutorial that talk about the scheduler ? > > Thanks. > -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) - http://github.com/we

Re: [web2py] Re: looking for a way to import big csv data file into the database.

2014-10-07 Thread Michele Comitini
Kenny c, Keep using the COPY, it's the correct way for large datasets. Add the column list to the COPY command without the id column and be sure that the table has the id column is defined as SERIAL type. You can also try pgloader: http://pgloader.tapoueh.org/ 2014-10-07 4:27 GMT+02:00 Massimo D