Implement dialog to add/edit a single channel in database

#69 (closed)

Implement a dialog to add/edit a single channel and a dialog to edit parameter that is call from the channel dialog

• Currently using QLineEdit for display/editing ValueColor. Later, a custom widget will be developed to have better display and easier editing.
• Parameter 'Default' is only display for the channel that has no record in DB but won't be allow to select or save or call para dialog to edit.

For testing add/edit single channel, run sohstationviewer/view/db_config/add_edit_single_channel_dialog.py and change the example lines in main

For testing edit single param, run sohstationviewer/view/db_config/add_edit_single_channel_dialog.py and change the example lines in main; or press on button 'EDIT PARAMETER' of the above dialog.

sohstationviewer/conf/dbSettings.py

 import re
+import os
+from pathlib import Path
 
 from sohstationviewer.conf.constants import (WF_1ST, WF_2ND, WF_3RD)
 """
@@ -42,3 +44,20 @@ dbConf = {
             "If D is not defined, dots won't be displayed.\n"
             "If L is not defined, lines will be plotted with color G")}
 }
+
+
+def modify_db_path():
+    """
+    Modify dbpath to absolute path.
+
+    This function is called in case database needs to be used when the working
+    directory is a sub folder of root, sohstationviewer/. The following lines
+    need to be added:
+        from sohstationviewer.conf.dbSettings import modify_db_path
+        modify_db_path()
+    """
+    global dbConf
+    current_file_path = os.path.abspath(__file__)
+    root = Path(current_file_path).parent.parent
+    db_path = [x for x in root.glob('**/soh.db')][0]
+    dbConf['dbpath'] = db_path.as_posix()