// Created by ‎ ‎ /* Hey guys. We can pass SQL commands in Sololearn Playground, using sqlite3. author: Paul Caron license: Free Public Domain feel free to use, modify and share */ #include #include using namespace std; // __libc function declarations need extern "C" to prevent C++ name mangling extern "C" void* __libc_dlopen_mode(const char*, int); extern "C" void* __libc_dlsym(void*, const char*); extern "C" int __libc_dlclose(void*); // a helper macro to load the functions // has to be changed if the functions are macros themselves (like in gmp) #define FUNCTION(NAME) decltype(&::NAME) NAME = (decltype(&::NAME))__libc_dlsym(handle, #NAME); // gathering all the module functions in a struct struct Sqlite3 { private: void* handle = __libc_dlopen_mode("/usr/lib/x86_64-linux-gnu/libsqlite3.so", 1); public: FUNCTION(sqlite3_open); FUNCTION(sqlite3_errmsg); FUNCTION(sqlite3_exec); FUNCTION(sqlite3_free); FUNCTION(sqlite3_close); ~Sqlite3() { __libc_dlclose(handle); } }; int main(){ // Loading the module Sqlite3 m; sqlite3 *db; char *errMsg = nullptr; int rc; const char *sql1 = "CREATE TABLE PILLCO(" "ID INTEGER PRIMARY KEY NOT NULL, " "NAME TEXT," "AGE INTEGER," "ADDRESS CHAR(50)," "SALARY REAL );"; const char *sql2 = "INSERT INTO PILLCO" " (NAME, AGE, ADDRESS, SALARY) " "VALUES (\"ChillPill\", 36, \"Canada\", 123456.78);"; const char *sql4 = "INSERT INTO PILLCO" " (NAME, AGE, ADDRESS, SALARY) " "VALUES (\"PillChill\", 63, \"Adanac\", 876543.21);"; const char *sql3 = "SELECT * FROM PILLCO;"; // callback for queries auto callback=[](void *data, int argc, char **argv, char **colName)->int{ cout<

sqlite3 dynamic cpp