[web2py] Re: Time to relax, off topic - Simple IQ Testing.

2010-12-03 Thread ron_m
When I saw these I was thinking what kind of weird number base is this in to get simple addition to yield those results. Oh well back to the planet I live on. On Dec 3, 1:25 pm, Jonathan Lundell jlund...@pobox.com wrote: On Dec 3, 2010, at 1:19 PM, Branko Vukelic wrote: On Fri, Dec 3, 2010

[web2py] Re: Using Jython with web2py

2010-11-30 Thread ron_m
Yes and Spring solved many of the original JEE AKA J2EE problems to the point the JEE people adopted the Spring way. I worked with many of the original EJB containers, some of it was not fun. Python and web2py makes getting work done so much easier. Ron On Nov 30, 1:50 pm, Michele Comitini

[web2py] Re: JSONRPC notes

2010-11-29 Thread ron_m
I would guess the id is so you can pair up the response if you had more than one request outstanding in an AJAX situation? On Nov 29, 12:39 am, Branko Vukelic bg.bra...@gmail.com wrote: Some notes I'd like to share. Comments and advice most welcome! web2py supports JSONRPC 1.1 (and not 2.0

[web2py] Re: Scalability of web2py?

2010-11-29 Thread ron_m
Beware the consultant that only recommends what they know about. :-) Sounds like early optimisation attempts by the consultant if you ask me. You have to do a traffic analysis on the network - sounds like these are scales at remote locations - how often do they report in, how much information per

[web2py] Re: Scalability of web2py?

2010-11-29 Thread ron_m
29, 11:00 am, ron_m ron.mco...@gmail.com wrote: Beware the consultant that only recommends what they know about. :-) Sounds like early optimisation attempts by the consultant if you ask me. You have to do a traffic analysis on the network - sounds like these are scales at remote locations - how

[web2py] Re: Scalability of web2py?

2010-11-29 Thread ron_m
:-) On Nov 29, 12:33 pm, Lorin Rivers lriv...@mosasaur.com wrote: The good news is that the guy who hired ME picked web2py in the first place… On Nov 29, 2010, at 13:51 , mdipierro wrote: Some political considerations (which may be wrong and off topic and improper)... Here is a

[web2py] Re: how to access the docstrings of controller functions

2010-11-25 Thread ron_m
It should work if you run web2py in shell mode and run the models, this will define auth. python web2py.py -S myapp -M then do the import etc. I just tried it on my own app, worked ok. The __init__.py had to be there (it was empty). Ron On Nov 25, 1:58 am, selecta gr...@delarue-berlin.de

[web2py] web2py_ajax.html googleapis jQuery version

2010-11-19 Thread ron_m
The URL pulls in the 1.4.3 version, locally web2py is using 1.4.4 Replacing 1.4.3 in the google apis URL with 1.4.4 should work, I got a file with version 1.4.4 when I tried. Ron

[web2py] jquery file addition in web2py_ajax.html trunk has a problem

2010-11-19 Thread ron_m
I use jQueryUI as well which is included in the view pages I create that need it. I found that using the current in trunk way to include jquery.js in web2py_ajax.html doesn't work: response.files.append(URL('static','js/jquery.js')) response.files.append(URL('static','css/calendar.css'))

[web2py] Re: New style 1.89.X forms seem washed out?

2010-11-18 Thread ron_m
mulone.mar...@gmail.comwrote: 2010/11/18 ron_m ron.mco...@gmail.com The text input fields are not very tall, in fact select boxes don't even show the full height of the font. I fixed that by changing the input text, input password and select height from 16px to 20px in base.css

[web2py] Re: web2py 1.89.4 is OUT

2010-11-18 Thread ron_m
Massimo, you certainly don't need to apologise for any delays. :-) Compared to almost any project I have seen out there either open source or commercial product you run rings around them. On Nov 18, 6:47 pm, mdipierro mdipie...@cs.depaul.edu wrote: Mostly bug fixes. Please let me know if your

[web2py] endswith patch in trunk exception message incorrect

2010-11-17 Thread ron_m
def endswith(self, value): if self.type in ('string', 'text'): return Query(self, ' LIKE ', '%%%s' % value) else: raise RuntimeError, startswith used with incompatible field type The last line should be raise RuntimeError, endswith used with

[web2py] New style 1.89.X forms seem washed out?

2010-11-17 Thread ron_m
I don't want to sound unappreciative of the new look for the application, it is a lot of good work and a definite improvement over all. Maybe I messed something up, I don't think so, but here is what I find unusual now. All form controls seem washed out, there are almost no visible borders on

[web2py] Re: New style 1.89.X forms seem washed out?

2010-11-17 Thread ron_m
phyo.arkarl...@gmail.com wrote: You seem to got CSS messed up. On 11/18/10, ron_m ron.mco...@gmail.com wrote: I don't want to sound unappreciative of the new look for the application, it is a lot of good work and a definite improvement over all. Maybe I messed something up, I don't think so

[web2py] 1.89.1 layout

2010-11-15 Thread ron_m
In the application I am writing there are IP video cameras displayed in a grid for one part of the application. In non-IE browsers this is realized as an IMG tag connected to the MJPEG video stream of the camera using the src= attribute. In the 1.88.2 version I used a padding: 1px; style to put a

[web2py] Re: 1.89.1 layout

2010-11-15 Thread ron_m
recommend them to you. -D On Nov 15, 6:11 pm, ron_m ron.mco...@gmail.com wrote: In the application I am writing there are IP video cameras displayed in a grid for one part of the application. In non-IE browsers this is realized as an IMG tag connected to the MJPEG video stream

[web2py] Re: create auth_user programatically?

2010-11-15 Thread ron_m
Look in gluon/tools.py at the Auth class, function register to see how it is done with the code behind the register form. Some of this function builds the form for initial posting, then on submit the function is revisited and the real work of adding the user is done in the if form.accepts():

[web2py] Re: PostgreSQL replication

2010-11-13 Thread ron_m
: Maybe any of this would help:http://www.haroonidrees.com/2009/04/open-sour.html On Nov 12, 2:07 pm, ron_m ron.mco...@gmail.com wrote: Thanks for the pointers from both of you, I appreciate that. It would be best to have multiple master but that will be very difficult. Bucardo has multiple

[web2py] Re: DAL() unusable ?

2010-11-11 Thread ron_m
Cross reference between tables, see this post http://groups.google.com/group/web2py/browse_thread/thread/b3cb1ce223649e0f/14688d53b3d88857?lnk=gstq=table+cross+reference#14688d53b3d88857 On Nov 11, 12:44 am, Mirek Zvolský zvol...@seznam.cz wrote: I have simplest model:

[web2py] PostgreSQL replication

2010-11-11 Thread ron_m
Any of you have experience with Bucardo or pgpool-II as a replication add-on? Some background: I switched from MySQL to PostgreSQL very cleanly using web2py as the vehicle. Sort description to document the process: Made a copy of the app, removed the content of the databases directory, added the

[web2py] Re: PostgreSQL replication

2010-11-11 Thread ron_m
to look into these tools as well. http://www.slony.info/ http://www.sistemasagiles.com.ar/trac/wiki/PyReplicaEn https://public.commandprompt.com/projects/replicator On Nov 11, 1:51 pm, ron_m ron.mco...@gmail.com wrote: Any of you have experience with Bucardo or pgpool-II as a replication

[web2py] Re: Calling a function that exists in another controller

2010-10-30 Thread ron_m
You could put the code in a module and use local_import in both controllers. On Oct 30, 11:52 am, Luther Goh Lu Feng elf...@yahoo.com wrote: Which syntax should I use to call in controllerA.py a private function __foo() defined in controllerB.py? I understand that one recommendation is to

[web2py] Re: Calling a function that exists in another controller

2010-10-30 Thread ron_m
Oops to clarify put the function in a file under the modules directory. While in development mode the local_import has a reload option so the code gets reloaded on each request. The default is to load once on first use which requires server restart if a change is needed. On Oct 30, 5:15 pm, ron_m

[web2py] Quiet here tonight

2010-10-28 Thread ron_m
Massimo, your users of web2py wish you a safe and successful trip spreading the good word about web2py.

[web2py] Re: Setting the default user id derived from a custom auth table in a record

2010-10-25 Thread ron_m
I think what is happening is the model is exec'd at the start of the request but if the user is not logged in yet or the session has expired forcing a trip to the login page, the model with get None because auth is not in the session. Once the trip to the login page completes it goes back to the

[web2py] Re: GUI widget web2py server

2010-10-23 Thread ron_m
Is this the cause of the slow close and the underlying purpose for it? http://www.freesoft.org/CIE/RFC/1323/24.htm I believe most systems allow this timer to be adjusted by registry in Windows and /proc in Linux, not sure on Mac If the server does the bind call with SO_REUSEADDR for the listen

[web2py] Re: Generically accessing the results of select

2010-10-23 Thread ron_m
A couple of comments that I hope might help. The rows is a dict so if you apply the keys() function you get a list of keys or values returns a list of values under the keys. rows = big_hairy_select_with_joins for row in rows: for table in row.values() for field in table.values() which is

[web2py] Re: GUI widget web2py server

2010-10-22 Thread ron_m
If you move too quick between pushing the stop button and hitting start you can get the error because the server hasn't completed the shutdown yet. I always wait a second between button presses. On Oct 22, 3:54 am, annet annet.verm...@gmail.com wrote: When I do 'stop server' and 'start server'

[web2py] Re: args in response.menu

2010-10-21 Thread ron_m
: On Oct 20, 2010, at 10:44 PM, ron_m wrote: This works URL(request.application,'default','products/used'), []) You can also do something like this, which to my mind is more readable: URL('default', 'products', args=['used']) or equivalently, and even more readable: URL(c='default', f

[web2py] Re: args in response.menu

2010-10-21 Thread ron_m
/ prefix to all paths. It will break all urls. URL and routes will take care of this. On Oct 21, 9:38 am, Jonathan Lundell jlund...@pobox.com wrote: On Oct 20, 2010, at 11:18 PM, ron_m wrote: Certainly the way you describe is in the book and is right, what I suggest is something I have done

[web2py] User interface for editing many to many relations

2010-10-21 Thread ron_m
I use a MySQL db so the many to many relations I use are implemented using an intermediate table containing two foreign keys referencing two other tables. I need to add a user interface that lets application admin types manage these relationships properly, easily and with minimum chance of user

[web2py] Re: Thumb generator - Thumbalizer

2010-10-21 Thread ron_m
This package says it does thumbnails, I have not personally run it but have seen it referenced in several places. PIL - Python Image Library http://www.pythonware.com/products/pil/ On Oct 21, 7:41 pm, weheh richard_gor...@verizon.net wrote: Do you know of something that will take a jpeg, png

[web2py] Re: Exception: class 'gluon.rocket.SocketClosed'(Client closed socket.)

2010-10-20 Thread ron_m
The first version protects from the case m_list is empty so IMHO it is better. I don't think that is what you are experiencing with the local vs remote web server observation. On Oct 20, 3:00 am, annet annet.verm...@gmail.com wrote: When I expose this function in controller locatormail: def

[web2py] Re: args in response.menu

2010-10-20 Thread ron_m
This works URL(request.application,'default','products/used'), []) On Oct 20, 7:40 pm, Jason Brower encomp...@gmail.com wrote: response.menu = [     (T('Home'), False, URL(request.application,'default','index'), []),     (T('Products'), False, URL(request.application,'default','products'),

[web2py] Re: deleting tables depending on user action

2010-10-18 Thread ron_m
http://web2py.com/book/default/chapter/06?search=drop#drop db.table_name.drop() Ron On Oct 18, 7:40 am, mart msenecal...@gmail.com wrote: Hi, does anybody know how to delete a table using dal.py? I need to provide users with the choice of starting a process from scratch (and over and over

[web2py] Re: TypeError: 'function' object is unsubscriptable

2010-10-17 Thread ron_m
As a test remove the promobox=box item from the dict returned from the controller and put this {{print globals().keys()}} in the view file before the failure and check the output on the console. This is also assuming you are running in developer mode with the rocket web server. You will likely

[web2py] Re: make two queries into one [need help]

2010-10-17 Thread ron_m
in user_products:}} and example of data div id=logo              h1/h1             p{{=row.logo}}/p  /div {{pass}} You can see the site @www.em-ecommerce.com/Working/display/indexto see whats happening *cheers Andrew On Sun, Oct 17, 2010 at 1:58 AM, ron_m ron.mco...@gmail.com wrote

[web2py] Re: make two queries into one [need help]

2010-10-16 Thread ron_m
A couple of things Put this in for the view html file temporarily {{extend 'layout.html'}} hr / {{=H2('Results')}} {{=SQLTABLE(user_products, headers='fieldname:capitalize', truncate=100) }} and you should see a nicely formatted table of the results of the query with the column names in

[web2py] Re: web2py 1.87.3 is OUT

2010-10-15 Thread ron_m
This could be the problem, since you are probably on CentOS or Redhat a version of Python 2.5 will not have hashlib built in http://pypi.python.org/pypi/hashlib/20060408a is where you can get one tested on 2.3 and 2.4 I have not had to do something like this yet but I believe site- packages is

[web2py] Re: make two queries into one [need help]

2010-10-14 Thread ron_m
That is because this line userstuff=db(db.user_extended.userinfo == db.product.userinfo).select(db.user_extended.ALL) is just a join of table user_extended to table product on userinfo from both tables. The join will return the same information every time you query no matter what

[web2py] Re: web2py 1.87.3 is OUT

2010-10-14 Thread ron_m
I found I need to login to the machine and as www-data run the application server once from python as in python web2py.py supply an admmin password with -a and then crtrl-c to break out. One clue is if the NEWINSTALL file is still there in the web2py directory then it won't work until the above

[web2py] Re: Accessing COUNT column from DAL row

2010-10-14 Thread ron_m
Just add a print row before the =row(count) line and see what the structure of the row looks like from the console. It might be row['count'] depending on how your data is structured. On Oct 14, 5:20 pm, Alex yue.a...@gmail.com wrote: Hmm, I gave it a try on the view and it doesn't seem to

[web2py] Re: please help us test new web site

2010-10-11 Thread ron_m
Grails is used by a Groovy framework modelled on Rails which runs on the Java JVM. The project was absorbed by the Spring framework guys which in turn was sold to EMC some time ago by the principles of Spring. On Oct 11, 7:50 am, Jonathan Lundell jlund...@pobox.com wrote: On Oct 11, 2010, at

[web2py] Re: please help us test new web site

2010-10-11 Thread ron_m
Sorry I meant VMWare, hard to keep track of all the open source acquisitions lately. On Oct 11, 1:15 pm, ron_m ron.mco...@gmail.com wrote: Grails is used by a Groovy framework modelled on Rails which runs on the Java JVM. The project was absorbed by the Spring framework guys which in turn

[web2py] Re: Simple search form

2010-10-11 Thread ron_m
jQuery is included in the standard layout.html indirectly by inclusion of web2py_ajax.html which are both under views. The jquery.js file is found under static in your application so you just have to use it. On Oct 11, 1:14 pm, elfuego1 elfue...@gmail.com wrote: Is it some additional file? I

[web2py] Re: Join on a join on a join on a.... eesh...

2010-10-09 Thread ron_m
The last statement is between two db(condition1 condition2) as in db(condition1 condition2) db(condition3 condition4) Why not make this statement and try it db(condition1 condition2 condition3 condition4).select() Ron On Oct 9, 11:09 am, Jason Brower encomp...@gmail.com wrote:      #Get

[web2py] Re: Join on a join on a join on a.... eesh...

2010-10-09 Thread ron_m
== db.advertisement_tags.advertisement_id) == (db.tag.id == db.advertisement_tags.tag_id)).select()' and it works until I use select() In additon to these I need to get the specific logged in user id on top of all this. BR Jason On 10/09/2010 09:25 PM, ron_m wrote: The last statement is between two db

[web2py] Re: please help us test new web site

2010-10-09 Thread ron_m
Looks very nice Massimo. Main site, under Documentation on the page the Epydoc link is for http://127.0.0.1:8000 On Oct 9, 1:07 pm, mdipierro mdipie...@cs.depaul.edu wrote: New web2py layout:    http://web2py.com Thanks Bruno and Martin New demo_admin:    http://web2py.com/demo_admin

[web2py] Re: please help us test new web site

2010-10-09 Thread ron_m
If you go to http://web2py.com and click the read more link at the end of the Includes bullet item I get invalid request. The target URL is http://web2py.com/what which is a broken link. If you click the Home button or the icon at the top of the page you end up inside the examples web site

[web2py] Re: Session data lose...

2010-10-07 Thread ron_m
have to be careful to make sure it works with python 2.4. Try prevents try: except: finally: and the user of with. On Oct 6, 6:23 pm, ron_m ron.mco...@gmail.com wrote:

[web2py] Re: Session data lose...

2010-10-07 Thread ron_m
server and lsof -l pid shows 90 files, mostly libraries and fonts. Ron On Oct 6, 9:54 pm, Jason Brower encomp...@gmail.com wrote: Yes, this still happens over time.  I thought it had to do with my code, but perhaps it was something else? Best Regards, Jason Brower On 10/07/2010 02:23 AM, ron_m

[web2py] Re: plugin legacy mysql: generates web2py code to access your mysql legacy db

2010-10-07 Thread ron_m
' Has anyone figured out how to get this script working? Thanks, S On Sep 17, 10:25 am, ron_m ron.mco...@gmail.com wrote: Program mysqldump produces a line like this for an id field   `id` int(11) NOT NULL AUTO_INCREMENT, and because there is no special case processing int becomes

[web2py] Re: Session data lose...

2010-10-07 Thread ron_m
Jason, I wrote a little test program and it looks like a file object is cleaned up by the library when it is unbound so based on what I see running this code there is no need to unlock or close as long as the file object loses scope. Test program produces no open files looking in

[web2py] Re: Session data lose...

2010-10-06 Thread ron_m
. And your right, I didn't realize the issue at hand, but now I understand.  Thank you!  Are you gong to file a patch for this one? Best regards, Jason Brower On 10/05/2010 07:06 PM, ron_m wrote: I think you partially missed my point. All it would take to have a shorter session pickle file

[web2py] Re: Session data lose...

2010-10-06 Thread ron_m
/2010 07:06 PM, ron_m wrote: I think you partially missed my point. All it would take to have a shorter session pickle file on a request is a shorter string stored in one of the session variables. Normally a pickle dump is done with a file open in mode 'wb' but in the server when a session

[web2py] Re: Session data lose...

2010-10-05 Thread ron_m
If you store something in session as in session.name = some_variable then that will be pickled at the end of the current request along with anything else in session. The result of the pickle operation is the session file for your session containing all your session variables. On the next request

[web2py] Re: How cache in db().select() works

2010-10-05 Thread ron_m
Would it work for you to do a 3 table JOIN and then it would be one select? You put the ON clauses in the same place as the WHERE clause with between e.g. db((db.name.id==db.ref_table.name_id) (db.secondname.id==db.ref_table.secondname_id)).select(. where ref_table is your third table in

[web2py] Re: Session data lose...

2010-10-05 Thread ron_m
space although I think the case is rare. :/ I will continue examine the session data to see if there is anything else that could cause this... Best Regards, Jason On 10/05/2010 11:40 AM, ron_m wrote: If you store something in session as in session.name = some_variable

[web2py] Re: unable to create application on Ubuntu 10.04 LTS

2010-10-05 Thread ron_m
Not trying to hijack a thread, I am doing the same thing and having the same problems. The sudo -u www-data python web2py.py -a hello step made it work for me. Prior to that I got unable to create application, unable to install application depending on what I was doing. I also had the NEWINSTALL

[web2py] Re: unable to create application on Ubuntu 10.04 LTS

2010-10-05 Thread ron_m
Sorry, I meant the ticket is written, I guess admin doesn't work to get at the ticket unless the client IP is localhost. I have been in developer mode too long. On Oct 5, 4:22 pm, ron_m ron.mco...@gmail.com wrote: Not trying to hijack a thread, I am doing the same thing and having the same

[web2py] Re: Sessions limitation...

2010-10-04 Thread ron_m
Depends on the OS you use to host - Windows, Linux, OSX. I don't use Windows much but for UNIX based systems there are per process file table limits which would put a cap on the number of open files per process as well as a system wide limit. I would be surprised if this is actually the session

[web2py] Re: database question

2010-09-24 Thread ron_m
If a store can only be in one region then you don't need a many to many relation expressed by intermediate table store_region. Instead just put a region_id field in store referencing the region table forming a one to many relation from region to store. You may have a reason for a many to many

[web2py] Re: Think you got something wrong in the web2py book

2010-09-22 Thread ron_m
No, I think you are possibly looking at the meaning of record_id in a different way than intended. If the parameter record_id is 0 then the permission refers to all the records in the table, If the record_id is 0 then it refers to the record in the table whose id == record_id On Sep 22, 1:33 

[web2py] Session variable setup at login

2010-09-21 Thread ron_m
I am writing an application where login is required for almost the entire site (Intranet application inside a company). There is an equipment access dictionary structure I called user_access I build from the database at login and cache in the session. I added code to the default controller user

[web2py] Re: plugin legacy mysql: generates web2py code to access your mysql legacy db

2010-09-17 Thread ron_m
The size of the data in the database shouldn't matter, it runs mysql to get the table list and then mysqldump on each table using the first output. This script needs some testing but the only way to test is pass more databases through it. It works well on my particular DB but yours has a new case

[web2py] Re: plugin legacy mysql: generates web2py code to access your mysql legacy db

2010-09-17 Thread ron_m
...@cs.depaul.edu wrote: I see a problem here:     Field('id','integer'), should be     Field('id','id'), On Sep 9, 12:01 am, ron_m ron.mco...@gmail.com wrote: On Sep 8, 1:30 pm, mdipierro mdipie...@cs.depaul.edu wrote: So maybe tonight do you want me to go through the manual

[web2py] Re: Simple search form

2010-09-15 Thread ron_m
Why do you have items = [] inside the else: it resets items to a blank list if you have data from the select() which is what you are trying to pass to the view. You might have intended the items = [] to be inside the if branch to pass an empty list if there is no data but then items will contain a

[web2py] Re: help stress test trunk

2010-09-11 Thread ron_m
I am running Ubuntu 10.04 64 bit with all patches. I start as python web2py.py in the app server install directory, all files are owned by my id. When the server GUI starts the browser I get an internal error on URL http://127.0.0.1:8000/ with ticket issued = unrecoverable and clicking that link

[web2py] Re: help stress test trunk

2010-09-11 Thread ron_m
Put this patch into sql.py and it now works with the base URL http://127.0.0.1:8000/ $ diff ~/tools/web2py/web2py_hg/gluon/sql.py sql.py 805c805,808 instances = thread.instances --- try: instances = thread.instances except AttributeError, e:

[web2py] permissions

2010-09-10 Thread ron_m
I see from the documentation it is possible to add a permission to auth_permission with a blank table name. The application I am working on has a notion of symbolic names for actions that can occur in the application which in a prior version was assigned to groups (roles) and then users were

[web2py] Re: permissions

2010-09-10 Thread ron_m
Thanks Massimo, I added the lines db.auth_permission.table_name.requires = IS_NULL_OR(IS_IN_SET(db.tables)) db.auth_permission.record_id.default = 0 to the end of my last model file which seems to work for what I need as well. The table name is allowed to be empty and the record_id defaults

[web2py] Re: permissions

2010-09-10 Thread ron_m
On Sep 10, 11:31 am, ron_m ron.mco...@gmail.com wrote: Thanks Massimo, I added the lines db.auth_permission.table_name.requires = IS_NULL_OR(IS_IN_SET(db.tables)) db.auth_permission.record_id.default = 0 It is much better to follow what Massimo was saying earlier in this thread after

[web2py] Re: plugin legacy mysql: generates web2py code to access your mysql legacy db

2010-09-08 Thread ron_m
On Sep 7, 5:10 pm, mdipierro mdipie...@cs.depaul.edu wrote: If you have a mysql database running locally, please help me test it. First problem I ran into Last line parameters are out of order on mysql() call so it outputs incorrect database URL string $ python scripts/extract_mysql_models.py

[web2py] Re: plugin legacy mysql: generates web2py code to access your mysql legacy db

2010-09-08 Thread ron_m
On Sep 8, 5:40 am, mdipierro mdipie...@cs.depaul.edu wrote: I think I fixed some of this in trunk. Could you print form me the line offending hit? If i see it I can fix the regular expression too. Thanks. I ran the new version from trunk. The if hit!=None: line added at line 74 covers up the

[web2py] Re: plugin legacy mysql: generates web2py code to access your mysql legacy db

2010-09-08 Thread ron_m
On Sep 8, 11:56 am, mdipierro mdipie...@cs.depaul.edu wrote: I think I fixed these. One more try? On Sep 8, 10:30 am, ron_m ron.mco...@gmail.com wrote: I think the re match still has a problem but it is closer. The fault is on a key error for longtext, which should not be trying to match

[web2py] Re: plugin legacy mysql: generates web2py code to access your mysql legacy db

2010-09-08 Thread ron_m
On Sep 8, 11:56 am, mdipierro mdipie...@cs.depaul.edu wrote: I think I fixed these. One more try? I did a temporary add of the key longtext, to get it to run further and found a key error mediumtext which also is at end of line with a comma so the regular expression parsing the line pulls out

[web2py] Re: plugin legacy mysql: generates web2py code to access your mysql legacy db

2010-09-08 Thread ron_m
On Sep 8, 1:30 pm, mdipierro mdipie...@cs.depaul.edu wrote: So maybe tonight do you want me to go through the manual and find all the missing datatypes and try to add them to the map? I would not stop you. ;-) Here is a replacement data_type_map, it was shuffled a bit to put like types

[web2py] tools.py self.settings.expiration

2010-09-03 Thread ron_m
I was looking at the nightly and noticed long_expiration was changed to add *24 for one month. In the line above self.settings.expiration either the comment is wrong or the *24 should be applied there as well. self.settings.expiration = 3600 # one day

[web2py] Re: Model with many to many defined across multiple database instances

2010-09-01 Thread ron_m
Commenting out the following lines shows servers as a drop down list on the insert site_servers form, leaving the line active causes the servers line to be a text input field. # Test for uniqueness across site_id and server_id db.site_servers.server_id.requires = IS_NOT_IN_DB(db

[web2py] Model with many to many defined across multiple database instances

2010-08-23 Thread ron_m
I have a model which has sites and servers with a many-to-many relation described by site_servers as follows: # Global table of known sites db.define_table('sites', Field('uuid', 'string', length=64, default=str(uuid.uuid4()), writable=False), Field('last_modified', 'datetime',

[web2py] Re: Model with many to many defined across multiple database instances

2010-08-23 Thread ron_m
To simplify I just used standard id fields, copied the scaffold (welcome) application with create new application in admin and then in db.py changed the db line to match MySQL and created the database else: # else use a normal relational database # db =

[web2py] Re: Access other middleware and business logic from web2py

2010-07-22 Thread ron_m
You could run web2py in a Jython environment which can then interface to Java libraries. You would still have to get into the JEE container held part of the application but my JEE knowledge is now dated and I never used JBoss so am not sure what would be involved there. Ron

[web2py] Partially distributed database

2010-07-06 Thread ron_m
I have 10 sites each with a server geographically separated over a WAN with a VPN mesh making it look like all the systems are on one network. Some of the basic tables containing global configuration need to be identical across all systems. Other tables which foreign key into the base tables occur

[web2py] Re: Upload to Static folder? Serve File without streaming?

2010-07-02 Thread ron_m
It reads the entire file into memory, then writes it out, not good for files large enough to consume a significant fraction of system memory. On Jul 2, 6:48 pm, weheh richard_gor...@verizon.net wrote: Massimo, just for my personal edification, why won't

[web2py] Re: Last Saved On field displays communication error using HTTPS on Apache2, OpenSSL 0.98k, mod_wsgi, python 2.6.5

2010-06-07 Thread ron_m
I just started using web2py and am on Ubuntu 10.04 386 Desktop. Browser is Firefox and I get this error. Looking for the error tickets I found them under the admin user and was making the first mods to the db.py file for a connection string to MySQL. Here is the traceback from the ticket Error

<    1   2   3