Menu ▾ ▴

#699 Create a logical value column

v1.1.x
closed
Erik Hänel
internal (109) datamanagement (17)
v1.1.5
New Functionality
2023-02-16
2022-05-03
Erik Hänel
No

Create a column, which will only contain logical values. Shall be convertible to a value and a string column. Furthermore, a value column shall be convertible to a logical column, a string column might be convertible. Date-time columns are excluded and need to first converted to or from a value column.

Analysis:

To implement s.th. like that, we need to introduce a new enum LogicalValue with the values LOGICAL_NAN=-1, LOGICAL_FALSE=0, LOGICAL_TRUE=1 to actually represent empty values in this column.

String values to be automatically convertible are "true", "false" (case independent) and "0" and "1".

Implementation:

  • Implementation: Implemented as proposed by the analysis.
  • Revision: [r1240]
  • Implementation test: Logical values were used within a table and conversion was working.

Documentation:

  • [x] ChangesLog updated
  • [x] Code changes commented
  • Documentation articles:
    • [x] corresponding documentation articles updated
    • [ ] new documentation articles created
    • [ ] not needed
  • Language files:
    • [x] corresponding language files updated
    • [ ] not needed

Tests:

Functionality was added to the automatic SW tests. No deviations detected.

Related

Commit: [r1240]

Discussion

  • Erik Hänel

    Erik Hänel - 2022-08-12
    • Version: Planned --> v1.1.5
     

  • Erik Hänel

    Erik Hänel - 2022-09-21
    • labels: --> internal, datamanagement
    • status: open --> accepted
     

  • Erik Hänel

    Erik Hänel - 2022-09-21
    • Description has changed:

    Diff:

    --- old
+++ new
@@ -1 +1,23 @@
 Create a column, which will only contain logical values. Shall be convertible to a value and a string column. Furthermore, a value column shall be convertible to a logical column, a string column might be convertible. Date-time columns are excluded and need to first converted to or from a value column.
+
+###Analysis:
+(*Describe, what's the issue and which changes have to be made*)
+
+###Implementation:
+* Implementation: (*Describe, what you've changed*) 
+* Revision: [rXXX]
+* Implementation test: (*Describe the type of test, which you performed, and if it was successful*)
+
+###Documentation:
+* [ ] ChangesLog updated
+* [ ] Code changes commented
+* **Documentation articles:**

+    * [ ] corresponding documentation articles updated
+    * [ ] new documentation articles created
+    * [ ] not needed
+* **Language files:**
+    * [ ] corresponding language files updated
+    * [ ] not needed
+
+###Tests:
+(*Describe, which tests you performed and their outcome*)
    • status: accepted --> analyzing
     

  • Erik Hänel

    Erik Hänel - 2022-10-10
    • Description has changed:

    Diff:

    --- old
+++ new
@@ -1,7 +1,9 @@
 Create a column, which will only contain logical values. Shall be convertible to a value and a string column. Furthermore, a value column shall be convertible to a logical column, a string column might be convertible. Date-time columns are excluded and need to first converted to or from a value column.

 ###Analysis:
-(*Describe, what's the issue and which changes have to be made*)
+To implement s.th. like that, we need to introduce a new `enum LogicalValue` with the values `LOGICAL_NAN=-1, LOGICAL_FALSE=0, LOGICAL_TRUE=1` to actually represent empty values in this column.
+
+String values to be automatically convertible are `"true"`, `"false"` (case independent) and `"0"` and `"1"`.

 ###Implementation:

 * Implementation: (*Describe, what you've changed*)
    • status: analyzing --> implementing
     

  • Erik Hänel

    Erik Hänel - 2022-10-15
    • Description has changed:

    Diff:

    --- old
+++ new
@@ -6,19 +6,19 @@
 String values to be automatically convertible are `"true"`, `"false"` (case independent) and `"0"` and `"1"`.

 ###Implementation:
-* Implementation: (*Describe, what you've changed*) 
-* Revision: [rXXX]
-* Implementation test: (*Describe the type of test, which you performed, and if it was successful*)
+* Implementation: Implemented as proposed by the analysis.
+* Revision: [r1240]
+* Implementation test: Logical values were used within a table and conversion was working.

 ###Documentation:
-* [ ] ChangesLog updated
-* [ ] Code changes commented
+* [x] ChangesLog updated
+* [x] Code changes commented

 * **Documentation articles:**
-    * [ ] corresponding documentation articles updated
+    * [x] corresponding documentation articles updated
     * [ ] new documentation articles created
     * [ ] not needed
 * **Language files:**
-    * [ ] corresponding language files updated
+    * [x] corresponding language files updated
     * [ ] not needed

 ###Tests:
    • status: implementing --> testing
     

    Related

    Commit: [r1240]

  • Erik Hänel

    Erik Hänel - 2023-02-16
    • Description has changed:

    Diff:

    --- old
+++ new
@@ -22,4 +22,4 @@

     * [ ] not needed

 ###Tests:
-(*Describe, which tests you performed and their outcome*)
+Functionality was added to the automatic SW tests. No deviations detected.
    • status: testing --> closed
     

Anonymous
Anonymous

Add attachments
Cancel





MongoDB Logo MongoDB