SQCloudVMClose
bool SQCloudVMClose (SQCloudVM *vm);
Description
Frees the storage associated with a SQCloudVM. The application must finalize every compiled statement in order to avoid resource leaks. This function resembles the sqlite3_finalize SQLite API.
Parameters
- vm: A valid VM obtained by SQCloudVMCompile.
Return value
If the VM is successfully freed without any errors, the function will return true
. If an error occurs during the freeing process, the function will return false
.
Example
int main (int argc, const char * argv[]) {
// setup config
SQCloudConfig config = {0};
config.username = "myusername";
config.password = "mypassword"
SQCloudConnection *conn = SQCloudConnect("myproject.sqlite.cloud", SQCLOUD_DEFAULT_PORT, &config);
if (SQCloudIsError(conn)) {
printf("ERROR connecting: %s (%d)\n", SQCloudErrorMsg(conn), SQCloudErrorCode(conn));
return -1;
} else {
printf("Connection to host OK...\n\n");
}
// choose a database first
SQCloudResult *r = SQCloudExec(conn, "USE DATABASE mydatabase.sqlite;");
// compile the INSERT SQL statement
SQCloudVM *vm = SQCloudVMCompile(conn, "INSERT INTO table1 (col1) VALUES ('Hello World');", -1, NULL);
// execute the previously compiled statement
SQCloudResult *type = SQCloudVMStep(vm);
// ...
// free resources associated with the VM
bool rc = SQCloudVMClose(vm);
}