cSqlAct Class Reference

cSqlAct processes all SQL operations needed by eDonkeyFileManager. It doesn't implement ANY new functions besides those one derived from cSQLBase. More...

#include <cSqlAct.h>

Inheritance diagram for cSqlAct:

List of all members.

Public Member Functions
	cSqlAct (void)
	~cSqlAct (void)
Bool	Connect (void)
	Return TRUE if success.
void	Close (void)
	Close SQL connection.
Int	ErrorNum (void)
	Return the error number for the most recently executed query.
list< string >	GetDatabaseList (void)
	Get Database list.
Bool	CreateDatabase (string sDbName)
	Create Database.
Bool	DeleteDatabase (string sDbName)
	Delete Database.
Bool	SelectDatabase (string sDbName)
	Select database.
void	CreateTables (void)
	Create all tables of a database.
list< list< string > >	GetFileList (void)
	Get a File List with their General information.
list< list< string > >	GetMovieList (void)
	Get a Movie List with their General information.
list< list< string > >	GetSoftwareList (void)
	Get a Software List with their General information.
list< list< string > >	GetMusicList (void)
	Get a Music List with their General information.
list< string >	GetFileRowResult (const string sMd4)
	Get a row data of FILE table.
list< string >	GetMovieRowResult (const string sMd4)
	Get a row data of MOVIE table.
list< string >	GetSoftwareRowResult (const string sMd4)
	Get a row data of SOFTWARE table.
list< string >	GetMusicRowResult (const string sMd4)
	Get a row data of MUSIC table.
Bool	InsertNewEntry2File (cFile *File)
	INSERT new entry into FILE tabel.
Bool	InsertNewEntry2Movie (cMovie *Movie)
	INSERT new entry into MOVIE table.
Bool	InsertNewEntry2Music (cMusic *Music)
	INSERT new entry into MUSIC table.
Bool	InsertNewEntry2Software (cSoftware *Software)
	INSERT new entry into SOFTWARE table.
Bool	IsMd4Found (const string sMd4)
	Is Md4 is found in FILE table.
const string	GetCategory (const string sMd4)
	Get category string from FILE table.
Bool	UpdateFile (cFile *pFile)
	UPDATE FILE table.
Bool	UpdateMovie (cMovie *pMovie)
	UPDATE MOVIE table.
Bool	UpdateSoftware (cSoftware *pSoftware)
	UPDATE SOFTWARE table.
Bool	UpdateMusic (cMusic *pMusic)
	UPDATE MUSIC table.
Bool	DeleteFromFile (const string sMd4)
	DELETE entry from FILE table.
Bool	DeleteFromMovie (const string sMd4)
	DELETE entry from MOVIE table.
Bool	DeleteFromSoftware (const string sMd4)
	DELETE entry from SOFTWARE table.
Bool	DeleteFromMusic (const string sMd4)
	DELETE entry from MUSIC table.
Private Attributes
cMySQL	MySQL
cConnect *	m_pConnect

---

Detailed Description

cSqlAct processes all SQL operations needed by eDonkeyFileManager. It doesn't implement ANY new functions besides those one derived from cSQLBase.

Author:

Xuan Ngo

Date:

Last Modified:

Version:

0.2

Since:

Sun Nov 23 02:46:06 2003

Bug:

Test:

Todo:

Warning:

Any warnings about using this class.

---

Constructor & Destructor Documentation

cSqlAct::cSqlAct (  void   )

cSqlAct::~cSqlAct (  void   )

---

Member Function Documentation

void cSqlAct::Close (  void   )  [virtual]

Close SQL connection. Implements cSqlBaseIf.

Bool cSqlAct::Connect (  void   )  [virtual]

Return TRUE if success. Implements cSqlBaseIf.

Bool cSqlAct::CreateDatabase (  string  sDbName  )  [virtual]

Create Database. Implements cSqlBaseIf.

void cSqlAct::CreateTables (  void   )  [virtual]

Create all tables of a database. Implements cSqlBaseIf.

Bool cSqlAct::DeleteDatabase (  string  sDbName  )  [virtual]

Delete Database. Implements cSqlBaseIf.

Bool cSqlAct::DeleteFromFile (  const string  sMd4  )  [virtual]

DELETE entry from FILE table. Implements cSqlBaseIf.

Bool cSqlAct::DeleteFromMovie (  const string  sMd4  )  [virtual]

DELETE entry from MOVIE table. Implements cSqlBaseIf.

Bool cSqlAct::DeleteFromMusic (  const string  sMd4  )  [virtual]

DELETE entry from MUSIC table. Implements cSqlBaseIf.

Bool cSqlAct::DeleteFromSoftware (  const string  sMd4  )  [virtual]

DELETE entry from SOFTWARE table. Implements cSqlBaseIf.

Int cSqlAct::ErrorNum (  void   )  [virtual]

Return the error number for the most recently executed query. Implements cSqlBaseIf.

const string cSqlAct::GetCategory (  const string  sMd4  )  [virtual]

Get category string from FILE table. Implements cSqlBaseIf.

list< string > cSqlAct::GetDatabaseList (  void   )  [virtual]

Get Database list. Implements cSqlBaseIf.

list< list< string > > cSqlAct::GetFileList (  void   )  [virtual]

Get a File List with their General information. Implements cSqlBaseIf.

list< string > cSqlAct::GetFileRowResult (  const string  sMd4  )  [virtual]

Get a row data of FILE table. Implements cSqlBaseIf.

list< list< string > > cSqlAct::GetMovieList (  void   )  [virtual]

Get a Movie List with their General information. Implements cSqlBaseIf.

list< string > cSqlAct::GetMovieRowResult (  const string  sMd4  )  [virtual]

Get a row data of MOVIE table. Implements cSqlBaseIf.

list< list< string > > cSqlAct::GetMusicList (  void   )  [virtual]

Get a Music List with their General information. Implements cSqlBaseIf.

list< string > cSqlAct::GetMusicRowResult (  const string  sMd4  )  [virtual]

Get a row data of MUSIC table. Implements cSqlBaseIf.

list< list< string > > cSqlAct::GetSoftwareList (  void   )  [virtual]

Get a Software List with their General information. Implements cSqlBaseIf.

list< string > cSqlAct::GetSoftwareRowResult (  const string  sMd4  )  [virtual]

Get a row data of SOFTWARE table. Implements cSqlBaseIf.

Bool cSqlAct::InsertNewEntry2File (  cFile *  File  )  [virtual]

INSERT new entry into FILE tabel. Implements cSqlBaseIf.

Bool cSqlAct::InsertNewEntry2Movie (  cMovie *  Movie  )  [virtual]

INSERT new entry into MOVIE table. Implements cSqlBaseIf.

Bool cSqlAct::InsertNewEntry2Music (  cMusic *  Music  )  [virtual]

INSERT new entry into MUSIC table. Implements cSqlBaseIf.

Bool cSqlAct::InsertNewEntry2Software (  cSoftware *  Software  )  [virtual]

INSERT new entry into SOFTWARE table. Implements cSqlBaseIf.

Bool cSqlAct::IsMd4Found (  const string  sMd4  )  [virtual]

Is Md4 is found in FILE table. Implements cSqlBaseIf.

Bool cSqlAct::SelectDatabase (  string  sDbName  )  [virtual]

Select database. Implements cSqlBaseIf.

Bool cSqlAct::UpdateFile (  cFile *  pFile  )  [virtual]

UPDATE FILE table. Implements cSqlBaseIf.

Bool cSqlAct::UpdateMovie (  cMovie *  pMovie  )  [virtual]

UPDATE MOVIE table. Implements cSqlBaseIf.

Bool cSqlAct::UpdateMusic (  cMusic *  pMusic  )  [virtual]

UPDATE MUSIC table. Implements cSqlBaseIf.

Bool cSqlAct::UpdateSoftware (  cSoftware *  pSoftware  )  [virtual]

UPDATE SOFTWARE table. Implements cSqlBaseIf.

---

Member Data Documentation

cConnect* cSqlAct::m_pConnect [private]

cMySQL cSqlAct::MySQL [private]

---

The documentation for this class was generated from the following files:

• cSqlAct.h
• cSqlAct.cpp

---