/// <summary> /// Clears the database /// </summary> /// <param name="conn"></param> public static void ClearDatabase(DatabaseConnection conn) { MySqlCommand cmd = new MySqlCommand(); cmd.Connection = conn.getConnection(); cmd.CommandText = @"DELETE FROM track_segments"; cmd.ExecuteNonQuery(); }
public void runQuery(DatabaseConnection db_connection, MySqlCommand cmd) { try { db_connection.openConnection(); MySqlDataReader reader = cmd.ExecuteReader(); string row = null; while (reader.Read()) { for (int i = 0; i < reader.FieldCount; i++) { row += reader.GetValue(i).ToString(); } Console.WriteLine(row); } } catch (MySqlException ex) { Console.WriteLine("Error: {0}", ex.ToString()); } finally { if (db_connection != null) { db_connection.closeConnection(); } } }
public void databaseConnected() { DatabaseConnection connection = new DatabaseConnection( "andrew.cs.fit.edu", 3306, "signalblockdesign", "signalblockdesig", "E2SnzbV922m6R51"); bool connected = false; connection.openConnection(); connected = true; Assert.True(connected); }
public void closeDatabaseConnection() { bool isClosed = false; DatabaseConnection connection = new DatabaseConnection( "andrew.cs.fit.edu", 3306, "signalblockdesign", "signalblockdesig", "E2SnzbV922m6R51"); connection.openConnection(); connection.closeConnection(); isClosed = true; Assert.True(isClosed); }
public static void removeFromDatabase(DatabaseConnection conn, Query q, TrackSegment obj) { MySqlCommand cmd = new MySqlCommand(); cmd.CommandText = @"Delete from track_segments (trackCircuit, brakeLocation, targetLocation, worst_case_grade_during_stop, max_entry_speed, overSpeed, vehicleAccel, reactionTime, brakeRate, runwayAccel, propulsion, build_up_brake, overhang) VALUES (@trackCircuit, @brakeLocation, @targetLocation, @worst_case_grade_during_stop, @max_entry_speed, @overSpeed, @vehicleAccel, @reactionTime, @brakeRate, @runwayAccel, @propulsion, @build_up_brake, @overhang)"; cmd.Parameters.AddWithValue("@trackCircuit", obj.TrackCircuit); cmd.Parameters.AddWithValue("@brakeLocation", obj.StartPoint); cmd.Parameters.AddWithValue("@targetLocation", obj.EndPoint); cmd.Parameters.AddWithValue("@worst_case_grade_during_stop", obj.GradeWorst); cmd.Parameters.AddWithValue("@max_entry_speed", obj.SpeedMax); cmd.Parameters.AddWithValue("@overSpeed", obj.OverSpeed); cmd.Parameters.AddWithValue("@vehicleAccel", obj.VehicleAccel); cmd.Parameters.AddWithValue("@reactionTime", obj.ReactionTime); cmd.Parameters.AddWithValue("@brakeRate", obj.BrakeRate); cmd.Parameters.AddWithValue("@runwayAccel", obj.RunwayAccelSec); cmd.Parameters.AddWithValue("@propulsion", obj.PropulsionRemSec); cmd.Parameters.AddWithValue("@build_up_brake", obj.BrakeBuildUpSec); cmd.Parameters.AddWithValue("@overhang", obj.OverhangDist); cmd.Connection = conn.getConnection(); cmd.ExecuteNonQuery(); }
//public void runQuery(DatabaseConnection db_connection, string queryText) //{ // db_connection.openConnection(); // MySqlCommand cmd = db_connection.getConnection().CreateCommand(); // cmd.CommandText = queryText; // MySqlDataReader reader = cmd.ExecuteReader(); // while (reader.Read()) // { // string row = ""; // for (int i = 0; i < reader.FieldCount; i++) // row += reader.GetValue(i).ToString() + ", "; // Console.WriteLine(row); // } // db_connection.closeConnection(); //} public List<string> runQuery(DatabaseConnection db_connection, string queryText) { List<string> result = new List<string>(); db_connection.openConnection(); MySqlCommand cmd = db_connection.getConnection().CreateCommand(); cmd.CommandText = queryText; MySqlDataReader reader = cmd.ExecuteReader(); // string row = ""; while (reader.Read()) { for (int i = 0; i < reader.FieldCount; i++) result.Add(reader.GetValue(i).ToString()); // result.Add(row); } db_connection.closeConnection(); return result; }
/// <summary> /// Loads a track from an excel file /// </summary> /// <param name="filename"></param> private static void LoadExcelFile(object filename) { ExcelParser parser = new ExcelParser(filename.ToString()); parser.processData(); try { ProgressBoxForm progress = new ProgressBoxForm(); progress.CurCircuit.Text = ""; progress.Show(); DatabaseConnection conn = new DatabaseConnection( Config.ConfigManager.Database, Config.ConfigManager.Port, Config.ConfigManager.DatabaseName, Config.ConfigManager.UserName, Config.ConfigManager.Password); conn.openConnection(); progress.progressBar1.Maximum = TrackLayout.Track.Count - 1; progress.progressBar1.Step = 1; int current = 1; Cursor.Current = Cursors.WaitCursor; foreach (TrackSegment t in TrackLayout.Track) { DatabaseOperations.InsertIntoDatabase(conn, t); progress.progressBar1.PerformStep(); progress.CurCircuit.Text = "Currently processing Track Circuit " + current + " of " + TrackLayout.Track.Count + "..."; current++; progress.CurCircuit.Refresh(); Thread.Sleep(500); } Cursor.Current = Cursors.Default; progress.Close(); conn.closeConnection(); } catch (Exception ex) { LogManager.Logger.Log(ex); } parser.cleanUp(); }