Icon based on "Database free icon" by smashicons from www.flaticon.com and "ready" by Arbcom from https://commons.wikimedia.org
Example code
#include "cdbc.h"
int main(int argc, char **argv) {
CDBC cdbc;
CDBC_QUERY q;
CDBC_RESULT res;
char *row_value;
int id = 1;
// initialize CDBC and connect
cdbc = cdbc_init();
cdbc_connect(cdbc, "MySQL", "DATABASE=mydb", "127.0.0.1", 3306, "username", "password");
// prepare SQL query
q = cdbc_prepare(cdbc, "SELECT * FROM table WHERE id = ?");
// bind input parameters
cdbc_bind_param(q, 1, CDBC_C_LONG, id, sizeof(id));
// execute SQL query
cdbc_execute(q);
// get pointer to row in resultset
row_value = cdbc_c_name(q, "row_name");
// fetch data
res = cdbc_fetch(q);
while (res) {
printf("%s\n", row_value);
res = cdbc_fetch(q);
}
// clean up
cdbc_finish(q);
cdbc_disconnect(cdbc);
cdbc_cleanup(cdbc);
return 0;
}
Have a look at https://github.com/fnordahl/cdbc/blob/master/tests/test.c for more a more complete example with error handling etc.
The functional tests (https://github.com/fnordahl/cdbc/blob/master/.travis.yml) for this repository contain some hints about consuming the library from your snap: https://github.com/fnordahl/cdbc/blob/master/tests/snap/snapcraft.yaml
Thank you for your report. Information you provided will help us investigate further.
There was an error while sending your report. Please try again later.
You are about to open
Do you wish to proceed?
Snaps are applications packaged with all their dependencies to run on all popular Linux distributions from a single build. They update automatically and roll back gracefully.
Snaps are discoverable and installable from the Snap Store, an app store with an audience of millions.
On a Raspberry Pi running the latest version of Raspbian snap can be installed directly from the command line:
sudo apt update
sudo apt install snapd
You will also need to reboot your device:
sudo reboot
After this, install the snapd snap in order to get the latest snapd:
sudo snap install snapd
To install cdbc, simply use the following command:
sudo snap install cdbc
Browse and find snaps from the convenience of your desktop using the snap store snap.
Interested to find out more about snaps? Want to publish your own application? Visit snapcraft.io now.
