Esempio n. 1
0
        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();
        }
Esempio n. 2
0
        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();
        }