static void DoDatabaseCall(ParameterisedQuery query, string sql, bool createDB,
DataTable results, ReaderCallback callback, params object[] args)
{
BindParams(query, args);
string connString = Backend.ConnectionString;
Exception e = null;
for (int i = 0; i < 10; i++)
{
try {
if (callback != null)
{
query.ExecuteReader(sql, connString, callback);
}
else if (results == null)
{
query.Execute(sql, connString, createDB);
}
else
{
query.Fill(sql, connString, results);
}
query.ClearParams();
return;
} catch (Exception ex) {
e = ex; // try yet again
}
}
File.AppendAllText("MySQL_error.log", DateTime.Now + " " + sql + "\r\n");
Server.ErrorLog(e);
}
public static DataTable fillData(ParameterisedQuery query, string queryString, bool skipError = false)
{
using (DataTable results = new DataTable("toReturn")) {
Exception e = null;
for (int i = 0; i < 10; i++)
{
try {
query.Fill(queryString, results);
query.ClearParams();
return(results);
} catch (Exception ex) {
e = ex; // try yet again
}
}
if (skipError)
{
return(results);
}
File.AppendAllText("MySQL_error.log", DateTime.Now + " " + queryString + "\r\n");
Server.ErrorLog(e);
query.ClearParams();
return(results);
}
}
internal static DataTable Fill(ParameterisedQuery query, string sql, params object[] args)
{
using (DataTable results = new DataTable("toReturn")) {
DoDatabaseCall(query, sql, false, results, null, args);
return(results);
}
}
static void BindParams(ParameterisedQuery query, object[] args)
{
if (args == null || args.Length == 0)
{
return;
}
string[] names = GetParamNames(args.Length);
for (int i = 0; i < args.Length; i++)
{
query.AddParam(names[i], args[i]);
}
}
public static void executeQuery(ParameterisedQuery query, string queryString, bool createDB = false)
{
Exception e = null;
for (int i = 0; i < 10; i++)
{
try {
query.Execute(queryString, createDB);
query.ClearParams();
return;
} catch (Exception ex) {
e = ex; // try yet again
}
}
File.AppendAllText("MySQL_error.log", DateTime.Now + " " + queryString + "\r\n");
Server.ErrorLog(e);
query.ClearParams();
}
internal static void Execute(ParameterisedQuery query, string sql, bool createDB, params object[] args)
{
DoDatabaseCall(query, sql, createDB, null, null, args);
}
public static DataTable Fill(string sql, params object[] args)
{
ParameterisedQuery query = Backend.CreateParameterised();
return(Fill(query, sql, args));
}
public static DataTable Fill(string sql)
{
ParameterisedQuery query = Backend.GetStaticParameterised();
return(Fill(query, sql, null));
}
public static DataTable fillData(string sql, bool skipError = false)
{
ParameterisedQuery query = Backend.GetStaticParameterised();
return(Fill(query, sql, null));
}
public static void ExecuteReader(string sql, ReaderCallback callback, params object[] args)
{
ParameterisedQuery query = Backend.CreateParameterised();
DoDatabaseCall(query, sql, false, null, callback, args);
}
public static void Execute(string sql, params object[] args)
{
ParameterisedQuery query = Backend.CreateParameterised();
Execute(query, sql, false, args);
}
public static void Execute(string sql)
{
ParameterisedQuery query = Backend.GetStaticParameterised();
Execute(query, sql, false, null);
}
public static void executeQuery(string sql, bool createDB = false)
{
ParameterisedQuery query = Backend.GetStaticParameterised();
Execute(query, sql, createDB, null);
}
public override void CreateDatabase()
{
ParameterisedQuery query = GetStaticParameterised();
Database.Execute(query, "CREATE DATABASE if not exists `" + Server.MySQLDatabaseName + "`", true);
}
