We would like to use the library to insert data into our database, like so:
Execute Sql String INSERT INTO user (firstname, lastname) VALUES ('${first_name}', '${last_name}')
The problem is that this doesn't work for names like Charles d’Artagnan. It would be nice to have a parametrized SQL string instead:
Execute Sql String INSERT INTO user (firstname, lastname) VALUES (%s, %s) ${first_name} ${last_name}
It looks like the method execute_sql_string() could be used as a base for a new method execute_parameterized_sql_string().
We would like to use the library to insert data into our database, like so:
The problem is that this doesn't work for names like
Charles d’Artagnan. It would be nice to have a parametrized SQL string instead:It looks like the method
execute_sql_string()could be used as a base for a new methodexecute_parameterized_sql_string().