Session.hpp

Go to the documentation of this file.

 
 
#pragma once
 
#include <cstddef>
#include <filesystem>
#include <map>
#include <optional>
#include <string>
#include <string_view>
#include <vector>
 
#include "Statement.hpp"
 
namespace tinysql {
 
struct ResultSet {
    std::vector<std::string> headers;        
    std::vector<std::size_t> widths;         
    std::vector<bool> literal;               
    std::vector<std::size_t> storageWidths;  
    std::vector<std::vector<std::string>> rows;  
    std::optional<std::size_t> idColumn;     
};
 
struct StatementResult {
    std::string sql;                 
    std::string tableName;           
    std::optional<ResultSet> table;  
    std::string message;             
    bool failed = false;             
    bool silent = false;             
};
 
class Session {
public:
    explicit Session(std::filesystem::path dataDir);
 
    StatementResult execute(std::string_view sql);
 
    std::vector<StatementResult> executeScript(std::string_view script);
 
private:
    StatementResult run(const SelectStmt& stmt);
 
    StatementResult run(const InsertStmt& stmt);
 
    StatementResult run(const UpdateStmt& stmt);
 
    StatementResult run(const DeleteStmt& stmt);
 
    StatementResult run(const CreateTableStmt& stmt);
 
    StatementResult run(const ColumnFormatStmt& stmt);
 
    StatementResult run(const DescribeStmt& stmt);
 
    StatementResult run(const CommentStmt&);
 
    std::filesystem::path dataDir_;                     
    std::map<std::string, std::size_t> displayWidths_;  
};
 
}  // namespace tinysql