[web2py] Re: Advice needed on complex SQL operation

2017-06-29 Thread Karoly Kantor
Thank you, that looks helpful, I will start along these lines. I have some questions, though: 1. Will this work if more than one fields are set to "group"? 2. What's up with count, does it ever make sense to have more than one field set to "count", and if yes, what would be the difference

[web2py] Advice needed on complex SQL operation

2017-06-28 Thread Karoly Kantor
I am hoping someone more experienced could give me some advice on how best to proceed with this: I have a large table with columns C1, C2, C3, Cx I have a user defined filter, e.g. select those where C1 = "active" and C2 > 2017.01.01. I have already implemented this, based on user input,

[web2py] google_adapters.py vs google.py

2017-06-21 Thread Karoly Kantor
I am using a web2py version from http://web2py.com/init/default/download, column "for normal users", "source code". I am under the impression that this is the latest official stable release. In gluon/packages/pdal/adapters it has a file named *google_adapters.py*. Now I am trying to test a fix

[web2py] Re: Newbie question about github / trunk

2017-06-21 Thread Karoly Kantor
Sorry I don't get it. The code under that link seems old to me, the particular pdal adapter file I am interested in is from 2016 May 10. On Wednesday, June 21, 2017 at 10:05:03 AM UTC+2, 黄祥 wrote: > > in http://web2py.com/init/default/download you can see there are several > links for tester

[web2py] Newbie question about github / trunk

2017-06-21 Thread Karoly Kantor
I raised an issue in github about Google Cloud SQL ( https://github.com/web2py/web2py/issues/1613 ), and I received a request to test the new code in trunk. I have never used trunk and I have no idea where to find it, can someone point me to the right direction, please? Thanks. -- Resources:

[web2py] Re: gae issue when using two independent apps with same data model under one project

2017-06-19 Thread Karoly Kantor
You can definitely create a new project, that is sure to work. Otherwise, I am also somewhat confused with the nomenclature, so I asked the question in the Google App Engine forum, you can follow any potential explanations here:

Re: [web2py] Re: Future of web2py

2017-06-12 Thread Karoly Kantor
For people to feel they have an understanding on the web2py roadmap and trust in in its future, i think it would be important to get clear answers to the following questions: 1. When "web3py" is released, what will happen to web2py? Will it come to an end of life, or will the two frameworks

Re: [web2py] Architectural advice needed: background report generation (on GAE)

2017-06-10 Thread Karoly Kantor
eport(): >userid = request.vars.userid > … > > ​ > > On Sat, Jun 10, 2017 at 10:54 AM Karoly Kantor <kar...@kantor.hu > > wrote: > >> I have a rather complex data base structure on which I need to enable >> users to define various reports and run them in the b

[web2py] Architectural advice needed: background report generation (on GAE)

2017-06-10 Thread Karoly Kantor
I have a rather complex data base structure on which I need to enable users to define various reports and run them in the background. (As the generation time might exceed what is acceptable real-time.) I want to enable users to launch the generation of these reports and then get a notification

[web2py] Re: Adding extra form elements to SQLFORM

2017-06-05 Thread Karoly Kantor
in the form. > > Anthony > > On Monday, June 5, 2017 at 4:19:29 AM UTC-4, Karoly Kantor wrote: >> >> I am having trouble properly formatting my extra elements to match the >> rest of the form. >> >> This is a quote from the web2py book below. Can someo

[web2py] web2py 2.15.1

2017-06-05 Thread Karoly Kantor
Dear Massimo, I saw your question in the developers group where I cannot post, therefore i do it here. I am currently aware of the following issues to be fixed: 1. Google 2nd generation SQL is definitely a problem. Please note I made a temporary hack to fix it, described here:

[web2py] Adding extra form elements to SQLFORM

2017-06-05 Thread Karoly Kantor
I am having trouble properly formatting my extra elements to match the rest of the form. This is a quote from the web2py book below. Can someone tell me what is exactly meant by "*The variable my_extra_element should be adapted to the formstyle*"? I am using bootsrap3_inline as formstyle, and

[web2py] Re: Future of web2py

2017-05-30 Thread Karoly Kantor
Hello Massimo, May I have two questions on this? 1. You say current web2py interprets code on every request. What does this mean on Google App Engine? (Every time I deploy, GAE seems to compile...) 2. Overall, what do your plans exactly mean for people with an existing app on web2py? Is this a

[web2py] Strange behaviour of SQL query on accented characters

2017-05-30 Thread Karoly Kantor
Please help: I have this: print "DEBUG: query = " + str(query) result = mydb(query).select(*column_names) print db._lastsql This will print this into the log: DEBUG: query = record.application = 3) AND (record.entity = 24)) AND (record.is_deleted =

[web2py] Re: Is web2py incompatible with 2nd generation Google Cloud SQL ?

2017-05-25 Thread Karoly Kantor
I have temporarily solved this problem, as described here: https://groups.google.com/forum/?fromgroups=#!topic/web2py/vs39zZpaH7g -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) - http://github.com/web2py/web2py (Source code) -

[web2py] Re: web2py uses deprecated driver to connect to Google Cloud SQL

2017-05-24 Thread Karoly Kantor
In the meantime, I have solved the syntax error above (there was a "-" in the data base name...), and I have successfully connected to a 2nd generation Google SQL instance To do this, i had to hack pyDAL. I would appreciate of someone could look at what I have done, and tell me if this is

[web2py] web2py uses deprecated driver to connect to Google Cloud SQL

2017-05-24 Thread Karoly Kantor
I have been unable to connect to a 2nd generation Google SQL instance for quite a time now. This is painful as 1st generation instances are less capable and declared "legacy" by Google. I suspect it may have to do with web2py using a deprecated driver "rdbms", e.g. in google_adapters.py.

[web2py] Re: Is web2py incompatible with 2nd generation Google Cloud SQL ?

2017-05-23 Thread Karoly Kantor
Dear Massimo, I am only writing again as a reminder because you said last month you would look into this asap. This is very important I think as one of the key offerings of web2py, supporting GAE, seems to be broken. At least for me. Thanks! -- Resources: - http://web2py.com -

[web2py] web2py.com is not responding

2017-05-18 Thread Karoly Kantor
web2py.com is not responding! -- 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 to the Google Groups

Re: [web2py] Language file on GAE

2017-05-16 Thread Karoly Kantor
Thank you, that's helpful. -- 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 to the Google Groups

Re: [web2py] Language file on GAE

2017-05-16 Thread Karoly Kantor
No, my language file is not updated. My local env is set to use Datastore. -- 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

[web2py] Language file on GAE

2017-05-15 Thread Karoly Kantor
I understand web2py would generate my language file (e.g. it.py) in runtime, except on GAE. Now, I am on GAE. What would be my best workaround? Could I somehow still force web2py update this file while I am local on my laptop? Without this, this piece of work becomes enormous... :-( --

[web2py] Re: Any easy way to prevent left_sidebar from scrolling down?

2017-05-15 Thread Karoly Kantor
Yes, it works on the laptop, but sidebar and main content suddenly completely overlap as I decrease window size. On Monday, May 15, 2017 at 11:45:41 AM UTC+2, Pierre wrote: > > this might help: > > https://www.w3schools.com/bootstrap/bootstrap_affix.asp > > howewer i am not sure this is very

[web2py] Any easy way to prevent left_sidebar from scrolling down?

2017-05-14 Thread Karoly Kantor
I would like a table of contents in the left sidebar that does not scroll down with the main text. I have been unsuccessful with "position: fixed" as things start to overlap and I can prevent it only with dirty hacks such as a large margin, but that looks ban on a small screen. Thank you. --

[web2py] Google Cloud SQL users of the world, unite!

2017-05-13 Thread Karoly Kantor
I would like to share experiences, so I would kindly ask anyone using Google Cloud SQL to sign in here. Specially interesting would be - if you are on 1st or 2nd generation SQL instances - what tier of instance you are using - what are your observations on performance -- Resources: -

[web2py] Re: Expected behaviour of IS_IN_SET(set) if set is empty ?

2017-05-13 Thread Karoly Kantor
t be at least one option > selected but less than 2 (i.e., so, exactly 1). However, by specifying the > "multiple" argument, the default widget would become the multi-select > widget, so to get a standard select widget, you must also specify that via > the "widget&qu

[web2py] Expected behaviour of IS_IN_SET(set) if set is empty ?

2017-05-12 Thread Karoly Kantor
I have a situation where the "set' in IS_IN_SET(set) is dynamic, and sometimes will be empty in: form = SQLFORM.factory( Field("value", type='string', label=field_name, default=value, requires=IS_IN_SET(set)), ... more fields ... ) I would expect that if 'set' is empty, this would always fail

[web2py] How can I make a form's action=... in a component return me within the component?

2017-05-03 Thread Karoly Kantor
I understand i can achieve this for links by inserting "cid=request.cid" into the A helper. However, if I have my form in a component's view as below, how can I achieve the same thing? One Two Three Four This will, upon form submit, open the

[web2py] Re: Why do the devs hate GAE? (two huge bugs and their stupid solutions)

2017-05-02 Thread Karoly Kantor
Dear Massimo, As you are looking into this particular issue, may I please suggest that you test it with a 2nd generation Google Cloud SQL instance? That would, with the same effort, automatically address the issue I have raised earlier. (Google declared 1st generation Cloud SQL instances

[web2py] Re: Is web2py incompatible with 2nd generation Google Cloud SQL ?

2017-04-28 Thread Karoly Kantor
Hello Massimo, One more piece of information that might be useful: One Google support person at the "Google App Engine" forum here told me my login attempt was made with password "password", which is NOT the password I set into the environment variable as seen in my attempted hack above, as

[web2py] Type of boolean queried from MYSQL: is this a bug of a feature?

2017-04-27 Thread Karoly Kantor
I had some difficult time with handling boolean values from MySQL. When I define a table with *db.define_table* and in the Field constructor define *type='boolean'*, the column in the data base becomes a *char(1)*. Values are "*T*" of "*F*". Now when I do a query/select and iterate through

[web2py] Re: How to change menu bar background and font colors

2017-04-27 Thread Karoly Kantor
Thank you, those are really helpful. I have learned again. :-) -- 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

[web2py] Re: Is web2py incompatible with 2nd generation Google Cloud SQL ?

2017-04-26 Thread Karoly Kantor
Thanks, Massimo. FYI, some more info that might be helpful in your investigation: Google docs tell me that my app is granted access to the SQL instance by default, as it is in the same project with the Cloud SQL license, so there's nothing to do there. Also, I set a password for the root user

[web2py] How to change menu bar background and font colors

2017-04-26 Thread Karoly Kantor
I am a little embarrassed to ask this, but I've been trying to do this for hours now... I find outdated info only in various posts. So, how exactly do I change the menu bar background and font colors? -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) -

[web2py] Is web2py incompatible with 2nd generation Google Cloud SQL ?

2017-04-24 Thread Karoly Kantor
Dear Sirs, I can connect my Google App Engine web2p app to a first generation GAE SQL instance, but not to a second generation one. I was talking to a cloud SQL support person on another forum and he said, I quote: "Your first generation CloudSQL instance has the app name as an authorized

[web2py] Re: Google SQL Database user and password - where to set?

2017-04-24 Thread Karoly Kantor
More info: This in the log: DEBUG: connect attempt 4, connection error: Traceback (most recent call last): File "/base/data/home/apps/e~unidb-project/2.400786701713097994/gluon/packages/dal/pydal/base.py", line 446

[web2py] Re: GAE Datastore performance / potential index issue

2017-04-24 Thread Karoly Kantor
More info again, still hoping someone can help: I tried to replace the DAL query with native app engine code. Original DAL: query=( (mydb[record].application == application_id) & (mydb[record].entity == entity_id) &

[web2py] Re: GAE Datastore performance / potential index issue

2017-04-24 Thread Karoly Kantor
Sorry for commenting on my own issue, but i have more information: The following query takes 20 seconds for only 800 items: query=( (mydb[record].application == application_id) & (mydb[record].entity == entity_id) &

[web2py] Google SQL Database user and password - where to set?

2017-04-22 Thread Karoly Kantor
A very simple question: I am trying to move to Google Cloud SQL. I created an SQL instance with Google, where I had to set a data base user name and password. Where do i set that in my web2py app? (Currently i have this in app.yaml, as prescribed by the Google Cloud Website: env_variables:

[web2py] GAE Datastore performance / potential index issue

2017-04-22 Thread Karoly Kantor
My queries on GAE Datastore are very slow. So I decided to try to fetch everything into memory before further processing, to no avail. For example, the following runs for 8 seconds for only 3000 items, which is very bad because my app might have much much more than that eventually.

[web2py] web2py and python future version strategy

2017-04-14 Thread Karoly Kantor
I know this has been discussed before, but I really would like to have an up-to-date perspective on this. I am currently developing an application in python 2.7, web2py 2.14.6 on Google App Engine, that I plan to release for commercial use in September, 2017. My short question is: should I

Re: [web2py] How do i make a field NOT required when using IS_IN_SET() ?

2017-04-10 Thread Karoly Kantor
Thank you, it works, you saved me the time for lunch :-) On Monday, April 10, 2017 at 2:14:12 PM UTC+2, Marvix wrote: > > tried this? > requires=IS_EMPTY_OR(IS_IN_SET(...)) > > 2017-04-10 14:07 GMT+02:00 Karoly Kantor <kar...@kantor.hu >: > >> I have a picklis

[web2py] How do i make a field NOT required when using IS_IN_SET() ?

2017-04-10 Thread Karoly Kantor
I have a picklist type of field where the user selects from a set of predefined values. I am using IS_IN_SET(list_of_values) in the Field constructor. The form cannot be saved unless a value is selected, i.e. the field is essentially a required field. I would like to allow the user NOT to

[web2py] Re: Password Recovery Not Sending (lazyT object being passed to GAE?)

2017-04-06 Thread Karoly Kantor
esponse.flash = 'Wrong Email address' > return dict(form=form) > > > But anyway the lazyT found is an annoying error width, for instance: auth. > settings.auth_two_factor_enabled = True > > > El jueves, 30 de marzo de 2017, 8:13:06 (UTC+2), Karoly Kantor escribió: &

[web2py] GAE Datastore conceptual question - different fields in different rows of a table

2017-04-05 Thread Karoly Kantor
In GAE Datastore I can put any arbitrary properties into an entity of an entity kind (in SQL terms, I can put any field into a table row), without having to redefine / migrate the table. This GAE datastore feature is very useful for my specific purposes. Is there a way I can make use of this

[web2py] Re: Password Recovery Not Sending (lazyT object being passed to GAE?)

2017-03-31 Thread Karoly Kantor
found is an annoying error width, for instance: auth. > settings.auth_two_factor_enabled = True > > > El jueves, 30 de marzo de 2017, 8:13:06 (UTC+2), Karoly Kantor escribió: >> >> As the issue is still unresolved, i have unchecked the "no action needed"

[web2py] Re: Password Recovery Not Sending (lazyT object being passed to GAE?)

2017-03-30 Thread Karoly Kantor
As the issue is still unresolved, i have unchecked the "no action needed" flag on this topic. Any help would be appreciated. Thank you. On Thursday, March 30, 2017 at 6:33:07 AM UTC+2, Karoly Kantor wrote: > > This issue still seems to be unsolved. I have a fresh installation

[web2py] Re: We do not delete posts

2017-03-29 Thread Karoly Kantor
Me too. :-) On Monday, March 20, 2017 at 2:42:16 PM UTC+1, ross mclean wrote: > > I've made 2 post put neither appear to have been published, assuming this > is due to me being a new member. If possible please could one of the > moderators review and approve. Ross > > On Monday, July 20, 2015

[web2py] Re: Password Recovery Not Sending (lazyT object being passed to GAE?)

2017-03-29 Thread Karoly Kantor
This issue still seems to be unsolved. I have a fresh installation on GAE, reset password emails fail due to "need string or buffer, lazyT found" Is there something I can do? Thanks. On Friday, July 29, 2016 at 7:49:14 AM UTC+2, webm...@trytha.com wrote: > > I just uploaded an updated version