definition: |
select :: String -> [SQLValue] -> [SQLType] -> DBAction [[SQLValue]] select query values types = executeRaw query (map valueToString values) >+= \a -> returnDB (convertValues a types) |
demand: |
no demanded arguments |
deterministic: |
deterministic operation |
documentation: |
----------------------------------------------------------------------------- --- Execute a query where the result of the execution is returned. --- @param query - The SQL Query as a String, might have '?' as placeholder --- @param values - A list of SQLValues that replace the '?' placeholder --- @param types - A list of SQLTypes that describe the types of the --- result-tables (e.g. "select * from exampletable" and [SQLTypeInt, --- SQLTypeFloat, SQLTypeString] --- when the table exampletable has three columns of type Int, Float and --- String.) The order of the list has to be the same as the order of the --- columns in the table --- @param conn - A Connection to a database where the query will be executed --- @return A Result with a list of SQLValues which types correspond to --- the SQLType-List that was given as a parameter if the execution was --- successful, otherwise an Error |
failfree: |
<FAILING> |
indeterministic: |
referentially transparent operation |
infix: |
no fixity defined |
iotype: |
{(_,_,_) |-> _} |
name: |
select |
precedence: |
no precedence defined |
result-values: |
_ |
signature: |
String -> [SQLValue] -> [SQLType] -> DBAction [[SQLValue]] |
solution-complete: |
operation might suspend on free variables |
terminating: |
possibly non-terminating |
totally-defined: |
possibly non-reducible on same data term |