cSqlBaseIf Class Reference

cSqlBaseIf is an interface. It ensures that its derived classes implement the "standard" SQL methods. More...

#include <cSqlBaseIf.h>

Inheritance diagram for cSqlBaseIf:

List of all members.

Public Member Functions
	cSqlBaseIf (void)
	Constructor.
virtual	~cSqlBaseIf (void)
	Destructor. Don't know why I have to put virtual in front of the destructor.
Protected Member Functions
virtual Bool	Connect (void)=0
	Return TRUE if connnection is connected successfully.
virtual void	Close (void)=0
	Close SQL connection.
virtual Int	ErrorNum (void)=0
	Return the error number for the most recently executed query.
virtual list< string >	GetDatabaseList (void)=0
	Get Database list.
virtual Bool	CreateDatabase (string sDbName)=0
	Create Database.
virtual Bool	DeleteDatabase (string sDbName)=0
	Delete Database.
virtual Bool	SelectDatabase (string sDbName)=0
	Select database.
virtual void	CreateTables (void)=0
	Create all tables of a database.
virtual list< list< string > >	GetFileList (void)=0
	Get a File List with their General information.
virtual list< list< string > >	GetMovieList (void)=0
	Get a Movie List with their General information.
virtual list< list< string > >	GetSoftwareList (void)=0
	Get a Software List with their General information.
virtual list< list< string > >	GetMusicList (void)=0
	Get a Music List with their General information.
virtual list< string >	GetFileRowResult (const string sMd4)=0
	Get a row data of FILE table.
virtual list< string >	GetMovieRowResult (const string sMd4)=0
	Get a row data of MOVIE table.
virtual list< string >	GetSoftwareRowResult (const string sMd4)=0
	Get a row data of SOFTWARE table.
virtual list< string >	GetMusicRowResult (const string sMd4)=0
	Get a row data of MUSIC table.
virtual Bool	InsertNewEntry2File (cFile *File)=0
	INSERT new entry into FILE table.
virtual Bool	InsertNewEntry2Movie (cMovie *Movie)=0
	INSERT new entry into MOVIE table.
virtual Bool	InsertNewEntry2Music (cMusic *Music)=0
	INSERT new entry into MUSIC table.
virtual Bool	InsertNewEntry2Software (cSoftware *Software)=0
	INSERT new entry into SOFTWARE table.
virtual Bool	IsMd4Found (const string sMd4)=0
	Is Md4 is found in FILE table.
virtual const string	GetCategory (const string sMd4)=0
	Get category string from FILE table.
virtual Bool	UpdateFile (cFile *pFile)=0
	UPDATE FILE table.
virtual Bool	UpdateMovie (cMovie *pMovie)=0
	UPDATE MOVIE table.
virtual Bool	UpdateSoftware (cSoftware *pSoftware)=0
	UPDATE SOFTWARE table.
virtual Bool	UpdateMusic (cMusic *pMusic)=0
	UPDATE MUSIC table.
virtual Bool	DeleteFromFile (const string sMd4)=0
	DELETE entry from FILE table.
virtual Bool	DeleteFromMovie (const string sMd4)=0
	DELETE entry from MOVIE table.
virtual Bool	DeleteFromSoftware (const string sMd4)=0
	DELETE entry from SOFTWARE table.
virtual Bool	DeleteFromMusic (const string sMd4)=0
	DELETE entry from MUSIC table.

---

Detailed Description

cSqlBaseIf is an interface. It ensures that its derived classes implement the "standard" SQL methods.

Author:

Xuan Ngo

Date:

Last Modified:

Version:

0.2

Since:

Sun Nov 23 03:25:00 2003

Bug:

Test:

Todo:

Warning:

Any warnings about using this class.

---

Constructor & Destructor Documentation

cSqlBaseIf::cSqlBaseIf (  void   )

Constructor.

cSqlBaseIf::~cSqlBaseIf (  void   )  [virtual]

Destructor. Don't know why I have to put virtual in front of the destructor.

---

Member Function Documentation

virtual void cSqlBaseIf::Close (  void   )  [protected, pure virtual]

Close SQL connection. Implemented in cMySQL, and cSqlAct.

virtual Bool cSqlBaseIf::Connect (  void   )  [protected, pure virtual]

Return TRUE if connnection is connected successfully. Implemented in cMySQL, and cSqlAct.

virtual Bool cSqlBaseIf::CreateDatabase (  string  sDbName  )  [protected, pure virtual]

Create Database. Implemented in cMySQL, and cSqlAct.

virtual void cSqlBaseIf::CreateTables (  void   )  [protected, pure virtual]

Create all tables of a database. Implemented in cMySQL, and cSqlAct.

virtual Bool cSqlBaseIf::DeleteDatabase (  string  sDbName  )  [protected, pure virtual]

Delete Database. Implemented in cMySQL, and cSqlAct.

virtual Bool cSqlBaseIf::DeleteFromFile (  const string  sMd4  )  [protected, pure virtual]

DELETE entry from FILE table. Implemented in cMySQL, and cSqlAct.

virtual Bool cSqlBaseIf::DeleteFromMovie (  const string  sMd4  )  [protected, pure virtual]

DELETE entry from MOVIE table. Implemented in cMySQL, and cSqlAct.

virtual Bool cSqlBaseIf::DeleteFromMusic (  const string  sMd4  )  [protected, pure virtual]

DELETE entry from MUSIC table. Implemented in cMySQL, and cSqlAct.

virtual Bool cSqlBaseIf::DeleteFromSoftware (  const string  sMd4  )  [protected, pure virtual]

DELETE entry from SOFTWARE table. Implemented in cMySQL, and cSqlAct.

virtual Int cSqlBaseIf::ErrorNum (  void   )  [protected, pure virtual]

Return the error number for the most recently executed query. Implemented in cMySQL, and cSqlAct.

virtual const string cSqlBaseIf::GetCategory (  const string  sMd4  )  [protected, pure virtual]

Get category string from FILE table. Implemented in cMySQL, and cSqlAct.

virtual list<string> cSqlBaseIf::GetDatabaseList (  void   )  [protected, pure virtual]

Get Database list. Implemented in cMySQL, and cSqlAct.

virtual list< list<string> > cSqlBaseIf::GetFileList (  void   )  [protected, pure virtual]

Get a File List with their General information. Implemented in cMySQL, and cSqlAct.

virtual list<string> cSqlBaseIf::GetFileRowResult (  const string  sMd4  )  [protected, pure virtual]

Get a row data of FILE table. Implemented in cMySQL, and cSqlAct.

virtual list< list<string> > cSqlBaseIf::GetMovieList (  void   )  [protected, pure virtual]

Get a Movie List with their General information. Implemented in cMySQL, and cSqlAct.

virtual list<string> cSqlBaseIf::GetMovieRowResult (  const string  sMd4  )  [protected, pure virtual]

Get a row data of MOVIE table. Implemented in cMySQL, and cSqlAct.

virtual list< list<string> > cSqlBaseIf::GetMusicList (  void   )  [protected, pure virtual]

Get a Music List with their General information. Implemented in cMySQL, and cSqlAct.

virtual list<string> cSqlBaseIf::GetMusicRowResult (  const string  sMd4  )  [protected, pure virtual]

Get a row data of MUSIC table. Implemented in cMySQL, and cSqlAct.

virtual list< list<string> > cSqlBaseIf::GetSoftwareList (  void   )  [protected, pure virtual]

Get a Software List with their General information. Implemented in cMySQL, and cSqlAct.

virtual list<string> cSqlBaseIf::GetSoftwareRowResult (  const string  sMd4  )  [protected, pure virtual]

Get a row data of SOFTWARE table. Implemented in cMySQL, and cSqlAct.

virtual Bool cSqlBaseIf::InsertNewEntry2File (  cFile *  File  )  [protected, pure virtual]

INSERT new entry into FILE table. Implemented in cMySQL, and cSqlAct.

virtual Bool cSqlBaseIf::InsertNewEntry2Movie (  cMovie *  Movie  )  [protected, pure virtual]

INSERT new entry into MOVIE table. Implemented in cMySQL, and cSqlAct.

virtual Bool cSqlBaseIf::InsertNewEntry2Music (  cMusic *  Music  )  [protected, pure virtual]

INSERT new entry into MUSIC table. Implemented in cMySQL, and cSqlAct.

virtual Bool cSqlBaseIf::InsertNewEntry2Software (  cSoftware *  Software  )  [protected, pure virtual]

INSERT new entry into SOFTWARE table. Implemented in cMySQL, and cSqlAct.

virtual Bool cSqlBaseIf::IsMd4Found (  const string  sMd4  )  [protected, pure virtual]

Is Md4 is found in FILE table. Implemented in cMySQL, and cSqlAct.

virtual Bool cSqlBaseIf::SelectDatabase (  string  sDbName  )  [protected, pure virtual]

Select database. Implemented in cMySQL, and cSqlAct.

virtual Bool cSqlBaseIf::UpdateFile (  cFile *  pFile  )  [protected, pure virtual]

UPDATE FILE table. Implemented in cMySQL, and cSqlAct.

virtual Bool cSqlBaseIf::UpdateMovie (  cMovie *  pMovie  )  [protected, pure virtual]

UPDATE MOVIE table. Implemented in cMySQL, and cSqlAct.

virtual Bool cSqlBaseIf::UpdateMusic (  cMusic *  pMusic  )  [protected, pure virtual]

UPDATE MUSIC table. Implemented in cMySQL, and cSqlAct.

virtual Bool cSqlBaseIf::UpdateSoftware (  cSoftware *  pSoftware  )  [protected, pure virtual]

UPDATE SOFTWARE table. Implemented in cMySQL, and cSqlAct.

---

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

• cSqlBaseIf.h
• cSqlBaseIf.cpp

---