Sampletable Class Reference

#include <libsample.h>

Collaboration diagram for Sampletable:

[legend]List of all members.

Public Member Functions
	Sampletable (Database *)
	Sampletable (Database *, const std::string &)
	Sampletable (Database *, Query *)
	Sampletable (Database &, long num)
	~Sampletable ()
void	select (const std::string &)
long	insert ()
void	update ()
void	save ()
void	erase ()
std::string	xml ()
std::string	xml (const std::string &, const std::string &)
int	num_cols ()
Public Attributes
long	num
std::string	name
Private Member Functions
void	update (long num)
void	clear ()
void	spawn (const std::string &)
void	spawn (Query *)
Private Attributes
Database *	database
short	new_object

---

Detailed Description

Class 'Sampletable' and 'cSampletable'

Definition at line 37 of file libsample.h.

---

Constructor & Destructor Documentation

Sampletable::Sampletable

(

Database *

db

)

Begin class 'Sampletable'

Definition at line 37 of file libsample.cpp.

References clear(), database, and new_object.

        {
                database = db;
                new_object = 1;
                clear();
        }

Sampletable::Sampletable	(	Database *	,
		const std::string &
	)

Definition at line 43 of file libsample.cpp.

References database, new_object, and spawn().

        {
                database = db;
                new_object = 1;
                spawn(sql);
        }

Sampletable::Sampletable	(	Database *	,
		Query *
	)

Definition at line 49 of file libsample.cpp.

References database, new_object, and spawn().

        {
                database = db;
                new_object = 0;
                spawn(qd);
        }

Sampletable::Sampletable	(	Database &	,
		long	num
	)

Definition at line 55 of file libsample.cpp.

References database, and spawn().

                                                        : database(&db),new_object(1)
        {
                Query q(database);
                std::string sql = "select * from sampletable where ";
                {
                        char slask[100];
                        sprintf(slask,"num='%ld'",i_num);
                        sql += slask;
                }
                spawn(sql);
        }

Sampletable::~Sampletable

(

)

Definition at line 66 of file libsample.cpp.

        {
        }

---

Member Function Documentation

void Sampletable::select

(

const std::string &

)

Definition at line 70 of file libsample.cpp.

References spawn().

        {
                spawn(sql);
        }

long Sampletable::insert

(

)

Definition at line 75 of file libsample.cpp.

References database, name, new_object, and num.

Referenced by save().

        {
                Query q(database);
                std::string sql;

                sql = "insert into sampletable(num,name)";
                {
                        char slask[100];
                        sprintf(slask," values(%ld",this -> num);
                        sql += slask;
                }
                sql += ", '" + q.safestr(this -> name) + "'";
                sql += ")";
                q.execute(sql);
                new_object = 0;
                return num = q.insert_id();
        }

void Sampletable::update

(

)

Definition at line 93 of file libsample.cpp.

References num.

Referenced by save().

        {
                update(this -> num);
        }

void Sampletable::save

(

)

Definition at line 111 of file libsample.cpp.

References insert(), new_object, and update().

        {
                if (new_object)
                        insert();
                else
                        update();
        }

void Sampletable::erase

(

)

Definition at line 119 of file libsample.cpp.

References database, new_object, and num.

        {
                if (!new_object)
                {
                        std::string sql = "delete from sampletable where";
                        Query q(database);
                        {
                                char slask[200];
                                sprintf(slask," num='%ld'",this -> num);
                                sql += slask;
                        }
                        q.execute(sql);
                }
        }

std::string Sampletable::xml

(

)

Definition at line 134 of file libsample.cpp.

References database, name, and num.

        {
                Query q(database);
                std::string dest;
                char slask[200];
                dest = "<SAMPLETABLE>";
                sprintf(slask,"<NUM>%ld</NUM>",num);
                dest += slask;
                dest += "<NAME>" + q.xmlsafestr(name) + "</NAME>";
                dest += "</SAMPLETABLE>";
                return dest;
        }

std::string Sampletable::xml	(	const std::string &	,
		const std::string &
	)

Definition at line 147 of file libsample.cpp.

References database, name, and num.

        {
                Query q(database);
                std::string dest;
                char slask[200];
                dest = "<SAMPLETABLE " + tag + "=\"" + xvalx + "\">";
                sprintf(slask,"<NUM>%ld</NUM>",num);
                dest += slask;
                dest += "<NAME>" + q.xmlsafestr(name) + "</NAME>";
                dest += "</SAMPLETABLE>";
                return dest;
        }

int Sampletable::num_cols

(

)

Definition at line 160 of file libsample.cpp.

        {
                return 2;
        }

void Sampletable::update

(

long

num

)

[private]

Definition at line 98 of file libsample.cpp.

References database, and name.

        {
                Query q(database);
                std::string sql;
                sql += "update sampletable set name='" + q.safestr(this -> name) + "'";
                {
                        char slask[200];
                        sprintf(slask," where num='%ld'",i_num);
                        sql += slask;
                }
                q.execute(sql);
        }

void Sampletable::clear

(

)

[private]

Definition at line 165 of file libsample.cpp.

References num.

Referenced by Sampletable(), and spawn().

        {
                num = 0;
        }

void Sampletable::spawn

(

const std::string &

)

[private]

Definition at line 169 of file libsample.cpp.

References clear(), database, name, new_object, and num.

Referenced by Sampletable(), and select().

        {
                Query q(database);
                std::string temp;

                if (!strncasecmp(sql.c_str(),"select * ",9))
                {
                        temp = "select num,name " + sql.substr(9);
                } else
                        temp = sql;
                q.get_result(temp);
                if (q.fetch_row())
                {
                        num = q.getval(0);                                    // 0 - num integer
                        name = q.getstr(1);                                   // 1 - name varchar(255)
                        new_object = 0;
                } else
                        clear();
                q.free_result();
        }

void Sampletable::spawn

(

Query *

)

[private]

Definition at line 190 of file libsample.cpp.

References name, and num.

        {
                num = qd -> getval(0);                                    // 0 - num integer
                name = qd -> getstr(1);                                   // 1 - name varchar(255)
        }

---

Member Data Documentation

long Sampletable::num

Definition at line 53 of file libsample.h.

Referenced by clear(), erase(), insert(), spawn(), update(), and xml().

std::string Sampletable::name

Definition at line 54 of file libsample.h.

Referenced by insert(), spawn(), update(), and xml().

Database* Sampletable::database [private]

Definition at line 62 of file libsample.h.

Referenced by erase(), insert(), Sampletable(), spawn(), update(), and xml().

short Sampletable::new_object [private]

Definition at line 63 of file libsample.h.

Referenced by erase(), insert(), Sampletable(), save(), and spawn().

---

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

• libsample.h
• libsample.cpp

---