[web2py] Autologin via janrain?

2012-05-21 Thread Rene Dohmen
Hi List, I'm building an app where users can make quiz content together; login via janrain (only facebook provider). We also have a small iOS app (game) to test the quiz content; it reads the data from a xml that is composed on the fly by a controller function. Is there an easy way to authenticat

[web2py] Mysql reserved words in a legacy db

2012-06-20 Thread Rene Dohmen
idn't experience any problems with a field "group" in a mysql table. It would be cool if there is a way to loosen the restrictions on reserved keywords on a per app basis. Kind Regards Rene Dohmen

Re: [web2py] Quoting reserved words in DAL

2012-06-20 Thread Rene Dohmen
I'm having the same problem: https://groups.google.com/d/msg/web2py/hCsxVaDLfT4/K6UMbG5p5uAJ On Mon, Jun 18, 2012 at 9:30 AM, Michael Toomim wrote: > I just got bit by the reserved-word problem: > https://groups.google.com/d/msg/web2py/aSPtD_mGXdM/c7et_2l_54wJ > > I am trying to port a postgres

Re: [web2py] Re: Mysql reserved words in a legacy db

2012-06-21 Thread Rene Dohmen
groupnames from the linked_table. >> >> In the documentation on >> >> http://www.web2py.com/examples/static/epydoc/web2py.gluon.reserved_sql_keywords-pysrc.html >> it says that "GROUP" is a keyword. >> Is there a way to force the DAL to quote the fieldNames in its insert >> and update query's? With our previous framework we didn't experience >> any problems with a field "group" in a mysql table. >> It would be cool if there is a way to loosen the restrictions on >> reserved keywords on a per app basis. >> >> Kind Regards >> >> Rene Dohmen --

Re: [web2py] Re: Mysql reserved words in a legacy db

2012-06-21 Thread Rene Dohmen
es me a ticket. >> >> Viewing the record is no problem. It even shows the dropdown with >> >> groupnames from the linked_table. >> >> >> >> In the documentation on >> >> >> >> http://www.web2py.com/examples/static/epydoc/web2py.gluon.reserved_sql_keywords-pysrc.html >> >> it says that "GROUP" is a keyword. >> >> Is there a way to force the DAL to quote the fieldNames in its insert >> >> and update query's? With our previous framework we didn't experience >> >> any problems with a field "group" in a mysql table. >> >> It would be cool if there is a way to loosen the restrictions on >> >> reserved keywords on a per app basis. >> >> >> >> Kind Regards >> >> >> >> Rene Dohmen > > -- --

[web2py] Re: SQLFORM.grid and joins

2013-03-01 Thread Rene Dohmen
Hi Massimo, We did print the t-shirt ourselves ;-) I'll send you one. Kind Regards, Rene On Thursday, February 28, 2013 6:06:56 PM UTC+1, Massimo Di Pierro wrote: > > Where did you get that? I want one. > -- --- You received this message because you are subscribed to the Google Groups "we

[web2py] Small error in current online web2py book

2013-03-08 Thread Rene Dohmen
I don't know if this is the correct place to post this: http://www.web2py.com/book/default/chapter/01#security Serves me: invalid function (default/chapter) Original page: http://web2py.com/init/default/what (containing the link) Greets Rene -- --- You received this message because you are

[web2py] Missing dumps() in rss2 contrib

2012-11-19 Thread Rene Dohmen
Hi All, i'm running web2py 2.2.1 When I try to return a rss with the generic.rss view or when I try to follow example http://www.web2py.com/examples/simple_examples/rss_aggregator It serves a ticket with: 'module' object has no attribute 'dumps' The gluon/contrib/rss2 -> doesn't have a dumps m

[web2py] scheduler problem in trunk when using datetime as return value?

2012-12-10 Thread Rene Dohmen
Hi, I like the new scheduler concept a lot. It looks promising. Something goes wrong when I try to return a datetime in the method I wanted to schedule... A Simple JSON parsing error -- raise TypeError(repr(o) + " is not JSON serializable") TypeError: datetime.datetime(2012, 12, 10, 15, 57, 59, 3

[web2py] Routes.py and janrain login

2012-02-01 Thread Rene Dohmen
Hi List, I've installed mod_wsgi on our server and added a vhost so that each application is accessible via www.examples.com/app_name One of the apps is ready; so I created another vhost and started an separate instance of web2py. The second instance uses a routes.py to remove the appname from th

[web2py] Re: Routes.py and janrain login

2012-02-13 Thread Rene Dohmen
s why it didn't work the 1st time R On Feb 2, 2:51 am, Rene Dohmen wrote: > Hi List, > > I've installed mod_wsgi on our server and added a vhost so that each > application is accessible viawww.examples.com/app_name > > One of the apps is ready; so I created another

[web2py] Web2py support the netherlands

2012-03-15 Thread Rene Dohmen
his is the correct place to request it) Kind Regards, Rene Dohmen

[web2py] Re: Web2Py Pages module (basic CMS)

2013-11-19 Thread Rene Dohmen
Hi List, Ruud, thanks for sharing. :) I'll build a w2p plugin from it at the end of this week. We are still testing it; and need to upgrade fancy box to fancybox2. Kind Regards, Rene On Wednesday, November 20, 2013 12:06:47 AM UTC+1, Ruud Schroen wrote: > > Also i forgot to mention: > > The ap

[web2py] Re: Is there a plan to put an official image of web2py on Docker?

2017-01-27 Thread Rene Dohmen
An official package would be souper douper :) I'm now running with: thehipbot/web2py which run fine: Nginx, Uwsgi emperror and Web2py It will use latest web2py version from source. On Tuesday, September 27, 2016 at 5:00:55 AM UTC+2, JorgeH wrote: > > It would be a great idea. > > To have one wi

[web2py] janrain login not working anymore?

2013-12-20 Thread Rene Dohmen
Hi, We use the janrain login method in a couple of our webapps. As of today it suddenly stopped working... Are there any other users that use the janrain login methods? (and have it working?) On the janrain site I found a story about and old and a new way to use janrain. The Iframe way seems

[web2py] Setting DAL less strict from a model

2014-02-04 Thread Rene Dohmen
Hi Web2py-users, I have developed a CMS kind of system based on web2py. https://github.com/acidjunk/web2py-pages I actually want to provide a release as a w2p file on a regular basis, so it can be used more easily. But I'm running into a problem if I don't overwrite any core web2py app files.

Re: [web2py] Setting DAL less strict from a model

2014-02-06 Thread Rene Dohmen
> parameters: > > DAL(., entity_quoting=True) after that you should have no conflict > with reserved SQL words. > You should be able to use any name, e.g. do things like > define_table('table', Field('select'), Field('update')) > > Let us

Re: [web2py] Setting DAL less strict from a model

2014-02-08 Thread Rene Dohmen
gards Rene On Thursday, February 6, 2014 7:03:29 PM UTC+1, Rene Dohmen wrote: > > Hi Mic, > > I will test it later on. But i'm not sure how this would solve the > problem; I still need to remove the check_reserved from the DAL connection > string. > The goal is to NOT c

Re: [web2py] Setting DAL less strict from a model

2014-02-14 Thread Rene Dohmen
/acidjunk/web2py-pages is now working without touching your web2py code. A .w2p plugin will be released soon. Kind regards, Rene On Sunday, February 9, 2014 1:55:46 AM UTC+1, Rene Dohmen wrote: > > Hi, > > Just checked with trunk > Version 2.8.2-stable+timestamp.2014.01.30.08.43.1

[web2py] Re: New to Web2Py: Large Model

2014-02-14 Thread Rene Dohmen
You could use extract_mysql_models.py (in the web2py/scripts folder) On Wednesday, February 12, 2014 4:58:29 PM UTC+1, Juslin Guo wrote: > > Hi, > > I have an application in PHP with 500 over tables, what's the best way to > managed them in Web2Py, without repeating model definitions nor load

[web2py] Weird truncate performance problem after upgrade to 2.8.2

2014-02-26 Thread Rene Dohmen
Hi Web2py-Users, We have an app which imports data form a .csv file into a sqlite table. The CSV has 70k lines. Once a week we re-import data with a new .csv. The controller that handles this job: 1) handles the upload and moves it to location for future reference 2) truncates the main table an

[web2py] Re: Bug on version 2.8.2

2014-02-26 Thread Rene Dohmen
Hi Paulo, Doesn't seem like a bug to me. More like a typo you made in the model... But if I remember correctly you would get an error defining a reference to a non existing table in older web2py releases. You could also build the reference like this; Field('image', db.image) That way you would

[web2py] Re: Weird truncate performance problem after upgrade to 2.8.2

2014-02-27 Thread Rene Dohmen
TC+1, Anthony wrote: > > What happens if you take the exact SQL that web2py executes and instead > execute it outside of web2py altogether (i.e., via some other database > client)? > > On Wednesday, February 26, 2014 7:06:46 PM UTC-5, Rene Dohmen wrote: >> >> Hi Web2p

[web2py] Re: Web2Py Pages module (basic CMS)

2014-02-27 Thread Rene Dohmen
This was solved a while ago :) On Friday, December 20, 2013 9:34:21 AM UTC+1, Ruud Schroen wrote: > > We are still working on a plugin. > But we are facing a problem regarding reserved keywords which prevents us > from creating a plugin. > > db = DAL('sqlite://storage.sqlite',pool_size=1,check_re

[web2py] Re: IMPORTANT - WEB2PY CONSULTING

2016-02-25 Thread Rene Dohmen
Hi Massimo, you could remove me from the list: Formatics.nl I still notice a lot of doublures on the current list. Cheers, Rene -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) - http://github.com/web2py/web2py (Source code) - https://code.google.com/p/web2py/issues/l

[web2py] Migrating from sqlite to postgres?

2014-04-24 Thread Rene Dohmen
Hi Web2py users, we are struggling, for some time now, with a migration of our apps from sqlite to postgres. We tried a couple of approaches: first we tried doing it with cp_db.py but that had problems with relations and seems broken. Our current approach consist of these steps: 1) export data

[web2py] Re: Best way to migrate from sqlite to postgresql (or other db)

2014-04-24 Thread Rene Dohmen
Hmm , I tried this approach (and some other variants from this thread.): but I run into an error after 15? minutes or so; The error occurs during the execution of the import_from_csv... --- Traceback (most recent call last): File "", line 1, in File "/Users/acidjunk/GIT/formatics.web2py/g

[web2py] Re: Best way to migrate from sqlite to postgresql (or other db)

2014-04-24 Thread Rene Dohmen
With some tweaking the script that Alan Proposed did work in my situation. (50+ tables and a lot of references) https://groups.google.com/d/msg/web2py-developers/QxeJNByj6qc/cpBHsa1ymUkJ In Short: 1) recreate the complete model in postgres: db_new = DAL('postgres://user:pass@localhost/projectnam

Re: [web2py] Re: Best way to migrate from sqlite to postgresql (or other db)

2014-04-25 Thread Rene Dohmen
An amazing piece of code: fast, smart and robust. > Once you have moved the database to postgresql you need only to change > the connection string in db.py to connect to your new postgresql copy. > > > 2014-04-25 3:11 GMT+02:00 Rene Dohmen >: > > With some tweaking the

[web2py] Re: Web2Py Pages module (basic CMS)

2014-05-06 Thread Rene Dohmen
Finding a way to avoid that so you can > use 'page' negates the purpose. > Thanks for your effort to release this work and it will be very nice to > see it in action! > Best wishes, D > > > On Thursday, 27 February 2014 20:07:21 UTC, Rene Dohmen wrote: >> >&g

Re: [web2py] Re: Web2Py Pages module (basic CMS)

2014-05-08 Thread Rene Dohmen
hit this > kind > > of issue when migrating from one database to another. Could this be > > rethinked again? > > > > Thanks. > > > > El martes, 6 de mayo de 2014 19:24:15 UTC+2, Rene Dohmen escribió: > >> > >> Hi Villas, > >> &

Re: [web2py] Re: Uforum - a forum web2py application

2014-05-08 Thread Rene Dohmen
+1 2014-05-08 12:26 GMT+02:00 Stefaan Himpe : > > > I have created a web2py forum software, now currently only in the Dutch > > but wil be ported to english. > > Ziet er goed uit! > > > -- > http://technogems.blogspot.com > http://a-touch-of-music.blogspot.com > http://youtube.com/stefaanhimpe >

[web2py] How to support DB migrations on Heroku?

2014-06-13 Thread Rene Dohmen
Hi Web2py Users, I deployed an app with postgres on Heroku following the info in: https://github.com/web2py/web2py/blob/master/scripts/setup-web2py-heroku.sh https://github.com/web2py/web2py/blob/master/gluon/contrib/heroku.py I already had a working postgres database from a previous deployment

[web2py] Re: How to support DB migrations on Heroku?

2014-06-17 Thread Rene Dohmen
, June 13, 2014 4:14:49 PM UTC+2, Rene Dohmen wrote: > > Hi Web2py Users, > > I deployed an app with postgres on Heroku following the info in: > > https://github.com/web2py/web2py/blob/master/scripts/setup-web2py-heroku.sh > https://github.com/web2py/web2py/blob/master/gluon/co

[web2py] Re: How to support DB migrations on Heroku?

2014-06-19 Thread Rene Dohmen
d your sql.log. > > what's your issue with file uploads? do they work locally and fail on > hosted? > > On Tuesday, June 17, 2014 7:27:25 AM UTC-7, Rene Dohmen wrote: >> >> Hi, >> >> Are the any users at all using heroku and web2py with a postgres DB? &g

[web2py] Re: Docker

2017-02-04 Thread Rene Dohmen
I also builded a docker; containing ssl-nginx-uwsgi based on ubuntu and with some extra python deps (Pillow and gdata). https://github.com/acidjunk/docker-web2py It's meant to be used with an existing app; it will add routes.py for your app. You can get it from docker hub also docker pull acidj

[web2py] Re: Docker

2017-02-04 Thread Rene Dohmen
@Michael M: Nice solution, with postgres and mysql :) -- 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

[web2py] Re: Janrain: NEW OpenID connect

2015-04-30 Thread Rene Dohmen
I have the same problem: Gmail user can't login anymore. Google Apps for business user can login; but they get a popup telling them it will expire 20 april 2015. R On Thursday, April 23, 2015 at 6:00:34 PM UTC+2, Stefan van den Eertwegh wrote: > > Dear fellow web2py users, > > I understand that