Re: [web2py] Re: Book 6.8. Exporting and Importing Data ( CSV and remote Database Synchronization )

2010-02-12 Thread Thadeus Burgess
'cStringIO' cStringIO.StringIO built-in function StringIO -Thadeus On Fri, Feb 12, 2010 at 10:02 AM, Thadeus Burgess thade...@thadeusb.com wrote: No its not missing the leading c. There is no leading c. Try importing cStringIO.cStringIO and see the stacktrace complaining there is no cStringIO

Re: [web2py] about docs

2010-02-12 Thread Thadeus Burgess
On another note, certain features are in web2py that are still under testing/development. I suppose it will be you to decide what gets put in the official documentation or not ? -Thadeus On Fri, Feb 12, 2010 at 9:35 AM, Thadeus Burgess thade...@thadeusb.com wrote: No. But we do need

Re: [web2py] Re: Book 6.8. Exporting and Importing Data ( CSV and remote Database Synchronization )

2010-02-12 Thread Thadeus Burgess
in book nor my code On Feb 12, 11:02 am, Thadeus Burgess thade...@thadeusb.com wrote: No its not missing the leading c. There is no leading c. Try importing cStringIO.cStringIO and see the stacktrace complaining there is no cStringIO module in the cStringIO package. -Thadeus On Fri, Feb 12

Re: [web2py] Re: web2py site problem ?!

2010-02-12 Thread Thadeus Burgess
Just keep in mind, if you have an EC2 server, if it goes down ever for ANY reason you lose ALL of the data on the server. Do not rely on Amazon to be a permanent will-be-there-always solution for the data -Thadeus On Fri, Feb 12, 2010 at 10:47 AM, mdipierro mdipie...@cs.depaul.edu wrote: I

Re: [web2py] Re: about docs

2010-02-12 Thread Thadeus Burgess
So I guess my real question is I want to add the documentation on reserved sql keywords checking. Should this be included as a WIKI page linked to the Connection Strings section, or should this go in that section? Same for the custom csv delimiters, in the book or as a wiki linked? -Thadeus

Re: [web2py] Re: why use the admin interface, at all?

2010-02-12 Thread Thadeus Burgess
Your points are valid snfctech. The presentation I gave the other night to a group of django developers, most of them had heard about web2py and stopped using it because they thought they had to use the built in editor/shell. Most people when looking for a framework don't read past the first line

Re: [web2py] Requiring arguments

2010-02-12 Thread Thadeus Burgess
what about default cases. I don't need to redirect if a var does not exist, but instead use a default value. Perhaps a dict instead of tuples ? -Thadeus On Fri, Feb 12, 2010 at 7:53 PM, Tiago Almeida tiago.b.alme...@gmail.com wrote: Sorry, spoke too soon. I saw how auth works and did

Re: [web2py] Re: web2py 1.75.1 is Out

2010-02-12 Thread Thadeus Burgess
Looking at the commit logs here is the following. Bug fixes. Reserved SQL keywords checking Parents and siblings Can specify port with Firebird Upgrade an app by unpacking over it -Thadeus On Fri, Feb 12, 2010 at 9:35 PM, Jonathan Lundell jlund...@pobox.com wrote: On Feb 12, 2010, at

Re: [web2py] Re: web2py 1.75.1 is Out

2010-02-12 Thread Thadeus Burgess
wow... web4py web5py... When will software stop being about versions and just being about feature sets and stability! -Thadeus On Fri, Feb 12, 2010 at 10:12 PM, Jonathan Lundell jlund...@pobox.com wrote: On Feb 12, 2010, at 8:02 PM, mdipierro wrote: Normally we bump because there is a

Re: [web2py] Re: How much memory does web2py need on Unix

2010-02-11 Thread Thadeus Burgess
I don't see how you are running any system on 64MB (unless it is DOS or some really really old linux version... maybe gentoo... maybe. ) You won't be able to run web2py on this system. Either upgrade the system or get a shared hosting service. -Thadeus On Thu, Feb 11, 2010 at 12:18 PM,

Re: [web2py] Form Dropdown - have value different from displayed text

2010-02-11 Thread Thadeus Burgess
is this integrated into sqlform? Field(..., requires=IS_IN_SET((1, 2, 3), (Car, Van, Truck))) -Thadeus On Thu, Feb 11, 2010 at 1:32 PM, Donald Hughes donald.hug...@gmail.com wrote: Sorry, I'm really new with both Python and web2py (coming from c#/ asp.net)! I'm trying to create a

Re: [web2py] Re: Form Dropdown - have value different from displayed text

2010-02-11 Thread Thadeus Burgess
(Sure?,SELECT('yes','no',_name=sure,requires=IS_IN_SET(['yes','no']))), Can I use sqlform without a database to populate the data? On Feb 11, 1:36 pm, Thadeus Burgess thade...@thadeusb.com wrote: is this integrated into sqlform? Field(..., requires=IS_IN_SET((1, 2, 3), (Car, Van, Truck

Re: [web2py] Re: Using curl to upload files

2010-02-11 Thread Thadeus Burgess
For one, the formkey is generated in the session. So you can only submit the form once after it is generated with your session, since curl is not tied to your browser session formkey will not work. You need to not pass session to form.accepts and then it will work. form.accepts(request.vars)

Re: [web2py] Requiring arguments

2010-02-11 Thread Thadeus Burgess
if not request.args(0): redirect() or default = hi -Thadeus On Thu, Feb 11, 2010 at 6:19 PM, minh mdn0...@gmail.com wrote: Is there a way to require arguments/vars in the controller functions other than explicitly checking for them? It would be nice if we could decorate the

Re: [web2py] Re: Customizing User Registration Form

2010-02-10 Thread Thadeus Burgess
alternatively if you want just one submit, and one form... You can use the formtowizard jquery plugin. it turns each fieldset into a wizard page. http://plugins.jquery.com/project/formwizard -Thadeus On Tue, Feb 9, 2010 at 10:11 PM, mdipierro mdipie...@cs.depaul.edu wrote: you can use

Re: [web2py] jquery wizard controll

2010-02-10 Thread Thadeus Burgess
For forms you might also want to take a look at http://plugins.jquery.com/project/formwizard Just include the file like any other javascript file and start using it. You can include it in your layout.html if you need it on every page, or just the views/controller/action.html file if you just need

Re: [web2py] Re: PDF manual soon available online in HTML (maybe)

2010-02-10 Thread Thadeus Burgess
is spam across the internet. Aside from this, openly allowing edits leaves ANYBODY to deface it, regardless of if they like web2py or not, they just like defacing things. -Thadeus On Tue, Feb 9, 2010 at 6:59 PM, Jonathan Lundell jlund...@pobox.com wrote: On Feb 9, 2010, at 4:52 PM, Thadeus

Re: [web2py] Deleting a db table row

2010-02-10 Thread Thadeus Burgess
rows = db(db.bid.id 0).select(limitby=(1, 2), orderby=db.bid.id) rows.first().delete_record() Test that out a bit see if it does what you want. -Thadeus On Wed, Feb 10, 2010 at 10:59 AM, Auden RovelleQuartz oves@gmail.com wrote: I hope this is a simple question: Specifically

Re: [web2py] Deleting a db table row

2010-02-10 Thread Thadeus Burgess
, Feb 10, 2010 at 11:06 AM, Thadeus Burgess thade...@thadeusb.com wrote: rows = db(db.bid.id 0).select(limitby=(1, 2), orderby=db.bid.id) rows.first().delete_record() Test that out a bit see if it does what you want. -Thadeus On Wed, Feb 10, 2010 at 10:59 AM, Auden RovelleQuartz oves

Re: [web2py] Re: DB query help

2010-02-10 Thread Thadeus Burgess
rows = db(db.post.id 0).select() for row in rows: comments = db(db.comment.post_id == row.id).select() -Thadeus On Wed, Feb 10, 2010 at 11:58 AM, minh mdn0...@gmail.com wrote: Thanks for the help. How would you implement a workaround for that 2nd JOIN case to work on GAE? On Feb 9,

Re: [web2py] Deleting a db table row

2010-02-10 Thread Thadeus Burgess
A Rows object is just an array with database specific operations added. So you can go rows = db(db.table.id 0).select() rows[n].delete_record() if you know what (n) is. first() syntax has been added since the manual was published. However, it is just a shortcut to the following, but returns

[web2py] deploy to gae

2010-02-10 Thread Thadeus Burgess
I just deployed my first app to GAE... something like this should not be this easy -Thadeus -- 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

Re: [web2py] Multi user development on web2py

2010-02-09 Thread Thadeus Burgess
I have thought about setting up a shared postgres. However the issue still remains that if the .table files are altered during two branches, when merging how do you pick which .table file to accept? And you can't get rid of .table files because then you would not be able to connect to the

Re: [web2py] Automatic domain class generation from table definition

2010-02-09 Thread Thadeus Burgess
I remember a post about an ORM layer class on top of DAL, that allowed for dynamic selects django style, I can't find the post though, can anyone remember what it was called? -Thadeus On Tue, Feb 9, 2010 at 9:11 AM, tiago almeida tiago.b.alme...@gmail.com wrote: Hello all, I've been

Re: [web2py] SQLite serialization

2010-02-09 Thread Thadeus Burgess
Take a look at my configure class in Blogitizor. It gives a class interface to a settings table, and will cache the results in ram, the only thing it misses is clearing out the cache when a setting changes http://code.google.com/p/blogitizor/source/browse/src/modules/utils.py You can take a look

Re: [web2py] Re: Multi user development on web2py

2010-02-09 Thread Thadeus Burgess
adds or creates a column, they do it directly on the dev database, and commit the changes to db.py. There is also a person in charge of the live database schema -- the schema (sql create files) gets tracked separately in version control. On Feb 9, 1:38 pm, Thadeus Burgess thade...@thadeusb.com

Re: [web2py] Re: PDF manual soon available online in HTML (maybe)

2010-02-09 Thread Thadeus Burgess
No anonymous edits... Django fanboys will deface it within minutes of it going up -Thadeus On Tue, Feb 9, 2010 at 6:36 PM, Mariano Reingart reing...@gmail.com wrote: Things already fixed: - No anonymous edits, but changed @auth.requires_membership('developer') to requires_login() - Fixed

Re: [web2py] Re: for your info

2010-02-08 Thread Thadeus Burgess
the problem with pdf is it is not searchable. Take a look at http://www.cubicweb.org/doc/en/index.html That is nice, its in a tutorial style format, but it is a wiki so it supports contextual searching via google. Its not all that special just a basic wiki where the pages are linked together in

Re: [web2py] Re: for your info

2010-02-08 Thread Thadeus Burgess
to use it. -Thadeus On Mon, Feb 8, 2010 at 11:54 AM, Thadeus Burgess thade...@thadeusb.com wrote: the problem with pdf is it is not searchable. Take a look at http://www.cubicweb.org/doc/en/index.html That is nice, its in a tutorial style format, but it is a wiki so it supports contextual

Re: [web2py] Re: for your info

2010-02-08 Thread Thadeus Burgess
I will document code that I contribute (such as sql reserved keywords check). I just need somebody to tell me where to put it. -Thadeus On Mon, Feb 8, 2010 at 12:11 PM, Jonathan Lundell jlund...@pobox.com wrote: On Feb 8, 2010, at 9:54 AM, Thadeus Burgess wrote: the problem with pdf

Re: [web2py] Re: AutocompleteWidget: experimental, magic, RFC

2010-02-08 Thread Thadeus Burgess
can we get an uncompressed version of the javascripts? -Thadeus On Mon, Feb 8, 2010 at 12:48 PM, villas villa...@gmail.com wrote: Can you give it one more try? Here are my results with latest sqlhtml.py Firefox 3.5.7: Works better, but not 100%.  The drop-down appears.   OK  Single

Re: [web2py] web2py vs. customizing existing e-commerce app

2010-02-08 Thread Thadeus Burgess
It may just be me, but I never could get satchmo to work. -Thadeus On Mon, Feb 8, 2010 at 1:22 PM, snfctech tschm...@sacfoodcoop.com wrote: I need to build an order-entry and tracking system for a Food Co-op. I was excited about using Python/web2py, but I'm struggling with the fact that

Re: [web2py] Re: web2py vs. customizing existing e-commerce app

2010-02-08 Thread Thadeus Burgess
, Thadeus Burgess thade...@thadeusb.com wrote: It may just be me, but I never could get satchmo to work. -Thadeus On Mon, Feb 8, 2010 at 1:22 PM, snfctech tschm...@sacfoodcoop.com wrote: I need to build an order-entry and tracking system for a Food Co-op. I was excited about using Python

Re: [web2py] PIL under web2py test server

2010-02-08 Thread Thadeus Burgess
is web2py running on python 2.6.1 or the built-in python 2.4? ? -Thadeus On Mon, Feb 8, 2010 at 3:02 PM, pistacchio pistacc...@gmail.com wrote: Hi to all, I'm running python 2.6.1 on MacOSX Snow Leopard. I installed PIL (the image manipulation library) with easy_install. If I run python

Re: [web2py] Re: PIL under web2py test server

2010-02-08 Thread Thadeus Burgess
? On 8 Feb, 22:09, Thadeus Burgess thade...@thadeusb.com wrote: is web2py running on python 2.6.1 or the built-in python 2.4? ? -Thadeus On Mon, Feb 8, 2010 at 3:02 PM, pistacchio pistacc...@gmail.com wrote: Hi to all, I'm running python 2.6.1 on MacOSX Snow Leopard. I installed PIL

Re: [web2py] Re: this thing runs web2py?

2010-02-08 Thread Thadeus Burgess
They are advertising that the embedded device runs linux and is powerful enough to run a web framework like web2py. Massimo is saying that he is impressed that the device that small can run web2py. -Thadeus On Mon, Feb 8, 2010 at 11:27 PM, Mengu whalb...@gmail.com wrote: nope, it's

[web2py] Multi user development on web2py

2010-02-08 Thread Thadeus Burgess
What is the recommended way of developing on a team with a web2py application using mercurial. The main issue is that we would like to share the sqlite database and .table files, however whenever any changes are made to these table files, mercurial complains with merge conflicts for every .table

Re: [web2py] how to disable field access if not authorized

2010-02-07 Thread Thadeus Burgess
It looks as if request.args(2) is empty. -Thadeus On Sun, Feb 7, 2010 at 2:02 AM, weheh richard_gor...@verizon.net wrote: I'm using crud and want to disable access to certain fields if user is not a member of the admin group. For instance, content can only be approved by admin. I want to

[web2py] web2py gae presentation

2010-02-07 Thread Thadeus Burgess
I am giving a presentation Wednesday on web2py running on GAE. I'm looking for ideas on a small app I could develop that would display the following web2py features. 1. Data centric, simplicity. 2. Generation of reports 3. Ease of deployment 4. Maintainability Most who are attending are

Re: [web2py] Re: wrong decisions and backward compatibility

2010-02-07 Thread Thadeus Burgess
. :) Well, sounds like I support changing IS_UPPER() 's behavior. But actually I am neutral to this proposal. On Feb7, 3:24pm, Thadeus Burgess thade...@thadeusb.com wrote: It will break backwards compatibility. I have apps that rely on the functionality of IS_UPPER applying .upper

Re: [web2py] Re: immediate web2py job opening

2010-02-06 Thread Thadeus Burgess
Google is phasing out IE 6 :) -Thadeus On Wed, Feb 3, 2010 at 3:24 AM, Jason Brower encomp...@gmail.com wrote: Sounds fun, but I wonder, how big is the team and so forth? It may be helpful for interested people to look into it. Are you willing to hire those coming out of school? (I have a

[web2py] Typo in cron..

2010-02-06 Thread Thadeus Burgess
How do these make it into the commit ? Also, why is softcron executing when running on mod_wsgi ? Traceback (most recent call last): [Sat Feb 06 18:54:13 2010] [error] [client] File gluon/contrib/wsgihooks.py, line 37, in close [Sat Feb 06 18:54:13 2010] [error] [client]

Re: [web2py] Re: need help with routes regex

2010-02-06 Thread Thadeus Burgess
This works, unless you have more than one controller. I found the following slice has been updated, perhaps this could be adapted. http://www.web2pyslices.com/main/slices/take_slice/41 The downside is that it still requires adding each controller that you create to be added to the list. Is

Re: [web2py] Re: wrong decisions and backward compatibility

2010-02-06 Thread Thadeus Burgess
It will break backwards compatibility. I have apps that rely on the functionality of IS_UPPER applying .upper() to the incoming variables. Anything that requires me to edit a single line of code on my app to just upgrade web2py breaks backwards compatibility, unless it was a bug to begin with.

Re: [web2py] Re: DAL migration problem

2010-02-05 Thread Thadeus Burgess
, Feb 5, 2010 at 6:23 AM, villas villa...@gmail.com wrote: On 5 Feb, 03:19, Thadeus Burgess thade...@thadeusb.com wrote: A quick question, what is your opinion on non-reserved keywords ? Should they be included, excluded, separated ? non-reserved words are acceptable and do not get in the way

Re: [web2py] [CLOSED] Re: Populate field based no other fields

2010-02-05 Thread Thadeus Burgess
Is this not in the book or did I miss it? -Thadeus On Fri, Feb 5, 2010 at 5:34 AM, Adi aditya.sa...@gmail.com wrote: Awesome, works as expected. Only change is that the request variables were strings and had to be converted into respective data types. Thanks a lot. On Feb 5, 4:19 pm,

Re: [web2py] new dal

2010-02-05 Thread Thadeus Burgess
I will only be able to test the new dal with sqlite and postgres. -Thadeus On Fri, Feb 5, 2010 at 10:14 AM, mdipierro mdipie...@cs.depaul.edu wrote: I encourage eveybody running from source to try the new dal: cd gluon cp sql.py sql.py.bak cp dal.py sal.py and restart web2py. Let me

Re: [web2py] Re: proposal for online documentation

2010-02-05 Thread Thadeus Burgess
I still think documenting the source code is the first step, then from that we can build a wiki/faq/walkthrough off of it. But gluon/* needs to be documented thoroughly before we do anything else. We should instead be discussing a method/style of documenting gluon, and then putting resources

Re: [web2py] Re: web2py on EC2

2010-02-05 Thread Thadeus Burgess
I noticed, at least for here in Austin TX that it is actually faster than the old host. -Thadeus On Fri, Feb 5, 2010 at 3:01 PM, mdipierro mdipie...@cs.depaul.edu wrote: Comparing apples to apples is different. Mostly I am playing with EC2 and this is not a definitive decision. It is

[web2py] Possible bug in new dal

2010-02-05 Thread Thadeus Burgess
Can anyone confirm the following traceback when using SQLFORM.factory(*fields) ? Traceback (most recent call last): File /home/tburgess/Applications/web2py/gluon/restricted.py, line 173, in restricted exec ccode in environment File

Re: [web2py] Re: Possible bug in new dal

2010-02-05 Thread Thadeus Burgess
did but only db(...).select(db.table.field) This will show in a few places since web2py sometimes passes the names of fields as opposed to actual field objects. On Feb 5, 6:09 pm, Thadeus Burgess thade...@thadeusb.com wrote: Can anyone confirm the following traceback when using

Re: [web2py] Re: DAL migration problem

2010-02-04 Thread Thadeus Burgess
* Could we use 'check_reserved' instead of 'check_reserve'? It sounds more natural to me. Why not. * Capitalize SQL in the error message strings It is capitalized. * dal.py is already much too long. Could the wordlists live somewhere else? No, they belong with their relative adapters.

Re: [web2py] Re: Changing redirect for @auth.requires_login()

2010-02-04 Thread Thadeus Burgess
yes but it wont. the redirect is bug since it creates the strings when you instantiate the Auth class, the urls set in stone. So auth = Auth(globals()) auth.settings.controller = 'myauth' print auth.settings.login_next '/init/default/index' -Thadeus On Wed, Feb 3, 2010 at 9:06 PM, weheh

Re: [web2py] Re: format zero IS_IN_DB

2010-02-04 Thread Thadeus Burgess
This is a difficult to decide. For me it is both ways. Since half of my forms require zero=None and the other half require zero='', either way it goes there will be no option that is more convenient for my development. I stand in support of zero=None. Web2py is a data/business logic oriented

Re: [web2py] Re: DAL migration problem

2010-02-04 Thread Thadeus Burgess
1. I do not capitalize name because this is actually what you are attempting to call your column, it could be 'select', 'Select', 'SELect'. It just seemed more logical to display the name that you wrote. Though it can be capitalized. I thought you were referring to the name of the database it was

Re: [web2py] Re: The state of the wiki and documentation in general

2010-02-04 Thread Thadeus Burgess
... tutorials, short tips, FAQs, discussions Search. The number one key feature is the ability to have intelligent search. I don't think we need an online book (bad idea). I think we need something more along the lines of like the django documentation. A 4 to 5 part tutorial that gets you

Re: [web2py] Re: The state of the wiki and documentation in general

2010-02-04 Thread Thadeus Burgess
We need two sets of documentation. Community documentation, for those who use web2py Developer documentation, for those who contribute to web2py. As far as developer documentation, I would be happy with lots of comments in the code. At the very least 25% of the lines should become meaningful

Re: [web2py] csv export/import oddities

2010-02-04 Thread Thadeus Burgess
The issue is when you export the entire web2py database. It exports it into a meta csv file. So its csv, but it has web2py generated metadata about what goes where, try opening your exported csv file in a text editor and you will see what I mean. This is why when you open in excel, it is unable

Re: [web2py] Dumb syntax error! Can't fix it!

2010-02-04 Thread Thadeus Burgess
A traceback might help :) -Thadeus On Thu, Feb 4, 2010 at 12:35 PM, Jason Brower encomp...@gmail.com wrote: Prolly obvious, but I can't see it... can you? -- You received this message because you are subscribed to the Google Groups web2py-users group. To post to this group, send email

Re: [web2py] Dumb syntax error! Can't fix it!

2010-02-04 Thread Thadeus Burgess
And thank you for your email password. -Thadeus On Thu, Feb 4, 2010 at 12:41 PM, Thadeus Burgess thade...@thadeusb.com wrote: A traceback might help :) -Thadeus On Thu, Feb 4, 2010 at 12:35 PM, Jason Brower encomp...@gmail.com wrote: Prolly obvious, but I can't see it... can you

Re: [web2py] Dumb syntax error! Can't fix it!

2010-02-04 Thread Thadeus Burgess
*a, **b: self._cursor.execute(*a, **b) OperationalError: near transaction: syntax error On Thu, 2010-02-04 at 12:41 -0600, Thadeus Burgess wrote: A traceback might help :) -Thadeus On Thu, Feb 4, 2010 at 12:35 PM, Jason Brower encomp...@gmail.com wrote: Prolly obvious, but I can't see

Re: [web2py] Re: DAL migration problem

2010-02-04 Thread Thadeus Burgess
? -Thadeus On Thu, Feb 4, 2010 at 1:00 PM, Jonathan Lundell jlund...@pobox.com wrote: On Feb 4, 2010, at 9:02 AM, Thadeus Burgess wrote: 1. I do not capitalize name because this is actually what you are attempting to call your column, it could be 'select', 'Select', 'SELect'. It just seemed

Re: [web2py] Re: Dumb syntax error! Can't fix it!

2010-02-04 Thread Thadeus Burgess
OperationalErrors only get raised by the cursor object, meaning there was an issue at the database level, not the web2py level. -Thadeus On Thu, Feb 4, 2010 at 1:03 PM, Jason Brower encomp...@gmail.com wrote: Gees thanks, I never thought about that one... Password changed, thanks... BR,

Re: [web2py] Re: The state of the wiki and documentation in general

2010-02-04 Thread Thadeus Burgess
The best doc help right now would probably be documenting web2py in a way which Sphinx could be used to generate the online documentation. Isnt this how python does it? I have started by documenting anything new I might contribute. -Thadeus On Thu, Feb 4, 2010 at 4:12 PM, mdipierro

[web2py] jsondumps update_record and delete_record

2010-02-04 Thread Thadeus Burgess
Is update_record and delete_record supposed to serialize with json ? -Thadeus -- 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

Re: [web2py] Re: jsondumps update_record and delete_record

2010-02-04 Thread Thadeus Burgess
: ? On Feb 4, 4:26 pm, Thadeus Burgess thade...@thadeusb.com wrote: Is update_record and delete_record supposed to serialize with json ? -Thadeus -- You received this message because you are subscribed to the Google Groups web2py-users group. To post to this group, send email to web

Re: [web2py] Re: jsondumps update_record and delete_record

2010-02-04 Thread Thadeus Burgess
0).select().as_dict()) you can call it with http://.index.json, .xml and it will convert. It can convert a dict of list of dict but not a dict of Rows. On Feb 4, 5:05 pm, Thadeus Burgess thade...@thadeusb.com wrote: if you... return dict(results=db(db.table.id 0).select

Re: [web2py] Re: DAL migration problem

2010-02-04 Thread Thadeus Burgess
Yes, there is much work to be done formatting each one of those lists into a python tuple object. -Thadeus On Thu, Feb 4, 2010 at 7:16 PM, Jonathan Lundell jlund...@pobox.com wrote: On Feb 3, 2010, at 9:45 AM, Thadeus Burgess wrote: As an added note, I could use some help in creating

Re: [web2py] Re: DAL migration problem

2010-02-04 Thread Thadeus Burgess
I have firebird, and now mysql 5.5 -Thadeus On Thu, Feb 4, 2010 at 9:14 PM, Jonathan Lundell jlund...@pobox.com wrote: On Feb 4, 2010, at 7:03 PM, Thadeus Burgess wrote: Yes, there is much work to be done formatting each one of those lists into a python tuple object. That part isn't so

Re: [web2py] Re: DAL migration problem

2010-02-04 Thread Thadeus Burgess
A quick question, what is your opinion on non-reserved keywords ? Should they be included, excluded, separated ? non-reserved words are acceptable and do not get in the way of your queries. -Thadeus On Thu, Feb 4, 2010 at 9:18 PM, Thadeus Burgess thade...@thadeusb.com wrote: I have firebird

Re: [web2py] Re: DAL migration problem

2010-02-04 Thread Thadeus Burgess
I now have postgres as well. -Thadeus On Thu, Feb 4, 2010 at 9:49 PM, Jonathan Lundell jlund...@pobox.com wrote: On Feb 4, 2010, at 7:19 PM, Thadeus Burgess wrote: A quick question, what is your opinion on non-reserved keywords ? Should they be included, excluded, separated ? non

Re: [web2py] Re: DAL migration problem

2010-02-04 Thread Thadeus Burgess
, -Thadeus On Fri, Feb 5, 2010 at 12:16 AM, Thadeus Burgess thade...@thadeusb.com wrote: I now have postgres as well. -Thadeus On Thu, Feb 4, 2010 at 9:49 PM, Jonathan Lundell jlund...@pobox.com wrote: On Feb 4, 2010, at 7:19 PM, Thadeus Burgess wrote: A quick question, what

Re: [web2py] 1.74.10 is OUT

2010-02-03 Thread Thadeus Burgess
It does not look like you included the patch for the reserved keywords? -Thadeus On Wed, Feb 3, 2010 at 10:22 AM, mdipierro mdipie...@cs.depaul.edu wrote: fixes a few problems with CRON, typos and check for invalid field and in DB (thanks Thedeus) -- You received this message because

Re: [web2py] 1.74.10 is OUT

2010-02-03 Thread Thadeus Burgess
You might want to wait before including patch, since I made some of the suggested changes last night, we can see how it looks then. -Thadeus On Wed, Feb 3, 2010 at 10:40 AM, Thadeus Burgess thade...@thadeusb.com wrote: It does not look like you included the patch for the reserved keywords

Re: [web2py] making changes in web2py

2010-02-03 Thread Thadeus Burgess
if you already have a clone, make your changes, then commit them to your local copy. When you want updates do hg pull web2py hg merge It should update and leave your changes, unless there is a conflict which you will need a program such as MELD to solve. -Thadeus On Wed, Feb 3, 2010 at

Re: [web2py] making changes in web2py

2010-02-03 Thread Thadeus Burgess
What is wrong with http://mercurial.selenic.com/guide/ There is nothing special about hg+web2py together. -Thadeus On Wed, Feb 3, 2010 at 11:13 AM, Jonathan Lundell jlund...@pobox.com wrote: On Feb 3, 2010, at 9:09 AM, Thadeus Burgess wrote: if you already have a clone, make your changes

Re: [web2py] making changes in web2py

2010-02-03 Thread Thadeus Burgess
Massimo seems to prefer emailing patches rather than pulling from our cloned repositories. Since he wants exact specific control over what gets pulled in. Kind of like quality control until he trusts the developer I suppose :) Linus Torvalds also prefers this approach of diffs instead of clones

Re: [web2py] Re: DAL migration problem

2010-02-03 Thread Thadeus Burgess
...@pobox.com wrote: On Feb 2, 2010, at 1:19 PM, Thadeus Burgess wrote: 1. Its only in two places. Once for tablename, and once for fieldname. And then this needs to be done for sql.py just in case DRY 2. Yes very chatty. What about the following? DAL('sqlite', pool_size=1, check_reserve

Re: [web2py] Re: DAL migration problem

2010-02-03 Thread Thadeus Burgess
As an added note, I could use some help in creating the database specific keywords lists. -Thadeus On Wed, Feb 3, 2010 at 11:43 AM, Thadeus Burgess thade...@thadeusb.com wrote: Ok take a look at the following proposed changes http://code.google.com/r/thadeusburgess-web2py/source/detail?r

Re: [web2py] Re: DAL migration problem

2010-02-03 Thread Thadeus Burgess
until then ALL will have to suffice. -Thadeus On Wed, Feb 3, 2010 at 12:27 PM, Jonathan Lundell jlund...@pobox.com wrote: On Feb 3, 2010, at 9:43 AM, Thadeus Burgess wrote: Ok take a look at the following proposed changes I'll try to look at it later today; I'm off to work now. Is the check

Re: [web2py] Re: The state of the wiki and documentation in general

2010-02-03 Thread Thadeus Burgess
There is no case. We all agree. Now who is actually going to DO it ? I can't. I work, sleep, and sometimes if I have time eat. Then I work some more. My company is not going to pay me to write web2py documentation. And as my comment earlier wasn't just to be funny it is serious. Do you have

Re: [web2py] IS_IN_SET multiple=True with non-ASCII character failed

2010-02-03 Thread Thadeus Burgess
Try assigning them unique ID's instead of the string. IS_IN_SET((1, 2, 3, 4), (option a, option b, option c, option d), multiple=True) -Thadeus On Wed, Feb 3, 2010 at 2:03 PM, szimszon szims...@gmail.com wrote: IS_IN_SET(['Új', 'Beépítve', 'Eladva', 'Használt','Selejtezve', 'Cseredarab',

Re: [web2py] Re: DAL migration problem

2010-02-03 Thread Thadeus Burgess
/sql.py. On Feb 3, 12:33 pm, Thadeus Burgess thade...@thadeusb.com wrote: A) Bring home the bacon ! B) Every time unless you set check_reserve to None. In production you would have check_reserve to None. C) It should be a union, and that is exactly what its documentation I added says. But we

[web2py] disable remember me

2010-02-03 Thread Thadeus Burgess
-Thadeus -- 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 this group at

Re: [web2py] disable remember me

2010-02-03 Thread Thadeus Burgess
self.settings.remember_me_form = True -wes On Wed, Feb 3, 2010 at 4:39 PM, Wes James compte...@gmail.com wrote: or have an option in db.py: auth.settings.remember_me=(True|False) On Wed, Feb 3, 2010 at 3:07 PM, Thadeus Burgess thade...@thadeusb.com wrote: -Thadeus -- You received

Re: [web2py] Re: making changes in web2py

2010-02-03 Thread Thadeus Burgess
-1 for admin username +1 for anti-brute-forcing. If incorrect password typed 3 times, ban the IP permanently until you log into ssh and edit a pickled file. -Thadeus On Wed, Feb 3, 2010 at 7:07 PM, mdipierro mdipie...@cs.depaul.edu wrote: I am confused. appadmin does not requires any.

Re: [web2py] Re: DAL migration problem

2010-02-02 Thread Thadeus Burgess
I see so many of those I would use on a daily basis :( -Thadeus On Tue, Feb 2, 2010 at 8:41 AM, villas villa...@gmail.com wrote: I get so frustrated when bitten by the reserved words problem. Unfortunately so many people only avoid the ones for their own chosen database, which is such a

Re: [web2py] Re: Search function

2010-02-02 Thread Thadeus Burgess
Feel free to take a look at http://code.google.com/p/blogitizor/source/browse/src/controllers/search.py Note you will see w = utils.w ws = utils.ws They just append wild cards to the variable. Look in http://code.google.com/p/blogitizor/source/browse/src/modules/utils.py for these two

Re: [web2py] Re: DAL migration problem

2010-02-02 Thread Thadeus Burgess
I am working on this, I am integrating a list of reserved words into the Field() class. For now just the common SQL keywords, which I'm sure can be extended to include backend-specific keywords. -Thadeus On Tue, Feb 2, 2010 at 11:08 AM, baloan balo...@googlemail.com wrote: Thanks David for

Re: [web2py] Re: DAL migration problem

2010-02-02 Thread Thadeus Burgess
Massimo, is there a better place (in dal.py) to place this check. The most logical I see is the Field.__init__ constructor. -Thadeus On Tue, Feb 2, 2010 at 11:27 AM, Thadeus Burgess thade...@thadeusb.com wrote: I am working on this, I am integrating a list of reserved words into the Field

Re: [web2py] Re: DAL migration problem

2010-02-02 Thread Thadeus Burgess
Actually, we can use the Adaptors to hold specific keywords. So in DAL.__init__ can have for fields if fieldname in self._adapter.KEYWORDS then raise SyntaxError -Thadeus On Tue, Feb 2, 2010 at 11:28 AM, Thadeus Burgess thade...@thadeusb.com wrote: Massimo, is there a better place

[web2py] dal.py

2010-02-02 Thread Thadeus Burgess
migrate=True self.db.define_table('settings', Field('key'), Field('name'), Field('value', 'text'), Field('description', 'text'), migrate=migrate ) First error testing out new dal.py Traceback (most recent call last): File

Re: [web2py] feature request: appadmin login - add a username

2010-02-02 Thread Thadeus Burgess
The best way is to use mercurial and make a clone of web2py. Make your changes, and the commit them to your local version. Then you can run hg export tip /path/to/a/file.diff That will create your diff file you can send to massimo. Then massimo can import that file and it will assign you as

Re: [web2py] Re: DAL migration problem

2010-02-02 Thread Thadeus Burgess
You can view a proposed change, I have sent this to Massimo to look at. http://code.google.com/r/thadeusburgess-web2py/source/detail?r=e875496cc5978200fb6c0aa0f85a8df1a945df21 I'm not sure what keywords we really want to use or not, but this is a starting point. I added two lists to BaseAdapter

Re: [web2py] Re: DAL migration problem

2010-02-02 Thread Thadeus Burgess
of these terms in the current system you get an OperationalError anyways. -Thadeus On Tue, Feb 2, 2010 at 3:09 PM, Jonathan Lundell jlund...@pobox.com wrote: On Feb 2, 2010, at 12:48 PM, Thadeus Burgess wrote: You can view a proposed change, I have sent this to Massimo to look at. http

Re: [web2py] Re: Newbie Question: Intellisense for Web2Py?

2010-02-02 Thread Thadeus Burgess
Have you tried it? -Thadeus On Tue, Feb 2, 2010 at 4:31 PM, DL choralr...@naver.com wrote: Are you sure?  I thought '__all__' was made for cases like this.. On Jan 21, 7:03 am, Thadeus Burgess thade...@thadeusb.com wrote: It is not, it will not pull in the imports of other files. You

Re: [web2py] Re: dal.py

2010-02-02 Thread Thadeus Burgess
: I'm confused about this - dal2.py is the new version but what is the difference between sql.py and dal.py? On Feb 3, 7:05 am, Thadeus Burgess thade...@thadeusb.com wrote: belay that :) was using sql.py's Field with dal.py's DAL -Thadeus On Tue, Feb 2, 2010 at 11:53 AM, Thadeus Burgess thade

Re: [web2py] hg export tip on fresh hg clone

2010-02-02 Thread Thadeus Burgess
The act of exporting a changeset generates an augmented patch file that describes the change. A Mercurial patch file contains some metadata and a traditional unified diff. Once a changeset has been exported from one repository, it can be imported into another. The actual command is hg export

Re: [web2py] Re: Global Variable Available Across Sessions

2010-02-01 Thread Thadeus Burgess
Why not use a chained cache.disk inside a cache.ram. This way it caches to both, so if it doesn't have cached in ram, it can always pull from the disk. I'm curious, what is the object your trying to cache ? I would think any object that had to persist in a thread-safe way like your requirements

Re: [web2py] Re: Global Variable Available Across Sessions

2010-02-01 Thread Thadeus Burgess
Sounds nasty. reading from the disk will always be faster than querying that database again. It seems the following should work for you then? t=cache.ram('from_sql_server',lambda:cache.disk('from_sql_server', lambda:myobject(),time_expire=5),time_expire=5) This way if

<    4   5   6   7   8   9   10   11   12   13   >