async Task DropDBSchemaTestAsync()
{
using (FileLogger _logger = new FileLogger("ORMDBTest", new FileLogSettings()
{
DateFolderMask = "yyyy-MM-dd"
}))
{
JMXSchemaProviderDB p = JMXSchemaProviderFactory.GetProvider <JMXSchemaProviderDB>(_cn, _logger);
await p.ClearCatalogAsync();
}
}
async Task SaveSchemaTestAsync()
{
using (FileLogger _logger = new FileLogger("ORMDBTest", new FileLogSettings()
{
DateFolderMask = "yyyy-MM-dd"
}))
{
JMXSchemaProviderDB p = JMXSchemaProviderFactory.GetProvider <JMXSchemaProviderDB>(_cn, _logger);
foreach (var s in GetTestSchemas())
{
await p.SaveSchemaAsync(s);
}
}
}
public async Task SyncSchemaTestAsync()
{
using (FileLogger _logger = new FileLogger("ORMDBTest", new FileLogSettings()
{
DateFolderMask = "yyyy-MM-dd"
}))
{
JMXSchemaProviderDB p = JMXSchemaProviderFactory.GetProvider <JMXSchemaProviderDB>(_cn, _logger);
//foreach( string s in getTestNames())
// await p.SyncSchemaAsync(s);
//await p.SyncSchemaAsync("dbo.SysDataTypesRow");
await p.SyncSchemaAsync("dbo.Order");
await p.SyncSchemaAsync("dbo.OrderDetail");
}
}
public void Test1()
{
using (FileLogger _logger = new FileLogger("ORMDBTest", new FileLogSettings()
{
DateFolderMask = "yyyy-MM-dd"
}))
{
JMXSchemaProviderDB p = JMXSchemaProviderFactory.GetProvider <JMXSchemaProviderDB>(_cn, _logger);
//_logger.Debug("Start speed test for obtain JMXSchemaProviderDB");
//for (int i = 0; i < 150000; i++)
// p.GetSchema("dbo.SysSequence");
//// p = JMXSchemaProviderFactory.GetProvider<JMXSchemaProviderDB>(_cn, _logger);
//_logger.Debug("End speed test for obtain JMXSchemaProviderDB");
//_logger.Debug(p.GetSchema("dbo.SysSequence"));
}
}
async Task ChangeSchemaTestAsync()
{
using (FileLogger _logger = new FileLogger("ORMDBTest", new FileLogSettings()
{
DateFolderMask = "yyyy-MM-dd"
}))
{
JMXSchemaProviderDB p = JMXSchemaProviderFactory.GetProvider <JMXSchemaProviderDB>(_cn, _logger);
var schema = await p.GetSchemaAsync("dbo.SysDataTypesRow");
//schema.DbObjectName = new JMXObjectName("dbo", "SDTRs");
schema.Attributes[12].Width = 512;
await p.SaveSchemaAsync(schema);
await p.SyncSchemaAsync("dbo.SysDataTypesRow");
}
}
