[web2py] import table

2010-01-09 Thread leone
I must import tables from a database manteining the id value of original tables. How can I do? It seems not possible force a value in rowid. Is it possible have more than one autonumber Field (not as rowid) in a table? Thanks leone -- You received this message because you are subscribed to the

Re: [web2py] import table

2010-01-09 Thread Philip Kilner
Hi Leone, leone wrote: I must import tables from a database manteining the id value of original tables. How can I do? It seems not possible force a value in rowid. Let web2py assign the id incrementally, as normal. Treat the imported row_id as a separate column of data, but set it as unique.

[web2py] Re: django and web2py

2010-01-09 Thread waTR
I agree that the documentation is lacking, especially for the newest features. Though, IMHO, documentation is ALWAYS a problem for developers. I am sure when this framework is popular enough there will be some people who will take that task on. For now I use the code, as it is quite readable, and

Re: [web2py] DataTables server-side processing on GAE?

2010-01-09 Thread Vasile Ermicioi
I had something like that in the past, my feeling is that GAE doesnt like importing ids, I changed just to insert new records (without ids, but the same data) On Sat, Jan 9, 2010 at 5:33 AM, toan75 toa...@gmail.com wrote: Hi all, I deploy a DataTables server-side processing on GAE (http://

[web2py] Re: DataTables server-side processing on GAE?

2010-01-09 Thread toan75
It's ok. This is error of format encoding DOS (on local) and UNIX. On Jan 9, 4:39 pm, Vasile Ermicioi elff...@gmail.com wrote: I had something like that in the past, my feeling is that GAE doesnt like importing ids, I changed just to insert new records (without ids, but the same data) On

[web2py] Re: import table

2010-01-09 Thread leone
Thanks for yours suggests. I have already created a new colum as integer valorized with rowids of old table. But I have to set it with the new value (in progress) when I insert a new row. There is a smart way to do it? leone On 9 Gen, 09:56, Philip Kilner phil.kil...@gmail.com wrote: Hi Leone,

[web2py] Re: import table

2010-01-09 Thread leone
I resolved with a new validator IS_AUTONUMBER On 9 Gen, 11:07, leone handja...@gmail.com wrote: Thanks for yours suggests. I have already created a new colum as integer valorized with rowids of old table. But I have to set it with the new value (in progress) when I insert a new row. There

[web2py] Re: Importing a large file

2010-01-09 Thread Brian M
paint_formulas is supposed to get the contents of the csv file. (See http://docs.python.org/library/csv.html) It should be populated by the line: paint_formulas = csv.reader(csvfile) where csv file should be the path to your csv file. Actually, I think that line should read like this instead:

[web2py] Re: Built-in Webserver

2010-01-09 Thread Timbo
would ? So you don't currently run a setup where you got to choose how it runs? I guess readers should take your comments with a grain of salt considering that in another thread you admit to being a young developer with not much experience. That's ok. It's good to start out conservative and

[web2py] Re: Looking for web2py, jQuery, AJAX contractors

2010-01-09 Thread weheh
Don't congratulate me, yet. It's not a done deal. But I would like to know, for planning purposes, what expertise I could have at my disposal. The scope of this project is novel, broad and deep and has high visibility, so would be a feather in anyone's cap. -- You received this message because

[web2py] Feature request?

2010-01-09 Thread kbochert
Problem: I have database tables for customers, members, etc that look like db.define_table('customer', Field('user_id', db.auth_user), address('bill'),#inherit address fields address('ship'),#inherit address fields phone, #inherit phone fields migrate =

[web2py] Re: Looking for web2py, jQuery, AJAX contractors

2010-01-09 Thread weheh
Oops, need I mention that there is money to be made? :^) -- You received this message because you are subscribed to the Google Groups web2py-users group. To post to this group, send email to web...@googlegroups.com. To unsubscribe from this group, send email to

[web2py] Re: Looking for web2py, jQuery, AJAX contractors

2010-01-09 Thread weheh
Don't congratulate me, yet. It's not a done deal. But I would like to know, for planning purposes, what expertise I could have at my disposal. The scope of this project is novel, broad and deep and has high visibility, so would be a feather in anyone's cap. There is also money to be made by all

Re: [web2py] Re: Built-in Webserver

2010-01-09 Thread Thadeus Burgess
would ? So you don't currently run a setup where you got to choose how it runs? Your assuming that by saying would that I mean if I had a choice I would. If I really ment the latter then I would have said the latter. As a general rhetorical comment, why do people have to put their own

[web2py] Re: Feature request?

2010-01-09 Thread mdipierro
yes db.define_table('customer', Field('user_id', db.auth_user, writable=False, readable=False), address('bill'),#inherit address fields address('ship'),#inherit address fields phone, #inherit phone fields migrate = 'customer.table' ) you

[web2py] Re: Built-in Webserver

2010-01-09 Thread mdipierro
I have not run any benchmark but it seems to me that running Apache provides better customization (like multiple domains, deny access to specific domains, better ssl support than wsgiserver) and speed for static files. Probably it does not make a major different when serving dynamic content in

[web2py] exec_environment exception

2010-01-09 Thread Jeff Bauer
Error attempting the example on page 125 of the new web2py manual: from gluon.shell import exec_environment oprep = exec_environment('applications/oprep/models/db.py') Traceback (most recent call last): File input, line 1, in module File gluon/shell.py, line 62, in exec_environment

[web2py] Re: exec_environment exception

2010-01-09 Thread mdipierro
Can you show what is in applications/oprep/models/db.py On Jan 9, 2:59 pm, Jeff Bauer jeffru...@gmail.com wrote: Error attempting the example on page 125 of the new web2py manual:   from gluon.shell import exec_environment   oprep = exec_environment('applications/oprep/models/db.py')

[web2py] repopulating form with data after form.errors encountered

2010-01-09 Thread Jeff Bauer
I'm following another example in the manual using SQLFORM. The code works as advertised. The only fly in the ointment is when form.errors is True, the user's entry form no longer displays her original values. I'm assuming there's a simple way to pass the request vars back into form at line 11

[web2py] error DAL with Sqlite in appadmin

2010-01-09 Thread Jose
The following errror when use occurs when DAL with Sqlite (no problems with postgres): Traceback (most recent call last): File /usr/home/jose/w2p/gluon/restricted.py, line 173, in restricted exec ccode in environment File /usr/home/jose/w2p/applications/prueba/views/appadmin.html, line

[web2py] enforcing a one-to-one relationship

2010-01-09 Thread Jeff Bauer
I'm trying to enforce a one-to-one relationship between tables socdiag and socform with unique: db.define_table('socdiag', Field('socform', db.socform, unique=True), However the socdiag table permits multiple values of the same socform's id to occur in the socform column. I'm using sqlite.

[web2py] Re: Looking for web2py, jQuery, AJAX contractors

2010-01-09 Thread Jon Romero
Just to add, two BIG projects are about to launch in web2py. One in Greece (we are talking for exposure to all media TV/Radio/Magazines etc) and another one in NY which today we got our seed funding! It's nice to see that more people starting to use web2py for their businesses (we've been using

[web2py] Where AJAXed things should live ...?

2010-01-09 Thread weheh
I'm using the web2py ajax function with an eval target. The question is where certain code should live? Here's the scenario. The view calls a function x() that creates a DIV(...,_id='y') with an ajax call to update the contents of itself and another DIV (...,_id='z'). The contents of the

[web2py] Re: Share some wisdom

2010-01-09 Thread rev
The thought of managing a semi-large application seems a bit... daunting to me. Yep, it is ;) I was hoping some older programmers, and those with experience managing projects that were either large, or had multiple developers work on, could share some insights with me. I'm a senior developer

[web2py] Re: Current List Of Web2py Plugins

2010-01-09 Thread Jon Romero
facebook connect (*) (1) (jon romera / massimo) It's Jon Romero :D Also I have submitted code that scaffolds admin areas for functions in controllers. Should I make it a plugin? On Jan 9, 7:42 am, Thadeus Burgess thade...@thadeusb.com wrote: Ok here is a list as I know it. I need some help

Re: [web2py] Re: Current List Of Web2py Plugins

2010-01-09 Thread Thadeus Burgess
Sorry for the typo! If you would like to make it into a plugin, send me the file and I will add it to the list. -Thadeus On Sat, Jan 9, 2010 at 6:15 PM, Jon Romero darks...@gmail.com wrote: o I have submitted code that scaffolds admin areas for functions in controllers. Should I make it a

Re: [web2py] Re: Built-in Webserver

2010-01-09 Thread Thadeus Burgess
It all gets processed to an internal WSGI layer anyways? What does web2py use as an WSGI layer (request/response)? I am wondering if while using WSGI and apache, does cherrypy/rocket get executed regardless? -Thadeus On Sat, Jan 9, 2010 at 12:11 PM, mdipierro mdipie...@cs.depaul.edu wrote:

Re: [web2py] Re: Share some wisdom

2010-01-09 Thread Thadeus Burgess
Currently I am the only programmer in the company. My goals are two-folded. One, I need a way to show my non-technical superiors that I am working and making progress. A way to provide a timeline with goals to work toward so they can see where I am at and how far I have to go. The problem I have

[web2py] how to custimize the submit button in auth form

2010-01-09 Thread Frank
I'm try to customize the submit button in auth form to an image button such as login, register and retrived password forms etc, what is the better way to do it, is that form.element or something like that? thanks, Frank -- You received this message because you are subscribed to the Google

[web2py] Re: how to custimize the submit button in auth form

2010-01-09 Thread mr.freeze
This should do it: form = SQLFORM.factory(...) submit = form.element(input,_type=submit) submit[_type] = image submit[_src] = URL(...) On Jan 9, 7:37 pm, Frank thethinkbo...@gmail.com wrote: I'm try to customize the submit button in auth form to an image button such as login,

[web2py] Re: repopulating form with data after form.errors encountered

2010-01-09 Thread mdipierro
You can simplify your code def diag_form(): form = SQLFORM(db.socdiag, request.args(0), deletable=True) if form.accepts(request.vars, session): response.flash = 'form accepted' elif form.errors: # (1) response.flash = 'form has errors' return

[web2py] Re: error DAL with Sqlite in appadmin

2010-01-09 Thread mdipierro
Can if you see if replacing layout.html with the one in trunk fixes the probelm? On Jan 9, 5:23 pm, Jose jjac...@gmail.com wrote: The following errror when use occurs when DAL with Sqlite (no problems with postgres): Traceback (most recent call last):   File

Re: [web2py] Re: repopulating form with data after form.errors encountered

2010-01-09 Thread Thadeus Burgess
like request.accept(keepvalues=True)... but only if there was an error. -Thadeus On Sat, Jan 9, 2010 at 11:32 PM, mdipierro mdipie...@cs.depaul.edu wrote: You can simplify your code def diag_form():    form = SQLFORM(db.socdiag, request.args(0), deletable=True)    if

Re: [web2py] Re: Built-in Webserver

2010-01-09 Thread Timothy Farrell
Web2py uses its own layer as opposed to using WebOb like some other frameworks do. To answer your question, no if you use apache + mod_wsgi no portion of the bundled webserver is run. Tim On Jan 9, 2010, at 7:01 PM, Thadeus Burgess thade...@thadeusb.com wrote: It all gets processed

[web2py] Re: enforcing a one-to-one relationship

2010-01-09 Thread mdipierro
I think sqlite may not enforce this. You can achieve this with validators but I think I can make it easier with an upgrade I am working on... tomorrow. On Jan 9, 5:30 pm, Jeff Bauer jeffru...@gmail.com wrote: I'm trying to enforce a one-to-one relationship between tables socdiag and socform

Re: [web2py] Re: error DAL with Sqlite in appadmin

2010-01-09 Thread Thadeus Burgess
I get the same error on all of my apps TypeError: 'NoneType' object is unsubscriptable The offending line is as follows in appadmin.html firstkey=tbl[tbl._primarykey[0]] -Thadeus On Sat, Jan 9, 2010 at 11:44 PM, mdipierro mdipie...@cs.depaul.edu wrote: Can if you see if replacing

Re: [web2py] Re: Built-in Webserver

2010-01-09 Thread Thadeus Burgess
This is what I gathered from looking at the source code, I just wanted to make sure. -Thadeus On Sat, Jan 9, 2010 at 11:42 PM, Timothy Farrell tfarr...@swgen.com wrote: Web2py uses its own layer as opposed to using WebOb like some other frameworks do. To answer your question, no if you

[web2py] Re: enforcing a one-to-one relationship

2010-01-09 Thread mdipierro
Try this again with the code in trunk. assuming you have a format db.define_table('socform',...,format=) you will get a default validator db.docfiag.socform.requires=IS_IN_DB(,_and=IS_NOT_IN_DB(...)) that will make both the dropdown and the reference unqueness enforced by the

[web2py] Re: error DAL with Sqlite in appadmin

2010-01-09 Thread mdipierro
For everybody else: this error was only with the trunk version and it is now fixed. This is because of an attempt in merging table and keyedtable. It required changes in both appadmin and sqlhtml. On Jan 9, 11:51 pm, Thadeus Burgess thade...@thadeusb.com wrote: I get the same error on all of my

[web2py] Re: repopulating form with data after form.errors encountered

2010-01-09 Thread mdipierro
That is the default. Are you telling me it is not? On Jan 9, 11:44 pm, Thadeus Burgess thade...@thadeusb.com wrote: like request.accept(keepvalues=True)... but only if there was an error. -Thadeus On Sat, Jan 9, 2010 at 11:32 PM, mdipierro mdipie...@cs.depaul.edu wrote: You can simplify

[web2py] twitter2web2py2twitter

2010-01-09 Thread weheh
Has anybody written a web2py app reading or writing twitter stuff from web2py? I was just curious how it went or is going and whether there are any issues. -- You received this message because you are subscribed to the Google Groups web2py-users group. To post to this group, send email to