示例#1
0
        private static SqlPreCommandSimple UpdateByFkChange(string tn, DiffColumn difCol, IColumn tabCol, Func <ObjectName, ObjectName> changeName)
        {
            if (difCol.ForeignKey == null || tabCol.ReferenceTable == null || tabCol.AvoidForeignKey)
            {
                return(null);
            }

            ObjectName oldFk = changeName(difCol.ForeignKey.TargetTable);

            if (oldFk.Equals(tabCol.ReferenceTable.Name))
            {
                return(null);
            }

            AliasGenerator ag = new AliasGenerator();

            return(new SqlPreCommandSimple(
                       @"UPDATE {2}
SET {0} =  -- get {5} id from {4}.Id
FROM {1} {2}
JOIN {3} {4} ON {2}.{0} = {4}.Id".FormatWith(tabCol.Name,
                                             tn, ag.NextTableAlias(tn),
                                             oldFk, ag.NextTableAlias(oldFk.Name),
                                             tabCol.ReferenceTable.Name.Name)));
        }
示例#2
0
        private static string GenerateColumnCode(DiffColumn c)
        {
            var type = CodeGeneration.CodeGenerator.Entities.GetValueType(c);

            if (c.Nullable)
            {
                type = type.Nullify();
            }

            StringBuilder sb = new StringBuilder();

            if (c.Identity)
            {
                sb.AppendLine("[ViewPrimaryKey]");
            }
            sb.AppendLine($"public {type.TypeName()} {c.Name};");
            return(sb.ToString());
        }
示例#3
0
        public static string CreateOldColumn(DiffColumn c)
        {
            string fullType = GetColumnType(c);

            var generatedAlways = c.GeneratedAlwaysType != GeneratedAlwaysType.None ?
                                  $"GENERATED ALWAYS AS ROW {(c.GeneratedAlwaysType == GeneratedAlwaysType.AsRowStart ? "START" : "END")} HIDDEN" :
                                  null;

            var defaultConstraint = c.DefaultConstraint != null ? $"CONSTRAINT {c.DefaultConstraint.Name} DEFAULT " + c.DefaultConstraint.Definition : null;

            return($" ".Combine(
                       c.Name.SqlEscape(),
                       fullType,
                       c.Identity ? "IDENTITY " : null,
                       generatedAlways,
                       c.Collation != null ? ("COLLATE " + c.Collation) : null,
                       c.Nullable ? "NULL" : "NOT NULL",
                       defaultConstraint
                       ));
        }
        private static SqlPreCommandSimple UpdateByFkChange(string tn, DiffColumn difCol, IColumn tabCol, Func<ObjectName, ObjectName> changeName)
        {
            if (difCol.ForeignKey == null || tabCol.ReferenceTable == null || tabCol.AvoidForeignKey)
                return null;

            ObjectName oldFk = changeName(difCol.ForeignKey.TargetTable);

            if (oldFk.Equals(tabCol.ReferenceTable.Name))
                return null;

            AliasGenerator ag = new AliasGenerator();

            return new SqlPreCommandSimple(
@"UPDATE {2}
SET {0} =  -- get {5} id from {4}.Id
FROM {1} {2}
JOIN {3} {4} ON {2}.{0} = {4}.Id".FormatWith(tabCol.Name,
                tn, ag.NextTableAlias(tn),
                oldFk, ag.NextTableAlias(oldFk.Name),
                tabCol.ReferenceTable.Name.Name));
        }
示例#5
0
 public static string GetColumnType(DiffColumn c)
 {
     return(c.SqlDbType == SqlDbType.Udt ? c.UserTypeName ! : c.SqlDbType.ToString().ToUpper()) /*+ GetSizeScale(Math.Max(c.Length, c.Precision), c.Scale)*/;
 }
示例#6
0
 public static SqlPreCommand AlterTableAddOldColumn(ITable table, DiffColumn column)
 {
     return(new SqlPreCommandSimple("ALTER TABLE {0} ADD {1}".FormatWith(table.Name, CreateOldColumn(column))));
 }