[web2py] Re: Huge amount of data slowing page loads...

this works like a charm: http://docs.jquery.com/Plugins/Autocomplete On 27 jan, 08:24, Jason Brower wrote: > I have a database with 16k entries in it... > I have a one to many relation with them. > When I create a form with the requiers=IS_ID_DB() feature I notice a > huge lag in page load time.

[web2py] bug in SQLFORM.factory?

Hi .*, it seems to me that there is a bug saving boolean fields with SQLFORM.factory forms. If I define a boolean field in a table and use the standard SQLFORM to make an input form, the accept function will save 'T' of 'F' to the DB. Whereas in the case where I create a form with SQLFORM.factory,

[web2py] Huge amount of data slowing page loads...

I have a database with 16k entries in it... I have a one to many relation with them. When I create a form with the requiers=IS_ID_DB() feature I notice a huge lag in page load time. (I would to if I had 16k entries in one drop down too.) Is there a way to do this similar to the autocompletion but h

[web2py] Issues with join...

I have a database as follow: # coding: utf8 from datetime import datetime, date, time now = datetime.utcnow() today = date.today() db = SQLDB('sqlite://paint.sqlite') db.define_table('order_que', Field('customer_code', length=30), Field('paint'), Field('can_size', requires

[web2py] Re: Serious issue with upgrading to latest version

I hear you and it makes perfect sense. However, I just quadruple- checked the model file and I guarantee (no lying this time) that every IS_DATE() and IS_DATETIME() validator corresponds to a Field of type 'date' or 'datetime" respectively. -- You received this message because you are subscribed

[web2py] Re: Custom form doesn't submit

Hi Denes/Massimo, Any inputs? On Jan 25, 8:20 pm, Adi wrote: > Sorry I was posting the other reply so missed this: Responses inline. > > > You are appending to form1 so check: > > 1) An INPUT named 'name', is it the only 'name' field in form1? > > Yes. names of all fields are different. > > > 2)

[web2py] Re: Serious issue with upgrading to latest version

No this it not the problem than. Yes your traceback: Traceback (most recent call last): File "gluon/restricted.py", line 173, in restricted File "D:/web2py/applications/myapp/controllers/admin.py", line 962, in File "gluon/globals.py", line 96, in File "gluon/tools.py", line 1847, in f

[web2py] Re: Serious issue with upgrading to latest version

Massimo, I checked all the fields with IS_DATE or IS_DATETIME validators and all are correctly declared either 'date' or 'datetime'. However, some of the validators are IS_NULL_OR(IS_DATE()) and IS_NULL_OR(IS_DATETIME()). Might this cause the ticket, if a field were None instead of a date/time? On

Re: [web2py] Making auth_user Field optional

db.example.relationship.requires = IS_NULL_OR(IS_IN_DB(db, 'auth_user.id', 'auth_user.first_name')) -Thadeus On Tue, Jan 26, 2010 at 9:12 PM, rppowell wrote: > Hello; > > This is probably a basic thing that I am unable to figure out. > > I have the following table: > > db.define_table('examp

[web2py] Re: How to load my db.py into the online sql designer?

I was searching for a "DAL designer" and i bumped this thread. Well you can't load your model into the sql designer. What you can do is diagram your db table(s) in the designer than export it as xml. Save the xml in your drive and this can be imported later for working again with the designer. It

[web2py] Making auth_user Field optional

Hello; This is probably a basic thing that I am unable to figure out. I have the following table: db.define_table('example', Field('relationship', db.auth_user)) When I use the addadmin interface to insert a record, I have the option in the dropdown to provide a blank selection. If I submi

Re: [web2py] Replacing template engine

Its going to be your best bet in using a different templating language. YOu will have to make sure to only parse your HTML requests and not json/download etc. Basically, response._caller is a function, that returns a string which is the html. So you would instead of response.render(d) you would d

[web2py] Replacing template engine

Hi, I want to replace web2py's template engine with Jinja 2, anyone has some experience doing something similar? I'm trying to assign response._caller with a custom function, but I'm not having much success, is that the right way? Thanks, Alexandre Rosenfeld Eng Comp 0

Re: [web2py] Re: RFC @completion

http://code.google.com/p/blogitizor/source/browse/src/models/plugin_compression.py -Thadeus On Tue, Jan 26, 2010 at 7:17 PM, hamdy.a.farag wrote: > > Thanks Thadeus for replying > > I didn't understand though, because this concept is new for me > > can you please give me examples ? > > -- > Y

Re: [web2py] Re: Alert when email not sent sucessfully !

mail.send only fails if there was an authentication error or it was an invalid formed email... if you send to idontex...@example.com mail.send will still return True. -Thadeus On Tue, Jan 26, 2010 at 7:02 PM, hamdy.a.farag wrote: > Hi Yannic > > I'm not sure whether this what you want or not,

[web2py] Re: validator that creates select with options from list of tuples?

sry just realized that mr web2py himself is called massimo, I should really go and sleep now On Jan 27, 2:20 am, selecta wrote: > IGNORE THE POST ABOVE > NOW TRULY SOLVED > > The problem with the post above was that the validator was not order > preserving, I added some lines to the IS_IN_SET con

[web2py] Re: validator that creates select with options from list of tuples?

IGNORE THE POST ABOVE NOW TRULY SOLVED The problem with the post above was that the validator was not order preserving, I added some lines to the IS_IN_SET constructor, not it truly works >>> IS_IN_SET([('a','max'), ('b','john')])('max') ('a', None) """ def __ini

[web2py] Re: RFC @completion

Thanks Thadeus for replying I didn't understand though, because this concept is new for me can you please give me examples ? -- 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 unsu

[web2py] Re: Alert when email not sent sucessfully !

Hi Yannic I'm not sure whether this what you want or not, but the mail.send() function itself returns True or false , so you could just do : if not mail.send(to=.., subject=,) : response.flash = "Message was not sent" -- You received this message because you are subscribed to the Googl

[web2py] Mercurial for a separate project

Hi all, Is it possible to hijack mercurial in web2py to create a repository that is not related to web2py? If so, I suspect it would be possible to create a web2py application to create and manage (including authentication) projects.Similar to bitbucket or google code. Does anyone have any though

[web2py] Re: validator that creates select with options from list of tuples?

SOLVED i thought i have to write my own validator, looking into IS_IN_SET i stumbeled upon the following code in the first few lines if isinstance(theset, dict): self.labels = theset.values() hmmm, lets try folders = dict(folders) db_webfolder.parent.requires = IS_IN_SET(folders) f

Re: [web2py] Re: table self reference not working

It happens to all of us -Thadeus On Tue, Jan 26, 2010 at 4:27 PM, selecta wrote: > thanks again! u're my hero > I guess I should read the manual before asking questions ... > starting to feel stupid here o_O > > On Jan 26, 11:22 pm, Thadeus Burgess wrote: > > Neither. > > > > You need > > >

[web2py] Re: table self reference not working

thanks again! u're my hero I guess I should read the manual before asking questions ... starting to feel stupid here o_O On Jan 26, 11:22 pm, Thadeus Burgess wrote: > Neither. > > You need > > Field('parent', 'reference plugin_webfolder_files') > > It is the same as using db.plugin_webfolder_file

[web2py] Re: validator that creates select with options from list of tuples?

oh it can ?:) sounds good, but still it solves only part of my problem, I also want to change what is shown to the user in option, I better show you what I want to do def getfolders(root = 0, spaces = '-'): folders = [] for f in db(db_webfolder.id>0)(db_webfolder.parent==root)

Re: [web2py] table self reference not working

Neither. You need Field('parent', 'reference plugin_webfolder_files') It is the same as using db.plugin_webfolder_files, but works for tables that have not been defined yet. -Thadeus On Tue, Jan 26, 2010 at 4:17 PM, selecta wrote: > I want to create a webfolder plugin, for that the table

Re: [web2py] Re: RFC @completion

I am using response._caller to compress all of my html output on my site to one line. I would use @completion if I was streaming a file or performing some really long task like emailing 1500 people :) -Thadeus On Tue, Jan 26, 2010 at 4:13 PM, hamdy.a.farag wrote: > Hi > > I'm interested in t

[web2py] table self reference not working

I want to create a webfolder plugin, for that the table needs a self reference in a Field db.define_table('plugin_webfolder_files', Field('name', requires=IS_NOT_EMPTY()), Field('file', 'upload', requires=IS_NOT_EMPTY()), Field('created_by', db.auth_user, readable=False, wri

[web2py] Re: RFC @completion

Hi I'm interested in that actually, but can you give me a practical use for this ? can it be used as a logging mechanism ? what about response._caller I don't get what it's used for Thanks -- You received this message because you are subscribed to the Google Groups "web2py-users" group. To po

Re: [web2py] validator that creates select with options from list of tuples?

IS_IN_DB can use a query can't it? -Thadeus On Tue, Jan 26, 2010 at 3:46 PM, selecta wrote: > Is there a validator that creates a select with options from a list of > tuples > > what I want do do is > Field("folder","integer",requires = IS_IN_TUPLELIST([('myfolder',12), > ('subfoler',23)]))

[web2py] validator that creates select with options from list of tuples?

Is there a validator that creates a select with options from a list of tuples what I want do do is Field("folder","integer",requires = IS_IN_TUPLELIST([('myfolder',12), ('subfoler',23)])) so that is creates SELECT([OPTION(name,_value=id) for name,id in [('myfolder',12), ('subfoler',23)] ],_name='

[web2py] Re: JOB POST: I need a Web2Py Developer

for what? On Jan 26, 2:24 pm, Alexandre Andrade wrote: > I apologize. > > 2010/1/26 Alexandre Andrade > > > > > Mr., > > > I'm insterested in your offer. > > > My websites, hipercenter.com/init and hipercenter.com/ciclismo are in > > web2py. > > > I wish to receive the details of project. > > >

[web2py] Re: Serious issue with upgrading to latest version

We can make it into a plugin. On Jan 26, 2:58 pm, Jonathan Lundell wrote: > On Jan 26, 2010, at 10:19 AM, mdipierro wrote: > > > Than it bust be an application bug. I think you may have a IS_DATE > > validator on a 'string' field instead of a 'date' field. > > You also need to move over the new a

[web2py] Re: Best place to store files derived from uploaded data

Thanks Massimo and Thadeus. Just to clarify, the pickled object files are an internal representation created by the application for its own use, so it seems like private/ is a reasonable place to keep them. The raw uploaded data files are never altered by the application. They just need to be ava

Re: [web2py] Re: Serious issue with upgrading to latest version

On Jan 26, 2010, at 10:19 AM, mdipierro wrote: > Than it bust be an application bug. I think you may have a IS_DATE > validator on a 'string' field instead of a 'date' field. > You also need to move over the new appadmin(s) into your app. Normally > this is not required during upgrades since they

Re: [web2py] JOB POST: I need a Web2Py Developer

I apologize. 2010/1/26 Alexandre Andrade > Mr., > > I'm insterested in your offer. > > My websites, hipercenter.com/init and hipercenter.com/ciclismo are in > web2py. > > I wish to receive the details of project. > > > -- > > -- > = > Alexandre Andrade > Hipercenter.com >

Re: [web2py] JOB POST: I need a Web2Py Developer

Mr., I'm insterested in your offer. My websites, hipercenter.com/init and hipercenter.com/ciclismo are in web2py. I wish to receive the details of project. -- -- = Alexandre Andrade Hipercenter.com 2010/1/25 tweety76 > I manage 2 websites that sell prepaid phonec

[web2py] Re: JOB POST: I need a Web2Py Developer

Thank you for those who emailed me. I've got 3 emails so far. I am still looking for some other offers before I decide. Please email me so I can email you the details of the project. On Jan 25, 3:21 pm, mdipierro wrote: > This would be a good occasion to test and bring to production quality > t

Re: [web2py] RFC @completion

response._caller is internal. response._caller is global for all actions response._caller wants to call you out @completion will allow for per-action notification and per-action notify functions. @completion will allow you to be free @completion agrees with you /political_satire off They eac

Re: [web2py] RFC @completion

I'm not knocking it because it's syntactic sugar, but you could already do this by setting response._caller right? On 1/26/2010 10:05 AM, mdipierro wrote: With current trunk you can now do: from gluon.tools import completion def callback(d): print '<<<',d @completion(callback) def test(

[web2py] Re: Serious issue with upgrading to latest version

Than it bust be an application bug. I think you may have a IS_DATE validator on a 'string' field instead of a 'date' field. You also need to move over the new appadmin(s) into your app. Normally this is not required during upgrades since they become part of your app. Nevertheless there was an issue

[web2py] Re: A design question with forms.

> So here is my question, are validators used anywhere else in web2py > except by crud and SQLFORM ? No > Am I safe by not setting validators on > the database level  ? Yes -- You received this message because you are subscribed to the Google Groups "web2py-users" group. To post to this group

[web2py] Re: A design question with forms.

And just another example I want to be able to store null or empty emails in my database, even though email field is unique. but anybody else who signs up must enter a valid new email address. So on my signup form it needs an IS_NOT_EMPTY validator, but on my internal forms i need IS_NULL_OR(...)

Re: [web2py] Re: Serious issue with upgrading to latest version

Wiadomość napisana przez weheh w dniu 2010-01-26, o godz. 19:00: > Massimo, the db is MySQL, not SQLITE. I think this is going to be more > complicated than what you suggest. I am going to do a wipe and clean > install. It's been awhile since I upgraded my server's version of > web2py. I honestly

[web2py] A design question with forms.

Notice how I have validators set on the database level of web2py. db.table.field.requires = IS_IN_DB(...) I only use SQLFORM.factory to create my forms. I only use SQLFORM.factory because for my purposes forms cannot be mapped directly to database tables. Take a reference field for example, I wa

[web2py] Re: Serious issue with upgrading to latest version

Massimo, the db is MySQL, not SQLITE. I think this is going to be more complicated than what you suggest. I am going to do a wipe and clean install. It's been awhile since I upgraded my server's version of web2py. I honestly do not like the install mechanism behind web2py. Seems error prone, as mea

[web2py] Re: ticket on examples cache

oops. type in example (dba instead of db). I fixed it there, I will fix it on trunk tonight, as I get home. On Jan 26, 11:18 am, Thadeus Burgess wrote: > http://www.web2py.com/examples/cache_examples/cache_db_select > > http://www.web2py.com/admin/default/ticket/examples/24.153.196.141.20... > >

[web2py] ticket on examples cache

http://www.web2py.com/examples/cache_examples/cache_db_select http://www.web2py.com/admin/default/ticket/examples/24.153.196.141.2010-01-26.11-15-40.af2f07f8-6752-4abc-b422-e70cae2627ea -Thadeus -- You received this message because you are subscribed to the Google Groups "web2py-users" group.

Re: [web2py] Re: web2py irc channel

You are right, freenode is blocking mibbit. The reason is "new freenode webchat" http://blog.freenode.net/2009/06/new-freenode-webchat-and-why-to-use-it/ Freenode webchat: http://webchat.freenode.net/ On Tue, Jan 26, 2010 at 5:59 PM, Wes James wrote: > I tried web2pychat.com and just from mibbi

[web2py] Re: web2py irc channel

web2pychat stopped working for me long time ago. The author has not been seen here in a while. Massimo On Jan 26, 10:59 am, Wes James wrote: > I tried web2pychat.com and just from mibbit.com with web2py channel. > I think irc.freenode.net is blocking mibbit, because neither seem to > work. > > -

Re: [web2py] Re: web2py irc channel

I tried web2pychat.com and just from mibbit.com with web2py channel. I think irc.freenode.net is blocking mibbit, because neither seem to work. -wes On Tue, Jan 26, 2010 at 8:45 AM, Drapko Nitzhonot wrote: > You can connect through mibbit.com to any IRC server > > On Tue, Jan 26, 2010 at 2:29 PM

Re: [web2py] Re: Best place to store files derived from uploaded data

Also the one thing with pickling these files is if any of the files get edited, you should perform some sort of locking since what if two people edit the same file at the same time? Just a disadvantage of using pickle in a multi-instanced environment such as web servers. But you probably already

[web2py] Re: Best place to store files derived from uploaded data

I think what matters if how the files are downloaded. If the are downloaded via the provided "download" action then they must be referenced by a database record and the names must follow the convention "table.field.uuid.extension" (so that web2py can locate the record and check authorization if an

[web2py] Best place to store files derived from uploaded data

I have a design question. I'm part of a team developing a scientific app that will allow users to upload seismic data and apply various kinds of processing and plotting. It looks as though we'll need to support several different raw data formats. The approach we're taking for this is to convert

[web2py] RFC @completion

With current trunk you can now do: from gluon.tools import completion def callback(d): print '<<<',d @completion(callback) def test(): return dict(value="hello World") What do you think? -- You received this message because you are subscribed to the Google Groups "web2py-users" group

Re: [web2py] Re: web2py irc channel

You can connect through mibbit.com to any IRC server On Tue, Jan 26, 2010 at 2:29 PM, tyoc 213 wrote: > I dont rememnber but I think that freenode has at less other 2 ports > (different than default sure) for connecting to freenode, so if you have > IRC port block on your location (perh

[web2py] Re: Web2py for PHP

you are right, desfrenes, it has namespace (indeed, it has gained namespaces only lately), but, talking about elegance, adding namespaces/that/look/like/paths is not what i consider a "wow" design decision :) On Jan 26, 1:49 pm, desfrenes wrote: > You're right, Python is (much more) elegant. But

[web2py] Re: SQLFORM upload field like in appadmin

Wow! It works. Thank you. -- 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+unsubscr...@googlegroups.com. For more options, visit t

Re: [web2py] Re: web2py irc channel

I dont rememnber but I think that freenode has at less other 2 ports (different than default sure) for connecting to freenode, so if you have IRC port block on your location (perhaps some 1 know) you can connect using the other ports and you are done. -- You received this message because

[web2py] Re: SQLFORM upload field like in appadmin

You need to pass the SQLFORM(,upload=URL(r=request,f='download')) so that web2py know what to link the button to. On Jan 26, 6:46 am, Alex wrote: > When I update record with upload field using database administration > tool of admin interface, loaded image file into this upload file is > show

[web2py] SQLFORM upload field like in appadmin

When I update record with upload field using database administration tool of admin interface, loaded image file into this upload file is shown with thumb, link to file and delete checkbox. When I try to update this record in my controller, I see input field with browse button only. Please, suggest

[web2py] Re: cron issue

I did not write cron personally and I am still trying to understand some of it, Attila did. I am in the looking at cron these days to treamline it a bit and I am trying to understand better as it works. Since windows does not have cron, you should use web2py hardcron. It should work on windows 7 b

[web2py] Re: Serious issue with upgrading to latest version

Did you ever edit appadmin in your app? Please backit up and replace - controllers/appadmin.py - views/appadmin.html with the ones from the new welcome app. This may partially fix your last two problems. The main problem is either you have an invalid combination of validators OR you have corrupted

[web2py] Re: Web2py for PHP

You're right, Python is (much more) elegant. But you're wrong, PHP has namespaces. On 25 jan, 18:27, pistacchio wrote: > python is a very elegant and mature language. php has gained a huge > popularity more for the moment when it came out that for the goodness > of the language itself. it has a

Re: [web2py] Web2py for PHP

First, I have to say I really likes web2py. But I have a project with short time and need developers (portuguese speakers). So I will develop using a php framework. For me, CodeIgniter is the most web2py-like php framework, so I will use this. 2010/1/25 Pynthon Pynthon > Hello > > Maybe it

Re: [web2py] Re: How to limit access to items in static?

2010/1/22 mdipierro : > You get invalid requests if the url is wrong or contains invalid chars > (the filename cannot contain special chars or spaces, only > alphanumeric and -). Thanks. It was not that easy to find the correct url, but in the end I found it. I have a subdirectory with all the re

[web2py] cron issue

Hi, I was trying to use the cron property of web2py at my project. I am using web2py under windows 7. I had installed wamp server with mod_wsgi. According to the documentation it is suggested to use the external cron. I tried to test the soft cron issue so i added the below line to my applica

[web2py] Re: web2py irc channel

i wasn't aware of that, see you there! :) On Jan 26, 9:23 am, Mengu wrote: > Right now, there are 16 web2py devs on irc.freenode.net :) > > On 25 Ocak, 21:14, pistacchio wrote: > > > > > hi, > > seen how active the community around web2py is (often a post on this > > newsgroup is answered in les

[web2py] Re: Serious issue with upgrading to latest version

I just re-downloaded the source from http://www.web2py.com/examples/default/download (not the latest dev snapshot) and re-installed it. I couldn't even get web2py to start. It looked like an incomplete set of files to me. So, I installed the Windows version on the server and then restarted web2py

[web2py] Re: web2py irc channel

Right now, there are 16 web2py devs on irc.freenode.net :) On 25 Ocak, 21:14, pistacchio wrote: > hi, > seen how active the community around web2py is (often a post on this > newsgroup is answered in less than a hour), i've thought that maybe a > irc channel could provide an even more "online" fe