PTimerTUI/dbConnection.h at main · plt3/PTimerTUI · GitHub

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
#ifndef TIMER_DBCONNECTION_H
#define TIMER_DBCONNECTION_H

#include "Solve.h"
#include <deque>
#include <sqlite3.h>
#include <string>

const std::string DEFAULT_FILENAME = "solves.db";
const std::string DEFAULT_SESSION_NAME = "default_session";

class dbConnection {
private:
    std::string filename;
    std::string sessionName;
    sqlite3 *dbPtr;
    void createTable();
    static int sessionListCallback(void *deqPtr, int argc, char **argv,
                                   char **azColName);
    static int rowidCallback(void *intPtr, int argc, char **argv,
                             char **azColName);
    static int pushSolveFrontCallback(void *deqPtr, int argc, char **argv,
                                      char **azColName);
    static int addOldSolveCallback(void *deqPtr, int argc, char **argv,
                                   char **azColName);

public:
    dbConnection(std::string filename = DEFAULT_FILENAME,
                 std::string sessionName = DEFAULT_SESSION_NAME);
    ~dbConnection();
    std::string getCurrentSession() { return sessionName; }
    void getAllSessions(std::deque<std::string> &sessionDeque);
    void changeSession(bool forward = true);
    void deleteSession(std::string name);
    void saveSolve(Solve toAdd);
    void deleteSolve(unsigned id);
    void updateSolvePenalty(unsigned id, unsigned newPenalty);
    unsigned getLastRowid();
    unsigned getSolveNumber(unsigned id = 0);
    void getLastNSolves(std::deque<Solve> &solvesDeque, unsigned numSolves);
    bool addOldSolve(std::deque<Solve> &solvesDeque);
};

#endif // !TIMER_DBCONNECTION_H