In message <gt3fv1$1ac...@news.ett.com.ua>, Paul Hemans wrote:
> One problem though that I didn't mention in my original
> posting was that the replication may only require updating one or more
> fields, that is a problem with a generating a single SQL statement to
> cover all requests.
That's not a big issue. Assume the field names and corresponding values are
coming from a Python dict, eg
FieldValues = \
{
"field1" : ... value1 ...;
"field2" : ... value2 ...;
}
then you can construct an SQL statement on the fly with something like
sqlcmd = \
(
"insert into my_table set "
+
", ".join
(
"%s = %s" % (k, SQLString(FieldValues[k]))
for k in FieldValues.keys()
)
)
where SQLString is as defined at
<http://codecodex.com/wiki/index.php?title=Useful_MySQL_Routines#Quoting>.
--
http://mail.python.org/mailman/listinfo/python-list
