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

2018-09-03 Thread Lovedie JC
Had to clean up cache, restart web2py. It's OK now. On Sun, 2 Sep 2018, 20:16 Maurice Waka wrote: > rows = db(db.definitions.definitions).select() > File "/usr/local/lib/python2.7/dist-packages/pydal/base.py", line 669, in > __getattr__ > return BasicStorage.__getattribute__(self, key) > Attr

[web2py] Re: port 800 busy

2018-09-03 Thread 黄祥
just revised my previous post for checked another process using that port (8000) you can use either netstat -ltnp | grep -w ':8000' lsof -i :8000 fuser 8000/tcp ps use just to find the process name by process id : ps -p pid -o comm= best regards, stifan -- Resources: - http://web2py.com - htt

[web2py] Can we commit the codes from web2py to Git

2018-09-03 Thread Vowner
I am planning to introduce Continuous Integration for our python web development activities. So as a first phase, we are planning to get a version control system GIT. So can i commit the code changes from Web2py to Git repo and from there I can trigger a job through Jenkins to modify the web

[web2py] IS_IN_SET handle dictionary

2018-09-03 Thread Yebach
Hello Is it possible to use validator IS_IN_SET to handle dictionary. I want to send a list of dicts for user to select [{"id": 1, "m:code": C-111}, {"id": 2, "m:code": BC-222},.], so when I use on_validate I can handle with id. Thank you -- Resources: - http://web2py.com - http://web2py.

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

2018-09-03 Thread Maurice Waka
Thanks for the response. Great! On Mon, 3 Sep 2018, 10:24 Lovedie JC wrote: > Had to clean up cache, restart web2py. It's OK now. > > On Sun, 2 Sep 2018, 20:16 Maurice Waka wrote: > >> rows = db(db.definitions.definitions).select() >> File "/usr/local/lib/python2.7/dist-packages/pydal/base.py"

[web2py] database field is added and deleted immediately afterwards

2018-09-03 Thread Yebach
Hello When I add a field to my db.py I get an error saying field does not exist. If I check the sql log file there is timestamp: 2018-09-03T12:08:38.256000 ALTER TABLE counters ADD c_total_difference INTEGER; success! timestamp: 2018-09-03T12:08:38.381000 ALTER TABLE counters DROP COLUMN c_total

[web2py] Can we commit the codes from web2py to Git

2018-09-03 Thread Tom Campbell
Yes it works fine with Git. In fact... https://github.com/web2py -- 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

Re: [web2py] Can we commit the codes from web2py to Git

2018-09-03 Thread vivek vijayan
Hello expert, As we already have svn, can we commit the code that we changed from web2py framework to svn repo from there I can initiate a Jenkins job trigger to deploy the change to web2py server under that application path On Mon, Sep 3, 2018, 4:46 PM Tom Campbell wrote: > Yes it works fine w

Re: [web2py] Can we commit the codes from web2py to Git

2018-09-03 Thread 黄祥
think you can do whatever you like with your own repo, but the question is ambigitous. web2py in terms of web2py root folder that contain -rw-rw-r-- 1 tetsu staff 66446 Aug 6 08:02 CHANGELOG -rw-rw-r-- 1 tetsu staff5727 Aug 6 08:02 LICENSE -rw-rw-r-- 1 tetsu staff 24 Aug 6

Re: [web2py] Can we commit the codes from web2py to Git

2018-09-03 Thread vivek vijayan
Hello expert, Little confused here. ”just a suggestion better to maintain your web2py app in your repo, not the web2py itself, except you want fix some bug or add some feature in web2py, but again better to separate it" So you are suggesting to put each the web2py application in my svn repo? So w

[web2py] Re: Error connecting to "Azure database for MySQL"

2018-09-03 Thread sa
Did you find a solution ? *here is my connection string:* db = DAL('mysql://user%40w-mysql-001-se:water123...@w-mysql-1254-se.mysql.database.azure.com/dbname', decode_credentials=True) Now it is showing InternalError: (1043, u'Bad handshake') On Friday, December 1, 2017 at 6:40:29 AM UTC

Re: [web2py] Can we commit the codes from web2py to Git

2018-09-03 Thread 黄祥
like pointed by tom's posted web2py repo is on https://github.com/web2py you can clone it and put it on your repo if you want (in previous posted *web2py itself not web2pyp app*) useful when you fix some bug in web2py core or add some feature to web2py core web2py app mean is whatever applicati

[web2py] Re: Smartgrid links with many-to-many join tables

2018-09-03 Thread miiheikk
Hi, thanks for taking the time to answer. I quickly tested this and it's effectively the solution I referred to as circumventing the problem. I could define controller functions (response mappings) manually and then lambdaing the links to them, but it'd require a lot of code and I'd lose the r

[web2py] Re: Can't understand this error in gluon/rewrite.py

2018-09-03 Thread Lisandro
This problem is getting weirder. I've found that passing integer numbers as args to URL() helper isn't a problem for web2py. I could successfully run some examples using integer and long integers as URL args, and it always works ok. In fact, as I stated before, my application uses URL in that

[web2py] Re: Can't understand this error in gluon/rewrite.py

2018-09-03 Thread Anthony
What does your routes.py file look like? On Monday, September 3, 2018 at 10:25:22 AM UTC-4, Lisandro wrote: > > This problem is getting weirder. > > I've found that passing integer numbers as args to URL() helper isn't a > problem for web2py. > I could successfully run some examples using intege

[web2py] Re: database field is added and deleted immediately afterwards

2018-09-03 Thread Anthony
Is it possible you have a second definition of the table that does not include the c_total_difference column? On Monday, September 3, 2018 at 7:13:26 AM UTC-4, Yebach wrote: > > Hello > > When I add a field to my db.py I get an error saying field does not exist. > If I check the sql log file ther

[web2py] Re: IS_IN_SET handle dictionary

2018-09-03 Thread Anthony
It is documented here: http://web2py.com/books/default/chapter/29/07/forms-and-validators#Range-set-and-equality-validators. Assuming you want separate values and labels, you can use a dictionary or list of tuples (not a list of dictionaries as you have, though). Anthony On Monday, September

[web2py] Re: global name 'Recaptcha' is not defined error when my app is run in web2py 2.17.1 (latest)

2018-09-03 Thread Anthony
On Monday, September 3, 2018 at 12:29:02 AM UTC-4, Rahul wrote: > > Hi Anthony, >Yes - It is defined in db.py file as > > from gluon.tools import Recaptcha > The above should generate an error, as there is no longer a Recaptcha in gluon.tools. It has been replaced with Recaptcha2. Act

[web2py] Web2py website shell not available?

2018-09-03 Thread broneksmiglo1
Dear All, First of all, I'm quite a newbie in web app dev, so there's a big chance I have a trival question - apologies for that (tried to find the answer here - without positive results). I want to perform a simple (let's say it's a one time activity) task => export one of tables in my db wi

[web2py] import integer (E+12) from csv

2018-09-03 Thread broneksmiglo1
Hello, I am using the database administration tool to import a small portion of data to one of the tables in my db (standard sqlite). The code to create the table: db.define_table('dict_prod_match', Field('prod_tes_id','integer'), #this field is causing troubles

[web2py] Exporting a table to csv

2018-09-03 Thread Chris_I
Hello All, Just started learning web2py a few days ago, and am really enjoying it! Working through the chapter on DAL in the Book, I noticed I got an error when doing this: open('test.csv', 'wb').write(str(db(db.student).select())) The message I get is: TypeError: a bytes-like object is requ

[web2py] Re: Web2py website shell not available?

2018-09-03 Thread Anthony
On Monday, September 3, 2018 at 10:52:44 AM UTC-4, broneksmig...@gmail.com wrote: > > Dear All, > > First of all, I'm quite a newbie in web app dev, so there's a big chance I > have a trival question - apologies for that (tried to find the answer here > - without positive results). > > I want t

[web2py] how to get currently logged in user name for the component embedded in the wiki text area

2018-09-03 Thread 98ujko9
i am getting the error: 'NoneType' object has no attribute 'first_name'. Field('logged_in_user', 'string',auth.user.first_name), AttributeError: 'NoneType' object has no attribute 'first_name' the site is behind the login page and even when I attempt to go the homepage (can't open the site

[web2py] Re: Can't understand this error in gluon/rewrite.py

2018-09-03 Thread Lisandro
This is my routes.py: # -*- coding: utf-8 -*- # creates a dictionary that will map each domain with its own app, # based on the content of a text file called "domains_apps", and also # a list of all the apps installed domains = {} apps = [] _archivo = open('domains_apps', 'r') _lineas = _archivo.

[web2py] Re: Can't understand this error in gluon/rewrite.py

2018-09-03 Thread Leonel Câmara
Since it only happens with some installations, my guess is that this is happening in the case where this is the only web2py app (not even the admin or welcome is installed). In this case the list of applications is probably a single string instead of a list. Are you setting routers.BASE.applic

[web2py] Re: IS_IN_SET handle dictionary

2018-09-03 Thread Leonel Câmara
What Anthony said. But, shouldn't you be using IS_IN_DB for this? -- 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 ar

[web2py] Re: how to get currently logged in user name for the component embedded in the wiki text area

2018-09-03 Thread 98ujko9
I think I have answered myself. This does the job: db.define_table('comments', Field('logged_in_user', 'reference auth_user', default=auth.user_id), Field('user_comment', 'text',requires=IS_NOT_EMPTY()), ) On Monday, September 3, 2018 at 12:02:24 PM

[web2py] Re: Web2py website shell not available?

2018-09-03 Thread broneksmiglo1
Thank you for help! W dniu poniedziałek, 3 września 2018 17:36:34 UTC+2 użytkownik Anthony napisał: > > On Monday, September 3, 2018 at 10:52:44 AM UTC-4, bronek...@gmail.com > wrote: >> >> Dear All, >> >> First of all, I'm quite a newbie in web app dev, so there's a big chance >> I have a tr

[web2py] Re: Can't understand this error in gluon/rewrite.py

2018-09-03 Thread Anthony
On Monday, September 3, 2018 at 1:47:41 PM UTC-4, Leonel Câmara wrote: > > Since it only happens with some installations, my guess is that this is > happening in the case where this is the only web2py app (not even the admin > or welcome is installed). In this case the list of applications is pro

[web2py] Re: global name 'Recaptcha' is not defined error when my app is run in web2py 2.17.1 (latest)

2018-09-03 Thread Rahul
Thank you very much Anthony. I have opened a ticket in git #2001 Cheers, Rahul On Monday, September 3, 2018 at 8:21:21 PM UTC+5:30, Anthony wrote: > > On Monday, September 3, 2018 at 12:29:02 AM UTC-4, Rahul wrote: >> >> Hi Anthony, >>Yes - It is defined in db.py file as >> >> from g

[web2py] Err while trying to submit a new web2py site

2018-09-03 Thread Rahul
Hi All, I am not able to submit a new site [http://web2py.com/poweredby/default/submit]. While doing that a ticket is raised. Please see the screenshot attached. Rahul -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) - http://github.com/web2py/web2py (Source

[web2py] Re: database field is added and deleted immediately afterwards

2018-09-03 Thread Yebach
I had another *.py file as backup in my model folder. I changed the extension and all is works fine. thanks for the hint On Monday, September 3, 2018 at 4:42:07 PM UTC+2, Anthony wrote: > > Is it possible you have a second definition of the table that does not > include the c_total_difference c

[web2py] Re: Exporting a table to csv

2018-09-03 Thread Chris_I
Hi there, Found a way to solve it, and thought I'd share in case others search on this topic. Replace the str(...) below with str(...).encode(), so that it looks like this: open('test.csv', 'wb').write(str(db(db.student).select()).encode()) Regards, Chris On Monday, 3 September 2018 22:53