1 files changed, 50 insertions, 0 deletions
diff --git a/tvscraperdb.h b/tvscraperdb.h
new file mode 100644
index 0000000..a8f06ee
--- /dev/null
+++ b/tvscraperdb.h
@@ -0,0 +1,50 @@
+#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);
+    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);
+    void SetRecordingSeries(int eventID); 
+    void 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