private static void ExportToXml() { var con = new MySQLWrapper("dbc_406", false); var areatable = con.ExecuteGetDataTable("select * from areatable"); var areatableList = new List<AreaTable>(); foreach (System.Data.DataRow row in areatable.Rows) { areatableList.Add(new AreaTable() { Id = int.Parse(row[0].ToString()), MapId = int.Parse(row[1].ToString()), ZoneId = int.Parse(row[2].ToString()), Name = row[11].ToString() }); } using (var sw = new System.IO.StreamWriter("AreaTable.xml")) { sw.Write(areatableList.ToXml()); } var map = con.ExecuteGetDataTable("select * from map"); var mapList = new List<Map>(); foreach (System.Data.DataRow row in map.Rows) { mapList.Add(new Map() { Id = int.Parse(row[0].ToString()), Name = row[1].ToString(), LongName = row[6].ToString() }); } using (var sw = new System.IO.StreamWriter("Map.xml")) { sw.Write(mapList.ToXml()); } var gameobjectdisplayinfo = con.ExecuteGetDataTable("select * from gameobjectdisplayinfo"); var gameobjectdisplayinfoList = new List<GameObjectDisplayInfo>(); foreach (System.Data.DataRow row in gameobjectdisplayinfo.Rows) { gameobjectdisplayinfoList.Add(new GameObjectDisplayInfo() { Id = int.Parse(row[0].ToString()), FileName = row[1].ToString(), }); } using (var sw = new System.IO.StreamWriter("GameObjectDisplayInfo.xml")) { sw.Write(gameobjectdisplayinfoList.ToXml()); } }
private static void ExportToSQLite() { var con = new MySQLWrapper("dbc_406", false); // Basic connection using (var consql = new SQLiteConnection()) { var filename = "maximusradar.db"; if (System.IO.File.Exists(filename)) System.IO.File.Delete(filename); consql.ConnectionString = "Data Source=" + filename; consql.Open(); //create tables using (var command = new SQLiteCommand(consql)) { command.CommandText = "CREATE TABLE IF NOT EXISTS AreaTable ( id INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, MapId INTEGER NOT NULL, ZoneId INTEGER NOT NULL, Name VARCHAR(100) NOT NULL);"; command.ExecuteNonQuery(); command.CommandText = "CREATE TABLE IF NOT EXISTS Map ( id INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, Name VARCHAR(100) NOT NULL, LongName VARCHAR(100) NOT NULL);"; command.ExecuteNonQuery(); command.CommandText = "CREATE TABLE IF NOT EXISTS GameObjectDisplayInfo ( id INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, FileName VARCHAR(100) NOT NULL);"; command.ExecuteNonQuery(); } //AreaTable using (var trans = consql.BeginTransaction()) { using (var command = consql.CreateCommand()) { command.CommandText = "insert into AreaTable (id, MapId, ZoneId, Name) VALUES (?,?,?,?);"; var id = command.CreateParameter(); id.DbType = System.Data.DbType.Int32; command.Parameters.Add(id); var MapId = command.CreateParameter(); MapId.DbType = System.Data.DbType.Int32; command.Parameters.Add(MapId); var ZoneId = command.CreateParameter(); ZoneId.DbType = System.Data.DbType.Int32; command.Parameters.Add(ZoneId); var Name = command.CreateParameter(); Name.DbType = System.Data.DbType.String; command.Parameters.Add(Name); var table = con.ExecuteGetDataTable("select * from areatable"); foreach (System.Data.DataRow row in table.Rows) { try { id.Value = int.Parse(row[0].ToString()); MapId.Value = int.Parse(row[1].ToString()); ZoneId.Value = int.Parse(row[2].ToString()); Name.Value = row[11].ToSQLite(); if (command.ExecuteNonQuery() <= 0) { throw new Exception("record not inserted?"); } } catch (Exception exc) { Console.WriteLine("Error: {0}", exc.Message); } } } trans.Commit(); } //Map using (var trans = consql.BeginTransaction()) { using (var command = consql.CreateCommand()) { command.CommandText = "insert into Map (id, Name, LongName) VALUES (?,?,?)"; var id = command.CreateParameter(); id.DbType = System.Data.DbType.Int32; command.Parameters.Add(id); var Name = command.CreateParameter(); Name.DbType = System.Data.DbType.String; command.Parameters.Add(Name); var LongName = command.CreateParameter(); LongName.DbType = System.Data.DbType.String; command.Parameters.Add(LongName); var table = con.ExecuteGetDataTable("select * from map"); foreach (System.Data.DataRow row in table.Rows) { try { id.Value = int.Parse(row[0].ToString()); Name.Value = row[1].ToSQLite(); LongName.Value = row[2].ToSQLite(); if (command.ExecuteNonQuery() <= 0) { throw new Exception("record not inserted?"); } } catch (Exception exc) { Console.WriteLine("Error: {0}", exc.Message); } } } trans.Commit(); } //GameObjectDisplayInfo using (var trans = consql.BeginTransaction()) { using (var command = consql.CreateCommand()) { command.CommandText = "insert into GameObjectDisplayInfo (id, FileName) VALUES (?,?)"; var id = command.CreateParameter(); id.DbType = System.Data.DbType.Int32; command.Parameters.Add(id); var FileName = command.CreateParameter(); FileName.DbType = System.Data.DbType.String; command.Parameters.Add(FileName); var table = con.ExecuteGetDataTable("select * from gameobjectdisplayinfo"); foreach (System.Data.DataRow row in table.Rows) { try { id.Value = int.Parse(row[0].ToString()); FileName.Value = row[1].ToSQLite(); if (command.ExecuteNonQuery() <= 0) { throw new Exception("record not inserted?"); } } catch (Exception exc) { Console.WriteLine("Error: {0}", exc.Message); } } } trans.Commit(); } } }