#ifndef _SYSAPPDB_SYSAPPDBHELPER_H_
#define _SYSAPPDB_SYSAPPDBHELPER_H_

#include <vector>
#include <map>
#include <string>
#include "sqlite3.h"

std::vector<std::string> read_text_file(std::string path);
std::vector<std::string> split_str(std::string src, char c);
std::string join_str(std::vector<std::string> strings, std::string connector);

template<typename K, typename V>
std::vector<K> map_get_keys(std::map<K, V> map);
template<typename K, typename V>
std::vector<V> map_get_values(std::map<K, V> map);

int db_insert(sqlite3* con, std::string table, std::map<std::string, std::string> values);

template<typename C>
std::vector<C> db_select(sqlite3* con, std::string table, std::string coloumn, std::string where_stmt);

#endif