From 9fc268e10ec78830df8ebb6b60f201790e5d5d6f Mon Sep 17 00:00:00 2001
From: ilotterytea <iltsu@alright.party>
Date: Sat, 12 Apr 2025 16:55:51 +0500
Subject: feat: db functions for lua

---
 bot/src/commands/command.cpp |   1 +
 bot/src/commands/lua.cpp     | 112 +++++++++++++++++++++++++++++++++++++++++++
 bot/src/commands/lua.hpp     |   3 ++
 3 files changed, 116 insertions(+)

(limited to 'bot/src/commands')

diff --git a/bot/src/commands/command.cpp b/bot/src/commands/command.cpp
index fe794ef..d98dc73 100644
--- a/bot/src/commands/command.cpp
+++ b/bot/src/commands/command.cpp
@@ -92,6 +92,7 @@ namespace bot {
       lua::library::add_bot_library(this->luaState, bundle);
       lua::library::add_irc_library(this->luaState, bundle);
       lua::library::add_twitch_library(this->luaState, request, bundle);
+      lua::library::add_db_library(this->luaState, bundle.configuration);
 
       auto command = std::find_if(
           this->commands.begin(), this->commands.end(),
diff --git a/bot/src/commands/lua.cpp b/bot/src/commands/lua.cpp
index 1140334..df14181 100644
--- a/bot/src/commands/lua.cpp
+++ b/bot/src/commands/lua.cpp
@@ -22,6 +22,7 @@
 #include "commands/request.hpp"
 #include "commands/response.hpp"
 #include "commands/response_error.hpp"
+#include "config.hpp"
 #include "cpr/api.h"
 #include "cpr/cprtypes.h"
 #include "cpr/multipart.h"
@@ -353,6 +354,117 @@ namespace bot::command::lua {
                           });
     }
 
+    void add_db_library(std::shared_ptr<sol::state> state,
+                        const Configuration &cfg) {
+      state->set_function("db_execute", [state, cfg](
+                                            const std::string &query,
+                                            const sol::table &parameters) {
+        pqxx::connection conn(GET_DATABASE_CONNECTION_URL(cfg));
+        pqxx::params p;
+
+        for (const auto &kv : parameters) {
+          auto v = kv.second;
+          switch (v.get_type()) {
+            case sol::type::lua_nil: {
+              p.append(nullptr);
+              break;
+            }
+            case sol::type::string: {
+              p.append(v.as<std::string>());
+              break;
+            }
+            case sol::type::boolean: {
+              p.append(v.as<bool>());
+              break;
+            }
+            case sol::type::number: {
+              double num = v.as<double>();
+              if (std::floor(num) == num) {
+                p.append(static_cast<long long>(num));
+              } else {
+                p.append(num);
+              }
+              break;
+            }
+            default:
+              throw std::runtime_error("Unsupported Lua type for DB queries");
+          }
+        }
+
+        pqxx::work work(conn);
+
+        work.exec_params(query, p);
+
+        work.commit();
+        conn.close();
+      });
+
+      state->set_function("db_query", [state, cfg](
+                                          const std::string &query,
+                                          const sol::table &parameters) {
+        pqxx::connection conn(GET_DATABASE_CONNECTION_URL(cfg));
+        pqxx::params p;
+
+        for (const auto &kv : parameters) {
+          auto v = kv.second;
+          switch (v.get_type()) {
+            case sol::type::lua_nil: {
+              p.append(nullptr);
+              break;
+            }
+            case sol::type::string: {
+              p.append(v.as<std::string>());
+              break;
+            }
+            case sol::type::boolean: {
+              p.append(v.as<bool>());
+              break;
+            }
+            case sol::type::number: {
+              double num = v.as<double>();
+              if (std::floor(num) == num) {
+                p.append(static_cast<long long>(num));
+              } else {
+                p.append(num);
+              }
+              break;
+            }
+            default:
+              throw std::runtime_error("Unsupported Lua type for DB queries");
+          }
+        }
+
+        pqxx::work work(conn);
+        pqxx::result res = work.exec_params(query, p);
+
+        sol::table o = state->create_table();
+
+        for (const auto &row : res) {
+          sol::table r = state->create_table();
+
+          for (int i = 0; i < row.size(); i++) {
+            auto v = row[i];
+
+            sol::object obj;
+            if (v.is_null()) {
+              obj = sol::make_object(*state, sol::nil);
+            } else {
+              obj = sol::make_object(*state, v.as<std::string>());
+            }
+
+            r[res.column_name(i)] = obj;
+          }
+
+          o.add(r);
+        }
+
+        work.commit();
+        conn.close();
+
+        return o;
+      });
+    }
+
     void add_base_libraries(std::shared_ptr<sol::state> state) {
       add_bot_library(state);
       add_time_library(state);
diff --git a/bot/src/commands/lua.hpp b/bot/src/commands/lua.hpp
index 6391a2e..ef16ade 100644
--- a/bot/src/commands/lua.hpp
+++ b/bot/src/commands/lua.hpp
@@ -10,6 +10,7 @@
 
 #include "commands/command.hpp"
 #include "commands/response.hpp"
+#include "config.hpp"
 #include "schemas/user.hpp"
 
 void print_lua_object_type(const sol::object &obj);
@@ -25,6 +26,8 @@ namespace bot::command::lua {
                             const Request &request,
                             const InstanceBundle &bundle);
     void add_net_library(std::shared_ptr<sol::state> state);
+    void add_db_library(std::shared_ptr<sol::state> state,
+                        const Configuration &config);
     void add_irc_library(std::shared_ptr<sol::state> state,
                          const InstanceBundle &bundle);
 
-- 
cgit v1.2.3