Re: Raw MySQL with SQLAlchemy using Pyramid framework

2011-02-22 Thread Iain Duncan
One more vote that it's absolutely worth learning SA even if you're an sql whiz. It's a superb library, and let's you operate at multiple levels of abstraction. And great sql injection insurance! iain On Sun, Feb 20, 2011 at 8:39 AM, Ben Bangert wrote: > On Feb 20, 2011, at 1:58 AM, AwaisMuzaff

Re: Raw MySQL with SQLAlchemy using Pyramid framework

2011-02-20 Thread Ben Bangert
On Feb 20, 2011, at 1:58 AM, AwaisMuzaffar wrote: > Thanks for the reply guys it has been very informative. > > My main reason for using raw is that I have spent so much time > learning MySQL, to me it seems counter productive to learn SQLALchemy > methodologies from scratch. > > Ok, so maybe ma

Re: Raw MySQL with SQLAlchemy using Pyramid framework

2011-02-20 Thread Christoph Zwerschke
Am 20.02.2011 10:58 schrieb AwaisMuzaffar: My main reason for using raw is that I have spent so much time learning MySQL, to me it seems counter productive to learn SQLALchemy methodologies from scratch. Ok, so maybe manually executing CREATE is not a great idea, but what about performing querie

Re: Raw MySQL with SQLAlchemy using Pyramid framework

2011-02-20 Thread AwaisMuzaffar
Thanks for the reply guys it has been very informative. My main reason for using raw is that I have spent so much time learning MySQL, to me it seems counter productive to learn SQLALchemy methodologies from scratch. Ok, so maybe manually executing CREATE is not a great idea, but what about perfo

Re: Raw MySQL with SQLAlchemy using Pyramid framework

2011-02-20 Thread Chris Withers
On 20/02/2011 02:06, Chris McDonough wrote: On Sun, 2011-02-20 at 00:02 +, Chris Withers wrote: and I want to use raw MySQL (personal reasons) Don't be an idiot ;-) Not really funny. Please see http://docs.pylonsproject.org/community/conduct.html . I know, with hindsight the smiley d

Re: Raw MySQL with SQLAlchemy using Pyramid framework

2011-02-19 Thread Chris McDonough
On Sun, 2011-02-20 at 00:02 +, Chris Withers wrote: > > and I want to use raw MySQL > > (personal reasons) > > Don't be an idiot ;-) Not really funny. Please see http://docs.pylonsproject.org/community/conduct.html . - C -- You received this message because you are subscribed to the Goo

Re: Raw MySQL with SQLAlchemy using Pyramid framework

2011-02-19 Thread Chris Withers
On 19/02/2011 09:44, AwaisMuzaffar wrote: I have recently made a decision to start using the Pyramid (python web framework) for my projects from now on. Yay :-) I have also decided to use SQLalchemy, Yay :-) and I want to use raw MySQL (personal reasons) Don't be an idiot ;-) The firs

Re: Raw MySQL with SQLAlchemy using Pyramid framework

2011-02-19 Thread Christoph Zwerschke
Am 19.02.2011 10:44 schrieb AwaisMuzaffar: Now from here how do I exectue a query for CREATE TABLE using raw MySQL. ... and recieve the following error: UnboundExecutionError: Could not locate a bind configured on SQL expression or this Session You're missing DBSession.configure(bind=engine) -

Raw MySQL with SQLAlchemy using Pyramid framework

2011-02-19 Thread AwaisMuzaffar
Hello guys, I have recently made a decision to start using the Pyramid (python web framework) for my projects from now on. I have also decided to use SQLalchemy, and I want to use raw MySQL (personal reasons) but still keep the ORM features. The first part of the code in models.py reads: DBSess