public void addCultureData(CultureData data)
{
String query = "INSERT INTO cultural_data(guid, age, gender, country, formation_type, formation_males,"
+ "formation_females, personal_space, social_space, public_space, avoidance_side_left_probability, speed)"
+ " VALUES (:guid, :age, :gender, :country, :formation_type, :formation_males, :formation_females, :personal_space, :social_space, "
+ ":public_space, :avoidance_side_left_probability, :speed)";
NpgsqlCommand command = new NpgsqlCommand(query, connection);
command.Parameters.Add(new NpgsqlParameter("guid", data.guid));
command.Parameters.Add(new NpgsqlParameter("age", data.age));
command.Parameters.Add(new NpgsqlParameter("gender", data.gender));
command.Parameters.Add(new NpgsqlParameter("country", data.country));
command.Parameters.Add(new NpgsqlParameter("formation_type", data.formationType));
command.Parameters.Add(new NpgsqlParameter("formation_males", data.formationMales));
command.Parameters.Add(new NpgsqlParameter("formation_females", data.formationFemales));
command.Parameters.Add(new NpgsqlParameter("personal_space", data.personalSpace));
command.Parameters.Add(new NpgsqlParameter("social_space", data.socialSpace));
command.Parameters.Add(new NpgsqlParameter("public_space", data.publicSpace));
command.Parameters.Add(new NpgsqlParameter("avoidance_side_left_probability", data.avoidanceSideLeftProb));
command.Parameters.Add(new NpgsqlParameter("speed", data.speed));
command.ExecuteNonQuery();
}
static void addCulturalData(String connectionParams)
{
CultureData dataMaleIraq = new CultureData(Guid.NewGuid().ToString(), 40, "male", "iraq", "individual", 0, 0, 0.438, 1.478, 5.478, 0.62, 4.554);
CultureData dataFemaleIraq = new CultureData(Guid.NewGuid().ToString(), 40, "female", "iraq", "individual", 0, 0, 0.183, 1.223, 5.223, 0.62, 3.978);
CultureData dataMaleCanada = new CultureData(Guid.NewGuid().ToString(), 40, "male", "canada", "individual", 0, 0, 0.658, 1.698, 5.698, 0.63, 5.004);
CultureData dataFemaleCanada = new CultureData(Guid.NewGuid().ToString(), 40, "female", "canada", "individual", 0, 0, 0.7, 1.74, 5.74, 0.63, 4.968);
CultureData dataMaleIsrael = new CultureData(Guid.NewGuid().ToString(), 40, "male", "israel", "individual", 0, 0, 0.665, 1.705, 5.705, 0.41, 4.806);
CultureData dataFemaleIsrael = new CultureData(Guid.NewGuid().ToString(), 40, "female", "israel", "individual", 0, 0, 0.503, 1.543, 5.543, 0.41, 4.482);
CultureData dataMaleEngland = new CultureData(Guid.NewGuid().ToString(), 40, "male", "england", "individual", 0, 0, 0.495, 1.535, 5.535, 0.77, 5.166);
CultureData dataFemaleEngland = new CultureData(Guid.NewGuid().ToString(), 40, "female", "england", "individual", 0, 0, 0.52, 1.56, 5.56, 0.77, 4.23);
CultureData dataMaleFrance = new CultureData(Guid.NewGuid().ToString(), 40, "male", "france", "individual", 0, 0, 0.575, 1.615, 5.615, 0.45, 4.914);
CultureData dataFemaleFrance = new CultureData(Guid.NewGuid().ToString(), 40, "female", "france", "individual", 0, 0, 0.405, 1.445, 5.445, 0.45, 4.68);
CultureGenderBiasData iraqBias = new CultureGenderBiasData(Guid.NewGuid().ToString(), "iraq", 0);
CultureGenderBiasData canadaBias = new CultureGenderBiasData(Guid.NewGuid().ToString(), "canada", 0);
CultureGenderBiasData israelBias = new CultureGenderBiasData(Guid.NewGuid().ToString(), "israel", 0);
CultureGenderBiasData englandBias = new CultureGenderBiasData(Guid.NewGuid().ToString(), "england", 0);
CultureGenderBiasData franceBias = new CultureGenderBiasData(Guid.NewGuid().ToString(), "france", 0);
NpgsqlConnection connection = new NpgsqlConnection(connectionParams);
connection.Open();
NpgsqlTransaction transaction = connection.BeginTransaction();
try
{
CultureDB cultureDB = new CultureDB(connection);
cultureDB.addCultureData(dataMaleIraq);
cultureDB.addCultureData(dataFemaleIraq);
cultureDB.addCultureData(dataMaleCanada);
cultureDB.addCultureData(dataFemaleCanada);
cultureDB.addCultureData(dataMaleIsrael);
cultureDB.addCultureData(dataFemaleIsrael);
cultureDB.addCultureData(dataMaleEngland);
cultureDB.addCultureData(dataFemaleEngland);
cultureDB.addCultureData(dataMaleFrance);
cultureDB.addCultureData(dataFemaleFrance);
cultureDB.addCultureGenderBiasData(iraqBias);
cultureDB.addCultureGenderBiasData(canadaBias);
cultureDB.addCultureGenderBiasData(israelBias);
cultureDB.addCultureGenderBiasData(englandBias);
cultureDB.addCultureGenderBiasData(franceBias);
transaction.Commit();
Console.WriteLine("addCulturalData: Transaction successful");
}
catch (Exception exception)
{
try
{
transaction.Rollback();
}
catch (Exception rollbackException)
{
Console.WriteLine("Rollback failed :(");
}
}
connection.Close();
}