Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]

Groups > comp.lang.python > #46361 > unrolled thread

MySQL dymanic query in Python

Back to article view | Back to comp.lang.python

Contents

  MySQL dymanic query in Python RAHUL RAJ <omrahulrajcse@gmail.com> - 2013-05-29 02:09 -0700
    Re: MySQL dymanic query in Python Fábio Santos <fabiosantosart@gmail.com> - 2013-05-29 11:02 +0100
      Re: MySQL dymanic query in Python RAHUL RAJ <omrahulrajcse@gmail.com> - 2013-05-30 05:22 -0700

#46361 — MySQL dymanic query in Python

Can anyone tell me the proper way in which I can execute dynamic MySQL queries in Python?

I want to do dynamic queries for both CREATE and INSERT statement.

Here is my attempted code:


sql="create table %s (%%s, %%s, %%s ... )" % (tablename,''.join(fields)+' '.join(types))
cur.execute(sql)  


where 'field' is the fieldnames stored in a list and 'types' are the fieldtypes stored in a list. 

[toc] | [next] | [standalone]

#46362

[Multipart message — attachments visible in raw view] — view raw

On 29 May 2013 10:13, "RAHUL RAJ" <omrahulrajcse@gmail.com> wrote:
>
> Can anyone tell me the proper way in which I can execute dynamic MySQL
queries in Python?
>
> I want to do dynamic queries for both CREATE and INSERT statement.
>
> Here is my attempted code:
>
>
> sql="create table %s (%%s, %%s, %%s ... )" % (tablename,''.join(fields)+'
'.join(types))
> cur.execute(sql)
>
>
> where 'field' is the fieldnames stored in a list and 'types' are the
fieldtypes stored in a list.

You need to join the fields and the field types. Use zip().

Then join with commas.

fields_and_types = ['%s %s' % (field, type) for field, type in zip(fields,
types)]

what_goes_between_the_parens = ', '.join(fields_and_types)

sql = 'create table %s (%s)' % (tablename, what_goes_between_the_parens)

See where that gets you.

[toc] | [prev] | [next] | [standalone]

#46467

On Wednesday, May 29, 2013 3:32:51 PM UTC+5:30, Fábio Santos wrote:
> On 29 May 2013 10:13, "RAHUL RAJ" <omrahu...@gmail.com> wrote:
> 
> >
> 
> > Can anyone tell me the proper way in which I can execute dynamic MySQL queries in Python?
> 
> >
> 
> > I want to do dynamic queries for both CREATE and INSERT statement.
> 
> >
> 
> > Here is my attempted code:
> 
> >
> 
> >
> 
> > sql="create table %s (%%s, %%s, %%s ... )" % (tablename,''.join(fields)+' '.join(types))
> 
> > cur.execute(sql)
> 
> >
> 
> >
> 
> > where 'field' is the fieldnames stored in a list and 'types' are the fieldtypes stored in a list.
> 
> You need to join the fields and the field types. Use zip().
> 
> Then join with commas.
> 
> fields_and_types = ['%s %s' % (field, type) for field, type in zip(fields, types)]
> 
> what_goes_between_the_parens = ', '.join(fields_and_types)
> 
> sql = 'create table %s (%s)' % (tablename, what_goes_between_the_parens)
> 
> See where that gets you.

Fantastic! It worked, Thanks :)

[toc] | [prev] | [standalone]

Back to top | Article view | comp.lang.python

csiph-web