cMySQL.h

Go to the documentation of this file.

#ifndef _cMySQL_h
#define _cMySQL_h

#include "TypesDef.h" // Need constants.

#if !wxLINUX
    #include <windows.h>
    #include <MySQL\mysql.h>
#else
    #include <mysql.h>
#endif


#include "cSqlBaseIf.h"

#include "cFileSqlString.h"
#include "cMovieSqlString.h"
#include "cSoftwareSqlString.h"
#include "cMusicSqlString.h"

#include "cFile.h"
#include "cMovie.h"
#include "cMusic.h"
#include "cSoftware.h"

class cMySQL: public cSqlBaseIf
{ 
public:
        cMySQL(void);
        ~cMySQL(void);
        
        Bool Connect(void);
        
        void Close(void);
        
        Int ErrorNum(void);
        
        list<string> GetDatabaseList(void);
        
        Bool CreateDatabase(string sDbName);

        Bool DeleteDatabase(string sDbName);

        Bool SelectDatabase(string sDbName);
        
        void CreateTables(void);


        list< list<string> > GetFileList(void);

        list< list<string> > GetMovieList(void);
        
        list< list<string> > GetSoftwareList(void);     
        
        list< list<string> > GetMusicList(void);                

        list<string> GetFileRowResult(const string sMd4);

        list<string> GetMovieRowResult(const string sMd4);

        list<string> GetSoftwareRowResult(const string sMd4);
        
        list<string> GetMusicRowResult(const string sMd4);


        Bool InsertNewEntry2File(cFile* File);  
        
        Bool InsertNewEntry2Movie(cMovie* Movie);

        Bool InsertNewEntry2Music(cMusic* Music);

        Bool InsertNewEntry2Software(cSoftware* Software);



        Bool IsMd4Found(const string sMd4);

        const string GetCategory(const string sMd4);
        

        Bool UpdateFile(cFile* pFile);
        
        Bool UpdateMovie(cMovie* pMovie);

        Bool UpdateSoftware(cSoftware* pSoftware);

        Bool UpdateMusic(cMusic* pMusic);
        

        Bool DeleteFromFile(const string sMd4);

        Bool DeleteFromMovie(const string sMd4);

        Bool DeleteFromSoftware(const string sMd4);

        Bool DeleteFromMusic(const string sMd4);

protected:

private:
        static MYSQL SQLConnection; // pointer to connection handler.
        
        MYSQL_RES *SQLResult;
        MYSQL_ROW SQLRow;
        
        Bool Init(void);                        // Initialize  the connection.

        Bool Query(string sQuery);
        
        list< list<string> > GetQueryTableResult(void);

        list<string> GetQueryRowResult(void);

        list<string> GetQueryColResult(void);
        
        Bool CompareList(const list<string> lFirst, const list<string> lSecond);
        Bool CompareTable(const string sTableName, list<string> lFixColNames);
        
        list< list<string> > GetGeneralInfoListOf(string sSqlCategory);
        
        cFileSqlString FileSqlString;
        cMovieSqlString MovieSqlString;
        cSoftwareSqlString SoftwareSqlString;
        cMusicSqlString MusicSqlString;
        
        
};

#endif // _cMySQL_h

---