public EditorColumnStructure(TableEditFrame frame, ColumnStructure src, ISqlDialect dialect)
{
m_frame = frame;
if (src.Domain != null)
{
Domain = m_frame.Domains[src.Domain];
}
ColumnName = src.ColumnName;
IsNullable = src.IsNullable;
CharacterSet = src.CharacterSet;
Collation = src.Collation;
if (src.DefaultValue != null)
{
DefaultValue = src.DefaultValue.GenerateSql(dialect, src.DataType, null);
}
m_originalGroupId = src.GroupId;
if (dialect == null)
{
DataType = src.DataType;
}
else
{
DataType = dialect.GenericTypeToSpecific(src.DataType);
}
Source = src;
}
public void DoEdit(AlterTableEditorPars.Tab initialTab)
{
string winid = TableKey + "#edit_table";
if (MainWindow.Instance.HasContent(winid))
{
var sett = TableSource.Database.Settings.Tree();
if (sett.DesignTableDuplicateMode.ShouldReuse())
{
MainWindow.Instance.ActivateContent(winid);
return;
}
}
var pars = new AlterTableEditorPars {
InitialTab = initialTab
};
var ts = new TableStructure {
FullName = TableSource.FullName
};
var content = new TableEditFrame(TableSource.Database.CloneSource(), ts, pars);
content.WinId = winid;
MainWindow.Instance.OpenContent(content);
}
public EditorCheckStructure(TableEditFrame frame, CheckConstraint src)
: base(frame)
{
m_originalGroupId = src.GroupId;
Source = src;
m_name = src.Name;
m_table = src.Table.FullName;
m_expression = src.Expression;
}
public EditorForeignKeyStructure(TableEditFrame frame, ForeignKey src)
: base(frame)
{
m_originalGroupId = src.GroupId;
Source = src;
m_name = src.Name;
m_table = src.Table.FullName;
m_onDelete = src.OnDeleteAction;
m_onUpdate = src.OnUpdateAction;
PrimaryKeyTable = src.PrimaryKeyTable;
for (int i = 0; i < src.Columns.Count; i++)
{
EditorForeignColumnStructure col = new EditorForeignColumnStructure();
col.SrcName = new ColumnReference(src.Columns[i]);
col.Fk = this;
if (src.PrimaryKeyColumns != null && i < src.PrimaryKeyColumns.Count)
{
col.DstName = new ColumnReference(src.PrimaryKeyColumns[i]);
}
Columns.Add(col);
}
}
public EditorIndexOrKeyStructure(TableEditFrame frame, ColumnsConstraint src)
: base(frame)
{
m_originalGroupId = src.GroupId;
Source = src;
m_name = src.Name;
m_columns.AddRange(src.Columns);
if (src is IPrimaryKey)
{
m_type = EditorIndexOrKeyType.PrimaryKey;
}
if (src is IIndex)
{
m_type = EditorIndexOrKeyType.Index;
m_isUnique = ((IIndex)src).IsUnique;
}
if (src is IUnique)
{
m_type = EditorIndexOrKeyType.UniqueConstraint;
}
m_origType = m_type;
}
public EditorCheckStructure(NameWithSchema table, ISqlDialect dialect, TableEditFrame frame)
: base(frame)
{
SetTable(table, dialect);
}
public EditorConstraintBase(TableEditFrame frame)
{
m_frame = frame;
}
public EditorColumnStructure(TableEditFrame frame)
{
m_frame = frame;
}
