00001 00014 #ifndef _cSQLBaseIF_h 00015 #define _cSQLBaseIF_h 00016 00017 #include "TypesDef.h" 00018 00019 #include "cFile.h" 00020 #include "cMovie.h" 00021 #include "cMusic.h" 00022 #include "cSoftware.h" 00023 00024 #include <string> 00025 #include <list> 00026 00027 using std::string; 00028 using std::list; 00029 00030 class cSqlBaseIf 00031 { 00032 public: 00034 cSqlBaseIf(void); 00035 00037 virtual ~cSqlBaseIf(void); 00038 00039 protected: 00040 //********************************************************************** 00041 // All Virtual Functions that have to be implemented in derived classes. 00042 //********************************************************************** 00044 virtual Bool Connect(void) =0; 00045 00047 virtual void Close(void) =0; 00048 00050 virtual Int ErrorNum(void) =0; 00051 00053 virtual list<string> GetDatabaseList(void) =0; 00054 00056 virtual Bool CreateDatabase(string sDbName) =0; 00057 00059 virtual Bool DeleteDatabase(string sDbName) =0; 00060 00062 virtual Bool SelectDatabase(string sDbName) =0; 00063 00065 virtual void CreateTables(void) =0; 00066 00067 00069 virtual list< list<string> > GetFileList(void) =0; 00070 00072 virtual list< list<string> > GetMovieList(void) =0; 00073 00075 virtual list< list<string> > GetSoftwareList(void) =0; 00076 00078 virtual list< list<string> > GetMusicList(void) =0; 00079 00080 00082 virtual list<string> GetFileRowResult(const string sMd4) =0; 00083 00085 virtual list<string> GetMovieRowResult(const string sMd4) =0; 00086 00088 virtual list<string> GetSoftwareRowResult(const string sMd4) =0; 00089 00091 virtual list<string> GetMusicRowResult(const string sMd4) =0; 00092 00093 00095 virtual Bool InsertNewEntry2File(cFile* File) =0; 00096 00098 virtual Bool InsertNewEntry2Movie(cMovie* Movie) =0; 00099 00101 virtual Bool InsertNewEntry2Music(cMusic* Music) =0; 00102 00104 virtual Bool InsertNewEntry2Software(cSoftware* Software) =0; 00105 00106 00107 00109 virtual Bool IsMd4Found(const string sMd4) =0; 00110 00112 virtual const string GetCategory(const string sMd4) =0; 00113 00114 00116 virtual Bool UpdateFile(cFile* pFile) =0; 00117 00119 virtual Bool UpdateMovie(cMovie* pMovie) =0; 00120 00122 virtual Bool UpdateSoftware(cSoftware* pSoftware) =0; 00123 00125 virtual Bool UpdateMusic(cMusic* pMusic) =0; 00126 00127 00128 00130 virtual Bool DeleteFromFile(const string sMd4) =0; 00131 00133 virtual Bool DeleteFromMovie(const string sMd4) =0; 00134 00136 virtual Bool DeleteFromSoftware(const string sMd4) =0; 00137 00139 virtual Bool DeleteFromMusic(const string sMd4) =0; 00140 00141 00142 }; 00143 00144 #endif // _cSQLBaseIF_h