//-------------------DELETE METHODS--------------------------------- public void deleteMysqlServer(mysql_servers server) { using (firedumpdbEntities1 contextdb = new firedumpdbEntities1()) { contextdb.mysql_servers.Remove(server); contextdb.SaveChanges(); } }
public mysql_servers getMysqlServerById(long id) { using (firedumpdbEntities1 contextdb = new firedumpdbEntities1()) { mysql_servers server = contextdb.mysql_servers.Find(id); return(server); } }
//return the new id public int saveMysqlServer(mysql_servers server) { using (firedumpdbEntities1 contextdb = new firedumpdbEntities1()) { contextdb.mysql_servers.Add(server); contextdb.SaveChanges(); return((int)server.id); } }
//-------------------UPDATE METHODS--------------------------------- public void updateMysqlServer(mysql_servers mysqlserver) { using (firedumpdbEntities1 context = new firedumpdbEntities1()) { mysql_servers original = context.mysql_servers.Find(mysqlserver.id); context.Entry(original).CurrentValues.SetValues(mysqlserver); context.SaveChanges(); } }
public AnalyzeDbForm(mysql_servers server, string database) { InitializeComponent(); this.server = server; this.database = database; setInfoTab(database); setTableNamesTab(); setColumnNamesTab(); setIndexesTab(); }
public void deleteMysqlServer(mysql_servers server) { contextdb.mysql_servers.Remove(server); contextdb.SaveChanges(); }
public mysql_servers getMysqlServerById(int id) { mysql_servers server = contextdb.mysql_servers.Find(id); return(server); }
//return the new id public int saveMysqlServer(mysql_servers server) { contextdb.mysql_servers.Add(server); contextdb.SaveChanges(); return((int)server.id); }
public SqlDbViewerForm(mysql_servers server, string database) { InitializeComponent(); DbConnection connection = DbConnection.Instance(); connection.username = server.username; connection.password = server.password; connection.Host = server.host; if (connection.testConnection().wasSuccessful) { this.server = server; this.database = database; List <string> tables = connection.getTables(database); MysqlWords.tables = tables; TreeNode[] nodearray = new TreeNode[tables.Count]; for (int i = 0; i < tables.Count; i++) { TreeNode treenode = new TreeNode(tables[i]); treenode.ImageIndex = 1; nodearray[i] = treenode; } for (int i = 0; i < MysqlWords.tables.Count; i++) { MysqlWords.tables[i] = MysqlWords.tables[i].ToUpper(); } ImageList imagelist = new ImageList(); imagelist.Images.Add(Bitmap.FromFile("resources\\icons\\databaseimage.bmp")); imagelist.Images.Add(Bitmap.FromFile("resources\\icons\\tableimage.bmp")); TreeNode rootNode = new TreeNode("database:" + database, nodearray); rootNode.ImageIndex = 1; rootNode.ImageIndex = 0; rootNode.Expand(); treeView1.Nodes.Add(rootNode); treeView1.ImageIndex = 0; treeView1.ImageList = imagelist; } else { MessageBox.Show("Couldent connect to " + database + " database"); } richTextBox1.Text = ""; for (int i = 0; i < limits.Length; i++) { toolStripComboBox1.Items.Add(limits[i]); } toolStripComboBox1.SelectedIndex = 2; intellform = new IntelliSense(); intellform.setListener(this, this); intellform.Location = point; intellform.Show(); intellform.Visible = false; intellform.Hide(); }
public void TestMysqlserversGetSave() { Firedump.tests.TestContext context = new Firedump.tests.TestContext(); FiredumpContextTest service = new FiredumpContextTest(context); for (int i = 0; i <= 100; i++) { mysql_servers server = new mysql_servers(); server.port = -10000 + i; server.host = "HOST" + i; server.name = "N" + i; server.password = "******" + i; server.username = "******" + i; server.id = i; service.saveMysqlServer(server); } List <mysql_servers> servers = service.getAllMySqlServers(); Assert.AreEqual(101, servers.Count); TestMysql_serverDbSet mysqlserverContext = new TestMysql_serverDbSet(); service = new FiredumpContextTest(mysqlserverContext); for (int i = 0; i <= 100; i++) { mysql_servers server = new mysql_servers(); server.port = -10000 + i; server.host = "HOST" + i; server.name = "N" + i; server.password = "******" + i; server.username = "******" + i; server.id = i; service.saveMysqlServer(server); } servers = service.getAllMySqlServers(); Assert.AreEqual(101, servers.Count); for (int i = 0; i < servers.Count; i++) { mysql_servers temps = mysqlserverContext.Find((int)servers[i].id); Assert.AreEqual(servers[i], temps); Assert.AreEqual(servers[i].id, temps.id); Assert.AreEqual(servers[i].host, temps.host); Assert.AreEqual(servers[i].name, temps.name); Assert.AreEqual(servers[i].password, temps.password); Assert.AreEqual(servers[i].port, temps.port); } mysql_servers mysqlserver = service.getAllMySqlServers()[0]; schedules schedule = new schedules(); schedule.hours = 1; schedule.activated = 0; schedule.date = new DateTime(); schedule.name = "scheduleName"; schedule.server_id = mysqlserver.id; service.saveSchedule(schedule); servers = service.getAllMySqlServers(); List <schedules> schedules = service.getSchedules(); for (int i = 0; i < servers.Count; i++) { } }