Exemplo n.º 1
0
        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}");
            }
        }
Exemplo n.º 2
0
        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}");
            }
        }