MonetDB: default - add missing interface
Changeset: c66770d9f246 for MonetDB URL: https://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=c66770d9f246 Modified Files: monetdb5/modules/mal/batcalc.c Branch: default Log Message: add missing interface diffs (19 lines): diff --git a/monetdb5/modules/mal/batcalc.c b/monetdb5/modules/mal/batcalc.c --- a/monetdb5/modules/mal/batcalc.c +++ b/monetdb5/modules/mal/batcalc.c @@ -2562,6 +2562,15 @@ static mel_func batcalc_init_funcs[] = { pattern("batcalc", "between", CMDbatBETWEEN, false, "B between V1 and V2 (or vice versa)", args(1,9, batarg("",bit),batargany("b",1),argany("v1",1),argany("v2",1),arg("sym",bit),arg("linc",bit),arg("hinc",bit),arg("nils_false",bit),arg("anti",bit))), pattern("batcalc", "between", CMDbatBETWEEN, false, "B between V1 and V2 (or vice versa) with candidate list", args(1,10, batarg("",bit),batargany("b",1),argany("v1",1),argany("v2",1),batarg("s",oid),arg("sym",bit),arg("linc",bit),arg("hinc",bit),arg("nils_false",bit),arg("anti",bit))), + pattern("batcalc", "between", CMDbatBETWEEN, false, "B between V1 and V2 (or vice versa)", args(1,10, batarg("",bit),batargany("b",1),batargany("v1",1),batargany("v2",1),batarg("ce",bit),arg("sym",bit),arg("linc",bit),arg("hinc",bit),arg("nils_false",bit),arg("anti",bit))), + pattern("batcalc", "between", CMDbatBETWEEN, false, "B between V1 and V2 (or vice versa) with candidate list", args(1,13, batarg("",bit),batargany("b",1),batargany("v1",1),batargany("v2",1),batarg("s",oid),batarg("s1",oid),batarg("s2",oid),batarg("ce",bit),arg("sym",bit),arg("linc",bit),arg("hinc",bit),arg("nils_false",bit),arg("anti",bit))), + pattern("batcalc", "between", CMDbatBETWEEN, false, "B between V1 and V2 (or vice versa)", args(1,10, batarg("",bit),batargany("b",1),batargany("v1",1),argany("v2",1),batarg("ce",bit),arg("sym",bit),arg("linc",bit),arg("hinc",bit),arg("nils_false",bit),arg("anti",bit))), + pattern("batcalc", "between", CMDbatBETWEEN, false, "B between V1 and V2 (or vice versa) with candidate list", args(1,12, batarg("",bit),batargany("b",1),batargany("v1",1),argany("v2",1),batarg("s",oid),batarg("s1",oid),batarg("ce",bit),arg("sym",bit),arg("linc",bit),arg("hinc",bit),arg("nils_false",bit),arg("anti",bit))), + pattern("batcalc", "between", CMDbatBETWEEN, false, "B between V1 and V2 (or vice versa)", args(1,10, batarg("",bit),batargany("b",1),argany("v1",1),batargany("v2",1),batarg("ce",bit),arg("sym",bit),arg("linc",bit),arg("hinc",bit),arg("nils_false",bit),arg("anti",bit))), + pattern("batcalc", "between", CMDbatBETWEEN, false, "B between V1 and V2 (or vice versa) with candidate list", args(1,12, batarg("",bit),batargany("b",1),argany("v1",1),batargany("v2",1),batarg("s",oid),batarg("s2",oid),batarg("ce",bit),arg("sym",bit),arg("linc",bit),arg("hinc",bit),arg("nils_false",bit),arg("anti",bit))), + pattern("batcalc", "between", CMDbatBETWEEN, false, "B between V1 and V2 (or vice versa)", args(1,10, batarg("",bit),batargany("b",1),argany("v1",1),argany("v2",1),batarg("ce",bit),arg("sym",bit),arg("linc",bit),arg("hinc",bit),arg("nils_false",bit),arg("anti",bit))), + pattern("batcalc", "between", CMDbatBETWEEN, false, "B between V1 and V2 (or vice versa) with candidate list", args(1,11, batarg("",bit),batargany("b",1),argany("v1",1),argany("v2",1),batarg("s",oid),batarg("ce",bit),arg("sym",bit),arg("linc",bit),arg("hinc",bit),arg("nils_false",bit),arg("anti",bit))), + pattern("aggr", "avg", CMDcalcavg, false, "Gives the avg of all tail values", args(1,2, arg("",dbl),batargany("b",2))), pattern("aggr", "avg", CMDcalcavg, false, "Gives the avg of all tail values", args(1,3, arg("",dbl),batargany("b",2),arg("scale",int))), ___ checkin-list mailing list checkin-list@monetdb.org https://www.monetdb.org/mailman/listinfo/checkin-list
MonetDB: default - Add missing interface, errors are kept with t...
Changeset: 883e9847872a for MonetDB URL: https://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=883e9847872a Modified Files: documentation/embedded/monetdbe_api.rst Branch: default Log Message: Add missing interface, errors are kept with the connection and removed at the end of the connection or the start of its next use diffs (128 lines): diff --git a/documentation/embedded/monetdbe_api.rst b/documentation/embedded/monetdbe_api.rst --- a/documentation/embedded/monetdbe_api.rst +++ b/documentation/embedded/monetdbe_api.rst @@ -21,10 +21,10 @@ The API wraps the internal data types to |float | float| |double | double| |char * | str| -|monetdb_data_blob | blob| -|monetdb_data_date | date| -|monetdb_data_time | time| -|monetdb_data_timestamp | timestamp| +|monetdbe_data_blob | blob| +|monetdbe_data_date | date| +|monetdbe_data_time | time| +|monetdbe_data_timestamp | timestamp| Data Types -- @@ -49,29 +49,29 @@ Connection and server options A simplified wrapper around the official MAPI protocol. It allows for development of the application using a local directory and simply replacing the startup call with a mapi_connect. -.. c:char* monetdb_connect(monetdb_connection *conn); +.. c:char* monetdbe_connect(monetdbe_connection *conn); Create a separate connection channel with the database. Don't use it in parallel threads to submit queries, because they would become mangled and even could hang your application. [TODO protect against it] -.. c:char* monetdb_disconnect(monetdb_connection *conn); +.. c:char* monetdbe_disconnect(monetdbe_connection *conn); From here on the connection can not be used anymore to pass queries or any pending result set is cleaned up. -.. c:char* monetdb_shutdown(void); +.. c:char* monetdbe_shutdown(void); Force a shutdown of the database server. This will not shutdown your application, you can simply restart the database server. However, be aware that the content of an ':inmemory:' database is discarded at shutdown. Transaction management - -.. c: char* monetdb_get_autocommit(monetdb_connection conn, int* result); +.. c: char* monetdbe_get_autocommit(monetdbe_connection conn, int* result); Retrieve the current transaction mode, i.e. 'autocommit' or 'no-autocommit' [TODO ?] -.. c:char *monetdb_set_autocommit(monetdb_connection conn, int value); +.. c:char *monetdbe_set_autocommit(monetdbe_connection conn, int value); Set the auto-commit mode to either true or false. An error is raised when you attempt to ...?? @@ -79,25 +79,25 @@ Transaction management Query execution __ -.. c:char* monetdb_query(monetdb_connection conn, char* query, monetdb_result** result, monetdb_cnt* affected_rows) +.. c:char* monetdbe_query(monetdbe_connection conn, char* query, monetdbe_result** result, monetdbe_cnt* affected_rows) The main query interface to the database kernel. The query should obey the MonetDB syntax. It returns a nested structure with the result set in binary form and the number of rows in the result set or affected by an update. -.. c:char* monetdb_prepare(monetdb_connection conn, char *query, monetdb_statement **stmt); +.. c:char* monetdbe_prepare(monetdbe_connection conn, char *query, monetdbe_statement **stmt); Sent a query to the database server and prepare an execution plan. Its arguments should be passed when called. -.. c:char* monetdb_bind(monetdb_statement *stmt, void *data, size_t parameter_nr); +.. c:char* monetdbe_bind(monetdbe_statement *stmt, void *data, size_t parameter_nr); Bind a local variable to a parameter in the prepared query structure. [TODO by pointer, do do you take a copy??]] -.. c:char* monetdb_execute(monetdb_statement *stmt, monetdb_result **result, monetdb_cnt* affected_rows); +.. c:char* monetdbe_execute(monetdbe_statement *stmt, monetdbe_result **result, monetdbe_cnt* affected_rows); When all parameters are bound, the statement is executed by the database server. An error is thrown if the number of parameters does not match. -.. c: char* monetdb_cleanup_statement(monetdb_connection conn, monetdb_statement *stmt); +.. c: char* monetdbe_cleanup_statement(monetdbe_connection conn, monetdbe_statement *stmt); Remove the execution pland and all bound variables. @@ -105,14 +105,14 @@ Query execution Database insert -- -.. c: char* monetdb_append(monetdb_connection conn, const char* schema, const char* table, monetdb_column **input, size_t column_count); +.. c: char* monetdbe_append(monetdbe_connection conn, const char* schema, const char* table, monetdbe_column **input, size_t column_count); The result set obtained from any query can be assigned to a new database table. [TODO which schema...] Result set -- -.. c: char* monetdb_result_fetch(monetdb_connection conn, monetdb_result *mres,