[web2py] Re: VoltDB

I tought yes, Python is a requirement, see at: http://cl.ly/1GMu Source: http://cl.ly/1GX1 Regards, Oscar. On 1 jun, 23:00, mdipierro wrote: > Is there a python driver for it? > > On Jun 1, 1:02 pm, Oscar wrote: > > > Hi there, > > > There is a new DBMS in the block, a new kind of DBMS. Ples

[web2py] error occurs when select all fields from a legacy datatable without id field

there is a legacy datatable named 'test' +---+--+--+-+-+---+ | Field | Type | Null | Key | Default | Extra | +---+--+--+-+-+---+ | jtk | varchar(255) | YES | | NULL| | | age | int(11) | YES |

[web2py] Re: Frivolous request for login/logout

It's probably not the most elegant of solutions, but in db.py I simply set: if auth.is_logged_in(): auth.messages.logged_in='Logged in successfully, welcome ' + auth.user.first_name + ' ' + auth.user.last_name auth.messages.logged_out='Logged out successfully, until next time ' + auth.use

[web2py] Re: Frivolous request for login/logout

Curious - I tried something like this earlier and had trouble with it. For now, I like hamdy's solution. On Jun 3, 4:33 am, annet wrote: > It's probably not the most elegant of solutions, but in db.py I simply > set: > > if auth.is_logged_in(): >     auth.messages.logged_in='Logged in successfull

[web2py] Re: Frivolous request for login/logout

This's not working !! you need to set the message before actually logged in !! your solution just set the message after user is actually logged in so it's useless moreover, setting the logout message will not work, unless the index page itself has no flash message set or else the flash message in

[web2py] Re: error occurs when select all fields from a legacy datatable without id field

in legacy databases, you should manually create a field called id for each table and set it to be a primary key you need in your model db.py , to set migrate=False for every table definition On Jun 3, 11:17 am, hywang wrote: > there is a legacy datatable named 'test' > +---+--+---

[web2py] proposal of introducing generic.load

Hi Massimo, I just came up with a handy myapp/views/generic.load, and I wonder whether you will like to accept it as part of web2py scaffold. It is already self-documented. {{ ''' With this generic.load file, you can use same action to serve two purposes. Example modified from http://www.web

[web2py] Re: Install in the linode.com?

I followed instructions from here: http://www.web2pyslices.com/main/slices/take_slice/14 Worked for me on linode. On Jun 3, 8:14 am, Ricardo Arg wrote: > How to install the web2py in linode.com in wsgi? > > thanks!

[web2py] Re: routes to have userprofile pages

thanks On Jun 3, 6:08 am, Adi wrote: > You could use an argument. > > www.myapp.com/userprofilecan be mapped to a controller/method > likewww.myapp.com/app/profiles/show/userprofile > > where app = application, profiles = controller, show = function, > userprofile is an argument accessed by requ

[web2py] Re: Web2py in Ireland

I'm in Ireland - sunny West Cork... web2py newbie at the moment but learning fast and planning on releasing a couple of apps sometime later this year... I too was wondering if there were other web2py users in Ireland... Tom On Jun 2, 2:18 pm, ChrisM wrote: > Calling all users in Ireland > > I

[web2py] Re: routes to have userprofile pages

Having trouble getting routes to work (not used before) for instance as a test I did: in routes.py: routes_in = ( ('/profile/*', '/init/default/userprofilepage/*'),) routes_out = ( ('/init/default/userprofilepage/*', '/profile'),) in default controller: def userprofilepage(): userprofile re

[web2py] Multiple instances of same application

Is there a preferred way to handle multiple instances of the same application installed on the same machine? Say for instance is there's 3 dev environments and 2 staging environments on one server pointing at different databases? Is there a preferred way of getting the configuration to each uniqu

[web2py] Re: variables turning into lists

Iceberg, Thanks, you were right. I didn't think I had to know/care about whether requests were POST or GET with web2py (and indeed had to refresh my memory of what the difference was - I'm new to this whole interweb thing), as far as I was concerned I was just calling functions within controllers.

[web2py] Re: Frivolous request for login/logout

def set_welcome(form): session.flash=T('hello %(name)s', dict(name=auth.user.first_name)) auth.settings.login_onaccept=set_welcome On Jun 3, 5:22 am, "hamdy.a.farag" wrote: > This's not working !! > > you need to set the message before actually logged in !! > your solution just set the mess

[web2py] Re: proposal of introducing generic.load

I am not convinced this is general enought but I like the idea. Let me think about it. On Jun 3, 7:17 am, Iceberg wrote: > Hi Massimo, > > I just came up with a handy myapp/views/generic.load, and I wonder > whether you will like to accept it as part of web2py scaffold. It is > already self-docum

[web2py] Re: new stuff in trunk...

I would also trust someone known like PayPal more than the average website. Hopefully a good PayPal solution can be implemented like PHP has. But it's a lot of work for a hobby programmer. What do you think about having some kind of bounty system where people interested in a difficult feature lik

[web2py] Re: Multiple instances of same application

they can see request.env.host_name and you can use hostnames like .yourdomain.com you can symlink different apps to the same one so you have one but it will see different request.application depending on the request On Jun 3, 8:50 am, Doug Warren wrote: > Is there a preferred way to handle mult

[web2py] date operation

hi, how i can increment a data field of x days? example i have db.Prestiti.Data_richiesta=2010-06-03 16:13:14 db.Prestiti.Durata=30 i want generate fineprestito=2010-07-03 16:13:14 i wanna add 30 days to a data field

[web2py] protect auth user registration

hi how i can permit the registration of new user (auth system) only for refistered user?

[web2py] Re: date operation

Search doc for python built-in timedelta please. On Jun3, 10:30pm, ceriox wrote: > hi, > how i can increment a data field of x days? > > example > i have > db.Prestiti.Data_richiesta=2010-06-03 16:13:14 > db.Prestiti.Durata=30 > > i want generate > fineprestito=2010-07-03 16:13:14 > > i wanna add

[web2py] current version source??

Hi, I would like to know if the source of the current version are fixed or if they change over time? I compared the dal.py and sql.py and they were differents for the same version of current version? Thanks. Jonhy

[web2py] Re: date operation

i'm looking for it but timedelta retun the difference from 2 date , i need to add 30 days to a date like my example i have a date field and an integer field with the number of days, i wanna add the number of days to a data field. (i'm not an expert pyton programmer) On 3 Giu, 16:32, Iceberg wr

[web2py] Re: date operation

delta = date1 - date2 and then delta is a timedelta instance. And you reverse it by: date2 + delta == date1 Isn't it simple maths? :-) So be a python lover. It is intuitive and it won't let you down. On Jun3, 11:06pm, ceriox wrote: > i'm looking for it but timedelta retun the difference f

[web2py] Dropbox with (IS_IN_DB) without requires constrains

Hi, I would like to know if there is a way as simple of "requires = IS_IN_DB" to show a dropbox of what is already in my table, but without the need of requiring that field be entered in my other table. I have many fields that need dropbox but they are not all used at the same time (nulls fields :

Re: [web2py] Re: VoltDB

System requirements http://voltdb.com/product/systemrequirements Dual-core processors are a minimum requirement. Four or eight physical cores are recommended for optimal performance 4 Gigabytes should be considered a minimum configuration So if I don't own a server I have no chance to run it.

[web2py] Re: date operation

i resolve reading some python guide around the web in my view: delta=datetime.timedelta(days=int(rows.Durata_prestito)) data= datetime.date(rows.Data_richiesta.year, rows.Data_richiesta.month, rows.Data_richiesta.day) fine_prestito=data+delta =fine_prestito - rows.Durata

[web2py] Re: Dropbox with (IS_IN_DB) without requires constrains

On Jun 3, 10:26 am, Jean Guy wrote: > Hi, > > I would like to know if there is a way as simple of "requires = IS_IN_DB" to > show a dropbox of what is already in my table, but without the need of > requiring that field be entered in my other table. I have many fields that > need dropbox but they

Re: [web2py] Re: Dropbox with (IS_IN_DB) without requires constrains

Wonderful! It works just fine. Thanks. Richard 2010/6/3 Yarko Tymciurak > > On Jun 3, 10:26 am, Jean Guy wrote: > > Hi, > > > > I would like to know if there is a way as simple of "requires = IS_IN_DB" > to > > show a dropbox of what is already in my table, but without the need of > > requir

[web2py] Database Image Rendering

How would I go about rendering an image that's been uploaded and stored in a database?

[web2py] Re: Database Image Rendering

Have you tried something like this: (replace png with whatever the correct image format it) Let us know if this works. - Yarko On Jun 3, 11:23 am, Aaron Crowe wrote: > How would I go about rendering an image that's been uploaded and > stored in a database?

Re: [web2py] Database Image Rendering

that should be enough http://web2py.com/book/default/docstring/URL>(r=request , f='download', args=image.file)}}" /> that is from http://web2py.com/book/default/section/3/6

Re: [web2py] Database Image Rendering

Yarkos approach will work only if you store it in a blob field, but not if image is uploaded in a directory my approach (Massimos approach :) ) should work for both cases

[web2py] Re: Database Image Rendering

On Jun 3, 11:52 am, Vasile Ermicioi wrote: > Yarkos approach will work only if you store it in a blob field, but not if > image is uploaded in a directory > my approach (Massimos approach :) ) should work for both cases What Vasile showed requires that the image file is in the downloads folder (r

[web2py] Re: protect auth user registration

you can try.. def user(): if request.args(0)=='register' and not auth.user: redirect('some_error_page') return dict(form=auth()) On Jun 3, 9:31 am, ceriox wrote: > hi > how i can permit the registration of new user (auth system) only for > refistered user?

[web2py] Re: current version source??

The source code changes every day. Once in a while we release a stable version. Stable releases are backward compatible. sql.py is the production database abstraction layer. dal.py is an experimental attempt to replace sql.py and remain backward compatible. It is there for testers. It is not used

[web2py] Re: Database Image Rendering

Vasile approach (create an action to serve the blob as an image) is to be preferred because Yarko's approach is not cross-browser compatible. Anyway, if you choose to do it the Yarko's way be careful because you need to base64 encode not urlescape. web2py provides a helper to do this http://web2p

[web2py] Re: checkboxes and radio widget failed with multiple validators

Hello, Is there any interest in this problem ? Is there any chance a correction may be integrated into trunk ? -Mathieu On Thu, May 27, 2010 at 20:20, Mathieu Clabaut wrote: > Reported as http://code.google.com/p/web2py/issues/detail?id=80 > > Hello, > > I've met a problem with checkboxes an

[web2py] Installing postreSQL and psycopg2 in Mac osx SnowLeopard

In theory, installing psycopg2 to connect with a PostreSQL database, would be so easy as: easy_install psycopg2 But in the default configuration of Mac Os X snowleopard 10.6 seems that we get some errors. This is an attempt to help to config you web2py with PostreSQL database and psycopg2 connecti

[web2py] Re: Upload Issue --- Very Wierd --- Maybe a bug!

Any idea Please ? Does any one already notice such thing ? I'm using Web2py Version: 1.76.5 Python: 2.5 Thanks! On Jun 3, 2:00 am, Yannick wrote: > Hello mate. > I can't upload in this situation below: > > Here is the view: > > ... > mainImage = $(".image-wrapper").HandlerFile( >             {

[web2py] Re: Frivolous request for login/logout

> This's not working !! you need to set the message before actually logged in !! Why is that? I welcome a user who logs in so setting auth.messages.logged_in works. When does auth.user provide you with values for first_name and last_name in your solution? Before logging in? > your solution just

[web2py] Re: Database Image Rendering

On Jun 3, 12:07 pm, mdipierro wrote: > Vasile approach (create an action to serve the blob as an image) is to > be preferred because Yarko's approach is not cross-browser compatible. Specifically IE 5-7 (see http://www.websiteoptimization.com/speed/tweak/inline-images/); There are other consi

[web2py] Re: Database Image Rendering

On Jun 3, 12:07 pm, mdipierro wrote: > Vasile approach (create an action to serve the blob as an image) is to > be preferred because Yarko's approach is not cross-browser compatible. just to be clear: this approach does not by itself serve a blob - if there is no image file in the "/upload

[web2py] Re: Multiple instances of same application

I think Doug's puzzle deserves a more general solution. The requirement and challenge is: R1. The app's central source code should contain default setting. R2. The app's multiple deployment instances should be allowed to contain its local setting. R3. And after the next "hg update", the default set

[web2py] Re: checkboxes and radio widget failed with multiple validators

I will look into this hopefully tomorrow. On Jun 3, 12:36 pm, Mathieu Clabaut wrote: > Hello, > > Is there any interest in this problem ? Is there any chance a correction may > be integrated into trunk ? > > -Mathieu > > On Thu, May 27, 2010 at 20:20, Mathieu Clabaut > > > >  wrote: > > Reported

[web2py] Re: Frivolous request for login/logout

Hi annet Saying it's useless I meant that setting the message after logging in , I didn't mean to be mean at all, sorry that you misunderstood me :) Now let's rethink you solution : It will work right ? but when ? it will work if you just in the index page made something like: def index():

[web2py] unable to install app from a dev in a prod web2py installation

Hello, I am unable unpack it in my prod web2py environnement... Is it a Linux permission issue? I pack it from my dev web2py I try to give my app.w2p www-data owner by sudo chown www-data.www-data myapp.w2p Before try to install it in my prod web2py installation. My prod web2py is full fonct

Re: [web2py] Re: Multiple instances of same application

Or... we can copy flask and integrate a configuration module.. God I pray we never use something like `0_local_config_pls_dont_pack_dont_commit.py` INTO web2py. web2py and its naming conventions >.< -- Thadeus On Thu, Jun 3, 2010 at 10:22 AM, Iceberg wrote: > I think Doug's puzzle deserves

[web2py] A slice hot from the oven: Cascading drop down lists

Here's a widget that attempts to handle cascading drop down lists. It's still a work in progress but seems to be functional (at least for my particular situation). http://web2pyslices.com/main/slices/take_slice/85

[web2py] Re: Frivolous request for login/logout

on the ideal case , most people don't force login_url because suppose for example, you've a login form above in the banner of your web app and when user stands in a specific page and enters his user/pass in login form , ...you don't want him to leave the current page right? moreover your web site

[web2py] Re: Multiple instances of same application

Well, If I well understood the problem, I think you can have something like: 0.py with a connection to a shared database database_to_use = request.application db = DAL(shared_db) db.define_table(Field('db_name', 'string')) row = db().select(db.shared_db.db_name==database_to_use).select().first() i

Re: [web2py] Re: Multiple instances of same application

What I was thinking was something we use in the gaming world, called a console variable, you can specify their values in code, in a config file, through an in app interface, or through the command line. In web2py terms, I was thinking to make a global singleton that when first instantiated would s

[web2py] Re: Frivolous request for login/logout

Annet, as I state in my previous post, I had tried your approach before first posting this thread and discovered it didn't work for exactly the reasons that hamdy lists. Massimo, thanks for the response, too. Looks like you are suggesting exactly hamdy's solution, which I have implemented, and it

[web2py] Re: Ticket when trying to upload an image

This is still an open issue for me. Please disregard my 2nd post as, obviously, jQuery has nothing to do with it (just delirious at 4:55am) as it is showing up in appadmin, which has no jQuery to speak of. In my app, the upload field is embedded in a jQuery UI accordion, but I can think of no reaso

Re: [web2py] Re: Multiple instances of same application

Exactly, We can copy flask and add the same configuration module which implements everything and more of what you just described. -- Thadeus On Thu, Jun 3, 2010 at 4:33 PM, Doug Warren wrote: > What I was thinking was something we use in the gaming world, called a > console variable, you can

Re: [web2py] Re: Multiple instances of same application

For context, please see http://flask.pocoo.org/docs/config/ http://flask.pocoo.org/docs/api/#configuration -- Thadeus On Thu, Jun 3, 2010 at 4:55 PM, Thadeus Burgess wrote: > Exactly, We can copy flask and add the same configuration module which > implements everything and more of what you

[web2py] Rocket for production sites?

Is it the intention that web2py can be deployed using Rocket for production sites?

Re: [web2py] Upload Issue --- Very Wierd --- Maybe a bug!

On Thu, Jun 3, 2010 at 03:00, Yannick wrote: > Hello mate. > I can't upload in this situation below: > > Here is the view: > > ... > mainImage = $(".image-wrapper").HandlerFile( >            { >                mainImageUrl: "", >                helper: $("#tooltip"), >                ... >      

[web2py] Wouldn't it be cool ...

if web2py could run native on the Droid? Then, give me a foldup keyboard and who would need a laptop any more?

Re: [web2py] Wouldn't it be cool ...

http://google-opensource.blogspot.com/2009/06/introducing-android-scripting.html ? On Thu, Jun 3, 2010 at 5:34 PM, weheh wrote: > if web2py could run native on the Droid? Then, give me a foldup > keyboard and who would need a laptop any more?

[web2py] LIKE is slow on RDBS; true for GAE also?

When implementing "LIKE", I noticed that the following line is extremely slow (for large numbers of records) on RDBS: rows = db(buyer.id>0).select().find(lambda row:row.name.startswith('C')) I haven't uploaded my data to GAE yet to test. Before I do, since the upload is rather monotonous, does an

[web2py] unique entry or null validation

There is a field which I want user to enter different answer, or just keep in empty. I've tried by: db.table.field.requires=IS_NOT_IN_DB(db, 'table.field') But, it will failed, if the second empty field entered. How could I do the validation for this case? Is there any method?

[web2py] Re: checkboxes and radio widget failed with multiple validators

Maybe your patch is ok. But wouldn't it be not necessary to use requires=[IS_IN_SET(...), IS_NOT_EMPTY()]? Because you must already mention all the allowed values in the IS_IN_SET() and usually empty value in not inside. On Jun4, 1:36am, Mathieu Clabaut wrote: > Hello, > > Is there any interest i

Re: [web2py] LIKE is slow on RDBS; true for GAE also?

On Fri, Jun 4, 2010 at 01:25, Matthew wrote: > When implementing "LIKE", I noticed that the following line is > extremely slow (for large numbers of records) on RDBS: > > rows = db(buyer.id>0).select().find(lambda > row:row.name.startswith('C')) Did you try: rows = db(db.buyer.name.like('C%')).se

[web2py] Re: Where can I download web2py 1.77.3?

Well, I followed the advise of Dr. Massimo, thank's a lot. I updated all about my applications in web2faction, but a I did all manually, because when I used the script for install I can't used admin well. (install applications and local_import). I am using in my applications mod_wgsi 2.5 and pytho

Re: [web2py] LIKE is slow on RDBS; true for GAE also?

I think GAE doesn't support like

[web2py] Re: unable to install app from a dev in a prod web2py installation

> Can I just copy the all the tree in /applications/myapp from my dev to my > prod web2py environnement? yes

[web2py] Re: A slice hot from the oven: Cascading drop down lists

+1 On Jun 3, 2:42 pm, "mr.freeze" wrote: > Here's a widget that attempts to handle cascading drop down lists. > It's still a work in progress but seems to be functional (at least for > my particular situation).http://web2pyslices.com/main/slices/take_slice/85

[web2py] Re: Ticket when trying to upload an image

which table? On Jun 1, 1:42 am, weheh wrote: > I got the following ticket when trying to upload an image via the > appadmin: > > Traceback (most recent call last): >   File "C:\web2py\gluon\restricted.py", line 178, in restricted >     exec ccode in environment >   File "C:/web2py/applications/my

[web2py] Re: Rocket for production sites?

I have run cherrypy on a production site for a while for a while. The CERN people use cherrypy to serve images from the Large Linear Collider. I trust rocket even more but I do not have data or direct experience of its use in production. On Jun 3, 5:46 pm, knitatoms wrote: > Is it the intention t

[web2py] Re: Wouldn't it be cool ...

hmmm. I must get one of these... On Jun 3, 7:54 pm, Doug Warren wrote: > http://google-opensource.blogspot.com/2009/06/introducing-android-scr... > ? > > On Thu, Jun 3, 2010 at 5:34 PM, weheh wrote: > > if web2py could run native on the Droid? Then, give me a foldup > > keyboard and who would ne

Re: [web2py] LIKE is slow on RDBS; true for GAE also?

http://stackoverflow.com/questions/47786/google-app-engine-is-it-possible-to-do-a-gql-like-query

[web2py] Re: unique entry or null validation

On Jun 3, 11:31 pm, dlin wrote: > There is a field which I want user to enter different answer, or just > keep in empty. empty, or unique answer: db.table.answer.requires=IS_NULL_OR( IS_NOT_IN_DB( db, 'table.answer' ) ) > > I've tried by: > > db.table.field.requires=IS_NOT_IN_DB(db, 'table.fie

[web2py] Re: unique entry or null validation

db.table.field.requires=IS_NULL_OR(IS_NOT_IN_DB(db, 'table.field')) On Jun 3, 11:31 pm, dlin wrote: > There is a field which I want user to enter different answer, or just > keep in empty. > > I've tried by: > > db.table.field.requires=IS_NOT_IN_DB(db, 'table.field') > > But, it will failed, if

[web2py] I can not update

Good afternoon, my question is this, there is a postgres sql query that does not work, I am doing the query q is: for r in rws: try: db.ratecltes.insert(id_rutas=r.rutas.id, id_clte=r.clientes.id, rate=r.rutaproveedor.valor) except: #

[web2py] Re: I can not update

In this try: #1 except: # 2 if #1 fails because it violates a constraint, than you need to rollback before you can access the database again. Try this: try: #1 db.commit()

[web2py] Re: Multiple instances of same application

IMHO, flask and my lightweight proposal try to solve same problem. Both can load configuration for sure. My proposal's loading ability relies only on python's built-in import (via web2py's model mechanism), therefore no need to introducing extra module. Isn't it clean? The basic challenge is how t

[web2py] Re: Multiple instances of same application

I normally use #in models/0.py from gluon.storage import Storage settings=Storage() settings.development=True settings.email_sender='m...@example.com' ... Anyway, this does not address Iceberg's problem of packing some config files and not others. I am not convinced this scenario should be handle

Re: [web2py] LIKE is slow on RDBS; true for GAE also?

On Fri, Jun 4, 2010 at 02:36, Vasile Ermicioi wrote: > I think GAE doesn't support like Ouch, I forgot this. Excuse me for that. -- Álvaro Justen - Turicas http://blog.justen.eng.br/ 21 9898-0141