Re: [web2py] Setting up database table with date.

2015-10-21 Thread Johann Spies
On 20 October 2015 at 14:16, Garry Smith wrote: > group and stop receiving emails from it, send an email to > web2py+unsubscr...@googlegroups.com. > For more options, visit https://groups.google.com/d/optout. > Which database do you use and how is the date format specified in that database? Reg

Re: [web2py] Re: PostgreSQL

2015-10-21 Thread Johann Spies
Also look at this: http://www.dbta.com/Editorial/Trends-and-Applications/Best-Database-Overall%C2%AD-105362.aspx Regards Johann -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) - http://github.com/web2py/web2py (Source code) - https://code.google.com/p/web2py/issues/lis

Re: [web2py] Type Cast Field On The Fly

2015-10-21 Thread Johann Spies
On 20 October 2015 at 20:03, Benson Myrtil wrote: > Hey guys, > > I have a quick question. Does the DAL support type casting on the fly? I > am working with a legacy mssql 2008 database that I cannot alter. Within > this database it has a field of integers but the field type is string. When > I t

[web2py] Voting In Massimo's Week 2 Video

2015-10-21 Thread Joffrey Baratheon
In Massimo's week 2 video for Web2py, he went over a Reddit style app. He never explained how to implement the vote button even though he created the infrastructure for doing so. Has anyone successfully implemented them? I'm having a tough time with it. -- Resources: - http://web2py.com - http

[web2py] Re: Ask Web2py Groups: Has anyone here used web2py with JQuery Mobile?

2015-10-21 Thread Julieta Abdala
How I can load Layout.html or plugin_jqmobile/layout.html according with the client? I need to do 2 applications? One for pc and other for mobile? Thanks El sábado, 17 de septiembre de 2011, 10:45:19 (UTC-3), Pystar escribió: > > I would like to know if anyone here has used web2py with JQuery

[web2py] Type Cast Field On The Fly

2015-10-21 Thread Benson Myrtil
Hey guys, I have a quick question. Does the DAL support type casting on the fly? I am working with a legacy mssql 2008 database that I cannot alter. Within this database it has a field of integers but the field type is string. When I try to run the sum() function on that field I get ((u'42000'

[web2py] Enabling Google Sign-In

2015-10-21 Thread Joffrey Baratheon
Hello. I have been using Web2py for a little less than a month. I have an app/website that I made using Web2py that utilizes Python and HTML/CSS. It's very similar to the app that Massimo made in his week 1 tutorial video for Web2py. I am currently using the default login/sign up registration s

[web2py] Consultant needed for GAE, testing, single page app issues

2015-10-21 Thread Tom Campbell
I'm a novice web2py developer working on a scheduling app using Google App Engine and Google Cloud SQL. Am looking for specific help on things that are holding me up, notably: - General deployment issues regarding App Engine and Google SQL - Testing. At the moment just t

[web2py] Google Cloud SQL: Unable to connect

2015-10-21 Thread Tom Campbell
My app is named todo. I want to deploy it to GAE using Google Cloud SQL. Connection looks like this: if not request.env.web2py_runtime_gae: db = DAL(myconf.take('db.uri'), pool_size=myconf.take('db.pool_size', cast=int), check_reserved=['all']) else: db = DAL('google:sql://gigcity-1951:db

[web2py] Re: Replace 'Log in' text in auth.navbar by 'User'

2015-10-21 Thread Anthony
> > But it's puffery to say it's non-intuitive (totally subjective) > By non-intuitive I mean it tends to confuse a non-trivial number of users. This is not subjective, though I will grant that it is an empirical question for which we have only anecdotal evidence at this point (i.e., two devel

[web2py] Re: Replace 'Log in' text in auth.navbar by 'User'

2015-10-21 Thread Willoughby
You contribute more in a day to this project than I have in years of usage, so I'll defer. But it's puffery to say it's non-intuitive (totally subjective) and non-standard (when there is no standard). On Wednesday, October 21, 2015 at 3:31:06 PM UTC-4, Anthony wrote: > > On Wednesday, October 2

[web2py] Re: How to filter table data in field of SQLFORM.factory?

2015-10-21 Thread Anthony
If only a single value is allowed, why bother including that field in the form at all -- just use that value? Anthony On Wednesday, October 21, 2015 at 3:19:51 PM UTC-4, Fabiano Almeida wrote: > > Hi, > > How to filter table data in field of SQLFORM.factory? > > my code: > > form = SQLFORM.facto

[web2py] Re: Replace 'Log in' text in auth.navbar by 'User'

2015-10-21 Thread Anthony
On Wednesday, October 21, 2015 at 3:15:43 PM UTC-4, Willoughby wrote: > > It's a bare-bones starting point. Not meant to be a design philosophy. > Let's not go down the rabbit-hole of putting every button design up for a > vote > I don't see anything like that happening. Not every proposed U

[web2py] How to filter table data in field of SQLFORM.factory?

2015-10-21 Thread Fabiano Almeida
Hi, How to filter table data in field of SQLFORM.factory? my code: form = SQLFORM.factory( Field('cbPerson', label='Person', requires=IS_IN_DB(db,' auth_user.id','%(first_name)s %(last_name)s', zero=None), default= auth.user.id)) need show only db.auth_user.id == auth.user.i

[web2py] Re: Replace 'Log in' text in auth.navbar by 'User'

2015-10-21 Thread Willoughby
It's a bare-bones starting point. Not meant to be a design philosophy. Let's not go down the rabbit-hole of putting every button design up for a vote On Wednesday, October 21, 2015 at 3:03:59 PM UTC-4, Anthony wrote: > > Agreed, it probably would make more sense to have separate "Log in" and

[web2py] Re: Replace 'Log in' text in auth.navbar by 'User'

2015-10-21 Thread Anthony
Agreed, it probably would make more sense to have separate "Log in" and "Register" links in the navbar when not yet logged in. Maybe submit an issue. Anthony On Wednesday, October 21, 2015 at 2:53:00 PM UTC-4, Gael Princivalle wrote: > > >but this is an extremely unimportant and minor enhanceme

[web2py] Re: Replace 'Log in' text in auth.navbar by 'User'

2015-10-21 Thread Gael Princivalle
>but this is an extremely unimportant and minor enhancement I agree with you, but it's also an extremely easy enhancement to apply. And I've saw a lot of users don't understanding why when they click on "Log in" the website don't display the login form, but a dropdown menu with the ultimate com

Re: [web2py] issue with conditional columns in select with web2py dal query

2015-10-21 Thread Richard Vézina
Workaround it like that : if someflag: try: base_date = db.other_table.received_timestamp.date() except: base_date = db.other_table.date columns = [(db[table].date - base_date).avg().with_alias('avg_date')] # Works YEAH! else: columns = [(db[table].date - db.other_

[web2py] Re: GAE bitbucket mirror - ImportError: Cannot import module 'applications.init.modules.pydal'

2015-10-21 Thread James Burke
Thank you for your reply Leonel. Is that a setting in Google Developers Console? I think I remember seeing it somewhere but can't recall where! -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) - http://github.com/web2py/web2py (Source code) - https://code.google.com/p

[web2py] Re: GAE bitbucket mirror - ImportError: Cannot import module 'applications.init.modules.pydal'

2015-10-21 Thread Leonel Câmara
You need to use --recursive when you clone web2py from a git repository so you get PyDAL too. -- 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 receive

[web2py] issue with conditional columns in select with web2py dal query

2015-10-21 Thread Richard
Hello, I think I just hit a limitation with web2py dal select query build with conditions... Here the issue: if someflag: columns = [(db[table].date - db.other_table.received_timestamp.date()).avg().with_alias('avg_date')] # This one does work # Failed on : 'Field' object has no attr

[web2py] GAE bitbucket mirror - ImportError: Cannot import module 'applications.init.modules.pydal'

2015-10-21 Thread James Burke
I've just uploaded a simple app to GAE using the bitbucket mirror. Seems odd that it is looking for pydal in an applications modules... I get the same error with versions: Version 2.12.3 & Version 2.9.12 But I don't get the error deploying from GAE Launcher Unable to store in FILE: /base/data

[web2py] Re: Inserting in db and summing with default values

2015-10-21 Thread Carla Raquel
Well, it seems I had to add db.cTable.cost.*default *to make it work and retrieve the default value, as db.cTable.cost is a field object. The case is now closed,then. quarta-feira, 21 de Outubro de 2015 às 10:36:05 UTC+1, Carla Raquel escreveu: > > I'm trying to add(or update in case it isn't a

Re: [web2py] Re: PostgreSQL

2015-10-21 Thread Richard Vézina
Thanks for sharing! Richard On Wed, Oct 21, 2015 at 10:07 AM, Leonel Câmara wrote: > It's the only database I use in production. I see no reason to use > anything else really. > > -- > Resources: > - http://web2py.com > - http://web2py.com/book (Documentation) > - http://github.com/web2py/web2p

[web2py] Re: Submenu of submenu not working?

2015-10-21 Thread 黄祥
not sure which front ui you use in web2py, but i assume that you have a recent web2py scaffolding apps that use bootstrap 3 (it doesn't support submenu in those version). ref: https://groups.google.com/forum/#!topic/web2py/oh3AjsVkzEc best regards, stifan -- Resources: - http://web2py.com - h

[web2py] Submenu of submenu not working?

2015-10-21 Thread Carla Raquel
I want to implement a submenu of a submenu within Web2py, but as it is, no submenu of submenu 'Communications' is showing. Below is my code: response.menu = [] submenu=[] submenu2=[] response.menu += [[(SPAN(_class='glyphicon glyphicon-wrench',_style='padding:0px 5px;color:black;'),(T('Manag

[web2py] Re: PostgreSQL

2015-10-21 Thread Leonel Câmara
It's the only database I use in production. I see no reason to use anything else really. -- 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 thi

[web2py] PostgreSQL

2015-10-21 Thread Massimo Di Pierro
https://www.compose.io/articles/what-postgresql-has-over-other-open-source-sql-databases/ -- 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 thi

[web2py] Inserting in db and summing with default values

2015-10-21 Thread Carla Raquel
I'm trying to add(or update in case it isn't alreadythere) some records to a db in a loop and I want to fill the entries with the sum of the default db values with some other values, but somehow, when trying to insert,it's not working. It's something like this: db.cTable.update_or_insert((db.c

[web2py] Re: Ractive and Single Page Apps

2015-10-21 Thread p a
On Wednesday, October 21, 2015 at 8:33:09 AM UTC+2, Niphlod wrote: > > if all you want is not reloading the entire page (before going to "full > logic pushed on the client, server just sends the data over") pjax takes > maybe 4 lines of code. > That was not my experience. I had been using (or ab