{"action":"created","issue":{"url":"https://api.github.com/repos/rbock/sqlpp11/issues/206","repository_url":"https://api.github.com/repos/rbock/sqlpp11","labels_url":"https://api.github.com/repos/rbock/sqlpp11/issues/206/labels{/name}","comments_url":"https://api.github.com/repos/rbock/sqlpp11/issues/206/comments","events_url":"https://api.github.com/repos/rbock/sqlpp11/issues/206/events","html_url":"https://github.com/rbock/sqlpp11/issues/206","id":285422836,"number":206,"title":"Questions reg. Android/Custom SQLite functions","user":{"login":"freekee1","id":31277958,"avatar_url":"https://avatars0.githubusercontent.com/u/31277958?v=4","gravatar_id":"","url":"https://api.github.com/users/freekee1","html_url":"https://github.com/freekee1","followers_url":"https://api.github.com/users/freekee1/followers","following_url":"https://api.github.com/users/freekee1/following{/other_user}","gists_url":"https://api.github.com/users/freekee1/gists{/gist_id}","starred_url":"https://api.github.com/users/freekee1/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/freekee1/subscriptions","organizations_url":"https://api.github.com/users/freekee1/orgs","repos_url":"https://api.github.com/users/freekee1/repos","events_url":"https://api.github.com/users/freekee1/events{/privacy}","received_events_url":"https://api.github.com/users/freekee1/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"assignees":[],"milestone":null,"comments":3,"created_at":"2018-01-02T12:53:15Z","updated_at":"2018-02-01T14:52:27Z","closed_at":null,"author_association":"NONE","body":"Hello,\r\n\r\nfirst I have to say, this is a really great project. Thanks for making this lib!\r\nI'm currently evaluating if it would be suitable/feasible for use in a specific project. (Context: C++ project using Qt for multiple mobile platforms.)\r\nAs I couldn't find answers to some questions, I'm hoping to get some answers here:\r\n1. Has the library be used on Android and iOS before (or does it work there at all)? Are there maybe any resources regarding building/using it on these platforms? Esp. in combination with the SQLite3 connector and SQLCipher (all of that would need to work).\r\n\r\n2. Is it possible (i.e. are there facilities) to introduce/use custom SQLite functions (registered with sqlite3_create_function) in SQL statements (i.e. using sqlpp11, for example in a select(...) call)? From looking at the code, for using them it seems one could implement a function like in sqlpp11/functions.h. Is that all or will more code have to be added in other places?\r\n\r\nThank you very much in advance for any help! If I overlooked some information, please just point me to it, I'll gladly take any bone thrown at me. ;-)\r\n\r\n// EDIT: Another question just came up: May it be possible to grab \"only\" the composed SQL statement as a string, to then pass it on manually (e.g. to Qt's SQL framework)?\r\n\r\nKind regards."},"comment":{"url":"https://api.github.com/repos/rbock/sqlpp11/issues/comments/362289128","html_url":"https://github.com/rbock/sqlpp11/issues/206#issuecomment-362289128","issue_url":"https://api.github.com/repos/rbock/sqlpp11/issues/206","id":362289128,"user":{"login":"freekee1","id":31277958,"avatar_url":"https://avatars0.githubusercontent.com/u/31277958?v=4","gravatar_id":"","url":"https://api.github.com/users/freekee1","html_url":"https://github.com/freekee1","followers_url":"https://api.github.com/users/freekee1/followers","following_url":"https://api.github.com/users/freekee1/following{/other_user}","gists_url":"https://api.github.com/users/freekee1/gists{/gist_id}","starred_url":"https://api.github.com/users/freekee1/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/freekee1/subscriptions","organizations_url":"https://api.github.com/users/freekee1/orgs","repos_url":"https://api.github.com/users/freekee1/repos","events_url":"https://api.github.com/users/freekee1/events{/privacy}","received_events_url":"https://api.github.com/users/freekee1/received_events","type":"User","site_admin":false},"created_at":"2018-02-01T14:52:27Z","updated_at":"2018-02-01T14:52:27Z","author_association":"NONE","body":"Had to work on a few urgent things first, back on this one. :-)\r\nNow I've successfully built the SQLite3-connector with SQLCipher support. The tests run fine, except for the floating point one, where a \"0\" value seems to end up in the database instead of \"inf\".\r\n\r\nBut ... when building our own application (with QMake), linking against \"sqlcipher\" and \"sqlpp11-connector-sqlite3\", there are several \"unresolved reference\" errors pointing to symbols which, according to \"dumpbin /SYMBOLS\", are actually not present in \"libsqlpp11-connector-sqlite3.a\". (\"sqlite3_errmsg\", \"sqlite3_last_insert_row_id\", and some more).\r\nSeems strange ... from what I see in the CMakeLists.txt, the tests aren't linked against anything else.\r\nAny ideas? I'm investigating, very likely a stupid mistake of mine, but I couldn't seem to find the cause yet.\r\n\r\n(Btw., I once had our QMake-based app built and running with sqlpp11 and SQLite3, but without SQLCipher, and directly having the amalgamation sources (sqlite3.c) as part of the project.)\r\n\r\nThanks a lot in advance!"}}
{"actor":{"display_login":"freekee1"}}