Add assignment of ON CONFLICT clause into GUI

dnuzhdin · MKleusberg · commit 6448ed7eacf1 · 2021-08-10T14:16:20.000+02:00
diff --git a/src/EditTableDialog.cpp b/src/EditTableDialog.cpp
@@ -96,6 +96,13 @@ EditTableDialog::EditTableDialog(DBBrowserDB& db, const sqlb::ObjectIdentifier&
         ui->comboSchema->setCurrentText(QString::fromStdString(curTable.schema()));
         ui->comboSchema->blockSignals(false);
 
+        if(m_table.primaryKey())
+        {
+            ui->checkWithoutRowid->blockSignals(true);
+            ui->comboOnConflict->setCurrentText(QString::fromStdString(m_table.primaryKey()->conflictAction()).toUpper());
+            ui->checkWithoutRowid->blockSignals(false);
+        }
+
         populateFields();
         populateConstraints();
     } else {
@@ -981,6 +988,26 @@ void EditTableDialog::changeSchema(const QString& /*schema*/)
     updateSqlText();
 }
 
+void EditTableDialog::setOnConflict(const QString& on_conflict)
+{
+    if(m_table.primaryKey())
+    {
+        m_table.primaryKey()->setConflictAction(on_conflict.toStdString());
+    } else {
+        QMessageBox::information(this, QApplication::applicationName(),
+                                 tr("Please add a field which meets the following criteria before setting the on conflict action:\n"
+                                    " - Primary key flag set"));
+
+        ui->comboOnConflict->blockSignals(true);
+        ui->comboOnConflict->setCurrentText(QString());
+        ui->comboOnConflict->blockSignals(false);
+        return;
+    }
+
+    // Update the SQL preview
+    updateSqlText();
+}
+
 void EditTableDialog::removeConstraint()
 {
     // Is there any item selected to delete?
diff --git a/src/EditTableDialog.h b/src/EditTableDialog.h
@@ -85,6 +85,7 @@ private slots:
     void changeSchema(const QString& schema);
     void removeConstraint();
     void addConstraint(sqlb::Constraint::ConstraintTypes type);
+    void setOnConflict(const QString& on_conflict);
 
 private:
     Ui::EditTableDialog* ui;
diff --git a/src/EditTableDialog.ui b/src/EditTableDialog.ui
@@ -86,6 +86,47 @@
            </property>
           </widget>
          </item>
+         <item row="2" column="0">
+          <widget class="QLabel" name="label_2">
+           <property name="text">
+            <string>On Conflict</string>
+           </property>
+          </widget>
+         </item>
+         <item row="2" column="1">
+          <widget class="QComboBox" name="comboOnConflict">
+           <item>
+            <property name="text">
+             <string notr="true"/>
+            </property>
+           </item>
+           <item>
+            <property name="text">
+             <string notr="true">ROLLBACK</string>
+            </property>
+           </item>
+           <item>
+            <property name="text">
+             <string notr="true">ABORT</string>
+            </property>
+           </item>
+           <item>
+            <property name="text">
+             <string notr="true">FAIL</string>
+            </property>
+           </item>
+           <item>
+            <property name="text">
+             <string notr="true">IGNORE</string>
+            </property>
+           </item>
+           <item>
+            <property name="text">
+             <string notr="true">REPLACE</string>
+            </property>
+           </item>
+          </widget>
+         </item>
         </layout>
        </widget>
       </item>
@@ -778,6 +819,22 @@
     </hint>
    </hints>
   </connection>
+  <connection>
+   <sender>comboOnConflict</sender>
+   <signal>currentIndexChanged(QString)</signal>
+   <receiver>EditTableDialog</receiver>
+   <slot>setOnConflict(QString)</slot>
+   <hints>
+    <hint type="sourcelabel">
+     <x>371</x>
+     <y>168</y>
+    </hint>
+    <hint type="destinationlabel">
+     <x>490</x>
+     <y>211</y>
+    </hint>
+   </hints>
+  </connection>
  </connections>
  <slots>
   <slot>fieldSelectionChanged()</slot>
@@ -793,5 +850,6 @@
   <slot>removeConstraint()</slot>
   <slot>moveTop()</slot>
   <slot>moveBottom()</slot>
+  <slot>setOnConflict(QString)</slot>
  </slots>
 </ui>
