nwnx_sql.nss

Go to the documentation of this file.

 
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)
{
    NWNXPushString(query);
    NWNXCall(NWNX_SQL, "PrepareQuery");
    return NWNXPopInt();
}
 
int NWNX_SQL_ExecutePreparedQuery()
{
    NWNXCall(NWNX_SQL, "ExecutePreparedQuery");
    return NWNXPopInt();
}
 
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()
{
    NWNXCall(NWNX_SQL, "ReadyToReadNextRow");
    return NWNXPopInt();
}
 
void NWNX_SQL_ReadNextRow()
{
    NWNXCall(NWNX_SQL, "ReadNextRow");
}
 
string NWNX_SQL_ReadDataInActiveRow(int column = 0)
{
    NWNXPushInt(column);
    NWNXCall(NWNX_SQL, "ReadDataInActiveRow");
    return NWNXPopString();
}
 
 
void NWNX_SQL_PreparedInt(int position, int value)
{
    NWNXPushInt(value);
    NWNXPushInt(position);
    NWNXCall(NWNX_SQL, "PreparedInt");
}
void NWNX_SQL_PreparedString(int position, string value)
{
    NWNXPushString(value);
    NWNXPushInt(position);
    NWNXCall(NWNX_SQL, "PreparedString");
}
void NWNX_SQL_PreparedFloat(int position, float value)
{
    NWNXPushFloat(value);
    NWNXPushInt(position);
    NWNXCall(NWNX_SQL, "PreparedFloat");
}
void NWNX_SQL_PreparedObjectId(int position, object value)
{
    NWNXPushObject(value);
    NWNXPushInt(position);
    NWNXCall(NWNX_SQL, "PreparedObjectId");
}
void NWNX_SQL_PreparedObjectFull(int position, object value, int base64 = TRUE)
{
    NWNXPushInt(base64);
    NWNXPushObject(value);
    NWNXPushInt(position);
    NWNXCall(NWNX_SQL, "PreparedObjectFull");
}
void NWNX_SQL_PreparedNULL(int position)
{
    NWNXPushInt(position);
    NWNXCall(NWNX_SQL, "PreparedNULL");
}
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)
{
    NWNXPushInt(base64);
    NWNXPushFloat(z);
    NWNXPushFloat(y);
    NWNXPushFloat(x);
    NWNXPushObject(owner);
    NWNXPushInt(column);
    NWNXCall(NWNX_SQL, "ReadFullObjectInActiveRow");
    return NWNXPopObject();
}
 
int NWNX_SQL_GetAffectedRows()
{
    NWNXCall(NWNX_SQL, "GetAffectedRows");
    return NWNXPopInt();
}
 
string NWNX_SQL_GetDatabaseType()
{
    NWNXCall(NWNX_SQL, "GetDatabaseType");
    return NWNXPopString();
}
 
void NWNX_SQL_DestroyPreparedQuery()
{
    NWNXCall(NWNX_SQL, "DestroyPreparedQuery");
}
 
string NWNX_SQL_GetLastError()
{
    NWNXCall(NWNX_SQL, "GetLastError");
    return NWNXPopString();
}
 
int NWNX_SQL_GetPreparedQueryParamCount()
{
    NWNXCall(NWNX_SQL, "GetPreparedQueryParamCount");
    return NWNXPopInt();
}
 
void NWNX_SQL_PostgreSQL_SetNextQueryResultsBinaryMode()
{
    NWNXCall(NWNX_SQL, "PostgreSQL_SetNextQueryResultsBinaryMode");
}