[web2py] Is GAE worth using

2010-05-06 Thread mike
>From my past experiences i have found GAE a little slow, is this just me? With web2py development what has the community found with deploying to GAE.

[web2py] Is T3 still in use, whats everyone using

2010-05-06 Thread mike
About a year ago or so, I was really excited about T3. But going back to web2py now, there is very little mention of it, so is this project dead? Is it worth using, or is there another system in development?

[web2py] drop shadow on text in admin editor safari

2010-06-17 Thread Mike
looks ok. Any ideas on how to fix this? Is it CSS or a browser setting? Thanks! Mike

[web2py] Re: drop shadow on text in admin editor safari

2010-06-18 Thread Mike
one for the primary text. I look though styles.css but didn't anything that looked like it is setting the margin-left. Any thoughts on where else to look? CSS is not my strong suite. Thanks for your help so far... Mike On Jun 17, 11:04 pm, Anthony wrote: > Same problem in IE8 on Windo

[web2py] upload field without storing the file

2010-02-11 Thread Mike
t I'd like to use web2py to take advange of it's other features. Thanks, Mike -- 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,

[web2py:34509] "LIKE" in GAE

2009-11-03 Thread mike
Im following the documentation, I have made this model (copy&paste it): buyer = db.define_table('buyer', Field('name')) and in my control, i try to do this: rows = db(buyer.id>0).select().find(lambda row:row.name.startswith ('C')) return dict(rows) but im getti

[web2py:34514] Re: "LIKE" in GAE

2009-11-03 Thread mike
Version 1.71.0 (2009-10-31 01:13:28) On Nov 3, 3:42 pm, mdipierro wrote: > Do you have the latest web2py version? Probably not. > > On Nov 3, 2:36 pm, mike wrote: > > > > > Im following the documentation, I have made this model (copy&paste > > it): &g

[web2py:34564] Re: "LIKE" in GAE

2009-11-04 Thread mike
Besides the code i have posted, is there any other requirements for this to work. On Nov 3, 5:18 pm, "mr.freeze" wrote: > Does it work locally but not on GAE? I am using the same version with > no problems locally. > > On Nov 3, 2:46 pm, mike wrote: > > > >

[web2py:34565] Re: "LIKE" in GAE

2009-11-04 Thread mike
Im currently only using mysql, localy, not yet on GAE On Nov 3, 5:18 pm, "mr.freeze" wrote: > Does it work locally but not on GAE? I am using the same version with > no problems locally. > > On Nov 3, 2:46 pm, mike wrote: > > > > > Version 1.71.0 (2009-10

[web2py:34600] running the source verison of web2py

2009-11-04 Thread mike
I have just downloaded it and trying to run it, but Im getting the following errors: Traceback (most recent call last): File "D:\servers3\web2py\web2py.py", line 20, in gluon.widget.start(cron=True) File "D:\servers3\web2py\gluon\widget.py", line 810, in start master = web2pyDialog(r

[web2py:34603] Re: running the source verison of web2py

2009-11-04 Thread mike
No i do not, do i need all off them? Must of missed that point. On Nov 4, 1:13 pm, mdipierro wrote: > Do you have the Mark Hammond win32 extensions? > > On Nov 4, 12:02 pm, mike wrote: > > > > > I have just downloaded it and trying to run it, but Im getting

[web2py:34621] Re: "LIKE" in GAE

2009-11-04 Thread mike
tallation. Can you try > reinstalling web2py? > > On Nov 4, 8:21 am, mike wrote: > > > > > Im currently only using mysql, localy, not yet on GAE > > > On Nov 3, 5:18 pm, "mr.freeze" wrote: > > > > Does it work locally but not on GAE? I am using

[web2py:13821] Unnecessary HTML code generated

2008-12-18 Thread mike
Looking into the code that is generated, there is an extra html code generated Created by Michal Zak - Powered by web2py This code is already part of the template, so its an unnecessary duplicate. Is there a way of removing this? --~--~-~--~---

[web2py:13824] Re: Unnecessary HTML code generated

2008-12-18 Thread mike
}} instead off just loading the layout.html On Dec 18, 1:30 pm, mdipierro wrote: > Sorry, I do not understand. How do you get this duplicate code? T3? > Which page? > > Massimo > > On Dec 18, 12:22 pm, mike wrote: > > > Looking into the code that is gener

[web2py:13835] Chaning the Menu order

2008-12-18 Thread mike
In T3, is there a way to change the order of the menu items. --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups "web2py Web Framework" group. To post to this group, send email to web2py@googlegroups.com To unsubscribe fr

[web2py:13838] Template Systems w web2py

2008-12-18 Thread mike
Are there any suggestions for template systems with web2py I would like to have an ability to have small templates that can be reused througout the main page. Ex. maybe have a file -> menuItem.html (would really like the ability to have separate files for different sub-templates) {{item}} Then

[web2py:14074] Multiple Applications using 1 template

2008-12-23 Thread mike
Whats the best practice in having multiple applications using same layout template. since we are one the subject, is there a possibility of having one application use functions from other applications. If so whats the best practice in doing so? --~--~-~--~~~---~--~---

[web2py:14078] limitby with mssql - can this be added to the DAL?

2008-12-23 Thread Mike
Hi Everyone, As the books notes, limitby isn't fully supported by mssql since the TOP command always starts at index 0. So to implement paging I ended up writing my own SQL to mimic the limitby behavior. The main example I used was from http://www.15seconds.com/issue/070628.htm and requires SQL

[web2py:14079] Re: Multiple Applications using 1 template

2008-12-23 Thread mike
What about reusing functions from other applications. On Dec 23, 2:06 pm, mdipierro wrote: > you can > > {{extend '../../otherapp/views/layout.html'}} > > but I suggest copying the layout else the apps will not be portable. > > Massimo > > On Dec 23, 12:41

[web2py:14081] Dictionary question

2008-12-23 Thread mike
I am using T3, in my setting page I have this var defined: response.topMenu = [dict(test1='test11', test2='test22')] In my layout.html template I want to use this, this is what I have: {{for link in response.topMenu:}} {{=link.test1}} {{pass}} I get this error: AttributeError: 'dict'

[web2py:14086] Re: Dictionary question

2008-12-23 Thread mike
7;test11', test2='test22') ] how to I loop through it. On Dec 23, 3:15 pm, "Wes James" wrote: > On Tue, Dec 23, 2008 at 12:44 PM, mike wrote: > > > I am using T3, in my setting page I have this var defined: > > > response.topMenu = [dict(test1='

[web2py:14090] User Login Through GAE in T3

2008-12-23 Thread mike
Is there anyone who tried this. This is what I will be trying to do: Have a new module GAEIdentity and just wrap around the login/out gae api into it. Then use it to modify these vars, to that it works with T2/3 session.t2.person_id session.t2.person_name session.t2.person_email

[web2py:14097] Re: Dictionary question

2008-12-23 Thread mike
ot;Wes James" wrote: > On Tue, Dec 23, 2008 at 1:32 PM, mike wrote: > > > Thanks for the reply, but just to make it more difficult, what if I > > have an array of dict objects. > > > ex. [dict(test1='test11', test2='test22') ,dict(test1=&#

[web2py:14110] Re: limitby with mssql - can this be added to the DAL?

2008-12-24 Thread Mike
t1 LEFT JOIN t2 ON t1.id=t2.t1 WHERE > w_rown>=1 AND w_rown<2)  GROUP BY t1.name ORDER BY t1.name;' > > If not, how should they be fixed (SQL)? > > Massimo > > On Dec 23, 4:59 pm, mdipierro wrote: > > > I think so. This is what we do with Oracle. Tomo

[web2py:14165] Re: limitby with mssql - can this be added to the DAL?

2008-12-27 Thread Mike
Hi Massimo - I'll be out of town for a few days so I may be a little slow to reply, but I will have access to my servers and can run any additional tests that you need. Thanks again! Mike On Dec 24, 11:43 am, mdipierro wrote: > Thank you. I will send another round of tests. >

[web2py:14950] Re: Labels on table definition

2009-01-14 Thread Mike
I recently tried this and it didn't seem to work...so I gather from this thread that T2 is currently required to define a label in the model but the plan is for this feature to migrate into the web2py core? Thanks for the clarification... Mike On Jan 13, 10:54 pm, mdipierro wrote: > I

[web2py:14981] Re: Labels on table definition

2009-01-14 Thread Mike
Hmm...it's working now. Thanks! Mike On Jan 14, 8:18 pm, vince wrote: > can you make it work with SQLTABLE's header as well? thanks > > -vince > > On Jan 15, 3:21 am, mdipierro wrote: > > > should work without T2. which version do you have? > > Massim

[web2py:18491] Re: jquery jqGrid JSON url problem

2009-03-23 Thread Mike
he XML data "return xml" instead of "return dict(xml = xml)" Hope that helps. I like jqGrid since it has excellent documentation and hope more of us can make it work with web2py. Mike On Mar 23, 5:27 am, ed wrote: > Hi, > I've been trying to execute a jquery jqGrid u

[web2py:18576] Re: jquery jqGrid JSON url problem

2009-03-25 Thread Mike
s["Content-Type"]="text/xml" #start the XML data set mystr = "1110" #get the data from the database records = db.executesql("SELECT TOP 10 col1, col2, col3 FROM tbl1") #MS SQL Server #build XML from dataset for row in records: mystr

[web2py:19961] admin interface issue 1.61.1

2009-04-17 Thread Mike
So if my app is call "myapp" and I click design, it tries to go to http://.../admin/design/m/y/a/p/p instead of http://.../admin/design/myapp Any thoughts? Mike --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups &q

[web2py:20070] Re: admin interface issue 1.61.1

2009-04-20 Thread Mike
core apps...but then the service wouldn't stay running. It would start but then immediately shut down. I've used this same upgrade process for several versions now but this is first problem I've had...perhaps its time for a clean install? Mike On Apr 17, 11:44 pm, Yarko Tymciurak

[web2py:22323] Re: Most complex app in Web2Py yet?

2009-05-21 Thread Mike
@Horst - I'd love to take a look when it's ready...this is my field. On May 21, 9:22 pm, Tito Garrido wrote: > I'm looking forward on it! > > On Thu, May 21, 2009 at 9:50 PM, Horst Herb > > > > wrote: > > > On Fri, May 22, 2009 at 9:42 AM, JorgeRpo wrote: > > > > Hello > > > > I'd like to kno

[web2py] Re: grid search behaviour with foreign keys

2012-08-01 Thread Mike
I'm also trying to get around this issue - anyone have any recommendations? On Monday, July 2, 2012 12:08:46 PM UTC-4, simon wrote: > > When you have a grid with a reference field then the search functionality > does not work as expected. > > For example grid shows: > >Owner Dog >

[web2py] Dynamic Ajax Content and Jquery

2012-08-09 Thread Mike
I guess this is really more of a jquery question but I figured there may be some easier web2py builtin way to do this... I'm doing some custom auto completion on an input field and thought the example from the book made more sense for my usage (as opposed to the built in autocomplete widget). T

[web2py] Re: Dynamic Ajax Content and Jquery

2012-08-09 Thread Mike
ethod works for me. Thanks again for the help man. Really appreciate web2py and this community. --Mike On Thursday, August 9, 2012 7:02:11 PM UTC-4, Anthony wrote: > > Here is your code reformatted: > > jQuery(".big_search").keyup(function() { > ajax('partial_se

[web2py] Web2Py in cluster and DATABASES folder

2012-08-23 Thread Mike
We are planning on deploying our Web2Py application under Apache-WSGI on a cluster of servers all accessing the same multiple databases. Since the new databases will be created on the fly, as needed, we cannot predict beforehand how many we will end up using and, consequently, how many files wil

[web2py] Re: Web2Py in cluster and DATABASES folder

2012-08-23 Thread Mike
the same > way as your codebase ? > > Il giorno giovedì 23 agosto 2012 17:14:51 UTC+2, Mike ha scritto: >> >> We are planning on deploying our Web2Py application under Apache-WSGI on >> a cluster of servers all accessing the same multiple databases. Since the >>

[web2py] Re: Web2Py in cluster and DATABASES folder

2012-08-23 Thread Mike
n it joined already. You should be > able to perform this check without looking at the filesystem. > > > > On Thursday, 23 August 2012 12:15:49 UTC-5, Mike wrote: >> >> Perhaps I haven't made myself clear enough... >> >> Forget about development environmen

[web2py] Reference Field, validation and representation

2012-05-22 Thread Mike
see the db.jack_listings format string instead of the id#. My question is, how can I keep this requires functionality but still have the field display as the correct representation in tables? Thanks for your help in advance! Mike

[web2py] Re: Reference Field, validation and representation

2012-05-22 Thread Mike
], represent= lambda jack,row: db(db.jack_listings.id == row.jack_id_string).select()[0].jack_and_bldg), (db.jack_listings is another table and 'jack_and_bldg' was the field I wanted to show up in the grid tables instead of the id #) --Mike On Tuesday, May 22, 2012 2:35:01 P

[web2py] grid, user_signature, and apache auth

2013-02-05 Thread Mike
ange user_signature to False. I assume I am not mapping the login function correctly? Can anyone offer me some pointers here? Thanks in advance for any assistance. --Mike -- --- You received this message because you are subscribed to the Google Groups "web2py-users" group. To u

[web2py] autocomplete tweak, jquery fade out time

2012-10-03 Thread Mike
en creating the db.t_port_to_jack.jack_id_string.widget instance but I'm not very adept with Python classes so I didn't get very far. Thanks in advance! Mike --

[web2py] Re: Question about 0.py

2012-03-27 Thread Mike
thing else I have to toggle after going through the app wizard? Thanks! Mike On Monday, February 7, 2011 8:48:09 PM UTC-5, Massimo Di Pierro wrote: > > 0.py is not a web2py file. It is created by the wizard. If a variable > is not used is a bug in the wizard. > > Massimo > >

[web2py] auth.add_group

2011-04-01 Thread Mike
DISCLAIMER: very new to web2py, read book and building first app... I'm having some brain cramps trying to add some default groups. Basically I need some default groups set-up when I rollout my application, like Admins, End-Users, Management - when users register one of us will manually filter the

[web2py] Re: auth.add_group

2011-04-01 Thread Mike
) groupadd('Maintenance Users') groupadd('Download Users') auth.settings.register_onaccept=lambda form: auth.add_membership(auth.id_group('Download Users'),form.vars.id) -- On Apr 1, 12:06

[web2py] app structural question

2011-04-01 Thread Mike
Hello, Im designing an application for license management of some software that my company produces. The intended workflow is as follows: 1) End-user of product registers on app, approval pending for review 2) When a user in the 'Admin' group logins they have access to a approval section where the

[web2py] Re: auth.add_group

2011-04-06 Thread Mike
understanding is correct). @Christopher - I like the concept of having the config file like you suggested, but it seems out of band with all the other web2py config - not sure if that's a good or bad thing yet. Still grasping this whole framework... Thanks again for the advice everyone.

[web2py] 2 field unique validator

2011-04-12 Thread Mike
I know this question has been asked and answered before, but I am having errors in implementation and I feel like it's something really silly. If anyone can point anything obvious out that I am missing, please let me know. Basically I am trying to implement so that two rows can not have the same co

[web2py] Re: 2 field unique validator

2011-04-12 Thread Mike
Thanks DenesL! That was definitely the issue. On Apr 12, 12:21 pm, DenesL wrote: > Move the requires from inside the field definition to after the table > definition. > web2py will not allow a reference to a field that has not been > created. > > On Apr 12, 12:

[web2py] SQLtable customizations + urls

2011-04-20 Thread Mike
*DISCLAIMER: NEWBIE ABOARD!*** I'm trying to display a table of the database with 'edit' URL links (that point to another function) tacked on at the last column. I saw that the SQLTABLE has a linkto= option but I don't want to change the look of the link and don't want it to display as the

[web2py] DAL compatibility with GAE design recommendations

2011-04-24 Thread Mike
I've just begun to explore web2py and the GAE. On the GAE site, there are several articles which discuss table design in the absence of joins. For example, at http://www.google.com/events/io/2009/sessions/BuildingScalableComplexApps.html, Brett Slatkin describes "relation index entities" and "me

[web2py] crud update weirdness

2011-05-06 Thread Mike
I check the database I see a new Row has been created but I was really trying to update the existing row that has the id of the Record variable. I know it's something silly I am missing here - let me know if anyone can provide some pointers or advice. Thanks! Mike

[web2py] Can you have multiple plugins use Web2py Scheduler in the same App?

2015-12-16 Thread mike
the right direction to get this working? Thanks, Mike -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) - http://github.com/web2py/web2py (Source code) - https://code.google.com/p/web2py/issues/list (Report Issues) --- You received this message because you are

[web2py] Re: Can you have multiple plugins use Web2py Scheduler in the same App?

2015-12-17 Thread mike
ey are installed in an App separately. If they are both >> isnstalled in the same App only one of the plugins scheduled tasks get run. >> (The one with the last loaded model alphabetically). Can someone point me >> in the right direction to get this working? >> >> Than

[web2py] Change in application request.vars when switching from Rocket to Lighttpd+FastCGI

2015-02-24 Thread Mike
_cmd() is empty: ** Although, the request.env.query_string contents are valid: *'query_string': 'id=2&src=cmd'* Any suggestions to resolve this issue would be greatly appreciated, thanks, Mike -- Resources: - http://web2py.com - http://web2py.com/book (Documentation

[web2py] Re: Change in application request.vars when switching from Rocket to Lighttpd+FastCGI

2015-02-25 Thread Mike
TTP["scheme"] == "http" { $HTTP["host"] =~ ".*" { url.redirect = ("^/ccs/.*" => "https://%0$0";) } } fastcgi.server = ( ".fcgi" => ( "localhost" => ( #name for logs "debug&q

[web2py] Re: Change in application request.vars when switching from Rocket to Lighttpd+FastCGI

2015-02-26 Thread Mike
On Wednesday, February 25, 2015 at 12:18:29 PM UTC-8, Niphlod wrote: > > reaally strange, although I don't use lighttpd since nginx came out. > request.vars are parsed out of request.QUERY_STRING. could you please > doublecheck what request.get('QUERY_STRING') dumps ? > > > request.get('QUERY_

[web2py:17572] Re: web2py on dreamhost shell account?

2009-03-05 Thread Mike Axelrod
ind, but I imagine some folks might give before getting it going. I look forward to reading any other comments, Mike P.S. by the way very nice framework! Kudos. --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups &q

[web2py:18000] Qusestion about the book?

2009-03-13 Thread Mike Axelrod
So is the book worth $50? and is it more than 68 pages? Mike --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups "web2py Web Framework" group. To post to this group, send email to web2py@googlegroups.com To u

[web2py:18036] Re: Qusestion about the book?

2009-03-14 Thread Mike Axelrod
Thanks everyone, I just bought the book from lulu. And yes it is a full 246 pages + additional front matter. Just scanning it now, it does look like it will be very helpful. Someone ought to correct that guy's strange page number reference on the Amazon review. It does the author a disservic

[web2py:18351] Re: Qusestion about the book?

2009-03-19 Thread Mike Axelrod
Hi all just commenting back to this thread that I have finished reading the book. And it is a very good book indeed. I bought the PDF version from lulu. I have a nice wide screen 24 inch iMac so I could have the book open in one window and work through the examples in a browser right next to th

[web2py] web2py and external editors

2011-01-18 Thread Mike Rans
x27;t want to turn warnings off as that defeats the object of Pylint. I can modify the Pylint plugin to do things before launching Pylint (and already do so with altering the PYTHONPATH), so do you know of a way to tell Pylint about the imports web2py has done? Cheers, Mike

[web2py] Re: web2py and external editors

2011-01-20 Thread Mike Rans
Thanks very much Niphlod and Plumo. I will check out these possible solutions.

[web2py] Search in Web2Py

2012-08-07 Thread Mike Girard
I notice that there is no search box on the main web2py site. The search on the book site is somewhat unorthodox in that it only provides links where the search term is located but does not show you where. Does web2py have a robust, conventional search utility? If not, what is the prescribed me

[web2py] Problem with Field display in SQLForm.Smartgrid

2012-08-09 Thread Mike Girard
Hello: I am building a movie database site with web2py. I have a movies table which has a many-to-many relationship with several other items: stars, directors and genres. I am using a SQLForm.Smartgrid declared in my controller like so: def manage_movies(): grid = SQLFORM.smartgrid(db.mov

[web2py] Just a quick eyeball on this, perhaps?

2012-08-09 Thread Mike Girard
Can anyone tell just by looking at this what the problem with the ID and Star fields might be? The record is actually fine. When I click Edit, everything is as it should be. Sorry for not providing the full background on this, for brevity's sake. Was wondering if someone can see the problem ju

[web2py] Re: Just a quick eyeball on this, perhaps?

2012-08-09 Thread Mike Girard
> it points to is represented as "None" > > star looks to be a Set, or the results of a query. something has gone > wrong in the setup of the table or in the representation of that field. > > On Thursday, August 9, 2012 1:00:06 PM UTC-7, Mike Girard wrote: >> &g

[web2py] Re: Just a quick eyeball on this, perhaps?

2012-08-09 Thread Mike Girard
Field('created', 'datetime','datetime', default=request.now), Field('modified', 'datetime','datetime', default=request.now)) Grid code: @auth.requires_login() def manage_movies(): grid = SQLFORM.smartgrid(db.movie) retu

[web2py] Re: Just a quick eyeball on this, perhaps?

2012-08-09 Thread Mike Girard
I fixed it. My column names were screwed up. Sorry. On Thursday, August 9, 2012 11:20:31 PM UTC-4, Mike Girard wrote: > > Model: > > db.define_table('movie', > Field('title','string'), > Field('api_id', 'string&#x

[web2py] Trouble adding lxml module to application

2012-08-12 Thread Mike Girard
I am attempting to use lxml in my app. I am using Mac OS X. I placed the lxml files in web2py/Content/Resources/applications//modules. I attempted to import lxml into default.py with this: from lxml import etree I am getting a module-not-found error. I anticipated problems because lxml req

[web2py] Re: Trouble adding lxml module to application

2012-08-12 Thread Mike Girard
found error went away. Is it ok to run web2py with python 2.6 or am I likely to encounter problems down the road? Thanks for your help. On Sunday, August 12, 2012 11:39:56 PM UTC-4, Mike Girard wrote: > > I am attempting to use lxml in my app. I am using Mac OS X. I placed the > l

[web2py] Re: Trouble adding lxml module to application

2012-08-12 Thread Mike Girard
Are you sure? I searched on this list and seemed that there had been some problems. In light of this I installed lxml in my 2.5 site-packages and ran web2py with the python2.5 command recommended on the installation page. Can someone confirm what Python version is best for running web2py as of

[web2py] Re: Trouble adding lxml module to application

2012-08-13 Thread Mike Girard
Thanks for the confirmation. Perhaps the official documentation should be updated. On Monday, August 13, 2012 9:17:51 AM UTC-4, Anthony wrote: > > Are you sure? I searched on this list and seemed that there had been some >> problems. > > > Shouldn't be any problems. 2.5 is the *oldest* version

[web2py] Re: Trouble adding lxml module to application

2012-08-13 Thread Mike Girard
work is written to target 2.5, so the > framework code doesn't include any language features that were new in 2.6 > or 2.7 (of course, your app code can include such features if you're > running 2.6 or 2.7). I think we may need to remove 2.4 from that list as > well. >

Re: [web2py] retrieve data from many to many relation

2012-08-13 Thread Mike Girard
I am sure that this answer is exactly what I am looking for to solve a problem I am having. However, I don't quite understand the particulars. Vincenzo, could you please provide an example of the queries used here to get the movie linked up with the genre. Maybe some code? On Saturday, July 28

[web2py] Helper for many-to-many result sets?

2012-08-13 Thread Mike Girard
I have a movie table that has a many-to-many relationship with a person table expressed through a star table. A simplified version of my model: db.define_table('movie', Field('title','string'), db.define_table('person', Field('name', 'string', unique=True), db.define_table('sta

Re: [web2py] Helper for many-to-many result sets?

2012-08-13 Thread Mike Girard
re more > resources than a simple join. So I recommend just sticking with the join, > and displaying in your view what you'd like. > > As for the wrapper to give things easier to work with names, just specify > said information in your controller. > On 14/08/2012 8:04 AM, &q

Re: [web2py] Helper for many-to-many result sets?

2012-08-13 Thread Mike Girard
o that. > > Examples are in the book. > > On Tue, Aug 14, 2012 at 8:59 AM, Mike Girard > > > wrote: > > I don't think you have understood my question. > > > > My concern is not that I have too many fields nor my field names. > > > > I am a

Re: [web2py] Re: Helper for many-to-many result sets?

2012-08-14 Thread Mike Girard
Salient bits of model at the top of the thread. On Tuesday, August 14, 2012 2:16:56 AM UTC-4, rochacbruno wrote: > > I guess you can also do: > > table = TABLE(*[TR(TD(movie.title), TD(UL(*[LI(star.name) for star in * > movie.stars.select()*])) for movie in movies]) > > when a table is referenced

Re: [web2py] Re: Helper for many-to-many result sets?

2012-08-14 Thread Mike Girard
This all looks promising. Meanwhile, here's my model with irrelevant Fields omitted and below that my query for the Select. Thanks for the help! A simplified version of my model: db.define_table('movie', Field('title','string'), db.define_table('person', Field('name', 'string', uni

[web2py] Best way to insert 200k records?

2012-08-17 Thread Mike Girard
Hello: What is the prescribed method for doing large bulk inserts? I am using sqllite as my backend. Is it ok to just write a Python script that talks to the db directly or should the DAL be used? The book says the bulk_insert method is not more advantageous than a for loop. I searched thi

Re: [web2py] Best way to insert 200k records?

2012-08-17 Thread Mike Girard
But what method should I use? Is there anything better than bulk_insert? Naturally I would like this to work as fast as possible. Thanks. --

[web2py] Re: Best way to insert 200k records?

2012-08-17 Thread Mike Girard
The data will be coming from a large XML file, so my script will parse that and make inserts into several different tables. It's fairly straightforward. So is it correct to say that - 1. There is no compelling reason to do this without the DAL 2. My options in the DAL are bulk_insert, looping

[web2py] Re: Best way to insert 200k records?

2012-08-17 Thread Mike Girard
being added by the DAL for inserts that a bulk insert using SQLLite directly won't add? On Friday, August 17, 2012 12:58:01 PM UTC-4, nick name wrote: > > On Friday, August 17, 2012 8:29:12 AM UTC-4, Mike Girard wrote: >> >> The data will be coming from a large XML file, so m

[web2py] Re: Congratulations to Bruno and Mariano

2012-08-17 Thread Mike Girard
Congratulations, guys. I appreciate all the work you do. On Friday, August 17, 2012 10:13:45 AM UTC-4, Massimo Di Pierro wrote: > > Congratulations to Bruno Rocha and Mariano Reingart, > > New members of the Python Software Foundations. > > http://pyfound.blogspot.com.br/2012/08/welcome-new-psf

[web2py] Get row count for query without loading data into memory

2012-08-17 Thread Mike Girard
Does this load the rows into memory? db(db.person.id > 0).count() If so, is there a DAL way to get a row count for a query without loading the rows? Thanks. Mike --

[web2py] Re: Get row count for query without loading data into memory

2012-08-17 Thread Mike Girard
00:20 PM UTC-4, Cliff Kachinske wrote: > > I'm not really a DAL guru, but I can't imagine DAL doing that. > > Every dbms I know about has something like "SELECT COUNT(id) WHERE > ..." > > > > On Friday, August 17, 2012 5:54:32 PM UTC-4, Mike Gir

[web2py] DAL field rules and form constraints

2012-08-18 Thread Mike Girard
In preparation for doing a bulk insert into my app's tables I have been doing some testing from the web2py shell. I issued the following command: >>db.person.insert(name = 'Dustin Hoffman') person.name has a unique=true setting as well as an IS_NOT_IN_DB form constraint. Dustin Hoffman is alre

[web2py] Re: DAL field rules and form constraints

2012-08-18 Thread Mike Girard
post-processing for duplicate records. Thanks. On Saturday, August 18, 2012 2:50:18 PM UTC-4, Mike Girard wrote: > > In preparation for doing a bulk insert into my app's tables I have been > doing some testing from the web2py shell. > > I issued the following command: > > &g

[web2py] Re: DAL field rules and form constraints

2012-08-18 Thread Mike Girard
use > it will be called automatically at the end of the request). Also, when you > use .insert(), the validators don't run -- they only run when using SQLFORM > or when you insert via .validate_and_insert(). > > Anthony > > On Saturday, August 18, 2012 2:50:18 PM UTC-4,

[web2py] global name 'psycopg2_adapt' is not defined

2012-08-18 Thread Mike Girard
I am attempting to move from SQLLite to Postgres because I was having table locking issues.. I downloaded and installed Postgres and the Psycopg2-2.4.5. They work. I am able to administer Postgres and the installation of the driver was uneventful. I first encountered the self-drivers error (

[web2py] Re: global name 'psycopg2_adapt' is not defined

2012-08-18 Thread Mike Girard
Apparently there is something wrong with my installation of the driver. Going to see if I can sort that before coming back. Consider this closed. On Saturday, August 18, 2012 8:16:36 PM UTC-4, Mike Girard wrote: > > I am attempting to move from SQLLite to Postgres because I was having &

[web2py] Re: global name 'psycopg2_adapt' is not defined

2012-08-18 Thread Mike Girard
web2py is now working with Postgres. On Saturday, August 18, 2012 8:38:27 PM UTC-4, Mike Girard wrote: > > Apparently there is something wrong with my installation of the driver. > Going to see if I can sort that before coming back. Consider this closed. > > On Saturday, August 1

[web2py] Re: Where to host web2py

2012-08-18 Thread Mike Girard
Hi Simon: I know from having reviewed the trail on this issue in this group that other members have been successful in getting web2py working on Webfaction and hostgator. Webfaction in particular seems to get high marks and their service seems to have some VPS-like features, though it is not V

Re: [web2py] Where to host web2py

2012-08-19 Thread Mike Girard
Wow, those are great prices for VPS. Was there anything besides price that made you choose them? On Sunday, August 19, 2012 5:42:32 AM UTC-4, Simon Carr wrote: > > I have just found this service > > http://webkeepers.com > > I think i will give their medium service a try on the one month contrac

Re: [web2py] Re: Best way to insert 200k records?

2012-08-19 Thread Mike Girard
"bulk insert is a way faster than regular insert when you have many rows" I think we need to clarify terms. By Massimo's own account in the web2py book, the DAL bulk insert is not faster than db.insert unless you are using the GAE. So are you talking about your db's native bulk methods or is the

Re: [web2py] Re: Best way to insert 200k records?

2012-08-20 Thread Mike Girard
input. This community is uniquely helpful. On Monday, August 20, 2012 1:49:46 AM UTC-4, Andrew wrote: > > HI Martin, > It depends on the RDBMS. Some are still one row at a time, which makes > insert and bulk_insert the same speed (it just makes the statement easier > to write. >

[web2py] Loading data into list:reference fields eliciting strange "NoneType" "not iterable' error

2012-08-22 Thread Mike Girard
I have written a script to parse a large xml file and insert the contents in to my app db. I am using lxml. After about 10 records get inserted, the script fails with argument of type 'NoneType' is not iterable Troubleshooting determined the following: 1. This error is associated with 3 list:

[web2py] Re: Loading data into list:reference fields eliciting strange "NoneType" "not iterable' error

2012-08-22 Thread Mike Girard
There were a couple typos in my post that do not correspond to my code. Should be movie['genre*s*'] = *[*456, 368, 239] On Wednesday, August 22, 2012 2:49:29 PM UTC-4, Mike Girard wrote: > > I have written a script to parse a large xml file and insert the contents > in to my

[web2py] Re: Loading data into list:reference fields eliciting strange "NoneType" "not iterable' error

2012-08-22 Thread Mike Girard
One other troubleshooting detail: I did type(obj) on the dict, 'movie' as well as all the items inside it. They all check out. No 'None's anywhere. On Wednesday, August 22, 2012 2:49:29 PM UTC-4, Mike Girard wrote: > > I have written a script to parse a large xml fi

  1   2   3   >