nwnx_sql.nss

Go to the documentation of this file.

#include "nwnx"
 
const string NWNX_SQL = "NWNX_SQL"; 
 
int NWNX_SQL_PrepareQuery(string query);
 
int NWNX_SQL_ExecutePreparedQuery();
 
int NWNX_SQL_ExecuteQuery(string query);
 
int NWNX_SQL_ReadyToReadNextRow();
 
void NWNX_SQL_ReadNextRow();
 
string NWNX_SQL_ReadDataInActiveRow(int column = 0);
 
void NWNX_SQL_PreparedInt(int position, int value);
 
void NWNX_SQL_PreparedString(int position, string value);
 
void NWNX_SQL_PreparedFloat(int position, float value);
 
void NWNX_SQL_PreparedObjectId(int position, object value);
 
void NWNX_SQL_PreparedObjectFull(int position, object value, int base64 = TRUE);
 
void NWNX_SQL_PreparedNULL(int position);
 
void NWNX_SQL_PreparedJson(int position, json value);
 
object NWNX_SQL_ReadFullObjectInActiveRow(int column = 0, object owner = OBJECT_INVALID, float x = 0.0, float y = 0.0, float z = 0.0, int base64 = TRUE);
 
int NWNX_SQL_GetAffectedRows();
 
string NWNX_SQL_GetDatabaseType();
 
void NWNX_SQL_DestroyPreparedQuery();
 
string NWNX_SQL_GetLastError();
 
int NWNX_SQL_GetPreparedQueryParamCount();
 
void NWNX_SQL_PostgreSQL_SetNextQueryResultsBinaryMode();
 
 
int NWNX_SQL_PrepareQuery(string query)
{
    string sFunc = "PrepareQuery";
 
    NWNX_PushArgumentString(query);
    NWNX_CallFunction(NWNX_SQL, sFunc);
    return NWNX_GetReturnValueInt();
}
 
int NWNX_SQL_ExecutePreparedQuery()
{
    string sFunc = "ExecutePreparedQuery";
 
    NWNX_CallFunction(NWNX_SQL, sFunc);
    return NWNX_GetReturnValueInt();
}
 
int NWNX_SQL_ExecuteQuery(string query)
{
    // Note: the implementation might change as support for more SQL targets arrives.
    if (NWNX_SQL_PrepareQuery(query))
    {
        int ret = NWNX_SQL_ExecutePreparedQuery();
        NWNX_SQL_DestroyPreparedQuery();
        return ret;
    }
 
    return FALSE;
}
 
int NWNX_SQL_ReadyToReadNextRow()
{
    string sFunc = "ReadyToReadNextRow";
 
    NWNX_CallFunction(NWNX_SQL, sFunc);
    return NWNX_GetReturnValueInt();
}
 
void NWNX_SQL_ReadNextRow()
{
    string sFunc = "ReadNextRow";
 
    NWNX_CallFunction(NWNX_SQL, sFunc);
}
 
string NWNX_SQL_ReadDataInActiveRow(int column = 0)
{
    string sFunc = "ReadDataInActiveRow";
 
    NWNX_PushArgumentInt(column);
    NWNX_CallFunction(NWNX_SQL, sFunc);
    return NWNX_GetReturnValueString();
}
 
 
void NWNX_SQL_PreparedInt(int position, int value)
{
    string sFunc = "PreparedInt";
 
    NWNX_PushArgumentInt(value);
    NWNX_PushArgumentInt(position);
    NWNX_CallFunction(NWNX_SQL, sFunc);
}
void NWNX_SQL_PreparedString(int position, string value)
{
    string sFunc = "PreparedString";
 
    NWNX_PushArgumentString(value);
    NWNX_PushArgumentInt(position);
    NWNX_CallFunction(NWNX_SQL, sFunc);
}
void NWNX_SQL_PreparedFloat(int position, float value)
{
    string sFunc = "PreparedFloat";
 
    NWNX_PushArgumentFloat(value);
    NWNX_PushArgumentInt(position);
    NWNX_CallFunction(NWNX_SQL, sFunc);
}
void NWNX_SQL_PreparedObjectId(int position, object value)
{
    string sFunc = "PreparedObjectId";
 
    NWNX_PushArgumentObject(value);
    NWNX_PushArgumentInt(position);
    NWNX_CallFunction(NWNX_SQL, sFunc);
}
void NWNX_SQL_PreparedObjectFull(int position, object value, int base64 = TRUE)
{
    string sFunc = "PreparedObjectFull";
 
    NWNX_PushArgumentInt(base64);
    NWNX_PushArgumentObject(value);
    NWNX_PushArgumentInt(position);
    NWNX_CallFunction(NWNX_SQL, sFunc);
}
void NWNX_SQL_PreparedNULL(int position)
{
    string sFunc = "PreparedNULL";
 
    NWNX_PushArgumentInt(position);
    NWNX_CallFunction(NWNX_SQL, sFunc);
}
void NWNX_SQL_PreparedJson(int position, json value)
{
    // Dump to string and continue as a string from here.
    // Famously assuming we're sent valid Json here.
    NWNX_SQL_PreparedString(position, JsonDump(value));
}
 
 
object NWNX_SQL_ReadFullObjectInActiveRow(int column = 0, object owner = OBJECT_INVALID, float x = 0.0, float y = 0.0, float z = 0.0, int base64 = TRUE)
{
    string sFunc = "ReadFullObjectInActiveRow";
 
    NWNX_PushArgumentInt(base64);
    NWNX_PushArgumentFloat(z);
    NWNX_PushArgumentFloat(y);
    NWNX_PushArgumentFloat(x);
    NWNX_PushArgumentObject(owner);
    NWNX_PushArgumentInt(column);
    NWNX_CallFunction(NWNX_SQL, sFunc);
    return NWNX_GetReturnValueObject();
}
 
int NWNX_SQL_GetAffectedRows()
{
    string sFunc = "GetAffectedRows";
 
    NWNX_CallFunction(NWNX_SQL, sFunc);
    return NWNX_GetReturnValueInt();
}
 
string NWNX_SQL_GetDatabaseType()
{
    string sFunc = "GetDatabaseType";
 
    NWNX_CallFunction(NWNX_SQL, sFunc);
    return NWNX_GetReturnValueString();
}
 
void NWNX_SQL_DestroyPreparedQuery()
{
    string sFunc = "DestroyPreparedQuery";
 
    NWNX_CallFunction(NWNX_SQL, sFunc);
}
 
string NWNX_SQL_GetLastError()
{
    string sFunc = "GetLastError";
 
    NWNX_CallFunction(NWNX_SQL, sFunc);
    return NWNX_GetReturnValueString();
}
 
int NWNX_SQL_GetPreparedQueryParamCount()
{
    string sFunc = "GetPreparedQueryParamCount";
 
    NWNX_CallFunction(NWNX_SQL, sFunc);
    return NWNX_GetReturnValueInt();
}
 
void NWNX_SQL_PostgreSQL_SetNextQueryResultsBinaryMode()
{
    string sFunc = "PostgreSQL_SetNextQueryResultsBinaryMode";
 
    NWNX_CallFunction(NWNX_SQL, sFunc);
}