public static void log(int woodID, List <String> log)
{
StringBuilder sb = new StringBuilder("INSERT INTO woods_log (woodID, monkeyID, message) VALUES ");
List <string> rows = new List <string>();
foreach (String line in log)
{
rows.Add(string.Format("('{0}','{1}','{2}')", woodID, line.Split(";")[0], line.Split(";")[1]));
}
sb.Append(string.Join(",", rows));
sb.Append(";");
MySqlConnection con = Program.db.getConnection();
con.Open();
using var cmd = DatabaseUtil.CommandExecutor(con, sb.ToString());
cmd.Prepare();
cmd.ExecuteNonQuery();
con.Close();
}
public static void logTrees(int woodID, List <Tree> trees)
{
StringBuilder sb = new StringBuilder("INSERT INTO woods_trees (woodID, treeID, x, y) VALUES ");
List <string> rows = new List <string>();
foreach (Tree tree in trees)
{
rows.Add(string.Format("('{0}','{1}','{2}','{3}')", woodID, tree.ID, tree.X, tree.Y));
}
sb.Append(string.Join(",", rows));
sb.Append(";");
MySqlConnection con = Program.db.getConnection();
con.Open();
using var cmd = DatabaseUtil.CommandExecutor(con, sb.ToString());
cmd.Prepare();
cmd.ExecuteNonQuery();
con.Close();
}
public static void logMonkeys(int woodID, Monkey monkey)
{
StringBuilder sb = new StringBuilder("INSERT INTO woods_monkeys (monkeyID, monkeyName, woodID, seqnr, treeID, x, y) VALUES ");
List <string> rows = new List <string>();
for (int i = 0; i < monkey.Path.Count; i++)
{
Tree tree = monkey.Path[i];
rows.Add(string.Format("('{0}','{1}','{2}','{3}','{4}','{5}','{6}')", monkey.ID, monkey.Name, woodID, i, tree.ID, tree.X, tree.Y));
}
sb.Append(string.Join(",", rows));
sb.Append(";");
MySqlConnection con = Program.db.getConnection();
con.Open();
using var cmd = DatabaseUtil.CommandExecutor(con, sb.ToString());
cmd.Prepare();
cmd.ExecuteNonQuery();
con.Close();
}
