public void addCultureGenderBiasData(CultureGenderBiasData data) { String query = "INSERT INTO cultural_gender_bias(guid, country, bias)" + " VALUES (:guid, :country, :bias)"; NpgsqlCommand command = new NpgsqlCommand(query, connection); command.Parameters.Add(new NpgsqlParameter("guid", Guid.NewGuid())); command.Parameters.Add(new NpgsqlParameter("country", data.country)); command.Parameters.Add(new NpgsqlParameter("bias", data.bias)); 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(); }