public static void Execute(IDbHost db)
{
var data = db.ExecuteTemplate <Test>(p =>
{
p.IntegerValue = 3;
});
Audit.Message("\n ** ALGORITHMS **");
foreach (var r in data.Algorithms)
{
Audit.Message($" {r.IdAlgorithm}, {r.Name}, {r.InvalidField}");
}
Audit.Message("\n ** USERS **");
foreach (var r in data.Users)
{
Audit.Message($" {r.IdUser}, {r.Name}");
}
}
public static void Load(IDbHost db)
{
Audit.Message("\n ** TABLES QUERY **");
var data = new SchemaTables("wikialgorithm").Exec(db);
foreach (var r in data.Tables)
{
Audit.Message($" Engine={r.Engine}, Table={r.TableName}, Type={r.TableType}, RowFormat={r.RowFormat}");
}
Audit.Message("\n ** COLUMNS QUERY **");
var columnsData = new SchemaColumns("wikialgorithm").Exec(db);
foreach (var c in columnsData.ColumnsList)
{
Audit.Message($" Table={c.TableName}, Column={c.ColumnName}, DataType={c.DataType}, ColumnType={c.ColumnType}, Nullable={c.IsNullable}, Key={c.ColumnKey}");
}
}