Exemplo n.º 1
0
        /// <summary>
        ///     Builds commands for the given <see cref="JetCreateDatabaseOperation" />
        ///     by making calls on the given <see cref="MigrationCommandListBuilder" />.
        /// </summary>
        /// <param name="operation"> The operation. </param>
        /// <param name="model"> The target model which may be <c>null</c> if the operations exist without a model. </param>
        /// <param name="builder"> The command builder to use to build the commands. </param>
        protected virtual void Generate(
            [NotNull] JetCreateDatabaseOperation operation,
            [CanBeNull] IModel model,
            [NotNull] MigrationCommandListBuilder builder)
        {
            Check.NotNull(operation, nameof(operation));
            Check.NotNull(builder, nameof(builder));

            builder
            .Append("CREATE DATABASE ")
            .Append(_keepBreakingCharactersStringTypeMapping.GenerateSqlLiteral(operation.Name));

            builder
            .AppendLine(Dependencies.SqlGenerationHelper.StatementTerminator)
            .EndCommand(suppressTransaction: true);
        }
        /// <summary>
        /// 如果脚本不存在,则获得Begin脚本
        /// </summary>
        /// <param name="migrationId">迁移ID</param>
        /// <returns></returns>
        public override string GetBeginIfExistsScript(string migrationId)
        {
            try
            {
                if (Check.IsTraceEnabled(m_oracleLogger?.Logger))
                {
                    Trace <DbLoggerCategory.Migrations> .Write(m_oracleLogger, LogLevel.Trace, OracleTraceTag.Entry, OracleTraceClassName.OracleHistoryRepository, OracleTraceFuncName.GetBeginIfExistsScript);
                }

                Check.NotEmpty(migrationId, nameof(migrationId));
                RelationalTypeMapping mapping = Dependencies.TypeMappingSource.GetMapping(typeof(string));
                return(new StringBuilder()
                       .AppendLine("DECLARE")
                       .AppendLine("    v_Count INTEGER;")
                       .AppendLine("BEGIN")
                       .Append("SELECT COUNT(*) INTO v_Count FROM ")
                       .Append(SqlGenerationHelper.DelimitIdentifier(TableName, TableSchema))
                       .Append(" WHERE ")
                       .Append(SqlGenerationHelper.DelimitIdentifier(MigrationIdColumnName))
                       .Append(" = ")
                       .AppendLine(mapping.GenerateSqlLiteral(migrationId))
                       .AppendLine("IF v_Count = 1 THEN")
                       .ToString());
            }
            catch (Exception ex)
            {
                if (Check.IsErrorEnabled(m_oracleLogger?.Logger))
                {
                    Trace <DbLoggerCategory.Migrations> .Write(m_oracleLogger, LogLevel.Error, OracleTraceTag.Error, OracleTraceClassName.OracleHistoryRepository, OracleTraceFuncName.GetBeginIfExistsScript, ex.ToString());
                }
                throw;
            }
            finally
            {
                if (Check.IsTraceEnabled(m_oracleLogger?.Logger))
                {
                    Trace <DbLoggerCategory.Migrations> .Write(m_oracleLogger, LogLevel.Trace, OracleTraceTag.Exit, OracleTraceClassName.OracleHistoryRepository, OracleTraceFuncName.GetBeginIfExistsScript);
                }
            }
        }
Exemplo n.º 3
0
        protected virtual void ProcessMinimumLengthInternal(
            IConventionProperty property,
            MemberInfo memberInfo,
            string tableName,
            string columnName,
            StringBuilder sql,
            int minLength)
        {
            var lengthFunctionName = _databaseProvider.Name switch
            {
                "Microsoft.EntityFrameworkCore.SqlServer" => "LEN",
                "Microsoft.EntityFrameworkCore.Sqlite" => "LENGTH",
                "Npgsql.EntityFrameworkCore.PostgreSQL" => "LENGTH",
                "Pomelo.EntityFrameworkCore.MySQL" => "LENGTH",
                _ => null
            };

            if (lengthFunctionName is null)
            {
                return;
            }

            sql.Clear();

            sql
            .Append(lengthFunctionName)
            .Append('(')
            .Append(_sqlGenerationHelper.DelimitIdentifier(columnName))
            .Append(')')
            .Append(" >= ")
            .Append(_intTypeMapping.GenerateSqlLiteral(minLength));

            var constraintName = $"CK_{tableName}_{columnName}_MinLength";

            property.DeclaringEntityType.AddCheckConstraint(constraintName, sql.ToString());
        }
 protected virtual void Test_GenerateSqlLiteral_helper(
     RelationalTypeMapping typeMapping,
     object value,
     string literalValue)
 => Assert.Equal(literalValue, typeMapping.GenerateSqlLiteral(value));