From e04b08fdf55e6e964f6fc2198b882d07ee463456 Mon Sep 17 00:00:00 2001 From: Robin Krahl Date: Sun, 19 Jul 2015 00:36:06 +0200 Subject: Update README.md. --- README.md | 47 +++++++++++++++++++++++++++++++++++++++++++++++ 1 file changed, 47 insertions(+) diff --git a/README.md b/README.md index 96c38e8..43f06fb 100644 --- a/README.md +++ b/README.md @@ -2,3 +2,50 @@ sqlitepp ======== C++ binding for the SQLite library + +Dependencies +------------ + + - compile dependencies + - CMake 3.0 (or later) + - libgtest + - runtime dependencies + - libsqlite3 + +Example +------- + +**test.cpp** + +```C++ +#include +#include +#include + +int main(int argc, char** argv) { + sqlitepp::Database database("/path/to/database.sqlite"); + database.execute("CREATE TABLE test (id, value);"); + std::shared_ptr statement = database.prepare( + "INSERT INTO test (id, value) VALUES (:id, :value);"); + statement->bind(":id", 1); + statement->bind(":value", "test value"); + statement->execute(); + statement = database.prepare("SELECT id, value FROM test;"); + ResultSet resultSet = statement->execute(); + while (resultSet.canRead()) { + std::cout << "ID: " << resultSet.readInt(0) << "\t value: " + << resultSet.readString(1) << std::endl; + resultSet.next(); + } +} +``` + +``` +$ g++ --std=c++11 -o test -lsqlitepp -lsqlite3 test.cpp +$ ./test +ID: 1 value: test value +``` + +For more information, see the [API documentation][api]. + +[api]: http://robinkrahl.github.io/sqlitepp/ -- cgit v1.2.1