public static string GetMessageErrorSqlService(TableSql tableSql, string table, string errorMessage)
{
string interactionTable;
switch (tableSql)
{
case TableSql.Insert:
interactionTable = "insert";
break;
case TableSql.Select:
interactionTable = "select";
break;
case TableSql.Update:
interactionTable = "update";
break;
case TableSql.Delete:
interactionTable = "Delete";
break;
default: throw new ArgumentOutOfRangeException(nameof(tableSql), tableSql, null);
}
return(string.Format($"Error {interactionTable} table {table}: {errorMessage}"));
}
public void ClassToSqlTest()
{
User user = new User();
TableSql a = NameConverter.GetTableSql(user);
System.Console.WriteLine(a.TableName);
foreach (var p in a.ColumnList)
{
System.Console.WriteLine(p);
}
}
public void TableSqltoClassTest()
{
TableSql t = new TableSql();
t.TableName = "user";
string type = NameConverter.ToCsharp(t.TableName);
// object keepo = Activator.CreateInstance(Type.GetType("ORM."+type));
var myObj = Activator.CreateInstance(Type.GetType("TestsORM" + "." + type)); // namespace + type
Type test = myObj.GetType();
var u = NameConverter.GetClassCsharp <object>(t);
System.Console.WriteLine(u.GetType());
}
public SqliteServiceException(TableSql tableSql, string table, string errorMessage) : base(
EnumsService.GetMessageErrorSqlService(tableSql, table, errorMessage))
{
}
public SqliteServiceException(TableSql tableSql, string table, Exception innerException) : base(
EnumsService.GetMessageErrorSqlService(tableSql, table, innerException.Message))
{
}
private async Task InitializeDb()
{
try
{
var tables = new TableSql();
await using var conn = SimpleDbConnection();
await conn.OpenAsync();
Log.Debug("Create Settings Table");
await conn.ExecuteAsync(tables.Settings);
Log.Debug("Create FileData Table");
await conn.ExecuteAsync(tables.FileData);
Log.Debug("Create TemplateCategory Table");
await conn.ExecuteAsync(tables.TemplateCategory);
Log.Debug("Create Template Table");
await conn.ExecuteAsync(tables.Templates);
Log.Debug("Create TemplateFields Table");
await conn.ExecuteAsync(tables.TemplateFields);
Log.Debug("Create TableCategory Table");
await conn.ExecuteAsync(tables.TableCategory);
Log.Debug("Create RandomTable Table");
await conn.ExecuteAsync(tables.RandomTables);
Log.Debug("Create TableEntry Table");
await conn.ExecuteAsync(tables.TableEntry);
Log.Debug("Create Section Table");
await conn.ExecuteAsync(tables.Sections);
Log.Debug("Create Page Table");
await conn.ExecuteAsync(tables.Pages);
Log.Debug("Create MapPage Table");
await conn.ExecuteAsync(tables.MapPages);
Log.Debug("Create MapMarker Table");
await conn.ExecuteAsync(tables.MapMarkers);
Log.Debug("Create Tag Table");
await conn.ExecuteAsync(tables.Tag);
Log.Debug("Create TagMap Table");
await conn.ExecuteAsync(tables.TagMap);
Log.Debug("Settings DB version to 1");
var version = new Setting {
Name = "version", Value = "1"
};
await conn.InsertAsync(version);
await conn.CloseAsync();
}
catch (Exception ex)
{
Log.Error(ex, "Exception initializing database!");
throw;
}
}