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
45
46
47
48
49
50
51
|
#ifndef __TVSCRAPER_TVSCRAPERDB_H
#define __TVSCRAPER_TVSCRAPERDB_H
using namespace std;
// --- cTVScraperDB --------------------------------------------------------
class cTVScraperDB {
private:
sqlite3 *db;
string dbPathPhys;
string dbPathMem;
bool inMem;
vector<vector<string> > Query(string query);
vector<vector<string> > QueryEscaped(string query, string where);
int LoadOrSaveDb(sqlite3 *pInMemory, const char *zFilename, int isSave);
bool CreateTables(void);
public:
cTVScraperDB(void);
virtual ~cTVScraperDB(void);
bool Connect(void);
void BackupToDisc(void);
void ClearOutdated(string movieDir);
bool CheckMovieOutdatedEvents(int movieID);
bool CheckMovieOutdatedRecordings(int movieID);
void DeleteMovie(int movieID, string movieDir);
void InsertSeries(int seriesID, string name, string overview);
void InsertEventSeries(int eventID, time_t validTill, int seriesID);
void InsertActor(int seriesID, string name, string role, string thumb);
void InsertMovie(int movieID, string title, string originalTitle, string overview);
void InsertEventMovie(int eventID, time_t validTill, int movieID);
void InsertMovieActor(int movieID, int actorID, string name, string role);
bool MovieExists(int movieID);
bool SeriesExists(int seriesID);
int SearchMovie(string movieTitle);
int SearchSeries(string seriesTitle);
void InsertRecording(int recEventID, int seriesID, int movieID);
bool SetRecordingSeries(int eventID);
bool SetRecordingMovie(int eventID);
void ClearRecordings(void);
bool CheckScrap(time_t timeStamp, string channelID);
bool CheckStartScrapping(int minimumDistance);
int GetSeriesID(int eventID, bool isRecording);
int GetMovieID(int eventID, bool isRecording);
vector<vector<string> > GetActorsSeries(int seriesID);
vector<vector<string> > GetActorsMovie(int movieID);
string GetDescriptionSeries(int seriesID);
string GetDescriptionMovie(int movieID);
};
#endif //__TVSCRAPER_TVSCRAPPERDB_H
|
