public void ExecuteTest() { using (FileLogger l = new FileLogger("MdbContextTest", new FileLogSettings() { DateFolderMask = "yyyy-MM-dd" })) { MdbContextOptions.GetOptions().CommandTimeout = 120; using (var ctx = new MdbContext(_cn)) { l.Debug("Test 1 Start "); int i = 0; string sql = @"Create Table TestTable( ID uniqueidentifier not null primary key, Name varchar(128) not null, DateOper datetime not null, Notes varchar(256) null, Handle int not null)" ; i = ctx.Execute(sql); l.Debug($"Test 1 Finish rows result {i}"); l.Debug("Test 2 Start "); sql = @"Insert Into TestTable (ID, Name, DateOper, Handle) Values(@ID, @Name, @DateOper, @Handle)" ; i = 0; for (; i < 1000; i++) { ctx.Execute(sql, new MdbParameter("@ID", Guid.NewGuid()), new MdbParameter("@Name", "Тестовая строка № " + i.ToString()), new MdbParameter("@DateOper", vbo.Date().AddDays(i - 1000)), new MdbParameter("@Handle", i) { NullIfEmpty = false });; } l.Debug($"Test 2 Finish rows result {i}"); l.Debug("Test 3 Start "); i = 0; using (var dr = ctx.GetReader("Select * From TestTable Order By Handle")) { for (; dr.Read(); i++) { l.Debug(dr.GetRowJSON()); } } l.Debug($"Test 3 Finish rows result {i}"); l.Debug("Test 4 Start "); sql = "Drop Table TestTable"; i = ctx.Execute(sql); l.Debug($"Test 4 Finish rows result {i}"); } } }
private void SpeedGetHashCodeTest() { using (MdbContext mdb = new MdbContext(_ci)) { //string s1 = mdb.Execute<string>("SysCat.Get_TableSchema_xml", // new MdbParameter("@table_name", "dbo.OrderDetails")); //_logger.Debug(s1); //_logger.Debug(JMXSchema.ParseXml(s1).ToString()); //s1 = mdb.Execute<string>("SysCat.Get_TableSchema", // new MdbParameter("@table_name", "dbo.Orders")); //_logger.Debug(s1); //_logger.Debug("Start speed test for SysCat.Get_TableSchema_xml"); //for (int i = 0; i < 100; i++) //{ // s1 = mdb.Execute<string>("SysCat.Get_TableSchema_xml", // new MdbParameter("@table_name", "dbo.OrderDetails")); // var schema = JMXSchema.ParseXml(s1); //} //_logger.Debug("End speed test for SysCat.Get_TableSchema_xml"); _logger.LogDebug("Start speed test for SysCat.Get_TableSchema"); for (int i = 0; i < 100; i++) { var s1 = mdb.Execute <string>("SysCat.Get_TableSchema", new MdbParameter("@table_name", "dbo.OrderDetails")); var schema = JMXSchema.Parse(s1); } _logger.LogDebug("End speed test for SysCat.Get_TableSchema"); } }
static void dropTestTable(MdbContext ctx, FileLogger l) { l.Debug("Drop Test Table Start"); int i = 0; string sql = @"Drop Table TestTable"; i = ctx.Execute(sql); l.Debug($"Drop Test Table Finish rows result {i}"); }
private static JObject GetSchema(string dbObjectName) { using (MdbContext mdb = new MdbContext(connection_string)) { string s = mdb.Execute <string>(@"[HQ\SVOSTRIKOV].Get_TableSchema", new MdbParameter("@table_name", dbObjectName)); return(JObject.Parse(s)); } }
public SysCatManager(MdbContext context) { context.NullTest(nameof(context)); _mdb = context; _log = _mdb.Logger; if (_defaultDbSchema.IsEmpty()) { _defaultDbSchema = _mdb.Execute <string>(SQLCat.GetCatalog(_mdb.ProviderName)["GetDefaultSchema"]); } }
static void createTestTable(MdbContext ctx, FileLogger l) { l.Debug("Create Test Table Start"); int i = 0; string sql = @"Create Table TestTable( ID uniqueidentifier not null primary key, Name varchar(128) not null, DateOper datetime not null, Notes varchar(256) null, Handle int not null)" ; ctx.BeginTransaction(); i = ctx.Execute(sql); ctx.Commit(); }
public void speedGetHashCodeTest() { using (FileLogger _logger = new FileLogger("ORMDBTest", new FileLogSettings() { DateFolderMask = "yyyy-MM-dd" })) { using (MdbContext mdb = new MdbContext(_cn)) { string s1 = mdb.Execute <string>("SysCat.Get_TableSchema_xml", new MdbParameter("@table_name", "dbo.OrderDetails")); _logger.Debug(s1); _logger.Debug(JMXSchema.ParseXml(s1).ToString()); s1 = mdb.Execute <string>("SysCat.Get_TableSchema", new MdbParameter("@table_name", "dbo.Orders")); _logger.Debug(s1); _logger.Debug("Start speed test for SysCat.Get_TableSchema_xml"); for (int i = 0; i < 100; i++) { s1 = mdb.Execute <string>("SysCat.Get_TableSchema_xml", new MdbParameter("@table_name", "dbo.OrderDetails")); var schema = JMXSchema.ParseXml(s1); } _logger.Debug("End speed test for SysCat.Get_TableSchema_xml"); _logger.Debug("Start speed test for SysCat.Get_TableSchema"); for (int i = 0; i < 100; i++) { s1 = mdb.Execute <string>("SysCat.Get_TableSchema", new MdbParameter("@table_name", "dbo.OrderDetails")); var schema = JMXSchema.Parse(s1); } _logger.Debug("End speed test for SysCat.Get_TableSchema"); } } }
static void insertTestTable(MdbContext ctx, FileLogger l) { l.Debug("Insert Test Table Start"); string sql = @"Insert Into TestTable (ID, Name, DateOper, Handle) Values(@ID, @Name, @DateOper, @Handle)" ; ctx.BeginTransaction(); int i = 0; for (; i < 100; i++) { ctx.Execute(sql, new MdbParameter("@ID", Guid.NewGuid()), new MdbParameter("@Name", "Тестовая строка № " + i.ToString()), new MdbParameter("@DateOper", vbo.Date().AddDays(i - 1000)), new MdbParameter("@Handle", i) { NullIfEmpty = false });; } ctx.Commit(); l.Debug($"Insert Test Table Finish rows result {i}"); }