//-------------------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++)
{
}
}
