newbie python mysql query

[alien12]

Hi, I am new to both python and mysql and have a problem.

c.execute('load data infile %s into table Thursday fields terminated by ",";',csv_file)
 

For some reason (and I've tried a lot !!) I am unable to figure out how to use a variable where "Thursday" is, this line works as is and has no problem with the csv_file variable. Any help would be much appreciated.

[bartonc]

Hi, I am new to both python and mysql and have a problem.

c.execute('load data infile %s into table Thursday fields terminated by ",";',csv_file)
 

For some reason (and I've tried a lot !!) I am unable to figure out how to use a variable where "Thursday" is, this line works as is and has no problem with the csv_file variable. Any help would be much appreciated.

>>> strVar = 'Thursday'
>>> print "today is %s" %strVar
today is Thursday
>>> 

Hope that's what you are looking for.

[alien12]

>>> strVar = 'Thursday'
>>> print "today is %s" %strVar
today is Thursday
>>> 

Hope that's what you are looking for.

Thank you for the quick reply.

I need it to work in the line:

c.execute('load data infile %s into table Thursday fields terminated by ",";',csv_file)

but no matter what I try eg

c.execute('load data infile %s into table %s fields terminated by ",";',csv_file,%day)

it doesn't work

[bartonc]

Thank you for the quick reply.

I need it to work in the line:

c.execute('load data infile %s into table Thursday fields terminated by ",";',csv_file)

but no matter what I try eg

c.execute('load data infile %s into table %s fields terminated by ",";',csv_file,%day)

it doesn't work

The number of formats ('%') need to match the number of arguments. For multiple arguments the line would look like:

"Here is some %s with a number which equals %d" %('text', 5)

It would be very helpful if you post more that just one line.

And note the use of CODE tags - instructions are on the right hand side while you are replying.

Thanks.

[alien12]

The number of formats ('%') need to match the number of arguments. For multiple arguments the line would look like:

"Here is some %s with a number which equals %d" %('text', 5)

It would be very helpful if you post more that just one line.

And note the use of CODE tags - instructions are on the right hand side while you are replying.

Thanks.

here are some of the variables and the function

 
# find what days today and tomorrow are
now=datetime.datetime.now()
add_one_day=datetime.timedelta(days=1)
today=datetime.datetime.now().strftime("%A")
tomorrow=(now+add_one_day).strftime("%A")
 
# loads csv files from above into db
 
def sql_load_data():
    try:
        db = MySQLdb.connect(host=host, user=user, passwd=passwd ,db=db_name)
        c = db.cursor()
    except:
        logger.critical("unable to access database")
        sys.exit()
    for csv_file in csv_files_r:
        csv_file=csv_file.strip("\n")
        try:
             c.execute('load data infile %s into table today fields terminated by ",";',csv_file)
        except TypeError:
             logger.warning("got type error")
             continue
        except csv.Error:
             logger.warning("bad csv record, skipping ....")
             continue
    c.close()
    db.commit()
    db.close()
 
 

I need to pass in the variable "today" as the table name eg Thursday
because I need it to load the data into the table named after the current day.

[bartonc]

here are some of the variables and the function

 
# find what days today and tomorrow are
now=datetime.datetime.now()
add_one_day=datetime.timedelta(days=1)
today=datetime.datetime.now().strftime("%A")
tomorrow=(now+add_one_day).strftime("%A")
 
# loads csv files from above into db
 
def sql_load_data():
    try:
        db = MySQLdb.connect(host=host, user=user, passwd=passwd ,db=db_name)
        c = db.cursor()
    except:
        logger.critical("unable to access database")
        sys.exit()
    for csv_file in csv_files_r:
        csv_file=csv_file.strip("\n")
        try:
             c.execute('load data infile %s into table today fields terminated by ",";',csv_file)
        except TypeError:
             logger.warning("got type error")
             continue
        except csv.Error:
             logger.warning("bad csv record, skipping ....")
             continue
    c.close()
    db.commit()
    db.close()
 
 

I need to pass in the variable "today" as the table name eg Thursday
because I need it to load the data into the table named after the current day.

#
             c.execute('load data infile %s into table today fields terminated by ",";' %today, csv_file)  # the var goes just after the closing quote

Sorry that I didn't see that in isolation. Context makes a big difference.

Check out the Articles section for some cool GUI examples using the same tools that you are using.

[alien12]

#
             c.execute('load data infile %s into table today fields terminated by ",";' %today, csv_file)  # the var goes just after the closing quote

Sorry that I didn't see that in isolation. Context makes a big difference.

Check out the Articles section for some cool GUI examples using the same tools that you are using.

Thanks for your help. I managed to fudge it by.

c.execute('load data infile %s into table ' + today + ' fields terminated by ",";',(csv_file))
 

:-)