[web2py:35012] Validator IS_IN_DB display string from joined tables

2009-11-10 Thread Frederik Wagner
Hi .*, is there a possibility in the Validator IS_IN_DB to have the display string show attributes from multiple (joined) tables? E.g.: If I say somthing like IS_IN_DB( db( (table1.id == table2.id_table1) , 'table1.id', '%(table1.attribute)s %(table2.attribute)s') It tried somthing like this,

[web2py:35013] Re: installing web2py on Ubuntu

2009-11-10 Thread salingrosso
I've installed web2py on arch linux and I only needed to download web2py. It was really really easy... :-) I think that Python is already included on default installation of Ubuntu. This script could be interesting because, as I see, it install and configure Apache. You think that this

[web2py:35014] mapping php style url to web2py in routes

2009-11-10 Thread Kuba Kucharski
hello, web2py i am dealing with a device whis is calling urls like: host_ip/CallerWantsCustomerService,arg1,arg2 how do I map them into standard web2py host_ip/myapp/default/CallerWantsCustomerService/arg1/arg2 I guess this is easy, maybe someone already answered this question, could you

[web2py:35015] MySQL error with Welcome and Examples

2009-11-10 Thread des
Hi guys i was trying to start the welcome and examples apps and i get this error with both of them: (i'm using mysql) SQL generated : CREATE TABLE mytable( id INT AUTO_INCREMENT NOT NULL, myfield VARCHAR(512), PRIMARY KEY(SUBSTRING(mytable.myfield,1,1)) ) ENGINE=InnoDB CHARACTER

[web2py:35016] Re: Using web2py with jython

2009-11-10 Thread Timbo
As it turns out, Java has a fair number of nasty WONT-FIX bugs. In my above documented attempt where it couldn't delete the file...there's a WONT-FIX bug for that: http://bugs.sun.com/bugdatabase/view_bug.do?bug_id=4715154 No wonder ppl hate Java. Massimo, are you going to re-work template.py

[web2py:35017] Re: Validator IS_IN_DB display string from joined tables

2009-11-10 Thread mdipierro
Yes you can do it with a bit of extra work: db.define_table('person',Field('name')) db.define_table('dog',Field('name'),Field('owner',db.person)) db.define_table('walk',Field('dog',db.dog),Field('when','datetime')) db.dog.owner.requires = IS_IN_DB(db,'person.id','%(name)s') class

[web2py:35018] Re: installing web2py on Ubuntu

2009-11-10 Thread mdipierro
That is similar the configuration I use. Ideally one should use mod_wsgi on production but I would not know how to automate its installation. I am sure the script can be improved. On Nov 10, 4:44 am, salingrosso salingro...@gmail.com wrote: I've installed web2py on arch linux and I only needed

[web2py:35019] Re: mapping php style url to web2py in routes

2009-11-10 Thread mdipierro
edit routes.py and write routes_in=[('/CallerWantsCustomerService,$arg1,$arg2', '/myapp/default/CallerWantsCustomerService/$arg1/$arg2')] routes_out=[('/myapp/default/CallerWantsCustomerService/$arg1/$arg2', '/CallerWantsCustomerService,$arg1,$arg2')] You may need to

[web2py:35020] Accessing Web2Py services via ExtJS

2009-11-10 Thread Don
Has anyone used web2py services with extjs, such as json-rpc? If so, do you have example code that you can share? --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups web2py-users group. To post to this group, send email

[web2py:35021] Re: Creating Models the Web2Py way

2009-11-10 Thread Wiiboy
Slightly off-topic, what's the difference between the following? In one of the tutorial videos I saw, Massimo used the latter of the two: db.define_table(my_table, Field(other_table, db.other_table)) And db.define_table(my_table, Field(other_table, reference other_table))

[web2py:35022] Re: Creating Models the Web2Py way

2009-11-10 Thread Wiiboy
Slightly off-topic, what's the difference between the following? In one of the tutorial videos I saw, Massimo used the latter of the two: db.define_table(my_table, Field(other_table, db.other_table)) And db.define_table(my_table, Field(other_table, reference other_table))

[web2py:35023] Re: mapping php style url to web2py in routes

2009-11-10 Thread Kuba Kucharski
I tried this but now I see I had made a typo and this is why it wasn't going to work thank you -- Kuba On Tue, Nov 10, 2009 at 3:49 PM, mdipierro mdipie...@cs.depaul.edu wrote: edit routes.py and write routes_in=[('/CallerWantsCustomerService,$arg1,$arg2',

[web2py:35025] faked ?

2009-11-10 Thread desfrenes
Hello ! Creating a table and then adding a new Field, here's what I get: timestamp: 2009-11-10T15:44:02.086000 CREATE TABLE product( id INTEGER PRIMARY KEY AUTOINCREMENT, title CHAR(64) ); success! timestamp: 2009-11-10T15:54:01.273000 ALTER TABLE product ADD subtitle CHAR(64); faked!

[web2py:35026] Re: faked ?

2009-11-10 Thread desfrenes
Oh, that was using the svn trunk. On 10 nov, 16:14, desfrenes desfre...@gmail.com wrote: Hello ! Creating a table and then adding a new Field, here's what I get: timestamp: 2009-11-10T15:44:02.086000 CREATE TABLE product(     id INTEGER PRIMARY KEY AUTOINCREMENT,     title CHAR(64) );

[web2py:35027] Re: faked ?

2009-11-10 Thread mdipierro
It seems I took a patch that was not tested enough (my mad only, I should have) and it is creating lots of problems. I am about to post 1.72.3. I apologize to everybody. Massimo On Nov 10, 9:14 am, desfrenes desfre...@gmail.com wrote: Hello ! Creating a table and then adding a new Field,

[web2py:35028] Major problem with 1.72.2

2009-11-10 Thread mdipierro
There is a major problem with 1.72.2. Do not do migrations with it or it will mess up your .table files. If you have done a migration with it and it did not go though. 1) revert your code to before the failed migration 2) add fake_migration=True in db.define_table(...) that you attempted to

[web2py:35031] Re: installing web2py on Ubuntu

2009-11-10 Thread salingrosso
If we add: libapache2-mod-wsgi ? 2009/11/10 mdipierro mdipie...@cs.depaul.edu That is similar the configuration I use. Ideally one should use mod_wsgi on production but I would not know how to automate its installation. I am sure the script can be improved. On Nov 10, 4:44 am,

[web2py:35032] Re: faked ?

2009-11-10 Thread desfrenes
thanks, latest revision got it right ! On 10 nov, 16:20, mdipierro mdipie...@cs.depaul.edu wrote: It seems I took a patch that was not tested enough (my mad only, I should have) and it is creating lots of problems. I am about to post 1.72.3. I apologize to everybody. Massimo On Nov 10,

[web2py:35029] 1.72.3 is OUT (do not use 1.72.1 and 1.72.2)

2009-11-10 Thread mdipierro
Fixes bugs introduced in 1.72.1 that may affect mysql, postgresql and migrations. --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups web2py-users group. To post to this group, send email to web2py@googlegroups.com To

[web2py:35033] Re: Accessing Web2Py services via ExtJS

2009-11-10 Thread Timbo
I've thought about it but that's it. If you're willing to do it yourself, here are some helpful links of some django options that could be ported over: http://github.com/gsancho/extdirect.django http://code.google.com/p/django-rest-interface/ On Nov 10, 8:58 am, Don sam...@gmail.com wrote:

[web2py:35034] Re: installing web2py on Ubuntu

2009-11-10 Thread mdipierro
Can you do it and email me the script? On Nov 10, 9:37 am, salingrosso salingro...@gmail.com wrote: If we add: libapache2-mod-wsgi ? 2009/11/10 mdipierro mdipie...@cs.depaul.edu That is similar the configuration I use. Ideally one should use mod_wsgi on production but I would not know

[web2py:35035] Re: Validator IS_IN_DB display string from joined tables

2009-11-10 Thread Frederik Wagner
thanks for the fast reply, but it does not work for me On Tue, Nov 10, 2009 at 3:45 PM, mdipierro mdipie...@cs.depaul.edu wrote: Yes you can do it with a bit of extra work: db.define_table('person',Field('name')) db.define_table('dog',Field('name'),Field('owner',db.person))

[web2py:35036] Re: installing web2py on Ubuntu

2009-11-10 Thread salingrosso
This is the script, I've only added libapache2-mod-wsgi, now I'm trying to execute the script in my secondary pc. But: why do you install python 2.5 and not the default 2.6? 2009/11/10 mdipierro mdipie...@cs.depaul.edu Can you do it and email me the script? On Nov 10, 9:37 am, salingrosso

[web2py:35037] Re: installing web2py on Ubuntu

2009-11-10 Thread salingrosso
I think that we can improve the script so that the user could choose the database to install. 2009/11/10 salingrosso salingro...@gmail.com This is the script, I've only added libapache2-mod-wsgi, now I'm trying to execute the script in my secondary pc. But: why do you install python 2.5 and

[web2py:35038] Re: Accessing Web2Py services via ExtJS

2009-11-10 Thread Fran
On Nov 10, 8:58 am, Don sam...@gmail.com wrote: Has anyone used web2py services with extjs, such as json-rpc? If so, do you have example code that you can share? JSON-RPC is fairly simple - search the list for Pyjamas as an example... On Nov 10, 3:52 pm, Timbo tfarr...@swgen.com wrote:

[web2py:35039] Re: installing web2py on Ubuntu

2009-11-10 Thread Thadeus Burgess
Also this script does nothing to configure postgres with users/permissions. So that will still need to be done It can be added if the script can su to postgres user. -Thadeus On Tue, Nov 10, 2009 at 10:34 AM, salingrosso salingro...@gmail.com wrote: I think that we can improve the script

[web2py:35040] Re: Validator IS_IN_DB display string from joined tables

2009-11-10 Thread mdipierro
It seems I was wrong. This is not possible but not diffciult to implement. Give me a couple of days. On Nov 10, 10:15 am, Frederik Wagner fner...@googlemail.com wrote: thanks for the fast reply, but it does not work for me On Tue, Nov 10, 2009 at 3:45 PM, mdipierro mdipie...@cs.depaul.edu

[web2py:35041] Re: installing web2py on Ubuntu

2009-11-10 Thread mdipierro
The script is supposed to be run as root so, it should have to problem to sudo postgres On Nov 10, 11:08 am, Thadeus Burgess thade...@thadeusb.com wrote: Also this script does nothing to configure postgres with users/permissions. So that will still need to be done It can be added if the

[web2py:35042] Re: installing web2py on Ubuntu

2009-11-10 Thread mdipierro
It should also configure ssl certificates. On Nov 10, 11:08 am, Thadeus Burgess thade...@thadeusb.com wrote: Also this script does nothing to configure postgres with users/permissions. So that will still need to be done It can be added if the script can su to postgres user. -Thadeus On

[web2py:35043] Re: installing web2py on Ubuntu

2009-11-10 Thread salingrosso
The server works! But how can I verify if it run with wsgi? And how can I access to the admin? Maybe that SSL doesn't work? 2009/11/10 mdipierro mdipie...@cs.depaul.edu It should also configure ssl certificates. On Nov 10, 11:08 am, Thadeus Burgess thade...@thadeusb.com wrote: Also this

[web2py:35044] Re: installing web2py on Ubuntu

2009-11-10 Thread mdipierro
the script I sent does not use mod_wsgi and does not setup ssl. I just said it should do those does things but it does not now. On Nov 10, 11:30 am, salingrosso salingro...@gmail.com wrote: The server works! But how can I verify if it run with wsgi? And how can I access to the admin? Maybe

[web2py:35045] Re: installing web2py on Ubuntu

2009-11-10 Thread salingrosso
I've tried the version that install wsgi, the one that I've send to you. You should try it. So this script install a server ready for web2py but without admin. I think this solution is better for production environments! The best should be a script that is distro agnostic and install everything

[web2py:35046] Re: installing web2py on Ubuntu

2009-11-10 Thread Thadeus Burgess
Source installations are still prone to distro-specific problems. It is best to just create an install script for each distro.. Or better yet, create .deb/.rpm/.pacman/.portage packages for web2py that can do all of this :) -Thadeus On Tue, Nov 10, 2009 at 11:37 AM, salingrosso

[web2py:35047] Re: Accessing Web2Py services via ExtJS

2009-11-10 Thread Don
Ext.Direct implements it's own specification that is not as simple as json-rpc to setup and use. On Nov 10, 11:49 am, Fran francisb...@googlemail.com wrote: On Nov 10, 8:58 am, Don sam...@gmail.com wrote: Has anyone used web2py services with extjs, such as json-rpc?  If so, do you have

[web2py:35048] Re: installing web2py on Ubuntu

2009-11-10 Thread mdipierro
I have not got it. On Nov 10, 11:37 am, salingrosso salingro...@gmail.com wrote: I've tried the version that install wsgi, the one that I've send to you. You should try it. So this script install a server ready for web2py but without admin. I think this solution is better for production

[web2py:35049] Re: installing web2py on Ubuntu

2009-11-10 Thread Jim
Google App Engine requires 2.5 I'm sure web2py will work with just 2.6 installed if it really bothers somebody to install 2.5 On Nov 10, 8:32 am, salingrosso salingro...@gmail.com wrote: But: why do you install python 2.5 and not the default 2.6?

[web2py:35050] Re: installing web2py on Ubuntu

2009-11-10 Thread mdipierro
I have had problems with running GAE dev_appserver and Python 2.6 (do not remember what they were and I was using stackless 2.6). Works fine with 2.5 of course. On Nov 10, 1:31 pm, Jim jdeib...@gmail.com wrote: Google App Engine requires 2.5 I'm sure web2py will work with just 2.6 installed

[web2py:35051] Re: installing web2py on Ubuntu

2009-11-10 Thread Timbo
That's so cool...but why so many unnecessary packages? mc, g++, emacs, ssh, build_essential, zip, unzip, openssh-server, postfix ??? Many of these are great packages and necessary for a well-run server (except emacs, build_essential, g++), but do they belong in a web2py install script? My take

[web2py:35052] Re: Using web2py with jython

2009-11-10 Thread Timbo
Massimo, I'm trying to rewrite template.py for Jython and I can't seem to figure out what the re_strings regex is doing. I wrote a routine for what I thought it was doing and that puts \n all over my pages. So I took it out entirely and things seem OK. What is re_strings for? On Nov 10, 8:15 

[web2py:35053] Re: installing web2py on Ubuntu

2009-11-10 Thread mdipierro
True. I was sharing the script I use. On Nov 10, 2:42 pm, Timbo tfarr...@swgen.com wrote: That's so cool...but why so many unnecessary packages? mc, g++, emacs, ssh, build_essential, zip, unzip, openssh-server, postfix ??? Many of these are great packages and necessary for a well-run

[web2py:35054] Re: Using web2py with jython

2009-11-10 Thread mdipierro
It finds all strings in the code, single quote, double quote, triple single and triple double. The complication is that single quotes for example, allow escaped single quotes inside, etc. On Nov 10, 2:55 pm, Timbo tfarr...@swgen.com wrote: Massimo, I'm trying to rewrite template.py for Jython

[web2py:35055] Re: Using web2py with jython

2009-11-10 Thread Jonathan Lundell
On Nov 10, 2009, at 12:55 PM, Timbo wrote: Massimo, I'm trying to rewrite template.py for Jython and I can't seem to figure out what the re_strings regex is doing. I wrote a routine for what I thought it was doing and that puts \n all over my pages. So I took it out entirely and

[web2py:35056] Re: Join web2py wave

2009-11-10 Thread Doberman_Illinois
Richard May I get a invite if any are left Thank You Dennis leisurehourshobb...@gmail.com On Nov 9, 5:56 pm, Richard richar...@gmail.com wrote: invited: encomp...@gmail.com ka...@gmx.net monch1...@gmail.com na...@napas.lt mp.ch...@gmail.com (4 invites left) On Nov 10, 9:40 am, mikech

[web2py:35057] Re: Other new DAL features in trunk

2009-11-10 Thread Tim Michelsen
1) to deal with legacy databases db.define_table('mytable',Field('myfield','id'),Field ('otherfield')) does legacy database id settings also support SQLite tables? --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google

[web2py:35058] Re: Other new DAL features in trunk

2009-11-10 Thread mdipierro
yes but the 'id' has to be integer On Nov 10, 5:50 pm, Tim Michelsen timmichel...@gmx-topmail.de wrote: 1) to deal with legacy databases       db.define_table('mytable',Field('myfield','id'),Field ('otherfield')) does legacy database id settings also support SQLite tables?

[web2py:35059] Re: Join web2py wave

2009-11-10 Thread Richard
invited: mft...@gmail.com leisurehourshobb...@gmail.com no invites left for now :( On Nov 11, 10:27 am, Doberman_Illinois leisurehourshobb...@gmail.com wrote: Richard May I get a invite if any are left Thank You Dennis leisurehourshobb...@gmail.com On Nov 9, 5:56 pm, Richard

[web2py:35060] Re: powered by web2py?

2009-11-10 Thread Richard
My business site: http://sitescraper.net/ On Oct 26, 1:46 pm, mdipierro mdipie...@cs.depaul.edu wrote: www.appliedstacks.comis dead. This means I lost a way to keep track of web2py sites. So I made something trivial for now: http://web2py.com/poweredby I am sure I missing many sites that

[web2py:35061] Python + C++ = Go

2009-11-10 Thread ionel
Somebody interested ? http://golang.org --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups web2py-users group. To post to this group, send email to web2py@googlegroups.com To unsubscribe from this group, send email to

[web2py:35062] Re: Python + C++ = Go

2009-11-10 Thread mdipierro
I may use this. I also like the D language. On Nov 10, 9:08 pm, ionel ionelanton...@gmail.com wrote: Somebody interested ?http://golang.org --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups web2py-users group. To

[web2py:35063] Re: get html content

2009-11-10 Thread MrGoni
Thank you very much! Worked like a charm! On Nov 10, 1:16 am, mdipierro mdipie...@cs.depaul.edu wrote: This: @service.xml def tableservice():     limitby = (int(request.vars.start),int(request.vars.count))     table = SQLTABLE(db().select(db [request.vars.table].ALL,limitby=limitby))    

[web2py:35064] Re: Plugin Layout

2009-11-10 Thread Wiiboy
I just noticed: if you hit change layout and you're not logged in as an Admin, it doesn't redirect you to the change layout page after you log in. The isn't a ?_next= in the url. --~--~-~--~~~---~--~~ You received this message because you are subscribed to the

[web2py:35065] Re: Python + C++ = Go

2009-11-10 Thread Graham Dumpleton
On Nov 11, 2:35 pm, mdipierro mdipie...@cs.depaul.edu wrote: I may use this. I also like the D language. On Nov 10, 9:08 pm, ionel ionelanton...@gmail.com wrote: Somebody interested ?http://golang.org Quoting the FAQ: There is no safe way to call Go code from C or C++ yet. Pity,

[web2py:35066] Re: Python + C++ = Go

2009-11-10 Thread mdipierro
Am I wrong or this is coming out from Google? I like the concurrency model. On Nov 10, 9:58 pm, Graham Dumpleton graham.dumple...@gmail.com wrote: On Nov 11, 2:35 pm, mdipierro mdipie...@cs.depaul.edu wrote: I may use this. I also like the D language. On Nov 10, 9:08 pm, ionel

[web2py:35067] ssh tunnel Dreamhost

2009-11-10 Thread Pepe
Hi! I need to manage the application I installed on Dreamhost, but I do not have ssl. Anyone could manage it through ssh tunnel? Could you explain how? Thank you very much! --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google

[web2py:35069] Re: Python + C++ = Go

2009-11-10 Thread Wiiboy
Ya, Google created it. See: http://google-opensource.blogspot.com/2009/11/hey-ho-lets-go.html --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups web2py-users group. To post to this group, send email to

[web2py:/] Re: Other new DAL features in trunk

2009-11-10 Thread chris_g
This is marvellous news. I read the manual last night and realised that the field ID restriction was the only thing stopping me deploying web2py in conjunction with a major legacy app that I am using. Thanks Michael for getting this feature happening. Can I confirm one thing, with a table like

[web2py:35070] floating imprecision

2009-11-10 Thread Richard
Hello, I have some floating point numbers in my database which I need to test for equality. Numbers like 0.3 are failing an equality test. So, is there a way to store floating point numbers precisely? Or should I be using something like: offset = 0.01 (db.table.fp v - offset)(db.table.fp v