public void DocDB_MYSQL_XML() { WizardManager target = new WizardManager(); // TODO: Initialize to an appropriate value target.myDoc = new DocDbObject(); target.myDoc.CurExportor = new XmlExportor(); target.myDoc.TargetFile = "C:\\testOutputDBFile_FromMySql.xml"; target.myDoc.SourceDbType = CoreEA.CoreE.UsedDatabaseType.MySql; target.myDoc.LoginInfo = new LoginInfo_MySql() { Server = "localhost", Username = "******", Pwd = "noway", Database = "test", }; CoreEA.ICoreEAHander srcHandle = new CoreEA.CoreE(CoreEA.CoreE.UsedDatabaseType.MySql).X_Handler; srcHandle.Open(target.myDoc.LoginInfo); string usedTable = string.Empty; if (srcHandle.IsOpened) { usedTable = srcHandle.GetTableListInDatabase()[0]; } BaseTableSchema schema = srcHandle.GetTableSchemaInfoObject(usedTable); List <DBObject> testData = new List <DBObject>(); testData.Add(new DBObject() { TableName = schema.TableName, ColumnName = schema.Columns[0].ColumnName, Category = "Tets1", Description = "Test1", DbType = schema.Columns[0].ColumnType, Length = schema.Columns[0].CharacterMaxLength, OrdinaryPosition = schema.Columns[0].OrdinalPosition, }); testData.Add(new DBObject() { TableName = schema.TableName, ColumnName = schema.Columns[1].ColumnName, Category = "Tets2", DbType = schema.Columns[1].ColumnType, Length = schema.Columns[1].CharacterMaxLength, OrdinaryPosition = schema.Columns[1].OrdinalPosition, }); target.myDoc.DbObjectList = testData; bool result = target.Export(); Assert.IsTrue(result); }
public void DocDB_SqlServer_XML() { WizardManager target = new WizardManager(); // TODO: Initialize to an appropriate value target.myDoc = new DocDbObject(); target.myDoc.CurExportor = new XmlExportor(); target.myDoc.TargetFile = "C:\\testOutputDBFile_FromSqlServer.xml"; target.myDoc.SourceDbType = CoreEA.CoreE.UsedDatabaseType.SqlServer; List <string> tableList = new List <string>(); CoreEA.ICoreEAHander srcHandle = new CoreEA.CoreE(CoreEA.CoreE.UsedDatabaseType.SqlServer).X_Handler; srcHandle.Open(new CoreEA.LoginInfo.LoginInfo_SqlServer() { X_Server = "", X_UserName = "", X_Pwd = "", X_Database = "", IsTrustedConn = false, X_CurDbConnectionMode = CoreEA.Args.CurDbServerConnMode.SqlServer2000 }); if (srcHandle.IsOpened) { tableList = srcHandle.GetTableListInDatabase(); } tableList = tableList.Take(4).ToList(); string usedTable = tableList[0]; BaseTableSchema schema = srcHandle.GetTableSchemaInfoObject(usedTable); List <DBObject> testData = new List <DBObject>(); testData.Add(new DBObject() { TableName = schema.TableName, ColumnName = schema.Columns[0].ColumnName, Category = "Tets1", DbType = schema.Columns[0].ColumnType, Length = schema.Columns[0].CharacterMaxLength, OrdinaryPosition = schema.Columns[0].OrdinalPosition, }); target.myDoc.DbObjectList = testData; bool result = target.Export(); Assert.IsTrue(result); }
public void DocDB_SSCE_XML() { WizardManager target = new WizardManager(); // TODO: Initialize to an appropriate value target.myDoc = new DocDbObject(); target.myDoc.CurExportor = new XmlExportor(); target.myDoc.TargetFile = "C:\\testOutputDBFile_FromSqlce.xml"; target.myDoc.SourceDbType = CoreEA.CoreE.UsedDatabaseType.SqlCE35; target.myDoc.LoginInfo = new LoginInfo_SSCE() { DbName = GlobalInfo.SqlCE_TestFile, }; CoreEA.ICoreEAHander srcHandle = new CoreEA.CoreE(CoreEA.CoreE.UsedDatabaseType.SqlCE35).X_Handler; srcHandle.Open(target.myDoc.LoginInfo); string usedTable = string.Empty; if (srcHandle.IsOpened) { usedTable = srcHandle.GetTableListInDatabase()[0]; } //here we just test the first table BaseTableSchema schema = srcHandle.GetTableSchemaInfoObject(usedTable); List <DBObject> testData = new List <DBObject>(); foreach (var item in schema.Columns) { testData.Add(new DBObject() { TableName = schema.TableName, ColumnName = item.ColumnName, Category = "Column", Description = "", DbType = item.ColumnType, Length = item.CharacterMaxLength, OrdinaryPosition = item.OrdinalPosition, }); } target.myDoc.DbObjectList = testData; bool result = target.Export(); Assert.AreEqual(true, result); }