[web2py] pyDAL "adapter" for Pandas syntax (phylosophical)

2018-05-01 Thread Jurgis Pralgauskis
Hi, Pandas syntax seems very nice (short), and popular ... But Pandas eat RAM..., and well, most of data is in DB... so I wonder, how hard would it be to overload operators to use pyDAL (or other DAL/ORM)? what are the main challanges? -- Resources: - http://web2py.com - http://web2py.com/bo

[web2py] Re: Traceback for Python 3

2018-05-01 Thread lyn2py
Now I have an error like this one: RecursionError: maximum recursion depth exceeded while calling a Python object ...and I have no idea how to debug it, since I'm not using any recursion in my code. I suspect it's an issue with the module or modules (not written by me) I'm using, but I can't t

Re: [web2py] Re: How to iterate through column items and display its rows data

2018-05-01 Thread pbreit
I am very sorry, I need to be more careful with my replies. I wasn't sure if random needed to be imported but it looks like it does. So: import random rows = db(db.person.id>0).select() random_number = random.randrange(0, len(rows)) row = rows[random_number] return row -- Resources: - http://

Re: [web2py] Re: How to iterate through column items and display its rows data

2018-05-01 Thread Dave S
On Monday, April 30, 2018 at 9:04:57 PM UTC-7, Maurice Waka wrote: > > Now another error :invalid syntax: random _number = > random.randrange(0,rows.count()) > > Is the typo just in your post, or in the code you are trying? (Remove space between "random" and "_number"). /dps On Tue, 1 May 20

[web2py] Re: Displaying Uploaded PDF Documents

2018-05-01 Thread Michael Dunga
thank you. I needed it too On Wednesday, December 15, 2010 at 9:27:58 PM UTC+3, azarkowsky wrote: > > Thanks everybody for your suggestions! I went with what Bruno > suggested and it worked like a champ! I figured I wouldn't be able > to bypass the upload security mechanism, but the uploadfol

[web2py] Traceback for Python 3

2018-05-01 Thread lyn2py
Hello, I've started using python3 with web2py and it has saved me a lot of encoding headaches. However, the traceback Tickets in web2py are not as comprehensive as those in python2 with web2py. They look like: 'dict' object has no attribute 'content'Version web2py™ Version 2.16.1-stable+times

Re: [web2py] DAL return all Fields

2018-05-01 Thread Maurice Waka
Thanks. Doing that already. On Tue, 1 May 2018, 18:55 Richard Vézina wrote: > I really recommand you to go through this book chapiter : > > http://web2py.com/books/default/chapter/29/02/the-python-language > > You will learn a lot of thing over which you fall right now. > > You also can use type

Re: [web2py] DAL return all Fields

2018-05-01 Thread Richard Vézina
Are you querying multiple table?? You can do a join... That way you will have all the value for every fields the only catch is that when you join to disambiguate fields names dal use table.field instead of just field as field name so it migth happen that if you call "manually" vs "programmatically"

Re: [web2py] DAL return all Fields

2018-05-01 Thread Maurice Waka
Thanks. It iterates well giving some fields data, but not all as needed. I get data from some 4 fields only. I have about 60 in some db. Plus there is this: On Tue, 1 May 2018, 16:44 Richard Vézina wrote: > for f, v in row: > > Should be > > for f, v in row.iteritems(): > > k, v for key, value,

Re: [web2py] DAL return all Fields

2018-05-01 Thread Richard Vézina
for f, v in row: Should be for f, v in row.iteritems(): k, v for key, value, but I use f instead of k because you will have field_name and value in this for loop... Richard On Mon, Apr 30, 2018 at 11:39 PM, Maurice Waka wrote: > What would f, v be. > I get this error : ValueError : too many

[web2py] Re: Insert data in firebird database

2018-05-01 Thread Nico de Groot
You don’t need to use sqlexecute(), insert can handle multiple fields. But you do need to separate them with comma. In the field definitions you need to add the field type otherwise the default type is assumed (string). See the DAL documentation for details. Nico -- Resources: - http://web2py

[web2py] Re: Insert data in firebird database

2018-05-01 Thread Константин Комков
Thank you, as I understand web2py function INSERT have only one argument and if I want to pass 2 or more variables I should use something else? I have read about executesql and use it for inserting some variables like that: db.executesql('INSERT INTO table (var1, var2, var3) VALUES (1, 2, 3)') с