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

2017-05-04 Thread dlypka
Reread the GAE Query documentation. Your use case is not the use case that GAE is optimized for. Fetch fewer records per call. Example:'= web2pyChildTableClass = db.ChildTable # gives the web2py Table class theNativeGAEChildTableClass = web2pyChildTableClass._tableobj # magic... into native GAE

[web2py] Re: switch to python 3

2016-12-07 Thread dlypka
I propose a new framework: things2py (Massimo might guess what I am talking about - think hardware and the "T" in IoT). I have bit of code that could jump start it On Friday, November 4, 2016 at 10:34:55 PM UTC-4, saeed mehrabi wrote: > > Hello > When do you want to switch to python 3? > I am wai

[web2py] Re: Problem running GAE SDK with web2py 2.14.5

2016-07-17 Thread dlypka
I found the fix here: https://code.google.com/p/googleappengine/issues/detail?id=12852 The key step is: You can add a appengine_config.py python file to the root directory of your application with the following contents: import sys sys.platform = 'linux3' On Friday, April 15, 2016 at 1

Re: [web2py] Re: Google App Engine Launcher 1.9.34 breaks web2py?

2016-07-17 Thread dlypka
I found the fix here (it is a true Google App Engine SDK issue): https://code.google.com/p/googleappengine/issues/detail?id=12852 The key step is this: You can add a appengine_config.py python file to the root directory of your application with the following contents: import sys sys.pla

[web2py] Re: Angularjs calls to web2py rest api

2016-07-17 Thread dlypka
I got angular to call web2py controller methods passing data both ways by using the older web2py approach not using '@... restful' decorators. So in the $http.get I pass the full URL such as 'http://127.0.0.1:8000/ welcome/default/api/auth_user/1' On Tuesday, July 12, 2016 at 6:45:40 AM UTC-4, bo

[web2py] Re: UPDATED AGENDA! Bay Area web2py meetup (refreshments) -- 12/5/2014, 6:30PM - 9:00PM -- BE THERE!!!

2014-11-29 Thread dlypka
Hi. I am not clear about the Location. 1125 jackson street albany ca 94706 does not seem to be anywhere near North Berkeley Station 1750 Sacramento Street / Berkeley, CA 94702 Please clarify the Meetup location and closest BART station. On Thursday, November 6, 2014 1:48:14 AM UTC-6, weheh wrote

[web2py] Re: UPDATED AGENDA! Bay Area web2py meetup (refreshments) -- 12/5/2014, 6:30PM - 9:00PM -- BE THERE!!!

2014-11-28 Thread dlypka
I will attend. -Dave Lypka. On Thursday, November 6, 2014 1:48:14 AM UTC-6, weheh wrote: > > *Massimo Di Pietro, web2py's originator, will attend our own Bay Area* > *web2py > meetup* to meet, greet and present. Additional talks by Dexter Hadley, of > Stanford University and Richard Gordon, of

[web2py] Re: web2py and post data

2014-11-24 Thread dlypka
I believe you can use the restful decorator to accept only a POST In the following example, 'mymethod' is not a real python method - it is just a logical concept for convenience. Use this URL: /myapp/mycontroller/api/mymethod "fields" will be a convenient dict of data converted from urle

[web2py] Re: web2py meetup Bay Area

2014-09-21 Thread dlypka
I will try to attend. But will it be during a week day? or possibly weekend? On Thursday, September 18, 2014 10:06:11 PM UTC-5, Dave S wrote: > > > > On Monday, September 15, 2014 11:39:04 PM UTC-7, ghufran syed wrote: >> >> I am new to web2py, but would be interested in attending, thank you for

[web2py] Re: Web2py ajax call and Angularjs

2014-09-21 Thread dlypka
var mypersistdict = {}; mypersistdict['myvar'] = 'myvalue'; var myurlencodeddata = $.param(mypersistdict); // ref: http://stackoverflow.com/questions/19254029/angularjs-http-post-does-not-send-data $http({ method: 'POST

[web2py] Re: GAE NDB is there a problem with using belongs on an id field?

2014-09-01 Thread dlypka
It looks like GAE has the 'Projection Query' feature to allow selecting a subset of columns / properties: https://developers.google.com/appengine/docs/python/datastore/projectionqueries On Friday, August 29, 2014 11:18:00 PM UTC-5, Massimo Di Pierro wrote: > > This should work, can you please ope

[web2py] Re: Web2py + AngularJS: routes

2014-08-16 Thread dlypka
#x27;? Did > you manage to get it with Angular? > > Best, > > Kristjan > > On Saturday, 16 August 2014 15:28:52 UTC+2, dlypka wrote: >> >> I did not put a folder name such as your projects/. >> I kept the html paths flat. >> >> I converted the

[web2py] Re: Web2py + AngularJS: routes

2014-08-16 Thread dlypka
teUrl: 'projects/index.html', > controller: 'ProjektiCtrl' > }) > }]); > > How can I get routes to the partiapl templates right? Let's say that > partial template for '/projects' is in views/projects/index.html direc

[web2py] Re: Web2py + AngularJS: routes

2014-08-14 Thread dlypka
in the Views folders as usual. But then I also had to make controller functions for each .html. For example: def jqplot(): # This method is necessary to allow views/home/jqplot.html to be rendered response.delimiters = ('{[',']}') return dict() On Thursday, August 14, 2014 3:41

[web2py] Re: Python upgrade

2014-08-14 Thread dlypka
Maybe just try rebooting you machine. On Thursday, August 14, 2014 10:44:21 AM UTC-7, Richard wrote: > > Good evening, > > I did upgrade python from 2.7.4 to 2.7.8. on my development laptop and > encounter a 'basic' issue. > > In a controller I call > > create_mgt_sys(form_add_entity.vars.

Re: [web2py] Delete Query Not Working

2014-07-16 Thread dlypka
you might need to db.commit() after the delete(). versioning might be doing a commit() for you. On Tuesday, July 15, 2014 9:05:09 AM UTC-5, samurai wrote: > > No, I hadn''t. But it worked on turning it on. Thanks > But I don't get it. Record versioning just creates an archived db for the > modifi

[web2py] Re: Using DAL inside a thread

2014-07-08 Thread dlypka
Perhaps the Scheduler can help. On Saturday, July 5, 2014 11:47:39 AM UTC-5, Wonton wrote: > > Hello! > > As I commented in other post ( > https://groups.google.com/forum/#!topic/web2py/ZbEndj2H-fk) I have > problems using APNSWrapper feedback service sending push notifications. > > While I wait

[web2py] Can the Scheduler run in stand alone gluon outside of web2py?

2014-06-17 Thread dlypka
If so, please outline what to put in the mainline code to start it up. Thanks. -- 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] Which pure python DB or BTree (like ZODB) is best to modify the Scheduler to use pure-python code?

2014-06-16 Thread dlypka
I am interested to deploy the Scheduler in gluon in a non web app, separate from the web2py web scaffolding, in pure python environments which may not have any SQL database installed or accessible.SQLite needs a platform-dependent installer so is unsuitable. Does the DAL have any support for a

[web2py] any upcoming web2py get together?

2014-06-02 Thread dlypka
I would like to visit the Chicago area and meet the web2py team (Massimo and co.). I have a very interesting (even inspiring) web2py story to tell. I will then bring other (major corporate) associates on a follow up trip. Is it possible? When, where? -- Resources: - http://web2py.com - http:

[web2py] FYI: DAL accepts a variety of connection strings based on the underlying driver

2014-02-27 Thread dlypka
FYI. Although few if any examples are documented, it is possible to for example to connect to Microsoft SQLExpress this way connStr = ( r'Driver={SQL Server};' + r'Server=(local)\SQLEXPRESS;' + r'Database=MyDB;' + r'Trusted_Connection=Yes;' ) d

[web2py] Re: sharing my d3.js experiments with web2py community

2013-08-16 Thread dlypka
Hi Margaret: OK I played with your samples. Great technology. I would like to see such effects overlayed onto an existing page. - Dave Lypka. On Saturday, August 10, 2013 7:47:00 PM UTC-5, greaneym wrote: > > > Hi there, > > I am sharing my experiments with D3.js this week. It's Geek Week, > ac

[web2py] Re: Apache import module failure

2013-08-16 Thread dlypka
May you are missing __init__.py in one of your folders. It needs that special file to mark the folder as having modules allowed for import. On Wednesday, August 14, 2013 9:37:58 AM UTC-5, mr...@rethinkrobotics.com wrote: > > Hi, > > I have a pretty straight forward app (AppBuilder in the log bel

[web2py] Re: deployment to google app engine did not include my static files

2013-08-14 Thread dlypka
The app.yaml sample for python 2.7 on GAE has always been wrong. The regular expression accidentally omits all static files that are in subfolders below static. I had to revert that regular expression part back to the pre 2.7 app.yaml example. The all the static subfolders were back again in the

[web2py] Re: Values in request.vars persist/doubled when form submitted after unexpected logout/session deletion

2013-08-07 Thread dlypka
Use request.post_vars instead of request.vars. Other postings discuss this issue. On Tuesday, August 6, 2013 9:21:06 PM UTC-5, Lamps902 wrote: > > I have a controller function which is protected by a standard > authentication decorator ("@auth.requires_login()"). The function presents > a page c

[web2py] Re: Quoting in export_to_csv_file() / import_from_csv_file()

2013-07-11 Thread dlypka
I was able to import rows which have minimal quotes, using the default import settings. Here is a sample row which worked for me: Atlanta,4214,GANGV19175,GANGV1917,S2C1,437,RBS6601W,"15-B Gainesville_3C",F3,NRCSGAJTCRBR12,Yes,Yes,Yes,Yes,No,Yes,Yes,Yes,CXP9018350/1_R10A/1,IP,Yes,Yes,Yes,Yes,Yes,

[web2py] Re: Can we disable creation of non-Auth sessions somehow?

2013-05-06 Thread dlypka
Can you show how you configured routes.py for it? Thanks. On Monday, May 6, 2013 11:31:29 AM UTC-5, Andriy wrote: > > Ok, thanks. I`ve put robots.txt in /static and configured routes.py for it. > -- --- You received this message because you are subscribed to the Google Groups "web2py-users"

[web2py] Re: simple customize layout

2013-03-20 Thread dlypka
No I believe this is a major issue in web2py css structure. I believe web2py css should not be globally changing attributes of standard html tags. It causes these kinds of rendering problems when one tries to use some standard web components such as a calendar. For example, standard web2py.css in

[web2py] Re: package import

2013-03-20 Thread dlypka
Every folder all the way down within modules and its child folders needs to have a __init__.py file. You are probabaly missing one somewhere there, On Wednesday, March 20, 2013 5:35:36 AM UTC-5, Phillipp Schmidt wrote: > > > Hi. Could you post the error traceback of the import error? >> > Here i

Re: [web2py] Re: Scheduler: new plugin cs_plugin_monitor

2013-03-16 Thread dlypka
Is there a way to stretch (resize) each column? I also suggest using jqgrid, from plugin_wiki I suppose. jqgrid also can do tree-style parent-child expandable subrows which would be very nice to have. A row with a tree style plus sign would indicate the task finished (a child task_run row is ava

[web2py] Re: Not to open a can of worms ... about web2py.com

2013-03-15 Thread dlypka
The web2py site has its own distinctive look which is very clever. Occasional tweaks are good, but let it follow its current course. Not so sure what that new banner background image (vertical lines) is about though... On Friday, March 15, 2013 4:10:04 PM UTC-5, stefaan wrote: > > > > > Should i

Re: [web2py] Re: Status of workflow functionality

2013-03-12 Thread dlypka
Workflow typically stores its state in very complex sql tables. If something goes wrong the tables are easily corrupted and then it is very hard to fix. (brittle) Also if the table design evolves, it is hard to migrate. This is my experience with Microsoft Workflow for Windows. I believe an entit

Re: [web2py] Re: How to TERMINATE a RUNNING Scheduler Task?

2013-03-11 Thread dlypka
than a task queue, but I'll see > what can be done. > > On Monday, March 11, 2013 10:54:10 PM UTC+1, dlypka wrote: >> >> a supervsior may decide to kill a task started by one of his team members. >> >> On Mon, Mar 11, 2013 at 4:50 PM, Niphlod wrote: >>

[web2py] Re: How to TERMINATE a RUNNING Scheduler Task?

2013-03-11 Thread dlypka
y do you need to terminate a > RUNNING task (that can't be accomplished using the timeout parameter)? > > > On Monday, March 11, 2013 9:18:48 PM UTC+1, dlypka wrote: >> >> Thanks for the quick reply. >> I suppose a workaround is to have a separate worker for each

[web2py] Re: How to TERMINATE a RUNNING Scheduler Task?

2013-03-11 Thread dlypka
T returning to the > main loop to execute potentially new QUEUED tasks (every scheduler process > is allowed to process a single task at a time). > if you need to limit the time the task runs, use the timeout parameter. > > If something is not clear please ask. > > On Monday, M

[web2py] How to TERMINATE a RUNNING Scheduler Task?

2013-03-11 Thread dlypka
I need a way to terminate a specific Scheduled Task while it is RUNNING. I tried using Admin Database Admin to update the scheduler_task.stop_time to a time close to now while it was running. But the task continued for several more minutes and COMPLETED its normal 5 minute run. The task calls ti

[web2py] Re: [newbee] - JqGrid - To get back the valor of a field

2013-03-05 Thread dlypka
Perhaps get the id using that technique then use jquery('#myhiddenfieldid').val(id) store it in a hidden input field so the post back will then send it back to the web2py server code when you can easily access it. Or send it back right away using an ajax() call. On Tuesday, March 5, 2013 12:19:

Re: [web2py] Re: Unable to import from modules folder?

2013-03-03 Thread dlypka
I ran into similar problems when I tried to install a plugin. I suggest that web2py be changed to create the __init__.py files automatically in all modules folders after it unpacks a plugin. I think the plugin system also needs to support subfolders in the modules folder. Does not look like it ha

[web2py] Re: Returning a token for Android app authentication

2013-01-06 Thread dlypka
token is passed to web2py, it would return the same > information that would normally be stored in session about the user. > > Thanks again for your help and checking my logic, I'm still pretty new to > this! > > On Thursday, January 3, 2013 7:57:45 PM UTC-8, dlypka wrote: >>

[web2py] Re: RESTful authentication with web2py?

2013-01-05 Thread dlypka
Try these 2 threads https://groups.google.com/forum/?fromgroups=#!topic/web2py/YVYQHRJmcos <-- This is my PhoneGap to web2py experiment https://groups.google.com/forum/?fromgroups=#!topic/web2py/-QPh73Ge2tk <-- Native Android to web2py discussion On Saturday, January 5, 2013 7:07:27 AM UTC-

[web2py] Re: Returning a token for Android app authentication

2013-01-03 Thread dlypka
s currently in the db.tokens, then > the user has been authenticated and the request returns the appropriate > data. > 5. On logout/password change, delete the issued tokens for this user from > db.tokens, so the same token can't be used to authenticate for future api > calls.

[web2py] Re: Returning a token for Android app authentication

2013-01-01 Thread dlypka
ks for the responses, and Happy New Years to you guys too! > > dlypka, for your cookieless solution, it assumes that the client app can't > store/extract tokens? In the Google Android link above, it says that both > Android and iOS can read and extract the tokens/cookies. So

[web2py] Re: Returning a token for Android app authentication

2013-01-01 Thread dlypka
Yes it is my New Year's Resolution to make time to put it in a Slice. On Tuesday, January 1, 2013 10:35:49 AM UTC-6, Massimo Di Pierro wrote: > > Perhaps this should go in a web2pyslice? > > On Monday, 31 December 2012 21:28:04 UTC-6, dlypka wrote: >> >> I develo

[web2py] Re: Returning a token for Android app authentication

2012-12-31 Thread dlypka
I developed a solution for this. I posted it here: https://groups.google.com/forum/?fromgroups=#!topic/web2py/YVYQHRJmcos Happy New Year! On Monday, December 31, 2012 4:38:40 PM UTC-6, Mark Li wrote: > > I am currently trying to authenticate users on an Android app to my Web2py > application. I

[web2py] Re: wxpython app using web2py username and password

2012-12-02 Thread dlypka
Here is the client code in Javascript for a PhoneGap mobile app using all the web2py mods and controller code I have previously posted. Hopefully it is straight forward to convert to C++ or C# for a Windows client app as well: It uses the HTML 5 feature "window.localStorage" instead of cookies

[web2py] Re: Integrated Development Environment with web2py

2012-12-02 Thread dlypka
One GOTCHA I found with WING IDE is that you must delete all .pyc files before running, in order to have it correctly stop on your breakpoints in non-module code, in the case where such .py source has been subsequently modified after the .pyc was created. For code that is in a module, the breakpo

[web2py] Re: wxpython app using web2py username and password

2012-12-02 Thread dlypka
Another patch: In login_cookieless(), after: session.person_email=rows[0].email insert this following line: session._try_store_in_db(request, response) # save changes to the session On Sunday, November 25, 2012 7:41:00 AM UTC-6, dlypka wrote: > > Sample controller code: >

[web2py] Re: Transactions in Web2Py over Google App Engine.

2012-12-01 Thread dlypka
I found this: https://developers.google.com/appengine/docs/python/datastore/overview#Cross_Group_Transactions "For example, to increment a counter field in an object, you need to read the value of the counter, calculate the new value, and then store it back. Without a transaction, it is possible

[web2py] Re: wxpython app using web2py username and password

2012-11-25 Thread dlypka
Sample controller code: (This is not production quality code. It is meant only to suggest an approach to use). def isloggedin_cookieless0(self): request,response,session,cache,T,db=self._globals() retIsLoggedIn = False person_id = session.person_id retIsLoggedIn = True if person_id else Fals

[web2py] Re: admin interface + GAE

2012-11-24 Thread dlypka
to write out. Then subsequent dev_appserver.py runs should work... On Monday, November 19, 2012 11:15:58 PM UTC-6, dlypka wrote: > > I had to work around this problem in tools.py in my web2py 1.9x code. > Maybe this issue is still in 2.x > > @staticmethod > > def get_or_cre

[web2py] Re: wxpython app using web2py username and password

2012-11-19 Thread dlypka
# ## session.connect(request, response, db) # dlypka mod - added ,db newsessionid = 0 # dlypka mod if 'sessioncookieval_fromweb2py' in request.post_vars or 'checkIsLoggedIn' in request.post_vars : # dlypka mod

[web2py] Re: admin interface + GAE

2012-11-19 Thread dlypka
ists(filename): key = open(filename,'r').read().strip() else: key = web2py_uuid() *#* open(filename,'w').write(key) *# dlypka workaround - this crashes on GAE, not allowing to write to a file!!* return key -- Also a sim

Re: [web2py] Re: wxpython app using web2py username and password

2012-11-18 Thread dlypka
Here is the first bit of my patch to enable web2py to handle a cookieless login and session reconnect: 1. in main.py around line 401 static_file = False try: try: try: change to static_file = False isSessionRecordCreated = False # dlypka mod try

[web2py] Re: wxpython app using web2py username and password

2012-11-18 Thread dlypka
But from what I understand, the session logic in globals.py and main.py pretty much depends on cookies in the client for finding out what session to reconnect to on subsequent requests after the very first request (which creates the session record). But a windows client will not know what a cooki

Re: [web2py] Re: wxpython app using web2py username and password

2012-11-16 Thread dlypka
I intend to create some sample code fragments. I will try to post something by Monday. On Thursday, November 15, 2012 9:16:09 PM UTC-6, Jim S wrote: > > I would be interested in learning more. do you have any samples you could > share? > On Nov 15, 2012 8:52 PM, "dlypka" &g

[web2py] Re: wxpython app using web2py username and password

2012-11-15 Thread dlypka
I recently devised some changes to globals.py and main.py to allow a non-cookies client to log into web2py and keep the same session record between requests, just as a browser does. In my case the client is a PhoneGap app and I hit web2py through HTTP. I store the web2py session record id on the

[web2py] Re: Unescaped single quotes break my json

2012-11-03 Thread dlypka
Well if the controller did the Escaping, then my suggestion will pass it back to the view untouched I think. So it might help. On Thursday, November 1, 2012 7:18:54 AM UTC-5, villas wrote: > > Hi dlypka, > > Not sure I was clear. I need to maintain the escaping. > > My point

[web2py] Re: Unescaped single quotes break my json

2012-11-01 Thread dlypka
I used this code in my controller: result = '{ "IsLoggedIn": "%s", "resmsg": "%s"}' % (retIsLoggedIn, resmsg) response.headers['Content-Type'] = 'application/jsonp' response.view = 'generic.jsonp' # Using python code in file init/views/generic.jsonp to leave data unescaped return result On We

[web2py] Which resource bundling framework / approach to use with web2py?

2012-09-17 Thread dlypka
Debugging web2py web apps under WING IDE for me is quite slow because each resource (.js, .css) is loaded individually and quite slowly on each request. I noticed the latest Microsoft .NET MVC 4.0 has resource bundling built-in to Visual Studio 2012 and it is automatic. I have researched bundl

[web2py] DAL Sybase Adapter testing update

2012-06-06 Thread dlypka
We have successfully queried rows using cursor.execute() with pythonodbc connected to our Sysbase database. We cannot test a native pythonsybase driver because from what we found in opensource, you have to have the Sybase SDK to build the opensource native driver and the SDK costs more than $1,70

[web2py] Re: How to use web2py DAL with sybase? Can we modify the adapter to use pyodbc?

2012-05-22 Thread dlypka
e dsn string: > >dsn = 'sybase:host=%s:%s;dbname=%s' % (host,port,db) > > This is one line I am not sure about because the docs for the adapter do > not explain it and I cannot try it. > > Massimo > > > > > > On Wednesday, 16 May 2012 16:24:02 UT

[web2py] Re: How to use web2py DAL with sybase? Update

2012-05-19 Thread dlypka
s is one line I am not sure about because the docs for the adapter do > not explain it and I cannot try it. > > Massimo > > > > > > On Wednesday, 16 May 2012 16:24:02 UTC-5, dlypka wrote: >> >> No preference on which python driver for sybase. >> So w

[web2py] Re: How to use web2py DAL with sybase? Please point me to the sybase adapter

2012-05-16 Thread dlypka
se:host=%s:%s;dbname=%s' % (host,port,db) > > This is one line I am not sure about because the docs for the adapter do > not explain it and I cannot try it. > > Massimo > > > > > > On Wednesday, 16 May 2012 16:24:02 UTC-5, dlypka wrote: >> >> No preferen

[web2py] Re: How to use web2py DAL with sybase? Please point me to the sybase adapter

2012-05-16 Thread dlypka
he pyhton drivers for sybase? > > On Wednesday, 16 May 2012 10:51:39 UTC-5, dlypka wrote: >> >> >> I do not see any reference to "sybase" in 1.99.7 dal.py. >> >> Please point me to the sybase adapter. >> >> There are 2 of us developers h

[web2py] cannot find the adapter for sybase which Massimo is referring to

2012-05-16 Thread dlypka
Please advise where it is. I do not see 'sybase' in dal.py. Is is somewhere else? Thanks.

[web2py] Re: How to use web2py DAL with sybase? Please point me to the sybase adapter

2012-05-16 Thread dlypka
> > web2py includes an adapter but nobody has tested it. If you can help us > test it we can help you debug any problem that may arise. Compatibility > with sybase and other SQL DB engines is a priority. > > > > On Wednesday, 16 May 2012 07:47:59 UTC-5, dlypka wrote: >&

[web2py] How to use web2py DAL with sybase?

2012-05-16 Thread dlypka
I see this posting which has some sybase adapter code: https://groups.google.com/forum/?fromgroups#!searchin/web2py/sybase/web2py/LXdEdc1th3M/8ZIOxE8tJQgJ Is there anything else? I have a need to use web2y + sybase at work. Thanks.

[web2py] Re: breakpoints + Eclipse + Web2Py

2012-03-23 Thread dlypka
I believe you must delete all .pyc files before running it with breakpoints. On Mar 23, 1:18 pm, web2py_tn wrote: > Hi guys- I sat up my Aptana Studio and loaded a web2py project that has > breakpoints in it. I ran web2py.py in a debug more and for some reason, it > doesn't stop at the breakpoint

[web2py] web2py on GAE: Issue #694 is a DAL patch to provide high performance parent-child queries

2012-03-16 Thread dlypka
GAE developers - you may be interested in Issue 694 http://code.google.com/p/web2py/issues/detail?id=694 It allows you to use a normal web2py query to retrieve the parent entity but that single datastore query automatically attaches all the child entities as well. So instead of following links

[web2py] Re: Which is faster, download() in default.py or static

2012-01-08 Thread dlypka
I don't think the static approach works on GAE.

[web2py] Re: Significant overhead with each define_table()

2012-01-08 Thread dlypka
I have always wondered why the tables are executed on each request. For my apps, I moved them into a module and I also check if the table already exists, then bypass the creation. I hope the DAL is stateless in its table operations and that there are no multiple request contention issues.

[web2py] Re: Alternative for GROUP BY in app-engine

2012-01-07 Thread dlypka
some relevant discussion is here: http://groups.google.com/group/google-appengine-java/browse_thread/thread/3dfe0f3268cd7e27

[web2py] Re: Optimizing web2py app for GAE

2011-12-30 Thread dlypka
Perhaps these links will help: http://groups.google.com/group/google-appengine/browse_thread/thread/21478bd9185dcc32/f61b532da5c46588?lnk=gst&q=index+reads#f61b532da5c46588 http://groups.google.com/group/google-appengine/browse_thread/thread/bdb45e04dd8f959e/0659767c7878bafb?lnk=gst&q=index+rea

[web2py] Re: How to cause radio buttons to auto deselect?

2011-11-26 Thread dlypka
a time. > > Anthony > > > > > > > > On Saturday, November 26, 2011 4:25:54 PM UTC-5, Anthony wrote: > > > Have you tried the radio widget -- SQLFORM.widgets.radio.widget (see > >http://web2py.com/book/default/chapter/07#Widgets). > > > An

[web2py] How to cause radio buttons to auto deselect?

2011-11-26 Thread dlypka
When I create several radio buttons in a web2py form, they do not auto deselect when another is selected. They all stay selected. Do I need to add my own javascript code to do the auto deselect (so that only one radio button at a time stays selected) or does web2py have some support for this behav

[web2py] Re: packaging return from executesql as Rows object?

2011-11-16 Thread dlypka
Why send legacy_db into sql.Rows()? It is not needed for anything at that point. Maybe just send in None or some default as the first arg. On Nov 16, 2:43 pm, David Watson wrote: > Does anybody have example code showing how to package the return from > executesql as a gluon.sql.Rows object? > > I

[web2py] Re: best way to contact a programmer

2011-11-12 Thread dlypka
I am a certified MCSD .NET developer using both ASP.NET 4 and web2py on my current job in a very large company. I consider .NET to be best for 'legacy' .NET designs, and web2py best for green field designs. .NET is fundamentally flawed for web work because it depends on old style compiled dlls. .N

[web2py] Re: Need File Chooser which does NOT upload upon form Submit

2011-11-12 Thread dlypka
les/. > > Anthony > > > > > > > > On Saturday, November 12, 2011 6:45:12 PM UTC-5, dlypka wrote: > > > Parse it on the local machine. > > > On Nov 12, 4:53 pm, Anthony wrote: > > > What do you want to do with the file? > > > > On S

[web2py] Re: Need File Chooser which does NOT upload upon form Submit

2011-11-12 Thread dlypka
Parse it on the local machine. On Nov 12, 4:53 pm, Anthony wrote: > What do you want to do with the file? > > > > > > > > On Saturday, November 12, 2011 5:12:39 PM UTC-5, dlypka wrote: > > > Is there a widget / technique in web2py forms to choose a file but not > > upload it?

[web2py] Need File Chooser which does NOT upload upon form Submit

2011-11-12 Thread dlypka
Is there a widget / technique in web2py forms to choose a file but not upload it?

[web2py] Re: Unwanted submit on checkbox click ?

2011-11-12 Thread dlypka
maybe ;return false; at the end of _onclick (after the alert). false will indicate that the event did not complete and so Javascript will not post/submit. On Nov 11, 2:54 pm, BrendanC wrote: > I'm building a dynamic table with a checkbox in each row with the code > below. The table displays corr

[web2py] Re: gae ReferenceProperty

2011-11-05 Thread dlypka
In the latest dal.py around line 3010 (may float a bit, I am looking at the trunk) if self.dbengine == 'google:datastore' in globals(): Change it to if self.dbengine == 'google:datastore': and the exception will go away The issue is that 'GoogleDatastoreAdapter' is in globals(), not 'google:datast

[web2py] Re: gae ReferenceProperty

2011-11-05 Thread dlypka
In the latest dal.py around line 3010 (may float a bit, I am looking at the trunk) if self.dbengine == 'google:datastore' in globals():http:// groups.google.com/group/web2py/browse_thread/thread/ 33b722be4316472a#Change it toif self.dbengine == 'google:datastore':and the exception will go away The

[web2py] Re: SQLFORM.factory does not create the table in db, so how to query results?

2011-10-11 Thread dlypka
Thanks - your reply helped me see how it works. I did not realize that web2py just puts the name of *only* the selected radio button in request.vars. I had been looking for all 3 of my radio buttons, assuming there would be a checked=true attribute on one of them. But instead, just the presence of

[web2py] Re: Help! import winrandom gives dll load failed error under Apache on Vista, but works under Rocket.

2011-10-11 Thread dlypka
P.S. In this scenario, you have to run web2py with -i 138.85.50.99 -p 8000 for example: python web2py.py -a "" -i 138.85.50.99 -p 8000 On Oct 10, 6:36 pm, dlypka wrote: > Resolved: > > After researching, I see this problem plagues many other developers as > wel

[web2py] Re: Help! import winrandom gives dll load failed error under Apache on Vista, but works under Rocket.

2011-10-10 Thread dlypka
Now if I browse to http://138.85.50.99/LTE1 It hits IIS 7 and magically reroutes to my UETR web2py app at http://138.85.50.99:8000/UETR?r=/LTE1 More work is needed to refine it, but the basic functionality is shown. O

[web2py] Help! import winrandom gives dll load failed error under Apache on Vista, but works under Rocket.

2011-10-06 Thread dlypka
My web2py app which uses paramiko sftp, works fine under the Rocket webserver, but fails here when run under the Apache 2.2 webserver, under WINDOWS VISTA Enterprise: • File "C:\Python27\lib\site-packages\Crypto\Random\OSRNG\nt.py", line 28 import winrandom <-- failing to load some D

[web2py] SQLFORM.factory does not create the table in db, so how to query results?

2011-10-05 Thread dlypka
form = SQLFORM.factory(*myFieldlist, table_name='OSSListFormTable', submit_button='Submit Query', formname='QueryForm', _method = 'POST') Problem: 'OSSListFormTable' is not registered as a table in the db, so myset = db(myquery) crashes Is this a bug in web2py? OR should 'OSSListFormTable' be

[web2py] Re: successful apache and web2py install on VISTA but what is the final step? - Solved

2011-10-01 Thread dlypka
in Password and after that run in Apache and use that same password. https://138.85.50.99/admin (enter it using password that was first created by running web2py Rocket version) http://138.85.50.99:8080/welcome On Oct 1, 6:25 pm, dlypka wrote: > Update:https://138.85.50.99/welcome/default/

[web2py] Re: successful apache and web2py install on VISTA but what is the final step?

2011-10-01 Thread dlypka
Update: https://138.85.50.99/welcome/default/index works! http://138.85.50.99:8080 works! (Apache index.html) http://138.85.50.99:8080/welcome/default/index does not work. What is the problem? On Oct 1, 5:27 pm, dlypka wrote: > I followed the web2py 3.1 Ed. book chapter for installation

[web2py] successful apache and web2py install on VISTA but what is the final step?

2011-10-01 Thread dlypka
I followed the web2py 3.1 Ed. book chapter for installation on Windows (VISTA Enterprise in my case). web2py and Apache 2.2 now work independently. web2py still just working in its own Rocket server. I made all the changes to C:\Program Files\Apache Software Foundation \Apache2.2\conf\httpd.conf an

[web2py] Re: Try Flask "in a browser"

2011-09-30 Thread dlypka
T3 can do that. On Sep 30, 9:09 pm, Bruno Rocha wrote: > On Fri, Sep 30, 2011 at 7:35 PM, Anthony wrote: > > We've already gothttp://www.web2py.com/demo_admin/default/site. I wonder > > if we could enable people to create their own apps and have them live for a > > day or so (the TryFlask apps l

[web2py] How to disable escaping in @service

2011-09-16 Thread dlypka
I need something like @service.json(escape=false) in my service: @service.json def mytasks(a, b): R = '{"completed_in":0.163,"max_id": 112677442623246336,"max_id_str":"112677442623246336","next_page":"? page=2&max_id=112677442623246336&q=miami&...}]' return R The problem for me is that th

[web2py] Re: sqlite OperationalError: database is locked in a cron job

2011-06-01 Thread dlypka
I had this problem when adding the 2nd record to a table using crud and sqlite3. Then I saw this posting http://groups.google.com/group/web2py/browse_thread/thread/ff93d18db6d4ed53/bc1f44c0cc0f50a3?lnk=gst&q=database+is+locked#bc1f44c0cc0f50a3 where Massimo suggests trying db.commit() I put a db.

[web2py] Re: TypeError: 'module' object is not callable on globals()

2011-05-29 Thread dlypka
Great news. Will upgrade. Thanks! On May 28, 7:40 pm, Massimo Di Pierro wrote: > This is fixed in trunk. > You cannot do > > from gluon import * > > in version before 1.95.1 > > On May 28, 3:44 pm, dlypka wrote: > > > > > > > > > I am tr

[web2py] TypeError: 'module' object is not callable on globals()

2011-05-28 Thread dlypka
I am trying to use crud but I get TypeError: 'module' object is not callable when I reference globals() in crud = Crud(globals(), mydb) At the top of my source file I have from gluon import * from gluon.globals import * from gluon.tools import Crud My web2py is Version 1.93.2 (2011-03-0

[web2py] Re: Google GAE Task Queue independence

2011-03-13 Thread dlypka
GAE debugging time - always welcomed. > > > The Web2py guys take backward compatiblilty v. seriously so there must be a > > reasonable reason for this change. I've searched GoogleGroups but couldn't > > find past threads but the search isn't great and I turned n

[web2py] Re: XML() object in html.py breaks ajax callback which needs HTML returned.

2011-03-12 Thread dlypka
around the return value. return XML(rewrite.url_out(r or _request, env, application, controller, function, args, other, scheme, host, port)) In 1.77.3 it was formerly: return rewrite.url_out(r or _request, env,) So basically they have changed the signature of the URL() object. On Mar

[web2py] Re: Google GAE Task Queue independence

2011-03-12 Thread dlypka
FYI:I found a *GOTCHA* issue when upgrading to 1.92.3 from 1.77.3 Now you have to use .xml() on the URL() that you send into the GAE API: upload_url = blobstore.create_upload_url(URL(r=request,c='default',f='upbm2gig_gaehandler',args=None).xml()) # This works upload_url = blobstore.cr

[web2py] Re: some functionality to mix html and {{python expression}} is broken since 1.92.3, even back to 1.91.6

2011-03-09 Thread dlypka
I have now reproduced the issue in a small project. So I will create an incident and attach a zip tomorrow. On Mar 8, 2:33 pm, dlypka wrote: > I will try to reduce it to a small example. From the call stack it > looks like web2py is confused between python code and html.  It seems &

  1   2   3   >