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
You are about to open
Do you wish to proceed?
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.
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.
If you’re running Kubuntu 16.04 LTS (Xenial Xerus) or later, including Kubuntu 18.04 LTS (Bionic Beaver) and Kubuntu 18.10 (Cosmic Cuttlefish), you don’t need to do anything. Snap is already installed and ready to go.
Versions of Kubuntu between 14.04 LTS (Trusty Tahr) and 15.10 (Wily Werewolf) don’t include snap by default, but snap can be installed from the command line as follows:
sudo apt update
sudo apt 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.