/// <summary>
/// 生成增加主键约束的语句
/// </summary>
/// <param name="op">增加逐渐约束的对象</param>
protected override void Generate(AddPKConstraint op)
{
using (var sql = this.Writer())
{
sql.Write("ALTER TABLE ");
sql.Write(this.Quote(op.TableName));
sql.Write(" ADD CONSTRAINT PK_");
sql.Write(op.TableName.ToUpper());
sql.Write(" PRIMARY KEY ");
sql.Write(this.Quote(op.TableName));
sql.Write("(");
sql.Write(this.Quote(op.ColumnName));
sql.Write(");");
this.AddRun(sql);
}
//using (var sql = this.Writer())
//{
// sql.Write("ALTER TABLE ");
// sql.Write(this.Quote(op.TableName));
// sql.Write(" DROP PRIMARY KEY,ADD PRIMARY KEY(");
// sql.Write(this.Quote(op.ColumnName));
// sql.Write(")");
// sql.Write(";");
// this.AddRun(sql);
//}
}
protected override void Generate(AddPKConstraint op)
{
using (var sql = this.Writer())
{
this.GenerateAddPKConstraint(sql, op.TableName, op.ColumnName);
this.AddRun(sql);
}
}
/// <summary>
/// 生成增加主键约束的语句
/// </summary>
/// <param name="op">增加逐渐约束的对象</param>
protected override void Generate(AddPKConstraint op)
{
//SQLite 不支持
}
protected abstract void Generate(AddPKConstraint op);
