An example of sqlite access using SOCI

soci_sqlite.cpp

#include <soci.h>
#include <sqlite3/soci-sqlite3.h>
#include <boost-fusion.h>

#include <iostream>

#include <boost/fusion/include/define_struct.hpp>
#include <boost/fusion/include/for_each.hpp>

using namespace soci;
using namespace std;

BOOST_FUSION_DEFINE_STRUCT(
	(), user,
	(int, user_id)
	(std::string, name)
	(std::string, email)
	(std::string, password))


int main()
{
	try {
		session sql(sqlite3, "path_to_db_file/data.sqlite");

		user u;
		sql << "select * from users", into(u);
		boost::fusion::for_each(u, [](auto const& e) { std::cout << e << ' '; });
		std::cout << std::endl;
	}
	catch (exception const &e) {
		cerr << "Error: " << e.what() << '\n';
	}
}