Re: [web2py] Re: pyDAL - Spurious "cross join"

2018-02-28 Thread Richard Vézina
Here some progress : https://github.com/web2py/pydal/issues/521 On Fri, Aug 4, 2017 at 12:57 PM, villas wrote: > With a where clause, it works OK. > However, in my example, I still should not have generated a CROSS JOIN. > I guess it's just a pyDAL issue. > > > > > On Friday, 4 August 2017 17

Re: [web2py] Re: please help us test trunk web2py

2018-02-27 Thread Richard Vézina
join_on_tables, important_tablenames, excluded, jtablemap ) = self._build_joins_for_select(tablemap, left) tablemap = merge_tablemaps(tablemap, dict(**tables_to_merge)) tablemap = merge_tablemaps(tablemap, jtablemap) On Tue, Feb 27, 2018 at 4:3

Re: [web2py] Re: please help us test trunk web2py

2018-02-27 Thread Richard Vézina
not doing empty query is related to the difficulty we were having supporting the empty query syntax??? I guess the answer to this question will resolve this definitely... Richard On Tue, Feb 27, 2018 at 2:11 PM, Richard Vézina wrote: > What causing the CROSS JOIN issue had been introduce between

Re: [web2py] Re: please help us test trunk web2py

2018-02-27 Thread Richard Vézina
What causing the CROSS JOIN issue had been introduce between pyDAL 16.11 and 17.01 There is a compare of the 2 : https://github.com/web2py/pydal/compare/v16.11...v17.01 Richard On Tue, Feb 27, 2018 at 12:59 PM, Richard Vézina < ml.richard.vez...@gmail.com> wrote: > At least there

Re: [web2py] Re: please help us test trunk web2py

2018-02-27 Thread Richard Vézina
At least there is a open issue on the book repo : https://github.com/web2py/web2py-book/issues/346 On Tue, Feb 27, 2018 at 12:57 PM, Richard Vézina < ml.richard.vez...@gmail.com> wrote: > Here : https://github.com/web2py/pydal/issues/388 > > I think the follow up update to the

Re: [web2py] Re: please help us test trunk web2py

2018-02-27 Thread Richard Vézina
otherwise than providing non empty query... I mean it rough mistake... Richard On Tue, Feb 27, 2018 at 12:39 PM, Richard Vézina < ml.richard.vez...@gmail.com> wrote: > @Leonel, I recall about empty query beeing deprecated... But I can't find > any reference to it neither in chang

Re: [web2py] Re: please help us test trunk web2py

2018-02-27 Thread Richard Vézina
@Leonel, I recall about empty query beeing deprecated... But I can't find any reference to it neither in change log of pyDAL nor web2py change log... Niether the book... Which version of the DAL the support been dropped? Richard On Tue, Feb 27, 2018 at 12:01 PM, Richard V

Re: [web2py] Re: please help us test trunk web2py

2018-02-27 Thread Richard Vézina
In [6]: db(db.auth_user.id > 0)._select(db.auth_membership.group_id, join=db.auth_membership.on(db.auth_user.id == db.auth_membership.user_id)) Out[6]: 'SELECT "auth_membership"."group_id" FROM "auth_user" JOIN "auth_membership" ON ("auth_user"."id" = "auth_membership"."user_id") WHERE ("auth_user"

Re: [web2py] Re: please help us test trunk web2py

2018-02-27 Thread Richard Vézina
"auth_membership" ON ("auth_user"."id" = "auth_membership"."user_id");' In [4]: db()._select(db.auth_membership.group_id, join=db.auth_membership.on(db.auth_user.id == db.auth_membership.user_id)) Out[4]: 'SELECT "auth_membership"."group_id"

Re: [web2py] Re: please help us test trunk web2py

2018-02-27 Thread Richard Vézina
Tue, Feb 27, 2018 at 10:55 AM, Richard Vézina < ml.richard.vez...@gmail.com> wrote: > I review my code and found what happen... > > Somehow this query : > > db()._select(db.table_name.other_table_id, join=db.table_name.on(db. > table_name.other_table_id == db.other_table_name

Re: [web2py] Re: please help us test trunk web2py

2018-02-27 Thread Richard Vézina
= " other_table_name"."id"); I think there is a bug somewhere (pyDAL??), removing the CROSS JOIN table_name in red above resolve the issue... On Tue, Feb 27, 2018 at 10:22 AM, Richard Vézina < ml.richard.vez...@gmail.com> wrote: > git clone --recursive https://g

Re: [web2py] Re: please help us test trunk web2py

2018-02-27 Thread Richard Vézina
git clone --recursive https://github.com/web2py/web2py.git On Tue, Feb 27, 2018 at 10:20 AM, Richard Vézina < ml.richard.vez...@gmail.com> wrote: > git clone --recursive web2py repo http address > > On Tue, Feb 27, 2018 at 1:29 AM, pbreit wrote: > >> Could someone please

Re: [web2py] Re: please help us test trunk web2py

2018-02-27 Thread Richard Vézina
git clone --recursive web2py repo http address On Tue, Feb 27, 2018 at 1:29 AM, pbreit wrote: > Could someone please confirm for me if I can just do a "git pull" or do I > need to do something else to make sure I also get latest DAL? > > -- > Resources: > - http://web2py.com > - http://web2py.co

Re: [web2py] please help us test trunk web2py

2018-02-26 Thread Richard Vézina
ranslating the web2py query in both version. Stay tune... Richard On Mon, Feb 26, 2018 at 6:21 PM, Richard Vézina wrote: > Issue is present in both 2.16.1 and trunk... > > On Mon, Feb 26, 2018 at 6:11 PM, Richard Vézina < > ml.richard.vez...@gmail.com> wrote: > >> See

Re: [web2py] please help us test trunk web2py

2018-02-26 Thread Richard Vézina
Issue is present in both 2.16.1 and trunk... On Mon, Feb 26, 2018 at 6:11 PM, Richard Vézina wrote: > Seems there in 2.16.1, but I am not sure if I have the same version or > not... > > I think I didn't test the trunk but 2.16.1 :( > > Richard > > On Mon, Feb 26, 20

Re: [web2py] please help us test trunk web2py

2018-02-26 Thread Richard Vézina
Seems there in 2.16.1, but I am not sure if I have the same version or not... I think I didn't test the trunk but 2.16.1 :( Richard On Mon, Feb 26, 2018 at 5:53 PM, Richard Vézina wrote: > All my automated tests passed, but one which trigger a 'psycopg2.ProgrammingError'&

Re: [web2py] please help us test trunk web2py

2018-02-26 Thread Richard Vézina
All my automated tests passed, but one which trigger a (table name "TABLE NAME" specified more than once ) error... This occurs only with the trunk not 2.14.6... I will test it with the last stable to get more insigth about the issue... Richard On Mon, Feb 26, 2018 at 3:11 PM, Rich

Re: [web2py] please help us test trunk web2py

2018-02-26 Thread Richard Vézina
I test a bit with the tester source from web2py.com download page... Work great with my old app, not test the welcome. Richard On Sat, Feb 24, 2018 at 9:44 PM, Massimo Di Pierro < massimo.dipie...@gmail.com> wrote: > Please help us test the version of web2py which is posted on github. > > I woul

Re: [web2py] 'DAL' object has no attribute 'db'

2018-02-07 Thread Richard Vézina
You define table into za_arts_and_reviews()?? If you it may occurs that this controller is call before db.py where you define your db connection... Richard On Wed, Feb 7, 2018 at 9:18 AM, Johann Spies wrote: > No. > > Regards > Johann > > On 7 February 2018 at 16:10, Richa

Re: [web2py] 'DAL' object has no attribute 'db'

2018-02-07 Thread Richard Vézina
Do you make a module function call without passing the db to it?? Richard On Wed, Feb 7, 2018 at 8:42 AM, Johann Spies wrote: > Version 2.16.1-stable+timestamp.2017.11.14.05.54.25 > > > Traceback (most recent call last): > File "/home/js/web2py/gluon/restricted.py", line 219, in restricted >

Re: [web2py] Problem with -L or --config= of command line

2018-02-07 Thread Richard Vézina
UP! On Wed, Jan 24, 2018 at 2:22 PM, Richard wrote: > Hello, > > I try to pass a logging.conf file as part of a crond tab job that is > launch, but the web2py command line option -L doesn't accept the > loggin.conf file... Is there any limitation over which type of > configuration file that are

Re: [web2py] Re: uploadfolder outside web2py

2018-01-17 Thread Richard Vézina
Symlink is another option... I had use symlink for a while for uploads files as I was storing them on another system, so they were backuped and reduced the size of my linux box... I stop doing it because there network latency and the mount point was often down. But it works very well... Richard O

Re: [web2py] Re: uploadfolder outside web2py

2018-01-16 Thread Richard Vézina
You can also mount the directory you want you file in into web2py folder with bindfs... Or saying it differently mount a directory to another location... https://bindfs.org/ But I think it would be only working with linux. Good luck Richard On Mon, Jan 15, 2018 at 11:22 AM, Anthony wrote:

Re: [web2py] Is there a way to put icon or image picker in form?

2018-01-10 Thread Richard Vézina
sqlform.factory() if you have 2 tables like now and SQLFORM() if you recude this 2 table into 1. Richard On Tue, Jan 9, 2018 at 7:33 AM, Dragan Matic wrote: > I would like to have an icon or image picker in form where user could > choose from a set of predefined icons. > Form would contain a fe

Re: [web2py] Re: Apache + multidomain + SSL

2018-01-09 Thread Richard Vézina
Virtual host?? https://www.digicert.com/ssl-support/apache-multiple-ssl-certificates-using-sni.htm error ticket in production you shouldn't allow that it not secure... You can configure access through SSH tunnel port fowarding and run another web2py instance for this purpose... I am not recalling

Re: [web2py] Re: Apache + multidomain + SSL

2018-01-08 Thread Richard Vézina
Hi Kenneth, Can you be more precise on your issues... I have upgrade my certificate in the begining of 2017 and fall on many issues and resolves them... In my case I was wanting to use one certificate for multiple sub-domains... But I may help you get out of some pitfall you face. Richard On Sun

Re: [web2py] url structure

2018-01-03 Thread Richard Vézina
You have to move in the root of web2py the file and rename it... Richard On Wed, Jan 3, 2018 at 11:12 AM, Richard Vézina wrote: > Look in web2py/examples/ parametric router file and set as default you > desired app : > > routers = dict( > > # base rout

Re: [web2py] url structure

2018-01-03 Thread Richard Vézina
Look in web2py/examples/ parametric router file and set as default you desired app : routers = dict( # base router BASE=dict( default_application='welcome', ), ) Replace welcome by you app... Web2py should then load your app as default and you can access it without the /appli

Re: [web2py] strange URL output ?!

2017-12-21 Thread Richard Vézina
Maybe inherited from the previous request?? You can set "extension='html|json|etc'" to try to correct that... Richard On Thu, Dec 21, 2017 at 7:06 AM, António Ramos wrote: > hello i cannot understand why this code > vars=dict(itemID=relatedto,t="entities",uuid=db.entities[ > relatedto]["uuid"]

Re: [web2py] manage web2py app

2017-12-11 Thread Richard Vézina
About the version stuff, you don't change folder version it make no sens, you use branch name in mercurial and git with tag : https://git-scm.com/book/en/v2/Git-Basics-Tagging If you do open source project github is free... Githud is the winner, gitlab try to take business with local deployement,

Re: [web2py] Re: Web2Py + VueJS SPA (Webpack)

2017-12-07 Thread Richard Vézina
That why I think we should keep sqlhtml a live so we can choose to create forms/tags from server side when ever it makes sens... I use web2py HELPERS all the time as I find it cleaner to write than HTML despite it slower... Though, at some point server side is painful (for complex form or piece of

Re: [web2py] How to use IS_NOT_IN_DB

2017-12-04 Thread Richard Vézina
Something like that : form_fields.append(db[request.args(0)][f].clone(requires=IS_EMPTY_OR(db[request.args(0)][f].requires))) Richard On Mon, Dec 4, 2017 at 3:13 PM, Richard Vézina wrote: > I think you have to clone the field, in context of .factory > > Richard > > On Mon, Dec

Re: [web2py] How to use IS_NOT_IN_DB

2017-12-04 Thread Richard Vézina
I think you have to clone the field, in context of .factory Richard On Mon, Dec 4, 2017 at 2:53 PM, Morganti wrote: > Hi, > > I am creating a form with SQLFORM.factory. I have a field 'username' and > > Field('username','string',requires=[IS_NOT_EMPTY(), > IS_NOT_IN_DB(db,'auth_user.username')]

Re: [web2py] Re: Help with icons

2017-12-04 Thread Richard Vézina
Sorry for caniblizing this thread :D On Mon, Dec 4, 2017 at 2:52 PM, Richard Vézina wrote: > I search further, I think my issue come form html.py > > https://github.com/web2py/web2py/blob/master/gluon/html.py#L1914 > > It seems where web2py is cooking the rendering of error st

Re: [web2py] Re: Help with icons

2017-12-04 Thread Richard Vézina
I search further, I think my issue come form html.py https://github.com/web2py/web2py/blob/master/gluon/html.py#L1914 It seems where web2py is cooking the rendering of error stuff... I am not sure how to pass particular class in error context only, so error get handle by semantic ui : https://s

Re: [web2py] Help with icons

2017-12-04 Thread Richard Vézina
;#' + target)[0] }); obj.trigger(event, data); return event.result !== false; }, But I am not sure how... On Mon, Dec 4, 2017 at 1:22 PM, Richard Vézina wrote: > I don't see much of icon stuff in widget.py and validators.py... > > There is also

Re: [web2py] Help with icons

2017-12-04 Thread Richard Vézina
js... It would be better that error message get append to field div instead of just below the input field... Richard On Mon, Dec 4, 2017 at 1:14 PM, Richard Vézina wrote: > Hello Massimo, > > Whit font-awesome 3.2.1 it was drop in replace, sadly they change their > way how to hook i

Re: [web2py] Help with icons

2017-12-04 Thread Richard Vézina
Hello Massimo, Whit font-awesome 3.2.1 it was drop in replace, sadly they change their way how to hook icons... I think we should suggest to pass them more than include them in the core code there is these settings for instance which is good : # jQuery UI ThemeRoller classes (empty if ui

Re: [web2py] Web2Py + VueJS SPA (Webpack)

2017-11-27 Thread Richard Vézina
Anvil seems pretty nice... But 49$/month is quite expensive... It professionnal tool and not open source I guess... I am not in the bangwagon of the UI drag and drop kind of thing as such kind of product (which work well in the begining) often ends up difficult to make working as simply in the long

Re: [web2py] Double registration form (one in controller, two in view)

2017-11-27 Thread Richard Vézina
rstand for users...and I like to >> complicate my life!! >> >> Thanks >> Fabio >> >> >> Il giorno venerdì 24 novembre 2017 16:50:17 UTC+1, Richard ha scritto: >>> >>> If you reuse the user function you can add an if statement : >

Re: [web2py] Double registration form (one in controller, two in view)

2017-11-27 Thread Richard Vézina
add an if statement : >> >> if request.args(1-2-3) or request.vars.somevarname == something >> particular in your url depending of the context of your form: >> db.auth_user.profile_type.default = PROFILE_TYPE_YOU_PREFER >> elif ... >> >> Richard >&g

Re: [web2py] Re: Web2Py + VueJS SPA (Webpack)

2017-11-24 Thread Richard Vézina
For me, having a good supported (backward) path to pick ractive/vue/angular (to big for my need) would be nice... Massimo's has made w3 if I recall, but I rapidly feel lost with ractive.js... I try vue.js and find it easier to pick it up. But there is a lot of boiler plate to implement to levrage

Re: [web2py] Double registration form (one in controller, two in view)

2017-11-24 Thread Richard Vézina
:47 AM, Richard Vézina < ml.richard.vez...@gmail.com> wrote: > Does removing writable=False in your extra_fields help? It you set this to > false it means the field is neither readable or writable it you want it to > be include in the form put it to writable=True so form will incl

Re: [web2py] Double registration form (one in controller, two in view)

2017-11-24 Thread Richard Vézina
Does removing writable=False in your extra_fields help? It you set this to false it means the field is neither readable or writable it you want it to be include in the form put it to writable=True so form will include the field... I am not sure what you try to achieve with session variable, but you

Re: [web2py] Make a form and edit multiple rows in web2py

2017-10-25 Thread Richard Vézina
Use sqlform.factory and custom.form and web2py helpers and you create an html table with you fields into... with sqlform.factory you can use field().clone() method to manager field attributes like requires and you will have to manually insert, update you model and db.commit() since facotry doesn't

Re: [web2py] Re: move database to mongodb

2017-09-26 Thread Richard Vézina
I think the issue you talk about is related or is the same one to the one report here : https://groups.google.com/forum/#!topic/web2py/oPcn_TFEJvQ Richard On Tue, Sep 26, 2017 at 10:15 AM, 黄祥 wrote: > thank you all for the input, this topic is open just to put what i tested > when using mongodb

Re: [web2py] Re: move database to mongodb

2017-09-26 Thread Richard Vézina
I listen a few vid tutorial about data modeling it mongoDB and basically you should think to put in a single document (mongo is a document database important to remember) all (or most of them) the piece of data into a single document base on the use case of these data (application view for instance

Re: [web2py] JWT with ldap_auth and auth methods

2017-09-25 Thread Richard Vézina
I think you can enforce that this way : auth.settings.login_methods = [ldap_auth(...)] as the only method... For instance I have : auth.settings.login_methods = [auth, ldap_auth(...)] So it check the password first in web2py then in Active Directory... I guess by removing the auth ad an authent

Re: [web2py] Re: move database to mongodb

2017-09-25 Thread Richard Vézina
Hello Steve, I had read about MongoDB for a project that I had in mind... When I see your thread first question come to mind is why porting relational database to mongo... In mongo you will have to design your database in a much different way then in and relational engine in order to make some ben

Re: [web2py] form replacing elements

2017-09-25 Thread Richard Vézina
Set proper validater in your models or create a custom validator or use a javascript plugin that behave has you would your input field to do in the front end as you collect the data in the way you want in the backend... Instead of asking why you try to use don't work, ask us how to do what you try

Re: [web2py] Re: Future of web2py

2017-09-18 Thread Richard Vézina
Hello Marlysson, The focus rigth now is on make web2py work with python 3... Actually it already works but there is maybe some bugs, so any input, testing and report is welcome... You can follow the progression here : https://github.com/web2py/ web2py/issues/1353 Richard On Sun, Sep 17, 2017

Re: [web2py] Re: web2py 2.15.4 is OUT

2017-09-08 Thread Richard Vézina
Here : https://github.com/web2py/web2py-book/pull/367/commits/edffd312bf31d946d4a907f97d665448cac16767 On Fri, Sep 8, 2017 at 1:32 PM, Richard Vézina wrote: > Here a PR to the book pending where you can know which files need to be > update in your own app... > > On Fri, Sep 8, 201

Re: [web2py] Re: web2py 2.15.4 is OUT

2017-09-08 Thread Richard Vézina
Here a PR to the book pending where you can know which files need to be update in your own app... On Fri, Sep 8, 2017 at 1:27 PM, Richard Vézina wrote: > I would copy my app over an other instance of web2py, I personaly do this : > > version_2-14-6/web2py/applications/myapps1... >

Re: [web2py] Re: web2py 2.15.4 is OUT

2017-09-08 Thread Richard Vézina
I would copy my app over an other instance of web2py, I personaly do this : version_2-14-6/web2py/applications/myapps1... version_2-15-3/web2py/applications/copy my app here (update web2py dedicated file) It recommended to download the web2py package over web2py web site download page instead of

Re: [web2py] Re: web2py 2.15.4 is OUT

2017-09-08 Thread Richard Vézina
Nop! You need to update some web2py reserved files in you own app(s)... Search the web2py groups about that I repeatedly details which files even write bash command to automated the task. Good luck! Richard On Thu, Sep 7, 2017 at 3:43 AM, pbreit wrote: > To update can i just do a `git pull` o

Re: [web2py] Re: logging

2017-09-07 Thread Richard Vézina
Hello Lars, Did you read that : https://github.com/web2py/web2py/blob/0d646fa5e7c731cb5c392adf6a885351e77e4903/examples/logging.example.conf I am looking at logging rigth now a new module and I do my research... Setting global logger might be one of the main reason of your issue as I guess you a

Re: [web2py] Re: mercurial

2017-09-05 Thread Richard Vézina
Ability to push mods made in prod (hot fix) would be interresting although I am not sure how it would work for me as I can't use github for my project (need to pay). Would need a fix location over ssh to make use of such a feature... I guess having when you have repo on github it make total sens th

Re: [web2py] Re: mercurial

2017-08-31 Thread Richard Vézina
Hello Martin, And sorry if I hurt feels (community), but it only me thinking... If I was you, I would avoid rely to such web2py feature (I am thinking to web2py upgrade button in admin here)... First the versioning feature limit you to linear change history (no branches) and to mercurial... Mercu

Re: [web2py] Python3 and uwsgi

2017-08-23 Thread Richard Vézina
Is the result you describe (unsuccessful installation) occur while using the nginx deployment script?? web2py/scripts/* Richard On Wed, Aug 23, 2017 at 3:15 AM, Henri Chapelle wrote: > Hi, > I can't get web2py to work with uwsgi and python3. > Does anybody succeeded with a similar setup ? > >

Re: {Disarmed} Re: {Disarmed} [web2py] Re: pytest and controllers protected with auth

2017-08-22 Thread Richard Vézina
Will try to wrapp up my stuff... It base on web2py.test, but I add a test launcher and extract save pytest output into a text file to be consulted after the ending of the test... I do include this file as a test report into my app for the client to see that all tests passed... It works with seleniu

Re: [web2py] Re: book help

2017-08-21 Thread Richard Vézina
Delete your branche and start all over: git push origin branch-name Then go over github see if it works... Richard On Fri, Aug 18, 2017 at 4:25 PM, Dave S wrote: > > > On Thursday, August 17, 2017 at 6:02:31 AM UTC-7, Richard wrote: >> >> No... Hmm... Use Github oneline, you should have butto

Re: [web2py] Re: book help

2017-08-17 Thread Richard Vézina
No... Hmm... Use Github oneline, you should have button beside your branch like "Create a PR" or something like that... It weird that you github desktop porpose you to create a PR against you own repo... I guess your setup is not properly done... Is your local copy a clone of you own repo or a clon

Re: [web2py] Re: book help

2017-08-16 Thread Richard Vézina
When you push your branch over your repo it will appears over it, you need to send PR then... Richard On Wed, Aug 16, 2017 at 5:08 PM, Dave S wrote: > > > On Wednesday, August 16, 2017 at 6:30:52 AM UTC-7, Richard wrote: >> >> Now you make a PR (Pull Request)... But I think you commit againts >

Re: [web2py] pycharm and web2py - setup project

2017-08-16 Thread Richard Vézina
aving trying to configure pycharm project within venv, I think there is tool to do so in pycharm I don't regularly use venv... I would say never install pyDAL with pip without venv... Richard On Tue, Aug 15, 2017 at 10:07 AM, Richard Vézina < ml.richard.vez...@gmail.com> wrote: > O

Re: [web2py] Re: book help

2017-08-16 Thread Richard Vézina
Now you make a PR (Pull Request)... But I think you commit againts master/trunk... You should have create a branch (git checkout -b branch/name-that-describe-the-nature-of-the-change) Always git checkout master, make sure master is up to date then create a branch from master... *Step by step com

Re: [web2py] 2.15.3: automatic update crashes appadmin

2017-08-15 Thread Richard Vézina
I send a PR to web2py book to include the Gist in Upgrading section... On Tue, Aug 15, 2017 at 12:49 PM, Richard Vézina < ml.richard.vez...@gmail.com> wrote: > Here : > > https://gist.github.com/BuhtigithuB/7d2f50203145542e0bdedb731be8a152 > > On Tue, Aug 15, 2017 at 12:

Re: [web2py] 2.15.3: automatic update crashes appadmin

2017-08-15 Thread Richard Vézina
Here : https://gist.github.com/BuhtigithuB/7d2f50203145542e0bdedb731be8a152 On Tue, Aug 15, 2017 at 12:18 PM, Richard Vézina < ml.richard.vez...@gmail.com> wrote: > Yes all these files from welcome should be updated... Before you must make > a backup of your app just to make sure it

Re: [web2py] 2.15.3: automatic update crashes appadmin

2017-08-15 Thread Richard Vézina
/* > js/* > > You can do this like that : > > From web2py/applications > > cp -R welcome/static/* YOURAPP/static/ > cp welcome/controllers/appadmin.py YOURAPP/controllers/ > cp *-R* welcome/views/* *YOURAPP*/views/ > > -

Re: [web2py] 2.15.3: automatic update crashes appadmin

2017-08-15 Thread Richard Vézina
sound idea. On Tue, Aug 15, 2017 at 10:55 AM, Richard Vézina < ml.richard.vez...@gmail.com> wrote: > There is mention of it in the book : > > http://web2py.com/books/default/chapter/29/14/other- > recipes?search=upgrade#Upgrading > > On Tue, Aug 15, 2017 at

Re: [web2py] 2.15.3: automatic update crashes appadmin

2017-08-15 Thread Richard Vézina
There is mention of it in the book : http://web2py.com/books/default/chapter/29/14/other-recipes?search=upgrade#Upgrading On Tue, Aug 15, 2017 at 10:54 AM, Richard Vézina < ml.richard.vez...@gmail.com> wrote: > Yes, I consider creating a gist too... > > Richard > > On Tue,

Re: [web2py] 2.15.3: automatic update crashes appadmin

2017-08-15 Thread Richard Vézina
Yes, I consider creating a gist too... Richard On Tue, Aug 15, 2017 at 10:52 AM, Martin Weissenboeck wrote: > Thank you - should be mentioned in the book. > > 2017-08-15 16:44 GMT+02:00 Richard Vézina : > >> Always the same issue... I would remove this update button to me...

Re: [web2py] 2.15.3: automatic update crashes appadmin

2017-08-15 Thread Richard Vézina
Always the same issue... I would remove this update button to me... Whe you update web2py you need to update many web2py reserved files in your app that the web2py update don't do for you... Those files includes : view/ appadmin.html generic.ics generic.load generic.rss layout.html generic.json

Re: [web2py] pycharm and web2py - setup project

2017-08-15 Thread Richard Vézina
Ok, I confirm, I did have to install pyDAL too in order to allow autocompletion of db.define_table... I use to test in controller and it was working with request... Not sure why... I guess this is cause by the fact that pyDAL is a external product since sometimes and PyCharm didn't address this c

Re: [web2py] pycharm and web2py - setup project

2017-08-14 Thread Richard Vézina
Also, do you have professional version of pycharm (you seems too)? On Mon, Aug 14, 2017 at 9:21 AM, Richard Vézina wrote: > hmm... I don't understand why you say it not working... Once the pycharm > indexing end, at the end of your vid you have autocomplete working no??? > &g

Re: [web2py] pycharm and web2py - setup project

2017-08-14 Thread Richard Vézina
hmm... I don't understand why you say it not working... Once the pycharm indexing end, at the end of your vid you have autocomplete working no??? I do have last pycharm version PyCharm 2017.2 Build *#PY-172.3317.103*, built on July 25, 2017 JRE: 1.8.0_152-release-915-b5 amd64 JVM: OpenJDK 64-Bit

Re: [web2py] 'gluon.contrib.pg8000.ProgrammingError'> ('ERROR', '42P07', 'relation “auth_user” already exists'

2017-08-11 Thread Richard Vézina
Use : psycopg2 pg8000 has known issues... Richard On Fri, Aug 11, 2017 at 10:42 AM, wrote: > Hi, > > I am new user to web2py and I copied repo from an existing project from > AWS. With following settings I need to make it work on local server so I > can make few changes but I am stuck at datab

Re: [web2py] pycharm and web2py - setup project

2017-08-11 Thread Richard Vézina
Kirill, I just try to create a new project and the autocompletion was working, so I guess the issue is limited to virtual environement... On Fri, Aug 11, 2017 at 9:44 AM, Richard wrote: > Good, could you maybe try with python 2.14.6 if it works, just to be sure > that web2py 2.15.x series trigge

Re: [web2py] pycharm and web2py - setup project

2017-08-10 Thread Richard Vézina
from there, which I kind of pretty sure thinking about it... Richard On Thu, Aug 10, 2017 at 2:07 PM, Richard Vézina wrote: > You may consider looking here if it a known bug and report it if not : > https://youtrack.jetbrains.com/issues/PY > > On Thu, Aug 10, 2017 at 1:20 PM, Kiri

Re: [web2py] pycharm and web2py - setup project

2017-08-10 Thread Richard Vézina
You may consider looking here if it a known bug and report it if not : https://youtrack.jetbrains.com/issues/PY On Thu, Aug 10, 2017 at 1:20 PM, Kirill Shatalaev wrote: > Just tried with python 2.7, it creates new project from scratch and > downloads web2py automatically. Still no autocomplete a

Re: [web2py] pycharm and web2py - setup project

2017-08-10 Thread Richard Vézina
Have you try with python 2.7 if it works... And are you using the pycharm project creation tool to configure your web2py environnement?? You can try with their tool before trying to make it work with virtual environnement... Richard On Tue, Aug 8, 2017 at 5:18 PM, Kirill Shatalaev wrote: > Hell

Re: [web2py] Re: book help

2017-08-09 Thread Richard Vézina
I take liberty to create a issue about in the book repo : https://github.com/web2py/web2py-book/issues/366 On Wed, Aug 9, 2017 at 7:44 AM, Leonel Câmara wrote: > 5. the ANY_OF validator also needs to be documented > > -- > Resources: > - http://web2py.com > - http://web2py.com/book (Documentatio

Re: [web2py] Re: Documenting a file with sphinx, that has local_import in it

2017-08-08 Thread Richard Vézina
've tried epydoc which is straightforward but I found its docstring > format a little labourious. > > On Tue, 8 Aug 2017 at 18:24, Richard Vézina > wrote: > >> I look at sphinx a long time ago, so you kind of lost me now... But I >> tought after I press send th

Re: [web2py] $.web2py is undefined

2017-08-08 Thread Richard Vézina
I would have embeded all the bts codes in the web2py component... You appears to try to apply bootstrap tabs feature over 2 differents web2py component, this doesn't make much sens, I guess it all coming from there... Richard On Tue, Aug 8, 2017 at 3:34 PM, Richard Vézina wrote: > W

Re: [web2py] $.web2py is undefined

2017-08-08 Thread Richard Vézina
Why doing that with web2py_component?? On Tue, Aug 8, 2017 at 5:56 AM, Filipe Reis wrote: > Hey guys what I'm trying to do is using bootstrap tabs load other views > using $.web2py.component() the first time it works but the the other > controllers or tabs gives me TypeError: $.web2py is undefin

Re: [web2py] Re: Documenting a file with sphinx, that has local_import in it

2017-08-08 Thread Richard Vézina
to deal with request et al. And gluon > itself doesn't have Sphinx config files so, perhaps, Sphinx-support has a > way to go? > > > On Tue, 8 Aug 2017 at 16:51 Richard Vézina > wrote: > >> I think web2py is sphinx compliant now, I recall that Simone (Niphold) >>

Re: [web2py] Re: web2py 2.15.3 is OUT

2017-08-08 Thread Richard Vézina
Most of the time ticket unknown is the results of bad permissions settings if I recall.. Richard On Tue, Aug 8, 2017 at 7:01 AM, 黄祥 wrote: > Internal error > > Ticket issued: unknown > > *error shown in terminal (previous version shown in appadmin errors)* > ERROR:web2py:Traceback (most recent

Re: [web2py] Re: Documenting a file with sphinx, that has local_import in it

2017-08-08 Thread Richard Vézina
I think web2py is sphinx compliant now, I recall that Simone (Niphold) had refactor docstring to do so... To be confirmed... Richard On Tue, Aug 8, 2017 at 11:06 AM, Carl Hunter Roach wrote: > Is this still the recommended workaround to get Sphinx to generate > documentation for projects built

Re: [web2py] Re: web2py 2.15.1 is OUT

2017-08-02 Thread Richard Vézina
I recall having conversation about that, I am not sure, I think it language file or pickle objects that get modify in a no way back manner... But, sure the app code it not affected... I should retrieve this exchange... will try tomorrow. Richard On Wed, Aug 2, 2017 at 9:53 PM, Anthony wrote: >

Re: [web2py] Re: Integrating existing web2py with GitHub

2017-08-02 Thread Richard Vézina
If he use windows there is a github app I think... I am not sure web2py should integrate with version control as there is too many of them and maintaining such kind of feature is painful On Tue, Aug 1, 2017 at 7:07 PM, Marlysson Silva wrote: > Do you want more easy than git command line? A inter

Re: [web2py] Re: web2py 2.15.1 is OUT

2017-08-02 Thread Richard Vézina
Don't forget to copy/paste (backup) you app before you try Python 3, because there is no way back with the app once you use it under python 3 as certain stuff are modify by python 3 that let your app unusable with python 2 after. Richard On Wed, Aug 2, 2017 at 9:24 AM, Anthony wrote: > On Wedne

Re: [web2py] Integrating existing web2py with GitHub

2017-07-31 Thread Richard Vézina
Hello William, I am not aware of that... But frankly, I would recommend you to properly configure your local repo (origin : https://help.github.com/articles/adding-a-remote/) and set a SSH key (prefered way if you don't want to enter password at every push) over your github account... Then you onl

Re: [web2py] Datatables Query String Parsing

2017-07-31 Thread Richard Vézina
Yes Villas you get good points... I think Massimo's had talked about abandonning SQLFROM.grid. I never been able to fully levrage it. Most of the time, I prefer handle forms myself, as they most of the time more complexe the what .grid() can handle. So there is no gain to having them to me... Toug

Re: [web2py] Datatables Query String Parsing

2017-07-31 Thread Richard Vézina
In my case I didn't activate server side processing, I instead reduce the length of the dataset to be displayed by year slicing... I had buttons to specify which years of data the user wants and an "All" button with a notice it could be long to load... It has reduce the load time of the page... So

Re: [web2py] Datatables Query String Parsing

2017-07-28 Thread Richard Vézina
Here they talk about data structure and list seems possible : https://datatables.net/manual/server-side#Example-data Richard On Fri, Jul 28, 2017 at 8:52 AM, Richard Vézina wrote: > Hello Villas, > > The subject interrest me, as I use DTs, but not the server-side feature... > B

Re: [web2py] Datatables Query String Parsing

2017-07-28 Thread Richard Vézina
Hello Villas, The subject interrest me, as I use DTs, but not the server-side feature... But, I am not sure what you want to achieve... I gonna read a bit about DTs server-side, waiting for precision from you and maybe will understand better your question then... Richard On Thu, Jul 27, 2017 a

Re: [web2py] Re: web2py 2.15.1 is OUT

2017-07-13 Thread Richard Vézina
Are you using rname feature? If so, the issue may need to be further investigate as why SELECT DISTINCT ON (TABLE_of_sites.title) is not double quoted and all the other table_name and field instance are... So maybe the flaw is somewhere in the escaping related to rname feature... Richard On Thu

Re: [web2py] Re: web2py 2.15.1 is OUT

2017-07-13 Thread Richard Vézina
@lyn2py, seems more a issue with naming in your model than anything else... Can you show us your model? On Thu, Jul 13, 2017 at 1:16 PM, lyn2py wrote: > I'm using a simple query to get aggregate: > > max = db.table.date.max() > row = db().select(max) > > Just following the example here http://ww

Re: [web2py] web2py 2.15.1 is OUT

2017-07-11 Thread Richard Vézina
, once we get there... Richard On Tue, Jul 11, 2017 at 3:40 PM, Richard Vézina wrote: > You right, my bad... > > On Tue, Jul 11, 2017 at 3:39 PM, Massimo Di Pierro < > massimo.dipie...@gmail.com> wrote: > >> The one released yesterday is 2.15.1. The next one will be 2.

Re: [web2py] web2py 2.15.1 is OUT

2017-07-11 Thread Richard Vézina
You right, my bad... On Tue, Jul 11, 2017 at 3:39 PM, Massimo Di Pierro < massimo.dipie...@gmail.com> wrote: > The one released yesterday is 2.15.1. The next one will be 2.15.2. (2.16.2 > was a typo). > > > On Tuesday, 11 July 2017 11:11:58 UTC-5, Paolo wrote: >> >> There is a bit of confusion re

Re: [web2py] web2py 2.15.1 is OUT

2017-07-11 Thread Richard Vézina
No confusion : mdipierro R-2.15.1 Massimo's talk about releasing another version soon which will be 2.16.something Richard On Tue, Jul 11, 2017 at 12:11 PM, Paolo wrote: > There i

<    1   2   3   4   5   6   7   8   9   10   >