public void Initialize(TableSchema table, ColumnSchemaCollection columns, ConstraintSchemaCollection constraints)
{
if (columns == null)
{
throw new ArgumentNullException("columns");
}
if (table == null)
{
throw new ArgumentNullException("table");
}
if (constraints == null)
{
throw new ArgumentNullException("constraints");
}
this.table = table;
this.columns = columns;
this.constraints = constraints;
columnSelecter.Initialize(columns);
foreach (UniqueConstraintSchema uni in constraints.GetConstraints(ConstraintType.Unique))
{
AddConstraint(uni);
}
//TODO: also col constraints
}
public void Initialize(TableSchema table, ColumnSchemaCollection columns, ConstraintSchemaCollection constraints)
{
if (columns == null)
{
throw new ArgumentNullException("columns");
}
if (table == null)
{
throw new ArgumentNullException("table");
}
if (constraints == null)
{
throw new ArgumentNullException("constraints");
}
this.table = table;
this.columns = columns;
this.constraints = constraints;
foreach (CheckConstraintSchema check in constraints.GetConstraints(ConstraintType.Check))
{
AddConstraint(check);
}
storeColumns = new SortedColumnListStore(columns);
columnRenderer.Model = storeColumns.Store;
//TODO: also col constraints
}
public virtual void RefreshConstraints()
{
store.Clear();
foreach (PrimaryKeyConstraintSchema pk in constraints.GetConstraints(ConstraintType.PrimaryKey))
{
AddConstraint(pk);
}
}
public PrimaryKeyConstraintEditorWidget(ISchemaProvider schemaProvider, SchemaActions action, TableSchema table, ColumnSchemaCollection columns, ConstraintSchemaCollection constraints)
{
if (columns == null)
{
throw new ArgumentNullException("columns");
}
if (table == null)
{
throw new ArgumentNullException("table");
}
if (constraints == null)
{
throw new ArgumentNullException("constraints");
}
if (schemaProvider == null)
{
throw new ArgumentNullException("schemaProvider");
}
this.schemaProvider = schemaProvider;
this.table = table;
this.columns = columns;
this.constraints = constraints;
this.action = action;
this.Build();
store = new ListStore(typeof(string), typeof(string), typeof(object));
listPK.Model = store;
TreeViewColumn colName = new TreeViewColumn();
colName.Title = GettextCatalog.GetString("Name");
CellRendererText nameRenderer = new CellRendererText();
nameRenderer.Editable = true;
nameRenderer.Edited += new EditedHandler(NameEdited);
colName.PackStart(nameRenderer, true);
colName.AddAttribute(nameRenderer, "text", colNameIndex);
listPK.AppendColumn(colName);
columnSelecter.Initialize(columns);
listPK.Selection.Changed += new EventHandler(SelectionChanged);
columnSelecter.ColumnToggled += new EventHandler(ColumnToggled);
foreach (PrimaryKeyConstraintSchema pk in constraints.GetConstraints(ConstraintType.PrimaryKey))
{
AddConstraint(pk);
}
ShowAll();
}
public void Initialize (TableSchema table, ColumnSchemaCollection columns, ConstraintSchemaCollection constraints)
{
if (columns == null)
throw new ArgumentNullException ("columns");
if (table == null)
throw new ArgumentNullException ("table");
if (constraints == null)
throw new ArgumentNullException ("constraints");
this.table = table;
this.columns = columns;
this.constraints = constraints;
columnSelecter.Initialize (columns);
foreach (UniqueConstraintSchema uni in constraints.GetConstraints (ConstraintType.Unique))
AddConstraint (uni);
//TODO: also col constraints
}
public UniqueConstraintEditorWidget(ISchemaProvider schemaProvider, SchemaActions action, TableSchema table, ColumnSchemaCollection columns, ConstraintSchemaCollection constraints)
{
if (columns == null)
{
throw new ArgumentNullException("columns");
}
if (table == null)
{
throw new ArgumentNullException("table");
}
if (constraints == null)
{
throw new ArgumentNullException("constraints");
}
if (schemaProvider == null)
{
throw new ArgumentNullException("schemaProvider");
}
this.schemaProvider = schemaProvider;
this.table = table;
this.columns = columns;
this.constraints = constraints;
this.action = action;
this.Build();
store = new ListStore(typeof(string), typeof(bool), typeof(string), typeof(object));
listUnique.Model = store;
listUnique.Selection.Changed += new EventHandler(SelectionChanged);
columnSelecter.ColumnToggled += new EventHandler(ColumnToggled);
TreeViewColumn colName = new TreeViewColumn();
TreeViewColumn colIsColConstraint = new TreeViewColumn();
colName.Title = GettextCatalog.GetString("Name");
colIsColConstraint.Title = GettextCatalog.GetString("Column Constraint");
CellRendererText nameRenderer = new CellRendererText();
CellRendererToggle toggleRenderer = new CellRendererToggle();
nameRenderer.Editable = true;
nameRenderer.Edited += new EditedHandler(NameEdited);
toggleRenderer.Activatable = true;
toggleRenderer.Toggled += new ToggledHandler(IsColumnConstraintToggled);
colName.PackStart(nameRenderer, true);
colIsColConstraint.PackStart(toggleRenderer, true);
colName.AddAttribute(nameRenderer, "text", colNameIndex);
colIsColConstraint.AddAttribute(toggleRenderer, "active", colIsColumnConstraintIndex);
listUnique.AppendColumn(colName);
listUnique.AppendColumn(colIsColConstraint);
columnSelecter.Initialize(columns);
foreach (UniqueConstraintSchema uni in constraints.GetConstraints(ConstraintType.Unique))
{
AddConstraint(uni);
}
//TODO: also col constraints
ShowAll();
}
public CheckConstraintEditorWidget(ISchemaProvider schemaProvider, SchemaActions action, TableSchema table, ColumnSchemaCollection columns, ConstraintSchemaCollection constraints)
{
if (columns == null)
{
throw new ArgumentNullException("columns");
}
if (table == null)
{
throw new ArgumentNullException("table");
}
if (constraints == null)
{
throw new ArgumentNullException("constraints");
}
if (schemaProvider == null)
{
throw new ArgumentNullException("schemaProvider");
}
this.schemaProvider = schemaProvider;
this.table = table;
this.columns = columns;
this.constraints = constraints;
this.action = action;
this.Build();
store = new ListStore(typeof(string), typeof(string), typeof(bool), typeof(string), typeof(object));
storeColumns = new SortedColumnListStore(columns);
listCheck.Model = store;
TreeViewColumn colName = new TreeViewColumn();
TreeViewColumn colColumn = new TreeViewColumn();
TreeViewColumn colIsColumnConstraint = new TreeViewColumn();
colName.Title = GettextCatalog.GetString("Name");
colColumn.Title = GettextCatalog.GetString("Column");
colIsColumnConstraint.Title = GettextCatalog.GetString("Column Constraint");
colColumn.MinWidth = 120; //request a bigger width
CellRendererText nameRenderer = new CellRendererText();
CellRendererCombo columnRenderer = new CellRendererCombo();
CellRendererToggle isColumnConstraintRenderer = new CellRendererToggle();
nameRenderer.Editable = true;
nameRenderer.Edited += new EditedHandler(NameEdited);
columnRenderer.Model = storeColumns.Store;
columnRenderer.TextColumn = SortedColumnListStore.ColNameIndex;
columnRenderer.Editable = true;
columnRenderer.Edited += new EditedHandler(ColumnEdited);
isColumnConstraintRenderer.Activatable = true;
isColumnConstraintRenderer.Toggled += new ToggledHandler(IsColumnConstraintToggled);
colName.PackStart(nameRenderer, true);
colColumn.PackStart(columnRenderer, true);
colIsColumnConstraint.PackStart(isColumnConstraintRenderer, true);
colName.AddAttribute(nameRenderer, "text", colNameIndex);
colColumn.AddAttribute(columnRenderer, "text", colColumnNameIndex);
colIsColumnConstraint.AddAttribute(isColumnConstraintRenderer, "active", colIsColumnConstraintIndex);
IDbFactory fac = schemaProvider.ConnectionPool.DbFactory;
columnConstraintsSupported = fac.IsCapabilitySupported("TableColumn", action, TableCapabilities.CheckConstraint);
tableConstraintsSupported = fac.IsCapabilitySupported("Table", action, TableCapabilities.CheckConstraint);
listCheck.AppendColumn(colName);
if (columnConstraintsSupported)
{
listCheck.AppendColumn(colColumn);
}
if (columnConstraintsSupported && tableConstraintsSupported)
{
listCheck.AppendColumn(colIsColumnConstraint);
}
listCheck.Selection.Changed += new EventHandler(OnSelectionChanged);
sqlEditor.TextChanged += new EventHandler(SourceChanged);
foreach (CheckConstraintSchema check in constraints.GetConstraints(ConstraintType.Check))
{
AddConstraint(check);
}
//TODO: also col constraints
ShowAll();
}
public PrimaryKeyConstraintEditorWidget (ISchemaProvider schemaProvider, SchemaActions action, TableSchema table, ColumnSchemaCollection columns, ConstraintSchemaCollection constraints)
{
if (columns == null)
throw new ArgumentNullException ("columns");
if (table == null)
throw new ArgumentNullException ("table");
if (constraints == null)
throw new ArgumentNullException ("constraints");
if (schemaProvider == null)
throw new ArgumentNullException ("schemaProvider");
this.schemaProvider = schemaProvider;
this.table = table;
this.columns = columns;
this.constraints = constraints;
this.action = action;
this.Build();
store = new ListStore (typeof (string), typeof (string), typeof (object));
listPK.Model = store;
TreeViewColumn colName = new TreeViewColumn ();
colName.Title = GettextCatalog.GetString ("Name");
CellRendererText nameRenderer = new CellRendererText ();
nameRenderer.Editable = true;
nameRenderer.Edited += new EditedHandler (NameEdited);
colName.PackStart (nameRenderer, true);
colName.AddAttribute (nameRenderer, "text", colNameIndex);
listPK.AppendColumn (colName);
columnSelecter.Initialize (columns);
listPK.Selection.Changed += new EventHandler (SelectionChanged);
columnSelecter.ColumnToggled += new EventHandler (ColumnToggled);
foreach (PrimaryKeyConstraintSchema pk in constraints.GetConstraints (ConstraintType.PrimaryKey))
AddConstraint (pk);
ShowAll ();
}
public void Initialize (TableSchema table, ColumnSchemaCollection columns, ConstraintSchemaCollection constraints)
{
if (columns == null)
throw new ArgumentNullException ("columns");
if (table == null)
throw new ArgumentNullException ("table");
if (constraints == null)
throw new ArgumentNullException ("constraints");
this.table = table;
this.columns = columns;
this.constraints = constraints;
foreach (CheckConstraintSchema check in constraints.GetConstraints (ConstraintType.Check))
AddConstraint (check);
storeColumns = new SortedColumnListStore (columns);
columnRenderer.Model = storeColumns.Store;
//TODO: also col constraints
}
public UniqueConstraintEditorWidget (ISchemaProvider schemaProvider, SchemaActions action, TableSchema table, ColumnSchemaCollection columns, ConstraintSchemaCollection constraints)
{
if (columns == null)
throw new ArgumentNullException ("columns");
if (table == null)
throw new ArgumentNullException ("table");
if (constraints == null)
throw new ArgumentNullException ("constraints");
if (schemaProvider == null)
throw new ArgumentNullException ("schemaProvider");
this.schemaProvider = schemaProvider;
this.table = table;
this.columns = columns;
this.constraints = constraints;
this.action = action;
this.Build();
store = new ListStore (typeof (string), typeof (bool), typeof (string), typeof (object));
listUnique.Model = store;
listUnique.Selection.Changed += new EventHandler (SelectionChanged);
columnSelecter.ColumnToggled += new EventHandler (ColumnToggled);
TreeViewColumn colName = new TreeViewColumn ();
TreeViewColumn colIsColConstraint = new TreeViewColumn ();
colName.Title = GettextCatalog.GetString ("Name");
colIsColConstraint.Title = GettextCatalog.GetString ("Column Constraint");
CellRendererText nameRenderer = new CellRendererText ();
CellRendererToggle toggleRenderer = new CellRendererToggle ();
nameRenderer.Editable = true;
nameRenderer.Edited += new EditedHandler (NameEdited);
toggleRenderer.Activatable = true;
toggleRenderer.Toggled += new ToggledHandler (IsColumnConstraintToggled);
colName.PackStart (nameRenderer, true);
colIsColConstraint.PackStart (toggleRenderer, true);
colName.AddAttribute (nameRenderer, "text", colNameIndex);
colIsColConstraint.AddAttribute (toggleRenderer, "active", colIsColumnConstraintIndex);
listUnique.AppendColumn (colName);
listUnique.AppendColumn (colIsColConstraint);
columnSelecter.Initialize (columns);
foreach (UniqueConstraintSchema uni in constraints.GetConstraints (ConstraintType.Unique))
AddConstraint (uni);
//TODO: also col constraints
ShowAll ();
}
public CheckConstraintEditorWidget (ISchemaProvider schemaProvider, SchemaActions action, TableSchema table, ColumnSchemaCollection columns, ConstraintSchemaCollection constraints)
{
if (columns == null)
throw new ArgumentNullException ("columns");
if (table == null)
throw new ArgumentNullException ("table");
if (constraints == null)
throw new ArgumentNullException ("constraints");
if (schemaProvider == null)
throw new ArgumentNullException ("schemaProvider");
this.schemaProvider = schemaProvider;
this.table = table;
this.columns = columns;
this.constraints = constraints;
this.action = action;
this.Build();
store = new ListStore (typeof (string), typeof (string), typeof (bool), typeof (string), typeof (object));
storeColumns = new SortedColumnListStore (columns);
listCheck.Model = store;
TreeViewColumn colName = new TreeViewColumn ();
TreeViewColumn colColumn = new TreeViewColumn ();
TreeViewColumn colIsColumnConstraint = new TreeViewColumn ();
colName.Title = GettextCatalog.GetString ("Name");
colColumn.Title = GettextCatalog.GetString ("Column");
colIsColumnConstraint.Title = GettextCatalog.GetString ("Column Constraint");
colColumn.MinWidth = 120; //request a bigger width
CellRendererText nameRenderer = new CellRendererText ();
CellRendererCombo columnRenderer = new CellRendererCombo ();
CellRendererToggle isColumnConstraintRenderer = new CellRendererToggle ();
nameRenderer.Editable = true;
nameRenderer.Edited += new EditedHandler (NameEdited);
columnRenderer.Model = storeColumns.Store;
columnRenderer.TextColumn = SortedColumnListStore.ColNameIndex;
columnRenderer.Editable = true;
columnRenderer.Edited += new EditedHandler (ColumnEdited);
isColumnConstraintRenderer.Activatable = true;
isColumnConstraintRenderer.Toggled += new ToggledHandler (IsColumnConstraintToggled);
colName.PackStart (nameRenderer, true);
colColumn.PackStart (columnRenderer, true);
colIsColumnConstraint.PackStart (isColumnConstraintRenderer, true);
colName.AddAttribute (nameRenderer, "text", colNameIndex);
colColumn.AddAttribute (columnRenderer, "text", colColumnNameIndex);
colIsColumnConstraint.AddAttribute (isColumnConstraintRenderer, "active", colIsColumnConstraintIndex);
IDbFactory fac = schemaProvider.ConnectionPool.DbFactory;
columnConstraintsSupported = fac.IsCapabilitySupported ("TableColumn", action, TableCapabilities.CheckConstraint);
tableConstraintsSupported = fac.IsCapabilitySupported ("Table", action, TableCapabilities.CheckConstraint);
listCheck.AppendColumn (colName);
if (columnConstraintsSupported)
listCheck.AppendColumn (colColumn);
if (columnConstraintsSupported && tableConstraintsSupported)
listCheck.AppendColumn (colIsColumnConstraint);
listCheck.Selection.Changed += new EventHandler (OnSelectionChanged);
sqlEditor.TextChanged += new EventHandler (SourceChanged);
foreach (CheckConstraintSchema check in constraints.GetConstraints (ConstraintType.Check))
AddConstraint (check);
//TODO: also col constraints
ShowAll ();
}
