Esempio n. 1
0
        private static void TestNewOrCreate(Arguments arguments)
        {
            var logger             = new StringBuilderLogger();
            var connectionManager  = new MySqlConnectionManager(logger);
            var dbConnectionConfig = GetConnectionConfig(arguments);
            var mySqlConnection    = connectionManager.GetConnection(dbConnectionConfig);

            if (mySqlConnection != null)
            {
                string statement =
                    "CREATE TABLE IF NOT EXISTS `product` ( " +
                    "`Id` varchar(256) NOT NULL," +
                    "`Description` varchar(256) NOT NULL," +
                    "`Rating` int(11) NOT NULL) " +
                    "ENGINE=InnoDB DEFAULT CHARSET=latin1;";

                MySqlCommand command = new MySqlCommand(statement, mySqlConnection);
                command.ExecuteNonQuery();
                connectionManager.Disconnect();
            }
            else
            {
                Console.WriteLine("Connection failed");
            }
        }
Esempio n. 2
0
        private static void TestDbConnection(Arguments arguments)
        {
            Console.WriteLine("Preparing logger and connection manager.");
            var logger            = new StringBuilderLogger();
            var connectionManager = new MySqlConnectionManager(logger);

            Console.WriteLine("Setting up the database configuration.");
            var dbConnectionConfig = GetConnectionConfig(arguments);

            Console.WriteLine("Connecting to the database.");
            var mySqlConnection = connectionManager.GetConnection(dbConnectionConfig);

            if (mySqlConnection != null)
            {
                Console.WriteLine("Connection was successful.");
                Console.WriteLine("Disconnecting from the database.");
                connectionManager.Disconnect();
                Console.WriteLine("Disconnected from database.");
            }
            else
            {
                Console.WriteLine("Connection failed");
            }

            Console.WriteLine("Log Dump: ");
            Console.WriteLine(logger.Dump());
            Console.ReadLine();
        }
Esempio n. 3
0
        private static void TestNewOrCreateWithStatementModel(Arguments arguments)
        {
            var logger             = new StringBuilderLogger();
            var connectionManager  = new MySqlConnectionManager(logger);
            var dbConnectionConfig = GetConnectionConfig(arguments);
            var mySqlConnection    = connectionManager.GetConnection(dbConnectionConfig);

            if (mySqlConnection != null)
            {
                CreateTableIfNotExistsStatement statement = new CreateTableIfNotExistsStatement(
                    "eror",
                    new TableColumnCollection(
                        new TableColumn[]
                {
                    new TableColumn(
                        "Id",
                        new ColumnType("VARCHAR", 256),
                        true),
                    new TableColumn(
                        "Description",
                        new ColumnType("VARCHAR", 256),
                        true),
                    new TableColumn(
                        "Rating",
                        new ColumnType("INT", 11),
                        true)
                }));

                MySqlCommand command = new MySqlCommand(statement.Serialize(), mySqlConnection);
                command.ExecuteNonQuery();
                connectionManager.Disconnect();
            }
            else
            {
                Console.WriteLine("Connection failed");
            }
        }