db_command.h

Go to the documentation of this file.

/*
**  ClanLib SDK
**  Copyright (c) 1997-2005 The ClanLib Team
**
**  This software is provided 'as-is', without any express or implied
**  warranty.  In no event will the authors be held liable for any damages
**  arising from the use of this software.
**
**  Permission is granted to anyone to use this software for any purpose,
**  including commercial applications, and to alter it and redistribute it
**  freely, subject to the following restrictions:
**
**  1. The origin of this software must not be misrepresented; you must not
**     claim that you wrote the original software. If you use this software
**     in a product, an acknowledgment in the product documentation would be
**     appreciated but is not required.
**  2. Altered source versions must be plainly marked as such, and must not be
**     misrepresented as being the original software.
**  3. This notice may not be removed or altered from any source distribution.
**
**  Note: Some of the libraries ClanLib link to may have additional
**  requirements or restrictions.
**
**  File Author(s):
**
**    Magnus Norddahl
*/

#ifndef header_db_command
#define header_db_command

#include "db_return_value.h"

class CL_ByteArray;
class CL_DBConnection;
struct sqlite3_stmt;

class CL_DBCommand
{
public:
        CL_DBCommand(CL_DBConnection *database);

        CL_DBCommand(const CL_String &sql_statement, CL_DBConnection *database);
        
        ~CL_DBCommand();
        
public:
        int get_last_insert_rowid() const;

        int get_columns() const;
        
        const char *get_name(int column) const;

        int get_index(const char *name) const;

        int get_index(const CL_String &name) const;

        const char *get_decltype(int column) const;

        const char *get_decltype(const char *name) const;

        CL_ByteArray get_blob(int column) const;

        CL_ByteArray get_blob(const char *name) const;

        void get_blob(int column, CL_ByteArray &array) const;

        void get_blob(const char *name, CL_ByteArray &array) const;

        const void *get_blob_raw(int column) const;

        const void *get_blob_raw(const char *name) const;

        int get_blob_size(int column) const;

        int get_blob_size(const char *name) const;

        double get_double(int column) const;

        double get_double(const char *name) const;

        int get_int(int column) const;

        int get_int(const char *name) const;

        const char *get_text(int column) const;

        const char *get_text(const char *name) const;
        
        CL_DBReturnValue operator[](int column) const;
        
        CL_DBReturnValue operator[](const char *name) const;
        
        CL_DBReturnValue operator[](const CL_String &name) const;

        int get_param_column(const char *name) const;

public:
        void compile(const CL_String &sql_statement);
        
        void compile(const char *sql_statement);

        void compilef(const char *sql_statement, ...);

        void set_param_double(int column, double value);

        void set_param_double(const char *column_name, double value);

        void set_param_int(int column, int value);

        void set_param_int(const char *column_name, int value);

        void set_param_blob(int column, const CL_ByteArray &blob);

        void set_param_blob(const char *column_name, const CL_ByteArray &blob);

        void set_param_text(int column, const char *text);

        void set_param_text(const char *column_name, const char *text);

        bool step();
        
        void reset();

private:
        CL_DBConnection *db;
        
        sqlite3_stmt *vm;

        int last_insert_rowid;
};

#endif

---