protected override void AppendTempKeyword(IExprTableFullName tableName) { if (tableName is ExprTempTableName) { this.Builder.Append("TEMP "); } }
private string BuildFkName(IExprTableFullName tableIn, IExprTableFullName foreignTableIn) { StringBuilder nameBuilder = new StringBuilder(); ExprTableFullName table = tableIn.AsExprTableFullName(); ExprTableFullName foreignTable = foreignTableIn.AsExprTableFullName(); var schemaName = table.DbSchema != null?this.Options.MapSchema(table.DbSchema.Schema.Name) + "_" : null; nameBuilder.Append("FK_"); if (schemaName != null) { nameBuilder.Append(schemaName); nameBuilder.Append('_'); } nameBuilder.Append(table.TableName.Name); nameBuilder.Append("_to_"); if (schemaName != null) { nameBuilder.Append(schemaName); nameBuilder.Append('_'); } nameBuilder.Append(foreignTable.TableName.Name); return(nameBuilder.ToString()); }
private string BuildPkName(IExprTableFullName tableIn) { var table = tableIn.AsExprTableFullName(); var schemaName = table.DbSchema != null?this.Options.MapSchema(table.DbSchema.Schema.Name) + "_" : null; return($"PK_{schemaName}{table.TableName.Name}"); }
protected string BuildIndexName(IExprTableFullName tableIn, IndexMeta index) { if (index.Name != null && !string.IsNullOrEmpty(index.Name)) { return(index.Name); } var table = tableIn.AsExprTableFullName(); var schemaName = table.DbSchema != null?this.Options.MapSchema(table.DbSchema.Schema.Name) + "_" : null; var columns = string.Join("_", index.Columns.Select(c => c.Column.ColumnName.Name + (c.Descending ? "_DESC" : null))); return($"IX_{schemaName}{table.TableName.Name}_{columns}"); }
public static ExprTable WithFullName(this ExprTable original, IExprTableFullName newFullName) => new ExprTable(fullName: newFullName, alias: original.Alias);
public static ExprInsert WithTarget(this ExprInsert original, IExprTableFullName newTarget) => new ExprInsert(target: newTarget, targetColumns: original.TargetColumns, source: original.Source);
protected override void AppendTempKeyword(IExprTableFullName tableName) { }
protected internal TableBase(IExprTableFullName fullName, ExprTableAlias?alias) : base(fullName, alias) { }
public ExprInsert(IExprTableFullName target, IReadOnlyList <ExprColumnName>?targetColumns, IExprInsertSource source) { this.Target = target; this.TargetColumns = targetColumns; this.Source = source; }
public ExprTable(IExprTableFullName fullName, ExprTableAlias?alias) { this.Alias = alias; this.FullName = fullName; }
protected abstract void AppendTempKeyword(IExprTableFullName tableName);
public StatementDropTable(IExprTableFullName table, bool ifExists) { this.Table = table; this.IfExists = ifExists; }