mirror of
https://github.com/Relintai/pandemonium_engine.git
synced 2025-02-04 15:15:56 +01:00
192 lines
9.5 KiB
C++
192 lines
9.5 KiB
C++
/*************************************************************************/
|
|
/* prepared_statement.cpp */
|
|
/*************************************************************************/
|
|
/* This file is part of: */
|
|
/* PANDEMONIUM ENGINE */
|
|
/* https://github.com/Relintai/pandemonium_engine */
|
|
/*************************************************************************/
|
|
/* Copyright (c) 2022-present Péter Magyar. */
|
|
/* Copyright (c) 2014-2022 Godot Engine contributors (cf. AUTHORS.md). */
|
|
/* Copyright (c) 2007-2022 Juan Linietsky, Ariel Manzur. */
|
|
/* */
|
|
/* 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. */
|
|
/*************************************************************************/
|
|
|
|
#include "prepared_statement.h"
|
|
|
|
#include "database_connection.h"
|
|
|
|
String PreparedStatement::get_sql() {
|
|
return _sql;
|
|
}
|
|
void PreparedStatement::set_sql(const String &p_sql) {
|
|
_sql = p_sql;
|
|
}
|
|
|
|
int PreparedStatement::get_current_column_index() const {
|
|
return _current_column_index;
|
|
}
|
|
void PreparedStatement::set_current_column_index(const int p_index) {
|
|
_current_column_index = p_index;
|
|
}
|
|
|
|
String PreparedStatement::next_column_name() {
|
|
return column_name(_current_column_index++);
|
|
}
|
|
String PreparedStatement::next_column_decltype() {
|
|
return column_decltype(_current_column_index++);
|
|
}
|
|
PreparedStatement::Type PreparedStatement::next_column_type() {
|
|
return column_type(_current_column_index++);
|
|
}
|
|
|
|
String PreparedStatement::next_column_database_name() {
|
|
return column_database_name(_current_column_index++);
|
|
}
|
|
String PreparedStatement::next_column_table_name() {
|
|
return column_table_name(_current_column_index++);
|
|
}
|
|
String PreparedStatement::next_column_origin_name() {
|
|
return column_origin_name(_current_column_index++);
|
|
}
|
|
|
|
Vector<uint8_t> PreparedStatement::next_column_blob() {
|
|
return column_blob(_current_column_index++);
|
|
}
|
|
float PreparedStatement::next_column_float() {
|
|
return column_float(_current_column_index++);
|
|
}
|
|
double PreparedStatement::next_column_double() {
|
|
return column_double(_current_column_index++);
|
|
}
|
|
int64_t PreparedStatement::next_column_int() {
|
|
return column_int(_current_column_index++);
|
|
}
|
|
int PreparedStatement::next_column_int64() {
|
|
return column_int64(_current_column_index++);
|
|
}
|
|
String PreparedStatement::next_column_text() {
|
|
return column_text(_current_column_index++);
|
|
}
|
|
Variant PreparedStatement::next_column_value() {
|
|
return column_value(_current_column_index++);
|
|
}
|
|
|
|
PreparedStatement::PreparedStatement() {
|
|
_current_column_index = 0;
|
|
}
|
|
|
|
PreparedStatement::~PreparedStatement() {
|
|
}
|
|
|
|
void PreparedStatement::_bind_methods() {
|
|
ClassDB::bind_method(D_METHOD("get_sql"), &PreparedStatement::get_sql);
|
|
ClassDB::bind_method(D_METHOD("set_sql"), &PreparedStatement::set_sql);
|
|
ADD_PROPERTY(PropertyInfo(Variant::STRING, "sql"), "set_sql", "get_sql");
|
|
|
|
ClassDB::bind_method(D_METHOD("get_expanded_sql"), &PreparedStatement::get_expanded_sql);
|
|
ClassDB::bind_method(D_METHOD("get_normalized_sql"), &PreparedStatement::get_normalized_sql);
|
|
|
|
// Binding
|
|
|
|
ClassDB::bind_method(D_METHOD("bind_blob", "index", "value"), &PreparedStatement::bind_blob);
|
|
ClassDB::bind_method(D_METHOD("bind_float", "index", "value"), &PreparedStatement::bind_float);
|
|
ClassDB::bind_method(D_METHOD("bind_double", "index", "value"), &PreparedStatement::bind_double);
|
|
ClassDB::bind_method(D_METHOD("bind_int", "index", "value"), &PreparedStatement::bind_int);
|
|
ClassDB::bind_method(D_METHOD("bind_int64", "index", "value"), &PreparedStatement::bind_int64);
|
|
ClassDB::bind_method(D_METHOD("bind_null", "index"), &PreparedStatement::bind_null);
|
|
ClassDB::bind_method(D_METHOD("bind_text", "index", "value"), &PreparedStatement::bind_text);
|
|
ClassDB::bind_method(D_METHOD("bind_zeroblob", "index", "num"), &PreparedStatement::bind_zeroblob);
|
|
ClassDB::bind_method(D_METHOD("bind_value", "index", "value"), &PreparedStatement::bind_value);
|
|
|
|
ClassDB::bind_method(D_METHOD("bind_parameter_index", "name"), &PreparedStatement::bind_parameter_index);
|
|
ClassDB::bind_method(D_METHOD("bind_parameter_name", "index"), &PreparedStatement::bind_parameter_name);
|
|
|
|
ClassDB::bind_method(D_METHOD("bind_parameter_count"), &PreparedStatement::bind_parameter_count);
|
|
|
|
ClassDB::bind_method(D_METHOD("clear_bindings"), &PreparedStatement::clear_bindings);
|
|
|
|
// Querying
|
|
|
|
ClassDB::bind_method(D_METHOD("column_name", "index"), &PreparedStatement::column_name);
|
|
ClassDB::bind_method(D_METHOD("column_decltype", "index"), &PreparedStatement::column_decltype);
|
|
ClassDB::bind_method(D_METHOD("column_type", "index"), &PreparedStatement::column_type);
|
|
|
|
ClassDB::bind_method(D_METHOD("column_database_name", "index"), &PreparedStatement::column_database_name);
|
|
ClassDB::bind_method(D_METHOD("column_table_name", "index"), &PreparedStatement::column_table_name);
|
|
ClassDB::bind_method(D_METHOD("column_origin_name", "index"), &PreparedStatement::column_origin_name);
|
|
|
|
ClassDB::bind_method(D_METHOD("column_blob", "index"), &PreparedStatement::column_blob);
|
|
ClassDB::bind_method(D_METHOD("column_float", "index"), &PreparedStatement::column_float);
|
|
ClassDB::bind_method(D_METHOD("column_double", "index"), &PreparedStatement::column_double);
|
|
ClassDB::bind_method(D_METHOD("column_int", "index"), &PreparedStatement::column_int);
|
|
ClassDB::bind_method(D_METHOD("column_int64", "index"), &PreparedStatement::column_int64);
|
|
ClassDB::bind_method(D_METHOD("column_text", "index"), &PreparedStatement::column_text);
|
|
ClassDB::bind_method(D_METHOD("column_value", "index"), &PreparedStatement::column_value);
|
|
|
|
ClassDB::bind_method(D_METHOD("column_count"), &PreparedStatement::column_count);
|
|
|
|
ClassDB::bind_method(D_METHOD("get_last_insert_rowid"), &PreparedStatement::get_last_insert_rowid);
|
|
|
|
|
|
ClassDB::bind_method(D_METHOD("get_current_column_index"), &PreparedStatement::get_current_column_index);
|
|
ClassDB::bind_method(D_METHOD("set_current_column_index", "index"), &PreparedStatement::set_current_column_index);
|
|
ADD_PROPERTY(PropertyInfo(Variant::INT, "current_column_index"), "set_current_column_index", "get_current_column_index");
|
|
|
|
ClassDB::bind_method(D_METHOD("next_column_name"), &PreparedStatement::next_column_name);
|
|
ClassDB::bind_method(D_METHOD("next_column_decltype"), &PreparedStatement::next_column_decltype);
|
|
ClassDB::bind_method(D_METHOD("next_column_type"), &PreparedStatement::next_column_type);
|
|
|
|
ClassDB::bind_method(D_METHOD("next_column_database_name"), &PreparedStatement::next_column_database_name);
|
|
ClassDB::bind_method(D_METHOD("next_column_table_name"), &PreparedStatement::next_column_table_name);
|
|
ClassDB::bind_method(D_METHOD("next_column_origin_name"), &PreparedStatement::next_column_origin_name);
|
|
|
|
ClassDB::bind_method(D_METHOD("next_column_blob"), &PreparedStatement::next_column_blob);
|
|
ClassDB::bind_method(D_METHOD("next_column_float"), &PreparedStatement::next_column_float);
|
|
ClassDB::bind_method(D_METHOD("next_column_double"), &PreparedStatement::next_column_double);
|
|
ClassDB::bind_method(D_METHOD("next_column_int"), &PreparedStatement::next_column_int);
|
|
ClassDB::bind_method(D_METHOD("next_column_int64"), &PreparedStatement::next_column_int64);
|
|
ClassDB::bind_method(D_METHOD("next_column_text"), &PreparedStatement::next_column_text);
|
|
ClassDB::bind_method(D_METHOD("next_column_value"), &PreparedStatement::next_column_value);
|
|
|
|
// Control
|
|
|
|
ClassDB::bind_method(D_METHOD("prepare"), &PreparedStatement::prepare);
|
|
ClassDB::bind_method(D_METHOD("step"), &PreparedStatement::step);
|
|
ClassDB::bind_method(D_METHOD("data_count"), &PreparedStatement::data_count);
|
|
ClassDB::bind_method(D_METHOD("reset"), &PreparedStatement::reset);
|
|
ClassDB::bind_method(D_METHOD("finalize"), &PreparedStatement::finalize);
|
|
|
|
ClassDB::bind_method(D_METHOD("get_connection"), &PreparedStatement::get_connection);
|
|
|
|
BIND_ENUM_CONSTANT(TYPE_NULL);
|
|
BIND_ENUM_CONSTANT(TYPE_BLOB);
|
|
BIND_ENUM_CONSTANT(TYPE_FLOAT);
|
|
BIND_ENUM_CONSTANT(TYPE_DOUBLE);
|
|
BIND_ENUM_CONSTANT(TYPE_INT);
|
|
BIND_ENUM_CONSTANT(TYPE_INT64);
|
|
BIND_ENUM_CONSTANT(TYPE_TEXT);
|
|
BIND_ENUM_CONSTANT(TYPE_VARCHAR);
|
|
BIND_ENUM_CONSTANT(TYPE_VALUE);
|
|
BIND_ENUM_CONSTANT(TYPE_BYTES);
|
|
BIND_ENUM_CONSTANT(TYPE_TYPE);
|
|
BIND_ENUM_CONSTANT(TYPE_UNKNOWN);
|
|
}
|