libsample.cpp

Go to the documentation of this file.

/*
 *       libsample.cpp
 *       Generated by sql2class by (C) AH 2000
 *       Sun May 30 12:33:30 2004
 */

/*
Copyright (C) 2001  Anders Hedstrom (grymse@alhem.net)

This program is free software; you can redistribute it and/or
modify it under the terms of the GNU General Public License
as published by the Free Software Foundation; either version 2
of the License, or (at your option) any later version.

This program is distributed in the hope that it will be useful,
but WITHOUT ANY WARRANTY; without even the implied warranty of
MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
GNU General Public License for more details.

You should have received a copy of the GNU General Public License
along with this program; if not, write to the Free Software
Foundation, Inc., 59 Temple Place - Suite 330, Boston, MA  02111-1307, USA.
*/

#include <stdio.h>
#include <stdlib.h>
#include <string.h>
#include <mysql/mysql.h>
#include <libsql++.h>
#include "libsample.h"


        Sampletable::Sampletable(Database *db)
        {
                database = db;
                new_object = 1;
                clear();
        }
        Sampletable::Sampletable(Database *db,const std::string& sql)
        {
                database = db;
                new_object = 1;
                spawn(sql);
        }
        Sampletable::Sampletable(Database *db,Query *qd)
        {
                database = db;
                new_object = 0;
                spawn(qd);
        }
        Sampletable::Sampletable(Database& db,long i_num) : 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()
        {
        }

        void Sampletable::select(const std::string& sql)
        {
                spawn(sql);
        }

        long Sampletable::insert()
        {
                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()
        {
                update(this -> num);
        }

        void Sampletable::update(long i_num)
        {
                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::save()
        {
                if (new_object)
                        insert();
                else
                        update();
        }

        void Sampletable::erase()
        {
                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()
        {
                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& tag,const std::string& xvalx)
        {
                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()
        {
                return 2;
        }

        void Sampletable::clear()
        {
                num = 0;
        }
        void Sampletable::spawn(const std::string& sql)
        {
                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 *qd)
        {
                num = qd -> getval(0);                                    // 0 - num integer
                name = qd -> getstr(1);                                   // 1 - name varchar(255)
        }

// End of implementation of class 'Sampletable'

---