Example #1
0
        static MySqlSubscriptionStorage GetStorage(bool createCustomSchema)
        {
            MySqlTestHelper.DropTable("Subscriptions");

            var loggerFactory      = new ConsoleLoggerFactory(false);
            var connectionProvider = new DbConnectionProvider(MySqlTestHelper.ConnectionString, loggerFactory);
            var storage            = new MySqlSubscriptionStorage(connectionProvider, "Subscriptions", true, loggerFactory);

            if (createCustomSchema)
            {
                var tableName = TableName.Parse("Subscriptions");

                MySqlTestHelper.Execute($@"
                    CREATE TABLE {tableName.QualifiedName} (
                        `topic` VARCHAR(350) NOT NULL,
	                    `address` VARCHAR(50) NOT NULL,
                        PRIMARY KEY (`topic`, `address`)
                    )");
            }
            else
            {
                storage.EnsureTableIsCreated();
            }

            return(storage);
        }