public void Pattern_Should_Handle_Yyymmdd_hhmm_minor_Version()
        {
            var parseResult = DbVersion.TryParse("20201208-1850.02", out var version);

            parseResult.Should().BeTrue("it's correct version");
            version.Major.Should().Be(202012081850, "version contains major version");
            version.Minor.Should().Be(2, "version contains minor version");
        }
        public void TryParse_Numeric_Major_Version()
        {
            var parseResult = DbVersion.TryParse("1", out var version);

            parseResult.Should().BeTrue("it's correct version");
            version.Major.Should().Be(1, "version contains only major version");
            version.Minor.Should().Be(0, "version contains only minor version");
        }
        public void Pattern_Should_Handle_Numeric_Major_Minor_2_Version()
        {
            var parseResult = DbVersion.TryParse("10001.020", out var version);

            parseResult.Should().BeTrue("it's correct version");
            version.Major.Should().Be(10001, "version contains major version");
            version.Minor.Should().Be(20, "version contains minor version");
        }
示例#4
0
        /// <inheritdoc />
        public async Task <IReadOnlyCollection <DbVersion> > GetAppliedMigrationVersionAsync(CancellationToken token = default)
        {
            // actual version is made by last migration because downgrade can decrease version
            var query = $"SELECT version FROM \"{_options.MigrationHistoryTableName}\"";

            var command = NpgsqlConnection.CreateCommand();

            command.CommandText = query;

            try
            {
                _sqLogger?.LogInformation(query);

                var appliedMigrations = new List <DbVersion>();

                using (var reader = await command.ExecuteReaderAsync(token))
                {
                    if (!reader.HasRows)
                    {
                        return(Array.Empty <DbVersion>());
                    }

                    while (await reader.ReadAsync(token))
                    {
                        var stringVersion = reader.GetString(0);

                        if (!DbVersion.TryParse(stringVersion, out var version))
                        {
                            throw new InvalidOperationException($"Incorrect migration version (source value = {stringVersion}).");
                        }

                        appliedMigrations.Add(version);
                    }

                    return(appliedMigrations.OrderBy(x => x).ToArray());
                }
            }
            catch (PostgresException e)
            {
                // Migration table does not exist.
                if (e.SqlState == "42P01")
                {
                    return(Array.Empty <DbVersion>());
                }

                throw;
            }
        }