[web2py] Re: datetime delta with Sqlite - how to?

2012-11-23 Thread apps in tables
I am using web2py 2.2.1 . I did import time in db.py still the error , epoch is not defined. What did i do wrong? Ashraf On Saturday, November 24, 2012 7:13:18 AM UTC+3, apps in tables wrote: > > sorry, I need to use 2.1.1 or above. > > On Saturday, November 24, 2012 6:57:33 AM UTC+3, apps in t

[web2py] Pylatte

2012-11-23 Thread Jaymin Oh
What a coincidence! I'm a friend of Pylatte developers. (we are in KAIST graduate school) It seems that they developed it for fun not for serious purpose. --

[web2py] Re: datetime delta with Sqlite - how to?

2012-11-23 Thread apps in tables
sorry, I need to use 2.1.1 or above. On Saturday, November 24, 2012 6:57:33 AM UTC+3, apps in tables wrote: > > Hi Niphlod, > > I got > > (global name 'epoch' is not defined) > > I am using version 2.0.9 > > What did i miss? > > Ashraf > > On Friday, November 23, 2012 1:54:31 AM UTC+3, Niphlod wro

[web2py] Re: datetime delta with Sqlite - how to?

2012-11-23 Thread apps in tables
Hi Niphlod, I got (global name 'epoch' is not defined) I am using version 2.0.9 What did i miss? Ashraf On Friday, November 23, 2012 1:54:31 AM UTC+3, Niphlod wrote: > > Mind that the functionality is database dependant, hence you won't get the > same results changing the db engine. Moreover

[web2py] Rails API

2012-11-23 Thread pbreit
We pretty much have this already, right? http://blog.steveklabnik.com/posts/2012-11-22-introducing-the-rails-api-project I think this approach to app development is only going to increase so having an easy, reliable, performant way to construct APIs is quite nice. --

[web2py] Re: How to get register_next to move on to the desired URL

2012-11-23 Thread Anthony
Does the dashboard page require login? If so, that's why it is redirecting to the login page. If you want the user to be logged in automatically after registration, you can do: auth.settings.login_after_registration = True Anthony On Friday, November 23, 2012 8:34:01 AM UTC-5, Daniele wrote:

[web2py] Re: Newbie: Cascading deletes with SQLFORM.grid and GAE

2012-11-23 Thread howesc
can you add some logging in and let us know if there are exceptions? about the delete limitations - web2py iterates over the set of items to delete and deletes them (the version in trunk is improved over the last release, but both still work). if the set of items to delete is large the query t

Re: [web2py] Re: powerTable AttributeError: 'DAL' object has no attribute 'virtual'

2012-11-23 Thread tomt
I run into the same problem. I don't have a solution other than removing the row from the represent statement when using powertable. example: db.acquisti.id_p.represent=lambda id: db.prodotti[id].nomeb or db.task.designer.represent = lambda value: db.staff[value].name The problem with this is

[web2py] powertable | insert JSFUNCTION in dtfeatures['fnFooterCallback']

2012-11-23 Thread palomar
Hi, I'm using the plugin powertable and I need to insert my JS funciont on the footer; the option to change is dtfeatures['fnFooterCallback'] but I have a problem to insert my JS function. What or where I have to insert it? Thanks... --

[web2py] Re: SQLFORM.factory unexpectedly sets id datatype to str

2012-11-23 Thread Mark Kirkwood
However you are correct that it is db related - if I remove the requires directive i.e: form=SQLFORM.factory( Field('dogid', 'integer') ) Then the form will post successfully (if I type in an integer). I did wonder if the lookup list was causing the types to be confused, so tr

[web2py] Re: SQLFORM.factory unexpectedly sets id datatype to str

2012-11-23 Thread Mark Kirkwood
I don't believe so, in sqlite the table id fields appear to be integer types. Just to be sure, I have retested against postgres. Same behavour. --

Re: [web2py] hidden fields ignored in form=crud.update()?

2012-11-23 Thread Marco Mansilla
This line here: ('ERROR','23502', 'null value in column "aboutid" violates not-null constraint') it seems that you have set a validator to one of the hidden fields, and since it doesn't seem to a have a default value either, then it's value on submit is null and therefore rejected... could you sh

[web2py] Re: Email upon registration not working

2012-11-23 Thread Daniele
Yes, basic emailing is working, and I do have that code in my db.py file. So if I do mail.send('email', 'title', 'body') it works. The reason I had so much trouble with this was because I set up my app using the wizard. The wizard created another file called 0.py (great name) that was overwritin

[web2py] Pylatte

2012-11-23 Thread Marco Mansilla
Does anyone has any thoughts about Pylatte, so far it seems to be the first Py3k supported web framework besides Pyramid http://www.pylatte.org/ which is wreid to me is the fact that is considered the second in the list and still lacks a lot of features, doesn't have an ORM or equivalent... --

[web2py] Re: Placing form into "table" with jQuery?

2012-11-23 Thread Niphlod
datatables does that. Basically inserts dinamically a td colspanning the entire row with a div holding whatever content you need http://datatables.net/release-datatables/examples/api/row_details.html On Friday, November 23, 2012 8:58:17 PM UTC+1, Joe Barnhart wrote: > > I want to achieve the effe

[web2py] Placing form into "table" with jQuery?

2012-11-23 Thread Joe Barnhart
I want to achieve the effect of an editable table. The implementation I want is a web2py form that gets moved into place beneath any row in a table when you click on the table row. In my imagination I see the user clicking on the row and the table contents beneath the row sliding down to revea

[web2py] Re: Sqlite3 to MySQL IntegrityError

2012-11-23 Thread Niphlod
did you inspect if indeed the data does fit the constraint you are imposing in your model? SQLite does a "shallow" check, so it's possible that even if you're indeed specifying in your model some costraint, it was not checked by SQlite. >From the error it seems that the row of the charon table

Re: [web2py] Re: powerTable AttributeError: 'DAL' object has no attribute 'virtual'

2012-11-23 Thread palomar
Thanks for your tips but I have one more problem: in my model I use represent to view the title instead of the ID of a linked table: #db.acquisti.id_p.represent=lambda id, row: db.prodotti[id].nomeb that (I think) generate this error whit powertable: (() takes exactly 2 arguments (1 given)) lin

Re: [web2py] Re: powerTable AttributeError: 'DAL' object has no attribute 'virtual'

2012-11-23 Thread palomar
i think response.files.append(URL(r=request,c='static',f='plugin_powertable/ui/css/%s/jquery-ui-1.8.24.custom.js')) ;) Il giorno giovedì 18 ottobre 2012 06:06:33 UTC+2, tomt ha scritto: > > After a little digging around on the web I found out why I was powertable > was generating errors with th

[web2py] Re: Proper way to reference logged user

2012-11-23 Thread Joe Barnhart
Why not create a group for each class -- tutor and student -- and assign group membership for each student? A student can participate in more than one group. It's easy to test for group membership -- just use the decorator: @auth.requires_membership('tutor') -- Joe B. On Tuesday, November

[web2py] Re: Virtual Fields on auth_user

2012-11-23 Thread Alex Benfica
Hi! I found this... https://groups.google.com/forum/?fromgroups=#!topic/web2py/77ei0yBbuhw Wil this feature be included again some day? Web2py is fine... and it is getting better each day! Em sexta-feira, 23 de novembro de 2012 16h57min33s UTC-2, Alex Benfica escreveu: > > Hi! > > I have t

[web2py] Re: Virtual Fields on auth_user

2012-11-23 Thread Alex Benfica
Hi! I have the same problem and the virtual fields availble on auth.user would save me 1 RPC call per request on App Engine. Is that a bug or is it the natural behavior!? I'm using web2py version 2.2.1! Thanks! Em sábado, 23 de abril de 2011 16h55min28s UTC-3, Gregory Hellings escreveu: > >

Re: [web2py] Database table prefix

2012-11-23 Thread Richard Vézina
Why exactly you change prefix? Installing differents apps dbs in the same db? Richard On Fri, Nov 23, 2012 at 10:57 AM, Chr_M wrote: > Hi, > > I am new to web2py and am migrating an application to web2py. All the > tables have a prefix that changes for the different deployments of the > applica

[web2py] Database table prefix

2012-11-23 Thread Chr_M
Hi, I am new to web2py and am migrating an application to web2py. All the tables have a prefix that changes for the different deployments of the application. Is there a way in web2py to have a prefix for all the tables in the database that I can change easely for different deployments? At this

[web2py] Re: Email upon registration not working

2012-11-23 Thread Massimo Di Pierro
To send emails you need to connect an SMTP server. For example, to send emails using your google mail account mail = auth.settings.mailer mail.settings.server = 'smtp.gmail.com:587' mail.settings.sender = 'y...@gmail.com' mail.settings.login = 'y...@gmail.com:password' Do you have similar code?

[web2py] Sqlite3 to MySQL IntegrityError

2012-11-23 Thread Remco K
Hi everyone, I've been spending all day to migrate my sqlite3 database to a MySQL database. I've tried multiple options but i always get the following, in the end: IntegrityError: (1452, u'Cannot add or update a child row: a foreign key constraint fails (`charon`.`deviceservices`, CONSTRAINT

Re: [web2py] Re: nginx+uwsgi and ubuntu 12.10

2012-11-23 Thread Richard
Anything new in trunk about nginx script except Bruno's optimization for 12.04?? I try with the make work nginx under 12.10 with the explanation of Roberto De Loris without success. I install with pip uswgi, I remove the ubuntu uwsgi package... Then I create a file in /etc/init/uwsgi-emperor w

Re: [web2py] Re: Bug? Invalid url puts python into a tight loop - 100% CPU

2012-11-23 Thread jc
The fix certainly works for me. And thanks, it's taken me a while to understand what Jonathan has been trying to tell me about changing the regex in routes.py. In fact it could hardly be simpler. However I think the revised regex is a much better default. On Wednesday, 21 November 2012 16:23:5

[web2py] Re: Password Change, not checking if old password is valid.

2012-11-23 Thread Rob_McC
M: >Please open a ticket and I will look into this asap . *DONE:* http://code.google.com/p/web2py/issues/detail?id=1180 Many thanks, I hope this is the right procedure for trouble tickets, i.e. discuss on Google Groups first (in case it is an error on my part) ... Then, submit ticket if it loo

[web2py] Email upon registration not working

2012-11-23 Thread Daniele
Hello all, I'm wondering why I cannot get the email upon registration to work. I've finally gotten basic emailing to work, but it doesn't seem to send anything automatically upon user registration. Here's my db.py file: from gluon.tools import Auth, Crud, Service, PluginManager, prettydate auth

[web2py] Re: Automatic login if username contains @ : Is this normal ?

2012-11-23 Thread Massimo Di Pierro
Good catch. I added your patch to trunk. On Friday, 23 November 2012 05:31:17 UTC-6, demetrio wrote: > > I made some progress on this issue. > > If ldap_mode is set to None, it always access and creates the user. > > Then I set ldap_mode to 'uid' and the @ issue doesn't happen more. But > there i

[web2py] Re: Orderby does not work field type 'double', sorts as if floats were strings

2012-11-23 Thread Massimo Di Pierro
Try this: rows = db(db.song_table).select() for x in rows.sort(lambda row: row.scores): print x.scores Only the selected ones will be sorted. On Thursday, 22 November 2012 18:25:13 UTC-6, Mark Li wrote: > > Ahh thanks Niphlod! > > On Thursday, November 22, 2012 2:49:28 PM UTC-8, Niphlod wro

[web2py] Re: SQLFORM.factory unexpectedly sets id datatype to str

2012-11-23 Thread Massimo Di Pierro
This is a sqlite issue probable. You you stored string in there and then you change the type, there are still strings in there. On Thursday, 22 November 2012 18:21:02 UTC-6, Mark Kirkwood wrote: > > Thanks, Niphlod - However amending the form definition as you suggested, > i.e: > > form=SQLF

[web2py] Re: Password Change, not checking if old password is valid.

2012-11-23 Thread Massimo Di Pierro
Please open a ticket and I will look into this asap. On Thursday, 22 November 2012 16:48:10 UTC-6, Rob_McC wrote: > > Hey: > > Been doing a lot of testing lately... > > It appears that Password Change should be checking OLD password, > > Here are the details of my tests: > > *Using*: > web2py > V

[web2py] Re: How to get register_next to move on to the desired URL

2012-11-23 Thread Daniele
I still cannot get this to work. Any tips? On Sunday, November 18, 2012 10:51:14 PM UTC, Daniele wrote: > > Hey guys, I would like to set register_next to move on to a URL upon > successful registration. However, it seems to be redirecting me to the > login page right now. I believe this is beca

[web2py] Re: SQLFORM.grid join repeats parent's data in table.

2012-11-23 Thread Michael Hall
Hiya This works a treat thanks. Mike On Thursday, 22 November 2012 14:32:38 UTC, Alan Etkin wrote: > > > On Thursday, November 22, 2012 9:07:23 AM UTC-3, Michael Hall wrote:I > have the following code for my join in SQLFORM.grid: > > Perhaps you can pass something like this to .grid(): > > fiel

[web2py] Re: Automatic login if username contains @ : Is this normal ?

2012-11-23 Thread demetrio
I made some progress on this issue. If ldap_mode is set to None, it always access and creates the user. Then I set ldap_mode to 'uid' and the @ issue doesn't happen more. But there is a little bug in exception handling in the ldap login method, because if the user exists but the password is inc

[web2py] Re: datetime delta with Sqlite - how to?

2012-11-23 Thread dederocks
Thank you so much -- saved quite a bit of work! With much appreciation, Andre Le jeudi 22 novembre 2012 23:54:31 UTC+1, Niphlod a écrit : > > Mind that the functionality is database dependant, hence you won't get the > same results changing the db engine. Moreover you get different "rounding" >