README.md

# libdbpp

A small C++ database abtraction library

## Dependcies
- postgresql(libpq)
- sqlite(sqlite-dev)
- duckdb(duckdb headers)
- C++14
- Cmake

### Optional
- Doxygen (for documentation)

## Build

1. cd libdbpp
2. mkdir build
3. cd build
4. cmake ../
5. make || ninja
6. make install || ninja install

## Usage Example

```CPP

#include <iostream>
#include <dbpp/database.h>

int main(int argc,char **argv){
    dbpp::Database db(atoi(argv[1]),argv[2]);
    dbpp::DBResult res;
    dbpp::SQL sql;

    sql << "CREATE TABLE IF NOT EXISTS test"
        << "(id INTEGER PRIMARY KEY "
        << db.autoincrement(sql)
        << ",name VARCHAR(255),value TEXT);";

    db.exec(sql,res);

    sql.clear();
    res.clear();

    std::string name,value;

    std::cout << "Enter Name: " << std::endl;
    std::cin >> name;

    std::cout << "Enter Value: " << std::endl;
    std::cin >> value;

    sql << "INSERT INTO test (name,value) VALUES"
        << "('"<< name.c_str() <<"','" << value.c_str() << "');";

    db.exec(sql,res);

    sql.clear();
    res.clear();

    sql << "SELECT name,value FROM test;";

    int count =db.exec(sql,res);

    for(int i=0; i<count; ++i){
        std::cout << "name: " << res[i][0]
                  << " value:" << res[i][1]
                  << std::endl;
    }

}

```

## Build example
```SH
gcc sdbpp.c -o sdbpp -ldbpp 
```

## Usage example
```SH
./sdbpp 1 /tmp/test.sql
```