 |  |  |  |  |  |  |  |
Python tuples and Sql query
 |
Hello all,
Is there any algorithm to convert a python tuple to MySql query.
Ex:
('*','name','sliver')
should convert to
select [Pri_Key] from [All Tables] where 'name' = 'sliver';
I have been able to do so ... but my algorithm looks very ugly and have to process everything bit by bit.
The query becomes even more complex when i have nested tuples.
Any Ideas?
Is there any algorithm to convert a python tuple to MySql query.
Ex:
('*','name','sliver')
should convert to
select [Pri_Key] from [All Tables] where 'name' = 'sliver';
I have been able to do so ... but my algorithm looks very ugly and have to process everything bit by bit.
The query becomes even more complex when i have nested tuples.
Any Ideas?
•
•
Join Date: Mar 2006
Posts: 18
Reputation: 
Solved Threads: 0
Newbie Poster
hi,
as i got you , i think the better way you can use is :
and then you can create your own method to run sql
-VS
as i got you , i think the better way you can use is :
Python Syntax (Toggle Plain Text)
-VS
•
•
•
•
Originally Posted by sliver_752 
Hello all,
Is there any algorithm to convert a python tuple to MySql query.
Ex:
('*','name','sliver')
should convert to
select [Pri_Key] from [All Tables] where 'name' = 'sliver';
I have been able to do so ... but my algorithm looks very ugly and have to process everything bit by bit.
The query becomes even more complex when i have nested tuples.
Any Ideas?
Best wishes,
Vivek Sharma
Zope/Python Developer
Vivek Sharma
Zope/Python Developer
|
Similar Threads
- sql query problem with MS Access and C# (C#)
- Urgent Help with SQL Query (MySQL)
- C# VS 2005 - SQL Query Parameters to an ODBC DataSource (C#)
- sql query updating problem (Visual Basic 4 / 5 / 6)
- Javascript array from sql query (JSP)
- Please help me out with MySQL query (MySQL)
- PHP/SQL query help (PHP)
- Retreiving variables from a sql query into a form (PHP)
Other Threads in the Python Forum
- Previous Thread: Stuck in GUI
- Next Thread: Find a word in a file
| Thread Tools | Search this Thread |
You need to join our community in order to build your list of favorite forums. You can visit the forum index for a listing of all forums.
Related Forum Features
Latest Python Posts
- Today's Posts
- Unanswered Threads
abrupt accessdenied anti apache application approximation argv array beginner book builtin calculator change converter countpasswordentry curved dan08 dictionaries dictionary dynamic edit enter examples file float format function gui heads homework import inches input java keyboard lapse launcher library line lines linux list lists loop microphone mouse movingimageswithpygame mysqlquery newb number numbers numeric output parameters parsing path phonebook plugin port prime programming projects py2exe pygame pyopengl python random recursion redirect remote reverse scrolledtext session simple software sprite statictext statistics string strings syntax table terminal text textarea threading time tlapse trick tuple tutorial twoup ubuntu unicode unit urllib urllib2 variable wordgame wxpython
