ConstraintWidget::ConstraintWidget(QWidget *parent): BaseObjectWidget(parent, OBJ_CONSTRAINT)
{
try
{
QStringList list;
map<QString, vector<QWidget *> > fields_map;
QGridLayout *grid=nullptr;
Ui_ConstraintWidget::setupUi(this);
excl_elems_wgt=new ElementsWidget(this);
grid=new QGridLayout;
grid->setContentsMargins(4,4,4,4);
grid->addWidget(excl_elems_wgt,0,0);
excl_elems_grp->setLayout(grid);
expression_hl=new SyntaxHighlighter(expression_txt);
expression_hl->loadConfiguration(GlobalAttributes::SQL_HIGHLIGHT_CONF_PATH);
columns_tab=new ObjectTableWidget(ObjectTableWidget::ALL_BUTTONS ^
(ObjectTableWidget::EDIT_BUTTON |
ObjectTableWidget::UPDATE_BUTTON), true, this);
ref_columns_tab=new ObjectTableWidget(ObjectTableWidget::ALL_BUTTONS ^
(ObjectTableWidget::EDIT_BUTTON |
ObjectTableWidget::UPDATE_BUTTON), true, this);
ref_table_sel=new ObjectSelectorWidget(OBJ_TABLE, true, this);
columns_tab->setColumnCount(2);
columns_tab->setHeaderLabel(trUtf8("Column"), 0);
columns_tab->setHeaderIcon(QPixmap(QString(":/icones/icones/column.png")),0);
columns_tab->setHeaderLabel(trUtf8("Type"), 1);
columns_tab->setHeaderIcon(QPixmap(QString(":/icones/icones/usertype.png")),1);
ref_columns_tab->setEnabled(false);
ref_columns_tab->setColumnCount(2);
ref_columns_tab->setHeaderLabel(trUtf8("Column"), 0);
ref_columns_tab->setHeaderIcon(QPixmap(QString(":/icones/icones/column.png")),0);
ref_columns_tab->setHeaderLabel(trUtf8("Type"), 1);
ref_columns_tab->setHeaderIcon(QPixmap(QString(":/icones/icones/usertype.png")),1);
dynamic_cast<QGridLayout *>(columns_tbw->widget(0)->layout())->addWidget(columns_tab, 1,0,1,3);
dynamic_cast<QGridLayout *>(columns_tbw->widget(1)->layout())->addWidget(ref_table_sel, 0,1,1,2);
dynamic_cast<QGridLayout *>(columns_tbw->widget(1)->layout())->addWidget(ref_columns_tab, 3,0,1,3);
configureFormLayout(constraint_grid, OBJ_CONSTRAINT);
ConstraintType::getTypes(list);
constr_type_cmb->addItems(list);
MatchType::getTypes(list);
match_cmb->addItems(list);
DeferralType::getTypes(list);
deferral_cmb->addItems(list);
ActionType::getTypes(list);
on_delete_cmb->addItems(list);
on_update_cmb->addItems(list);
IndexingType::getTypes(list);
indexing_cmb->addItems(list);
info_frm=generateInformationFrame(trUtf8("Columns which were included by relationship can not be added / removed manually from the primary key. If done such changes they can raise errors. To create primary key using columns included by relationship use the following options: identifier field, attributes & constraints tab or primary key tab on the relationship form."));
constraint_grid->addWidget(info_frm, constraint_grid->count()+1, 0, 1, 0);
info_frm->setParent(this);
fields_map[generateVersionsInterval(AFTER_VERSION, PgSQLVersions::PGSQL_VERSION_92)].push_back(no_inherit_lbl);
warn_frm=generateVersionWarningFrame(fields_map);
constraint_grid->addWidget(warn_frm, constraint_grid->count()+1, 0, 1, 0);
warn_frm->setParent(this);
connect(parent_form->apply_ok_btn,SIGNAL(clicked(bool)), this, SLOT(applyConfiguration(void)));
connect(constr_type_cmb, SIGNAL(currentIndexChanged(int)), this, SLOT(selectConstraintType(void)));
connect(deferrable_chk, SIGNAL(toggled(bool)), deferral_cmb, SLOT(setEnabled(bool)));
connect(deferrable_chk, SIGNAL(toggled(bool)), deferral_lbl, SLOT(setEnabled(bool)));
connect(indexing_chk, SIGNAL(toggled(bool)), indexing_cmb, SLOT(setEnabled(bool)));
connect(columns_tab, SIGNAL(s_rowAdded(int)), this, SLOT(addColumn(int)));
connect(columns_tab, SIGNAL(s_rowRemoved(int)), this, SLOT(removeColumn(int)));
connect(columns_tab, SIGNAL(s_rowsRemoved(void)), this, SLOT(removeColumns(void)));
connect(ref_columns_tab, SIGNAL(s_rowAdded(int)), this, SLOT(addColumn(int)));
connect(ref_columns_tab, SIGNAL(s_rowRemoved(int)), this, SLOT(removeColumn(int)));
connect(ref_columns_tab, SIGNAL(s_rowsRemoved(void)), this, SLOT(removeColumns(void)));
connect(ref_table_sel, SIGNAL(s_selectorCleared(void)), this, SLOT(selectReferencedTable(void)));
connect(ref_table_sel, SIGNAL(s_objectSelected(void)), this, SLOT(selectReferencedTable(void)));
connect(fill_factor_chk, SIGNAL(toggled(bool)), fill_factor_sb, SLOT(setEnabled(bool)));
parent_form->setMinimumSize(600, 640);
selectConstraintType();
configureTabOrder();
}
catch(Exception &e)
{
throw Exception(e.getErrorMessage(),e.getErrorType(),__PRETTY_FUNCTION__,__FILE__,__LINE__, &e);
}
}
ConstraintWidget::ConstraintWidget(QWidget *parent): BaseObjectWidget(parent, OBJ_CONSTRAINT)
{
try
{
QStringList list;
Ui_ConstraintWidget::setupUi(this);
check_expr_hl=new SyntaxHighlighter(check_expr_txt, false);
check_expr_hl->loadConfiguration(GlobalAttributes::CONFIGURATIONS_DIR +
GlobalAttributes::DIR_SEPARATOR +
GlobalAttributes::SQL_HIGHLIGHT_CONF +
GlobalAttributes::CONFIGURATION_EXT);
columns_tab=new ObjectTableWidget(ObjectTableWidget::ALL_BUTTONS ^
(ObjectTableWidget::EDIT_BUTTON |
ObjectTableWidget::UPDATE_BUTTON), true, this);
ref_columns_tab=new ObjectTableWidget(ObjectTableWidget::ALL_BUTTONS ^
(ObjectTableWidget::EDIT_BUTTON |
ObjectTableWidget::UPDATE_BUTTON), true, this);
ref_table_sel=new ObjectSelectorWidget(OBJ_TABLE, true, this);
columns_tab->setColumnCount(2);
columns_tab->setHeaderLabel(trUtf8("Column"), 0);
columns_tab->setHeaderIcon(QPixmap(":/icones/icones/column.png"),0);
columns_tab->setHeaderLabel(trUtf8("Type"), 1);
columns_tab->setHeaderIcon(QPixmap(":/icones/icones/usertype.png"),1);
ref_columns_tab->setEnabled(false);
ref_columns_tab->setColumnCount(2);
ref_columns_tab->setHeaderLabel(trUtf8("Column"), 0);
ref_columns_tab->setHeaderIcon(QPixmap(":/icones/icones/column.png"),0);
ref_columns_tab->setHeaderLabel(trUtf8("Type"), 1);
ref_columns_tab->setHeaderIcon(QPixmap(":/icones/icones/usertype.png"),1);
dynamic_cast<QGridLayout *>(columns_tbw->widget(0)->layout())->addWidget(columns_tab, 1,0,1,3);
dynamic_cast<QGridLayout *>(columns_tbw->widget(1)->layout())->addWidget(ref_table_sel, 0,1,1,2);
dynamic_cast<QGridLayout *>(columns_tbw->widget(1)->layout())->addWidget(ref_columns_tab, 3,0,1,3);
configureFormLayout(constraint_grid, OBJ_CONSTRAINT);
parent_form->setMinimumSize(580, 560);
ConstraintType::getTypes(list);
constr_type_cmb->addItems(list);
selectConstraintType();
MatchType::getTypes(list);
match_cmb->addItems(list);
DeferralType::getTypes(list);
deferral_cmb->addItems(list);
ActionType::getTypes(list);
on_delete_cmb->addItems(list);
on_update_cmb->addItems(list);
info_frm=generateInformationFrame(trUtf8("Columns which were included by relationship can not be added / removed manually from the primary key. If done such changes they will be ignored. To create primary key using columns included by relationship use the feature attributes, constraints and primary key on the relationship form."));
constraint_grid->addWidget(info_frm, constraint_grid->count()+1, 0, 1, 0);
info_frm->setParent(this);
connect(parent_form->apply_ok_btn,SIGNAL(clicked(bool)), this, SLOT(applyConfiguration(void)));
connect(constr_type_cmb, SIGNAL(currentIndexChanged(int)), this, SLOT(selectConstraintType(void)));
connect(deferrable_chk, SIGNAL(toggled(bool)), deferral_cmb, SLOT(setEnabled(bool)));
connect(deferrable_chk, SIGNAL(toggled(bool)), deferral_lbl, SLOT(setEnabled(bool)));
connect(columns_tab, SIGNAL(s_rowAdded(int)), this, SLOT(addColumn(int)));
connect(columns_tab, SIGNAL(s_rowRemoved(int)), this, SLOT(removeColumn(int)));
connect(columns_tab, SIGNAL(s_rowsRemoved(void)), this, SLOT(removeColumns(void)));
connect(ref_columns_tab, SIGNAL(s_rowAdded(int)), this, SLOT(addColumn(int)));
connect(ref_columns_tab, SIGNAL(s_rowRemoved(int)), this, SLOT(removeColumn(int)));
connect(ref_columns_tab, SIGNAL(s_rowsRemoved(void)), this, SLOT(removeColumns(void)));
connect(ref_table_sel, SIGNAL(s_selectorCleared(void)), this, SLOT(selectReferencedTable(void)));
connect(ref_table_sel, SIGNAL(s_objectSelected(void)), this, SLOT(selectReferencedTable(void)));
}
catch(Exception &e)
{
throw Exception(e.getErrorMessage(),e.getErrorType(),__PRETTY_FUNCTION__,__FILE__,__LINE__, &e);
}
}