Re: [sqlalchemy] SqlAlchemy dynamic query generation
Hi, Try composing a criteria using and_(), or_(), or its equivalent binary operators ,|: crit = literal(false) crit |= (table.c.field == value) crit = (table.c.field == value) etc... And then: q = session.query(entity).filter(crit) 2011/12/22 Sana klh sana.kl...@gmail.com I tried it but i still get the same error. On Thu, Dec 22, 2011 at 2:31 PM, Robert Forkel xrotw...@googlemail.comwrote: conditions = [db.User.id==id] if user_name != ' ': conditions.append(db.User.name == user_name) elif age != ' ': conditions.append(db.User.age == age) elif place != ' ': conditions.append(db.User.place == place) result = db.User.filter(and_(*conditions)).all() might do the trick (untested). On Thu, Dec 22, 2011 at 9:53 AM, Sana klh sana.kl...@gmail.com wrote: Hi Robert Forkel, You got it right i am trying to have a combination of expression combined in and_. I need to add the attribute only when it is not equal to null.So i tried to check if it is not null and then from the expression and pass it to filter .But this does not work. I went through the document but unable to figure out how to do this through sql. Thank you On Thu, Dec 22, 2011 at 12:11 PM, Robert Forkel xrotw...@googlemail.com wrote: You may want to look at the tutorial [1]. In the code you pasted you are assembling a string to pass to filter. While you can do that (but then it should be proper sql not python!), what you want to do is passing a python expression like db.User.age==age, or a combination of expressions combined using and_, or_, etc. [1] http://www.sqlalchemy.org/docs/orm/tutorial.html#common-filter-operators On Thu, Dec 22, 2011 at 6:34 AM, Sana klh sana.kl...@gmail.com wrote: I am getting the following error ProgrammingError: (ProgrammingError) (1064, You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '== 1,db.User.age==23,d' at line 3) Is there any way by which i can generate dynamic query? Thank you Sana On Thu, Dec 22, 2011 at 4:40 AM, Jackson, Cameron cameron.jack...@thalesgroup.com.au wrote: You might get more help if you provide more details. What error are you getting? -Original Message- From: sqlalchemy@googlegroups.com [mailto: sqlalchemy@googlegroups.com] On Behalf Of Sana Sent: Thursday, 22 December 2011 2:50 AM To: sqlalchemy Subject: [sqlalchemy] SqlAlchemy dynamic query generation Hi All, I am trying to do query based on the user input as follows condition = 'and_(db.User.id == id' if user_name != ' ': condition += ',db.User.name == user_name' elif age != ' ': condition += ',db.User.age == age' elif place != ' ': condition += ',db.User.place == place' where = condition+')' result = db.User.filter(where).all() But Im getting error when i do this. Is there any way by which i can do this Thank you Sana -- 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. To unsubscribe from this group, send email to sqlalchemy+unsubscr...@googlegroups.com. For more options, visit this group at http://groups.google.com/group/sqlalchemy?hl=en. - DISCLAIMER: This e-mail transmission and any documents, files and previous e-mail messages attached to it are private and confidential. They may contain proprietary or copyright material or information that is subject to legal professional privilege. They are for the use of the intended recipient only. Any unauthorised viewing, use, disclosure, copying, alteration, storage or distribution of, or reliance on, this message is strictly prohibited. No part may be reproduced, adapted or transmitted without the written permission of the owner. If you have received this transmission in error, or are not an authorised recipient, please immediately notify the sender by return email, delete this message and all copies from your e-mail system, and destroy any printed copies. Receipt by anyone other than the intended recipient should not be deemed a waiver of any privilege or protection. Thales Australia does not warrant or represent that this e-mail or any documents, files and previous e-mail messages attached are error or virus free. - -- 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. To unsubscribe from this group, send email to sqlalchemy+unsubscr
Re: [sqlalchemy] SqlAlchemy dynamic query generation
Hi Robert Forkel, You got it right i am trying to have a combination of expression combined in and_. I need to add the attribute only when it is not equal to null.So i tried to check if it is not null and then from the expression and pass it to filter .But this does not work. I went through the document but unable to figure out how to do this through sql. Thank you On Thu, Dec 22, 2011 at 12:11 PM, Robert Forkel xrotw...@googlemail.comwrote: You may want to look at the tutorial [1]. In the code you pasted you are assembling a string to pass to filter. While you can do that (but then it should be proper sql not python!), what you want to do is passing a python expression like db.User.age==age, or a combination of expressions combined using and_, or_, etc. [1] http://www.sqlalchemy.org/docs/orm/tutorial.html#common-filter-operators On Thu, Dec 22, 2011 at 6:34 AM, Sana klh sana.kl...@gmail.com wrote: I am getting the following error ProgrammingError: (ProgrammingError) (1064, You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '== 1,db.User.age==23,d' at line 3) Is there any way by which i can generate dynamic query? Thank you Sana On Thu, Dec 22, 2011 at 4:40 AM, Jackson, Cameron cameron.jack...@thalesgroup.com.au wrote: You might get more help if you provide more details. What error are you getting? -Original Message- From: sqlalchemy@googlegroups.com [mailto:sqlalchemy@googlegroups.com] On Behalf Of Sana Sent: Thursday, 22 December 2011 2:50 AM To: sqlalchemy Subject: [sqlalchemy] SqlAlchemy dynamic query generation Hi All, I am trying to do query based on the user input as follows condition = 'and_(db.User.id == id' if user_name != ' ': condition += ',db.User.name == user_name' elif age != ' ': condition += ',db.User.age == age' elif place != ' ': condition += ',db.User.place == place' where = condition+')' result = db.User.filter(where).all() But Im getting error when i do this. Is there any way by which i can do this Thank you Sana -- 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. To unsubscribe from this group, send email to sqlalchemy+unsubscr...@googlegroups.com. For more options, visit this group at http://groups.google.com/group/sqlalchemy?hl=en. - DISCLAIMER: This e-mail transmission and any documents, files and previous e-mail messages attached to it are private and confidential. They may contain proprietary or copyright material or information that is subject to legal professional privilege. They are for the use of the intended recipient only. Any unauthorised viewing, use, disclosure, copying, alteration, storage or distribution of, or reliance on, this message is strictly prohibited. No part may be reproduced, adapted or transmitted without the written permission of the owner. If you have received this transmission in error, or are not an authorised recipient, please immediately notify the sender by return email, delete this message and all copies from your e-mail system, and destroy any printed copies. Receipt by anyone other than the intended recipient should not be deemed a waiver of any privilege or protection. Thales Australia does not warrant or represent that this e-mail or any documents, files and previous e-mail messages attached are error or virus free. - -- 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. To unsubscribe from this group, send email to sqlalchemy+unsubscr...@googlegroups.com. For more options, visit this group at http://groups.google.com/group/sqlalchemy?hl=en. -- 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. To unsubscribe from this group, send email to sqlalchemy+unsubscr...@googlegroups.com. For more options, visit this group at http://groups.google.com/group/sqlalchemy?hl=en. -- 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. To unsubscribe from this group, send email to sqlalchemy+unsubscr...@googlegroups.com. For more options, visit this group at http://groups.google.com/group/sqlalchemy?hl=en. -- You received this message because you are subscribed to the Google Groups sqlalchemy group. To post to this group, send email to sqlalchemy
Re: [sqlalchemy] SqlAlchemy dynamic query generation
conditions = [db.User.id==id] if user_name != ' ': conditions.append(db.User.name == user_name) elif age != ' ': conditions.append(db.User.age == age) elif place != ' ': conditions.append(db.User.place == place) result = db.User.filter(and_(*conditions)).all() might do the trick (untested). On Thu, Dec 22, 2011 at 9:53 AM, Sana klh sana.kl...@gmail.com wrote: Hi Robert Forkel, You got it right i am trying to have a combination of expression combined in and_. I need to add the attribute only when it is not equal to null.So i tried to check if it is not null and then from the expression and pass it to filter .But this does not work. I went through the document but unable to figure out how to do this through sql. Thank you On Thu, Dec 22, 2011 at 12:11 PM, Robert Forkel xrotw...@googlemail.com wrote: You may want to look at the tutorial [1]. In the code you pasted you are assembling a string to pass to filter. While you can do that (but then it should be proper sql not python!), what you want to do is passing a python expression like db.User.age==age, or a combination of expressions combined using and_, or_, etc. [1] http://www.sqlalchemy.org/docs/orm/tutorial.html#common-filter-operators On Thu, Dec 22, 2011 at 6:34 AM, Sana klh sana.kl...@gmail.com wrote: I am getting the following error ProgrammingError: (ProgrammingError) (1064, You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '== 1,db.User.age==23,d' at line 3) Is there any way by which i can generate dynamic query? Thank you Sana On Thu, Dec 22, 2011 at 4:40 AM, Jackson, Cameron cameron.jack...@thalesgroup.com.au wrote: You might get more help if you provide more details. What error are you getting? -Original Message- From: sqlalchemy@googlegroups.com [mailto:sqlalchemy@googlegroups.com] On Behalf Of Sana Sent: Thursday, 22 December 2011 2:50 AM To: sqlalchemy Subject: [sqlalchemy] SqlAlchemy dynamic query generation Hi All, I am trying to do query based on the user input as follows condition = 'and_(db.User.id == id' if user_name != ' ': condition += ',db.User.name == user_name' elif age != ' ': condition += ',db.User.age == age' elif place != ' ': condition += ',db.User.place == place' where = condition+')' result = db.User.filter(where).all() But Im getting error when i do this. Is there any way by which i can do this Thank you Sana -- 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. To unsubscribe from this group, send email to sqlalchemy+unsubscr...@googlegroups.com. For more options, visit this group at http://groups.google.com/group/sqlalchemy?hl=en. - DISCLAIMER: This e-mail transmission and any documents, files and previous e-mail messages attached to it are private and confidential. They may contain proprietary or copyright material or information that is subject to legal professional privilege. They are for the use of the intended recipient only. Any unauthorised viewing, use, disclosure, copying, alteration, storage or distribution of, or reliance on, this message is strictly prohibited. No part may be reproduced, adapted or transmitted without the written permission of the owner. If you have received this transmission in error, or are not an authorised recipient, please immediately notify the sender by return email, delete this message and all copies from your e-mail system, and destroy any printed copies. Receipt by anyone other than the intended recipient should not be deemed a waiver of any privilege or protection. Thales Australia does not warrant or represent that this e-mail or any documents, files and previous e-mail messages attached are error or virus free. - -- 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. To unsubscribe from this group, send email to sqlalchemy+unsubscr...@googlegroups.com. For more options, visit this group at http://groups.google.com/group/sqlalchemy?hl=en. -- 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. To unsubscribe from this group, send email to sqlalchemy+unsubscr...@googlegroups.com. For more options, visit this group at http://groups.google.com/group/sqlalchemy?hl=en. -- You received this message because you are subscribed to the Google Groups sqlalchemy group
Re: [sqlalchemy] SqlAlchemy dynamic query generation
I tried it but i still get the same error. On Thu, Dec 22, 2011 at 2:31 PM, Robert Forkel xrotw...@googlemail.comwrote: conditions = [db.User.id==id] if user_name != ' ': conditions.append(db.User.name == user_name) elif age != ' ': conditions.append(db.User.age == age) elif place != ' ': conditions.append(db.User.place == place) result = db.User.filter(and_(*conditions)).all() might do the trick (untested). On Thu, Dec 22, 2011 at 9:53 AM, Sana klh sana.kl...@gmail.com wrote: Hi Robert Forkel, You got it right i am trying to have a combination of expression combined in and_. I need to add the attribute only when it is not equal to null.So i tried to check if it is not null and then from the expression and pass it to filter .But this does not work. I went through the document but unable to figure out how to do this through sql. Thank you On Thu, Dec 22, 2011 at 12:11 PM, Robert Forkel xrotw...@googlemail.com wrote: You may want to look at the tutorial [1]. In the code you pasted you are assembling a string to pass to filter. While you can do that (but then it should be proper sql not python!), what you want to do is passing a python expression like db.User.age==age, or a combination of expressions combined using and_, or_, etc. [1] http://www.sqlalchemy.org/docs/orm/tutorial.html#common-filter-operators On Thu, Dec 22, 2011 at 6:34 AM, Sana klh sana.kl...@gmail.com wrote: I am getting the following error ProgrammingError: (ProgrammingError) (1064, You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '== 1,db.User.age==23,d' at line 3) Is there any way by which i can generate dynamic query? Thank you Sana On Thu, Dec 22, 2011 at 4:40 AM, Jackson, Cameron cameron.jack...@thalesgroup.com.au wrote: You might get more help if you provide more details. What error are you getting? -Original Message- From: sqlalchemy@googlegroups.com [mailto: sqlalchemy@googlegroups.com] On Behalf Of Sana Sent: Thursday, 22 December 2011 2:50 AM To: sqlalchemy Subject: [sqlalchemy] SqlAlchemy dynamic query generation Hi All, I am trying to do query based on the user input as follows condition = 'and_(db.User.id == id' if user_name != ' ': condition += ',db.User.name == user_name' elif age != ' ': condition += ',db.User.age == age' elif place != ' ': condition += ',db.User.place == place' where = condition+')' result = db.User.filter(where).all() But Im getting error when i do this. Is there any way by which i can do this Thank you Sana -- 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. To unsubscribe from this group, send email to sqlalchemy+unsubscr...@googlegroups.com. For more options, visit this group at http://groups.google.com/group/sqlalchemy?hl=en. - DISCLAIMER: This e-mail transmission and any documents, files and previous e-mail messages attached to it are private and confidential. They may contain proprietary or copyright material or information that is subject to legal professional privilege. They are for the use of the intended recipient only. Any unauthorised viewing, use, disclosure, copying, alteration, storage or distribution of, or reliance on, this message is strictly prohibited. No part may be reproduced, adapted or transmitted without the written permission of the owner. If you have received this transmission in error, or are not an authorised recipient, please immediately notify the sender by return email, delete this message and all copies from your e-mail system, and destroy any printed copies. Receipt by anyone other than the intended recipient should not be deemed a waiver of any privilege or protection. Thales Australia does not warrant or represent that this e-mail or any documents, files and previous e-mail messages attached are error or virus free. - -- 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. To unsubscribe from this group, send email to sqlalchemy+unsubscr...@googlegroups.com. For more options, visit this group at http://groups.google.com/group/sqlalchemy?hl=en. -- 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
[sqlalchemy] SqlAlchemy dynamic query generation
Hi All, I am trying to do query based on the user input as follows condition = 'and_(db.User.id == id' if user_name != ' ': condition += ',db.User.name == user_name' elif age != ' ': condition += ',db.User.age == age' elif place != ' ': condition += ',db.User.place == place' where = condition+')' result = db.User.filter(where).all() But Im getting error when i do this. Is there any way by which i can do this Thank you Sana -- 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. To unsubscribe from this group, send email to sqlalchemy+unsubscr...@googlegroups.com. For more options, visit this group at http://groups.google.com/group/sqlalchemy?hl=en.
RE: [sqlalchemy] SqlAlchemy dynamic query generation
You might get more help if you provide more details. What error are you getting? -Original Message- From: sqlalchemy@googlegroups.com [mailto:sqlalchemy@googlegroups.com] On Behalf Of Sana Sent: Thursday, 22 December 2011 2:50 AM To: sqlalchemy Subject: [sqlalchemy] SqlAlchemy dynamic query generation Hi All, I am trying to do query based on the user input as follows condition = 'and_(db.User.id == id' if user_name != ' ': condition += ',db.User.name == user_name' elif age != ' ': condition += ',db.User.age == age' elif place != ' ': condition += ',db.User.place == place' where = condition+')' result = db.User.filter(where).all() But Im getting error when i do this. Is there any way by which i can do this Thank you Sana -- 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. To unsubscribe from this group, send email to sqlalchemy+unsubscr...@googlegroups.com. For more options, visit this group at http://groups.google.com/group/sqlalchemy?hl=en. - DISCLAIMER: This e-mail transmission and any documents, files and previous e-mail messages attached to it are private and confidential. They may contain proprietary or copyright material or information that is subject to legal professional privilege. They are for the use of the intended recipient only. Any unauthorised viewing, use, disclosure, copying, alteration, storage or distribution of, or reliance on, this message is strictly prohibited. No part may be reproduced, adapted or transmitted without the written permission of the owner. If you have received this transmission in error, or are not an authorised recipient, please immediately notify the sender by return email, delete this message and all copies from your e-mail system, and destroy any printed copies. Receipt by anyone other than the intended recipient should not be deemed a waiver of any privilege or protection. Thales Australia does not warrant or represent that this e-mail or any documents, files and previous e-mail messages attached are error or virus free. - -- 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. To unsubscribe from this group, send email to sqlalchemy+unsubscr...@googlegroups.com. For more options, visit this group at http://groups.google.com/group/sqlalchemy?hl=en.
Re: [sqlalchemy] SqlAlchemy dynamic query generation
I am getting the following error ProgrammingError: (ProgrammingError) (1064, You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '== 1,db.User.age==23,d' at line 3) Is there any way by which i can generate dynamic query? Thank you Sana On Thu, Dec 22, 2011 at 4:40 AM, Jackson, Cameron cameron.jack...@thalesgroup.com.au wrote: You might get more help if you provide more details. What error are you getting? -Original Message- From: sqlalchemy@googlegroups.com [mailto:sqlalchemy@googlegroups.com] On Behalf Of Sana Sent: Thursday, 22 December 2011 2:50 AM To: sqlalchemy Subject: [sqlalchemy] SqlAlchemy dynamic query generation Hi All, I am trying to do query based on the user input as follows condition = 'and_(db.User.id == id' if user_name != ' ': condition += ',db.User.name == user_name' elif age != ' ': condition += ',db.User.age == age' elif place != ' ': condition += ',db.User.place == place' where = condition+')' result = db.User.filter(where).all() But Im getting error when i do this. Is there any way by which i can do this Thank you Sana -- 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. To unsubscribe from this group, send email to sqlalchemy+unsubscr...@googlegroups.com. For more options, visit this group at http://groups.google.com/group/sqlalchemy?hl=en. - DISCLAIMER: This e-mail transmission and any documents, files and previous e-mail messages attached to it are private and confidential. They may contain proprietary or copyright material or information that is subject to legal professional privilege. They are for the use of the intended recipient only. Any unauthorised viewing, use, disclosure, copying, alteration, storage or distribution of, or reliance on, this message is strictly prohibited. No part may be reproduced, adapted or transmitted without the written permission of the owner. If you have received this transmission in error, or are not an authorised recipient, please immediately notify the sender by return email, delete this message and all copies from your e-mail system, and destroy any printed copies. Receipt by anyone other than the intended recipient should not be deemed a waiver of any privilege or protection. Thales Australia does not warrant or represent that this e-mail or any documents, files and previous e-mail messages attached are error or virus free. - -- 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. To unsubscribe from this group, send email to sqlalchemy+unsubscr...@googlegroups.com. For more options, visit this group at http://groups.google.com/group/sqlalchemy?hl=en. -- 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. To unsubscribe from this group, send email to sqlalchemy+unsubscr...@googlegroups.com. For more options, visit this group at http://groups.google.com/group/sqlalchemy?hl=en.
Re: [sqlalchemy] SqlAlchemy dynamic query generation
You may want to look at the tutorial [1]. In the code you pasted you are assembling a string to pass to filter. While you can do that (but then it should be proper sql not python!), what you want to do is passing a python expression like db.User.age==age, or a combination of expressions combined using and_, or_, etc. [1] http://www.sqlalchemy.org/docs/orm/tutorial.html#common-filter-operators On Thu, Dec 22, 2011 at 6:34 AM, Sana klh sana.kl...@gmail.com wrote: I am getting the following error ProgrammingError: (ProgrammingError) (1064, You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '== 1,db.User.age==23,d' at line 3) Is there any way by which i can generate dynamic query? Thank you Sana On Thu, Dec 22, 2011 at 4:40 AM, Jackson, Cameron cameron.jack...@thalesgroup.com.au wrote: You might get more help if you provide more details. What error are you getting? -Original Message- From: sqlalchemy@googlegroups.com [mailto:sqlalchemy@googlegroups.com] On Behalf Of Sana Sent: Thursday, 22 December 2011 2:50 AM To: sqlalchemy Subject: [sqlalchemy] SqlAlchemy dynamic query generation Hi All, I am trying to do query based on the user input as follows condition = 'and_(db.User.id == id' if user_name != ' ': condition += ',db.User.name == user_name' elif age != ' ': condition += ',db.User.age == age' elif place != ' ': condition += ',db.User.place == place' where = condition+')' result = db.User.filter(where).all() But Im getting error when i do this. Is there any way by which i can do this Thank you Sana -- 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. To unsubscribe from this group, send email to sqlalchemy+unsubscr...@googlegroups.com. For more options, visit this group at http://groups.google.com/group/sqlalchemy?hl=en. - DISCLAIMER: This e-mail transmission and any documents, files and previous e-mail messages attached to it are private and confidential. They may contain proprietary or copyright material or information that is subject to legal professional privilege. They are for the use of the intended recipient only. Any unauthorised viewing, use, disclosure, copying, alteration, storage or distribution of, or reliance on, this message is strictly prohibited. No part may be reproduced, adapted or transmitted without the written permission of the owner. If you have received this transmission in error, or are not an authorised recipient, please immediately notify the sender by return email, delete this message and all copies from your e-mail system, and destroy any printed copies. Receipt by anyone other than the intended recipient should not be deemed a waiver of any privilege or protection. Thales Australia does not warrant or represent that this e-mail or any documents, files and previous e-mail messages attached are error or virus free. - -- 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. To unsubscribe from this group, send email to sqlalchemy+unsubscr...@googlegroups.com. For more options, visit this group at http://groups.google.com/group/sqlalchemy?hl=en. -- 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. To unsubscribe from this group, send email to sqlalchemy+unsubscr...@googlegroups.com. For more options, visit this group at http://groups.google.com/group/sqlalchemy?hl=en. -- 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. To unsubscribe from this group, send email to sqlalchemy+unsubscr...@googlegroups.com. For more options, visit this group at http://groups.google.com/group/sqlalchemy?hl=en.
Re: [sqlalchemy] SqlAlchemy dynamic query generation
the string you are generating must be proper sql. to test is you migth print it and try in directly against the db. but what you show us is for sure no valid sql. In sql the equality operator is not '==' but '='. robert On 22/12/11 06:34, Sana klh wrote: I am getting the following error ProgrammingError: (ProgrammingError) (1064, You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '== 1,db.User.age==23,d' at line 3) Is there any way by which i can generate dynamic query? Thank you Sana On Thu, Dec 22, 2011 at 4:40 AM, Jackson, Cameron cameron.jack...@thalesgroup.com.au mailto:cameron.jack...@thalesgroup.com.au wrote: You might get more help if you provide more details. What error are you getting? -Original Message- From: sqlalchemy@googlegroups.com mailto:sqlalchemy@googlegroups.com [mailto:sqlalchemy@googlegroups.com mailto:sqlalchemy@googlegroups.com] On Behalf Of Sana Sent: Thursday, 22 December 2011 2:50 AM To: sqlalchemy Subject: [sqlalchemy] SqlAlchemy dynamic query generation Hi All, I am trying to do query based on the user input as follows condition = 'and_(db.User.id http://db.User.id == id' if user_name != ' ': condition += ',db.User.name http://db.User.name == user_name' elif age != ' ': condition += ',db.User.age == age' elif place != ' ': condition += ',db.User.place == place' where = condition+')' result = db.User.filter(where).all() But Im getting error when i do this. Is there any way by which i can do this Thank you Sana -- 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 mailto:sqlalchemy@googlegroups.com. To unsubscribe from this group, send email to sqlalchemy+unsubscr...@googlegroups.com mailto:sqlalchemy%2bunsubscr...@googlegroups.com. For more options, visit this group at http://groups.google.com/group/sqlalchemy?hl=en. - DISCLAIMER: This e-mail transmission and any documents, files and previous e-mail messages attached to it are private and confidential. They may contain proprietary or copyright material or information that is subject to legal professional privilege. They are for the use of the intended recipient only. Any unauthorised viewing, use, disclosure, copying, alteration, storage or distribution of, or reliance on, this message is strictly prohibited. No part may be reproduced, adapted or transmitted without the written permission of the owner. If you have received this transmission in error, or are not an authorised recipient, please immediately notify the sender by return email, delete this message and all copies from your e-mail system, and destroy any printed copies. Receipt by anyone other than the intended recipient should not be deemed a waiver of any privilege or protection. Thales Australia does not warrant or represent that this e-mail or any documents, files and previous e-mail messages attached are error or virus free. - -- 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 mailto:sqlalchemy@googlegroups.com. To unsubscribe from this group, send email to sqlalchemy+unsubscr...@googlegroups.com mailto:sqlalchemy%2bunsubscr...@googlegroups.com. For more options, visit this group at http://groups.google.com/group/sqlalchemy?hl=en. -- 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. To unsubscribe from this group, send email to sqlalchemy+unsubscr...@googlegroups.com. For more options, visit this group at http://groups.google.com/group/sqlalchemy?hl=en. -- 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. To unsubscribe from this group, send email to sqlalchemy+unsubscr...@googlegroups.com. For more options, visit this group at http://groups.google.com/group/sqlalchemy?hl=en.