[sqlalchemy] Re: major help required with SQLAlchemy and Turbogears.

2007-06-30 Thread Lee McFadden
also post anything else that you might think is pertinent. :) Lee -- Lee McFadden blog: http://www.splee.co.uk work: http://fireflisystems.com skype: fireflisystems --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups

[sqlalchemy] Re: Lazy load a single column

2007-01-05 Thread Lee McFadden
On 1/5/07, Sean Davis [EMAIL PROTECTED] wrote: A simple question: I have a table with one HUGE column. Is there a way to make this column lazy-loaded? http://www.sqlalchemy.org/docs/adv_datamapping.myt#advdatamapping_properties_deferred -- Lee McFadden blog: http://www.splee.co.uk work

[sqlalchemy] Re: how to rename labels?

2006-12-28 Thread Lee McFadden
On 12/28/06, jose [EMAIL PROTECTED] wrote: I would like to know how assign label names as in: comune.cod_provincia AS sigla_provincia instead of: comune.cod_provincia AS comune_cod_provincia http://www.sqlalchemy.org/docs/sqlconstruction.myt#sql_select_labels -- Lee McFadden blog: http

[sqlalchemy] Re: how to rename labels?

2006-12-28 Thread Lee McFadden
outside of the logging of the SQL statements. Is there some error you're coming across due to the automatically generated labels? Lee -- Lee McFadden blog: http://www.splee.co.uk work: http://fireflisystems.com skype: fireflisystems --~--~-~--~~~---~--~~ You

[sqlalchemy] Re: how to rename labels?

2006-12-28 Thread Lee McFadden
be able to use the labels properly as per the documentation. Lee -- Lee McFadden blog: http://www.splee.co.uk work: http://fireflisystems.com skype: fireflisystems --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups

[sqlalchemy] Re: SQLAlchemy 0.3.2 released

2006-12-11 Thread Lee McFadden
... I was looking for something similar a while ago and found Pandoc[1]. I've not actually used it though as the client decided not to use Markdown syntax. It has a command line script called markdown2pdf which might help. [1]: http://sophos.berkeley.edu/macfarlane/pandoc/README.html -- Lee

[sqlalchemy] Re: MySQL Has Gone Away

2006-12-07 Thread Lee McFadden
that *always* causes the app to fail at some point during the process is as follows: ab -n 500 -c 10 http://localhost:8080/ I'm pretty sure that this isn't a TG problem (although I don't have an issue with being proven wrong :) so is this an SA issue or a MySQLdb issue? Thanks, Lee -- Lee McFadden

[sqlalchemy] Re: Searching TEXT fields

2006-11-29 Thread Lee McFadden
with an indexer as Julien suggested. [1]: http://dev.mysql.com/doc/refman/4.1/en/fulltext-search.html Lee -- Lee McFadden blog: http://www.splee.co.uk work: http://fireflisystems.com skype: fireflisystems --~--~-~--~~~---~--~~ You received this message because

[sqlalchemy] Re: Searching TEXT fields

2006-11-29 Thread Lee McFadden
to search then add a search method that does the last two lines of code. That way you can just call: Post.search(nasty midgets) Lee -- Lee McFadden blog: http://www.splee.co.uk work: http://fireflisystems.com skype: fireflisystems --~--~-~--~~~---~--~~ You received

[sqlalchemy] Re: Dynamic where-statement with OR

2006-11-10 Thread Lee McFadden
: query_args.append(my_table.c.id==id) if name: query_args.append(my_table.c.name==name) statement = my_table.select(or_(*query_args)) You can build quite complex queries this way by nesting and_() and or_() in the list. Lee -- Lee McFadden blog: http://www.splee.co.uk work: http

[sqlalchemy] Re: Bind Parameters, MySQL and Full text search.

2006-10-19 Thread Lee McFadden
. -- Lee McFadden blog: http://www.splee.co.uk work: http://fireflisystems.com --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups sqlalchemy group. To post to this group, send email to sqlalchemy@googlegroups.com