/// <summary>
/// Returns result of SQLite database query as 2d string array.
/// </summary>
/// <param name="query">SQLite query to be executed.</param>
/// <param name="columns">Number of columns returned by query.</param>
/// <returns></returns>
public static async Task <SqlPacket> GetDataAs2DArray(string query, int columns)
{
Setup();
List <string[]> outerList = new List <string[]>();
bool readData = false;
using (DatabaseThreadWatcher _ = new DatabaseThreadWatcher())
{
#pragma warning disable CA2100 // Review SQL queries for security vulnerabilities
// Is secure: only main server instances can access the database server.
// SQL Injection checks are running on main server.
sqlCommand.CommandText = query;
#pragma warning restore CA2100 // Review SQL queries for security vulnerabilities
try
{
await sqlCommand.ExecuteNonQueryAsync();
}
catch (DbException ex)
{
return(SqlPacket.Create(null, false, MainServer.Config.DebuggingEnabled ? "Error: '" + ex.ToString() + "'\nTried to execute the following query: \'" + query + "\'" : string.Empty));
}
using SQLiteDataReader reader = (SQLiteDataReader) await sqlCommand.ExecuteReaderAsync();
while (reader.Read())
{
try
{
string[] row = new string[columns];
for (int i = 0; i < columns; i++)
{
if (!readData)
{
readData = true;
}
row[i] = reader[i].ToString();
}
outerList.Add(row);
}
catch (IndexOutOfRangeException outOfRange)
{
return(SqlPacket.Create(null, false, MainServer.Config.DebuggingEnabled ? "Error 'Reader out of range' occurred: '" + outOfRange.ToString() + "'\nTried to execute the following query: \'" + query + "\'" : string.Empty));
}
}
}
return(SqlPacket.Create(readData ? outerList.ToArray() : Array.Empty <string[]>()));
}
/// <summary>
/// Executes a SQLite query to manipulate data.
/// </summary>
/// <param name="query">SQLite query to be executed.</param>
/// <returns></returns>
public static async Task <SqlPacket> ModifyData(string query)
{
Setup();
using DatabaseThreadWatcher _ = new DatabaseThreadWatcher();
#pragma warning disable CA2100 // Review SQL queries for security vulnerabilities
// Is secure: only main server instances can access the database server.
// SQL Injection checks are running on main server.
sqlCommand.CommandText = query;
#pragma warning restore CA2100 // Review SQL queries for security vulnerabilities
try
{
int i = await sqlCommand.ExecuteNonQueryAsync();
return(SqlPacket.Create(i));
}
catch (DbException ex)
{
return(SqlPacket.Create(null, false, MainServer.Config.DebuggingEnabled ? "Error: '" + ex.ToString() + "'\nTried to execute the following query: \'" + query + "\'" : string.Empty));
}
}
/// <summary>
/// Returns result of SQLite database query as string or empty string if the query returns nothing.
/// </summary>
/// <param name="query">SQLite query to be executed.</param>
/// <returns></returns>
public static async Task <SqlPacket> GetSingleOrDefault(string query)
{
Setup();
string returnData = string.Empty;
using (DatabaseThreadWatcher _ = new DatabaseThreadWatcher())
{
#pragma warning disable CA2100 // Review SQL queries for security vulnerabilities
// Is secure: only main server instances can access the database server.
// SQL Injection checks are running on main server.
sqlCommand.CommandText = query;
#pragma warning restore CA2100 // Review SQL queries for security vulnerabilities
try
{
await sqlCommand.ExecuteNonQueryAsync();
}
catch (DbException ex)
{
return(SqlPacket.Create(null, false, MainServer.Config.DebuggingEnabled ? "Error: '" + ex.ToString() + "'\nTried to execute the following query: \'" + query + "\'" : string.Empty));
}
using SQLiteDataReader reader = (SQLiteDataReader) await sqlCommand.ExecuteReaderAsync();
while (reader.Read())
{
try
{
returnData = reader[0].ToString();
break;
}
catch (IndexOutOfRangeException outOfRange)
{
return(SqlPacket.Create(null, false, MainServer.Config.DebuggingEnabled ? "Error 'Reader out of range' occurred: '" + outOfRange.ToString() + "'\nTried to execute the following query: \'" + query + "\'" : string.Empty));
}
}
}
return(SqlPacket.Create(returnData));
}
