Hi,
Sorry for asking this, but due to the differences between HDBC.SQLite and your Database.SQLite, what I need to do kind of falls in between the capabilities of the two modules.
Would it be possible, do you think, to add something like an
execParamStatement' :: SQLiteResult a => SQLiteHandle -> String -> [Value] -> IO (Either String [[Row a]])
function that substitute parameters in order (like HDBC execute)? I need to construct dynamic queries, and the steps involved in generating and splicing randomized labels to make it all work with execParamStatement does not seem very unnatural for this kind of application. But, if you need regexp matching too in the SQLite queries, then you also cannot use HDBC, so.. Please consider it.
Hi,
Sorry for asking this, but due to the differences between HDBC.SQLite and your Database.SQLite, what I need to do kind of falls in between the capabilities of the two modules.
Would it be possible, do you think, to add something like an
function that substitute parameters in order (like HDBC execute)? I need to construct dynamic queries, and the steps involved in generating and splicing randomized labels to make it all work with
execParamStatementdoes not seem very unnatural for this kind of application. But, if you need regexp matching too in the SQLite queries, then you also cannot use HDBC, so.. Please consider it.