sqlite.hpp

Go to the documentation of this file.

// Copyright 2019 Matthew Chandler

// Permission is hereby granted, free of charge, to any person obtaining a copy
// of this software and associated documentation files (the "Software"), to deal
// in the Software without restriction, including without limitation the rights
// to use, copy, modify, merge, publish, distribute, sublicense, and/or sell
// copies of the Software, and to permit persons to whom the Software is
// furnished to do so, subject to the following conditions:

// The above copyright notice and this permission notice shall be included in
// all copies or substantial portions of the Software.

// THE SOFTWARE IS PROVIDED "AS IS", WITHOUT WARRANTY OF ANY KIND, EXPRESS OR
// IMPLIED, INCLUDING BUT NOT LIMITED TO THE WARRANTIES OF MERCHANTABILITY,
// FITNESS FOR A PARTICULAR PURPOSE AND NONINFRINGEMENT. IN NO EVENT SHALL THE
// AUTHORS OR COPYRIGHT HOLDERS BE LIABLE FOR ANY CLAIM, DAMAGES OR OTHER
// LIABILITY, WHETHER IN AN ACTION OF CONTRACT, TORT OR OTHERWISE, ARISING FROM,
// OUT OF OR IN CONNECTION WITH THE SOFTWARE OR THE USE OR OTHER DEALINGS IN THE
// SOFTWARE.

#ifndef SQLITE_HPP
#define SQLITE_HPP

#include <string>

#include <sqlitepp/sqlite3.h>


namespace sqlite
{

    class Connection final
    {
    public:
        class Stmt;


        explicit Connection(const std::string & filename);
        ~Connection();

        // non-copyable
        Connection(const Connection &) = delete;
        Connection & operator=(const Connection &) = delete;

        // movable
        Connection(Connection &&);
        Connection & operator=(Connection &&);


        Stmt create_statement(const std::string & sql);


        void exec(const std::string & sql, int (*callback)(void *, int, char **, char **) = nullptr,
            void * arg = nullptr);


        void begin_transaction();


        void commit();


        void rollback();


        void interrupt();


        sqlite3_int64 last_insert_rowid();


        int total_changes();



        struct Column_metadata
        {
            std::string type; 
            std::string collation; 
            bool not_null = false; 
            bool primary_key = false; 
            bool auto_inc = false; 
        };


        Column_metadata table_column_metadata(const std::string & table_name, const std::string & column_name,
            const std::string & db_name = "main");


        const sqlite3 * get_c_obj() const;


        sqlite3 * get_c_obj();

    private:
        sqlite3 * db_ = nullptr;
    };


    class Connection::Stmt final
    {
    public:

        Stmt(const std::string & sql, Connection & db);
        ~Stmt();

        // non-copyable
        Stmt(const Stmt &) = delete;
        Stmt & operator=(const Stmt &) = delete;

        // movable
        Stmt(Stmt &&);
        Stmt & operator=(Stmt &&);



        void bind(const int index, const double val);

        void bind(const int index, const int val);

        void bind(const int index, const sqlite3_int64 val);

        void bind(const int index, const std::string & val);

        void bind(const int index, const char * val);


        void bind_null(const int index);

        void bind(const int index);


        void bind(const std::string & name, const double val);

        void bind(const std::string & name, const int val);

        void bind(const std::string & name, const sqlite3_int64 val);

        void bind(const std::string & name, const std::string & val);

        void bind(const std::string & name, const char * val);


        void bind_null(const std::string & name);

        void bind(const std::string & name);



        std::string bind_parameter_name(const int index);


        int bind_parameter_index(const std::string & name);


        int bind_parameter_count();


        bool step();


        template<typename T>
        T get_col(const int column);


        void reset();


        void clear_bindings();


        bool busy();


        bool readonly();


        const sqlite3_stmt * get_c_obj() const;


        sqlite3_stmt * get_c_obj();

    private:
        sqlite3_stmt * stmt_ = nullptr;
        sqlite3 * db_ = nullptr;
    };
};

# endif // SQLITE_HPP