aboutsummaryrefslogtreecommitdiff
diff options
context:
space:
mode:
-rw-r--r--README.md47
1 files changed, 47 insertions, 0 deletions
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 <iostream>
+#include <memory>
+#include <sqlitepp/sqlitepp.h>
+
+int main(int argc, char** argv) {
+ sqlitepp::Database database("/path/to/database.sqlite");
+ database.execute("CREATE TABLE test (id, value);");
+ std::shared_ptr<sqlitepp::Statement> 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/