cSqlAct.h

Go to the documentation of this file.

#ifndef _cSqlAct_h
#define _cSqlAct_h

#include "TypesDef.h"
#include "cSqlBaseIf.h"

#include "cMySQL.h"
#include "cConnect.h"

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

#include <string>
#include <list>

using std::string;
using std::list;


class cSqlAct: public cSqlBaseIf
{
public:
        cSqlAct(void);
        ~cSqlAct(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:
        // All RDMS classes.
        cMySQL MySQL;

        cConnect *m_pConnect;

};

#endif // _cSqlAct_h

---