private bool records_exists_in_table(infinite_loops infinite_loops)
{
PostgresConnection con = new PostgresConnection();
con.connection().Open();
NpgsqlCommand cmd = new NpgsqlCommand("SELECT CASE WHEN EXISTS (SELECT * FROM " + infinite_loops.getTable_name() + " LIMIT 1) THEN 1 ELSE 0 END", con.connection());
NpgsqlDataReader rdr = cmd.ExecuteReader();
int value = -1;
while (rdr.Read())
{
value = rdr.GetInt16(0);
}
rdr.Close();
con.connection().Close();
return(value == 1 ? true : false);
}
private void testing_add_record_Click(object sender, EventArgs e)
{
string temporarty_bag_record = null;
temporarty_bag_record = "test_record";
PostgresConnection con = new PostgresConnection();
con.connection().Open();
NpgsqlCommand cmd = new NpgsqlCommand("select var_table from existing_bags eb order by id ", con.connection());
NpgsqlDataReader rdr = cmd.ExecuteReader();
bool table_already_exists = false;
while (rdr.Read())
{
if (rdr.GetString(0).Equals(temporarty_bag_record))
{
table_already_exists = true;
}
}
rdr.Close();
if (table_already_exists == false)
{
// NpgsqlCommand cmd_2 = new NpgsqlCommand("insert into existing_bags(var_table, alive, gather_data_time) values('"+ temporarty_bag_record + "',true,2000 ", con.connection());
// NpgsqlDataReader rdr_2 = cmd_2.ExecuteReader();
using (var cmd_2 = new NpgsqlCommand("insert into existing_bags(var_table, alive, gather_data_time) values(@p1,@p2,@p3)", con.connection()))
{
cmd_2.Parameters.Add(new NpgsqlParameter("p1", NpgsqlTypes.NpgsqlDbType.Text));
cmd_2.Parameters.Add(new NpgsqlParameter("p2", NpgsqlTypes.NpgsqlDbType.Boolean));
cmd_2.Parameters.Add(new NpgsqlParameter("p3", NpgsqlTypes.NpgsqlDbType.Integer));
cmd_2.Parameters[0].Value = temporarty_bag_record;
cmd_2.Parameters[1].Value = true;
cmd_2.Parameters[2].Value = 2000;
cmd_2.ExecuteNonQuery();
}
infinite_loops inf_temp = new infinite_loops(2000, temporarty_bag_record);
inifite_loop_list.Add(inf_temp);
create_additional_table(temporarty_bag_record, con);
MessageBox.Show("table created", "Database information", MessageBoxButtons.OK);
insert_example_values_to_table(temporarty_bag_record, con);
MessageBox.Show("values added", "Database information", MessageBoxButtons.OK);
inf_temp.initizalizer();
MessageBox.Show("loop initialized", "Database information", MessageBoxButtons.OK);
}
else
{
MessageBox.Show("Rekord aleady exists", "Database information", MessageBoxButtons.OK);
}
con.connection().Close();
}
