[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

[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 th

[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@googlegro

[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: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 wrote: > On Nov 11, 2:35 pm, mdipierro wrote: > > > I may use this. I also like the D language. > > > On Nov 10, 9:08 pm, ionel wrote: > > > > Somebody interested ?http://golang.org

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

2009-11-10 Thread Graham Dumpleton
On Nov 11, 2:35 pm, mdipierro wrote: > I may use this. I also like the D language. > > On Nov 10, 9:08 pm, ionel wrote: > > > Somebody interested ?http://golang.org Quoting the FAQ: "There is no safe way to call Go code from C or C++ yet." Pity, otherwise would have contemplated using it

[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: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 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)) >     return table >

[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 wrote: > 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

[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:35060] Re: powered by web2py?

2009-11-10 Thread Richard
My business site: http://sitescraper.net/ On Oct 26, 1:46 pm, mdipierro 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 were reported. Cou

[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 wrote: > Richard > > May I get a invite if any are left > > Thank You > Dennis > leisurehourshobb...@gmail.com > > On Nov 9, 5:56 pm, Richard wrote: > > > invited: > > enc

[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 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: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 Goo

[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 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 wrote: >

[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 a

[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 wrote: > Massimo, > > I'm trying to rewrite template.py for Jython and I can't see

[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 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 server > (except e

[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:1

[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: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 wrote: > Google App Engine requires 2.5 > > I'm sure web2py will work with just 2.6 installed if it really both

[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 wrote: > But: why do you install python 2.5 and not the default 2.6? --~--~-~--~~~---~--~~ You received

[web2py:35048] Re: installing web2py on Ubuntu

2009-11-10 Thread mdipierro
I have not got it. On Nov 10, 11:37 am, salingrosso 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 environments! > The be

[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 wrote: > > On Nov 10, 8:58 am, Don wrote: > > > Has anyone used web2py services with extjs, such as json-rpc?  If so, > > > do you have example code that you can share? >

[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 wrote: > I'v

[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 fro

[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 wrote: > 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?

[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 > > It should also configure ssl certificates. > > On Nov 10, 11:08 am, Thadeus Burgess wrote: > > Also this script does nothing to configure postgre

[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 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 Tue, Nov 10, 20

[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 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 postg

[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 wrote: > thanks for the fast reply, but it does not work for me > > > > On Tue, Nov 10, 2009 at 3:45 PM, mdipierro wrote: > > > Yes you can do it with a bit

[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 wrote: > I think that we can improve the script so that the user could

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

2009-11-10 Thread Fran
> On Nov 10, 8:58 am, Don 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 wrote: > I've thought about it but that

[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 > 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.

[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 > > Can you do it and email me the script? > > On Nov 10, 9:37 am, salingrosso wrote: > > If we add:

[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 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)) > db.define_table('walk',Field('dog

[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 wrote: > If we add: libapache2-mod-wsgi ? > > 2009/11/10 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 > > installatio

[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 wrote: > Has anyone used we

[web2py:35032] Re: faked ?

2009-11-10 Thread desfrenes
thanks, latest revision got it right ! On 10 nov, 16:20, mdipierro 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, 9:14 am, desf

[web2py:35031] Re: installing web2py on Ubuntu

2009-11-10 Thread salingrosso
If we add: libapache2-mod-wsgi ? 2009/11/10 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 wrote: > > I'

[web2py:35030] Re: faked ?

2009-11-10 Thread desfrenes
No problem :-) On 10 nov, 16:20, mdipierro 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, 9:14 am, desfrenes wrote: > > > Hel

[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 u

[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 migra

[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 wrote: > Hello ! > > Creating a table and then adding a new Field, here's what I ge

[web2py:35026] Re: faked ?

2009-11-10 Thread desfrenes
Oh, that was using the svn trunk. On 10 nov, 16:14, desfrenes 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) > ); > success! >

[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:35024] Re: MySQL error with Welcome and Examples

2009-11-10 Thread mdipierro
In gluon/sql.py there is a if self._db._dbname == 'mysql': fields.append('PRIMARY KEY(%s)' % field[0].name) other = ' ENGINE=InnoDB CHARACTER SET utf8;' should be if self._db._dbname == 'mysql': fields.append('PRIMARY KEY(%s)' % self.fields[0]

[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 wrote: > > edit routes.py and write > > routes_in=[('/CallerWantsCustomerService,$arg1,$arg2', >'/myapp/default/CallerWantsCustomerSer

[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: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: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 emai

[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 map

[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 wrote: > I've installed web2py on "arch linux" and I only needed to download > web2

[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 ComputedDogAttr

[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: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 SET

[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 pleas

[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 configura

[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,