Changeset 903 for branches/prototype-v0/thirds/zcfg2sql/zcfg2sql.c

Timestamp:

Apr 19, 2019, 4:08:59 PM (5 years ago)

Author:

djay

Message:

Fix issue with UOM definitions

File:

• branches/prototype-v0/thirds/zcfg2sql/zcfg2sql.c (modified) (5 diffs)

branches/prototype-v0/thirds/zcfg2sql/zcfg2sql.c

@@ -2 +2 @@
  * Author : Gérald FENOY
  *
- *  Copyright (c) 2017 GeoLabs SARL. All rights reserved.
+ *  Copyright (c) 2017-2019 GeoLabs SARL. All rights reserved.
  *
  * Permission is hereby granted, free of charge, to any person obtaining a copy
@@ -96 +96 @@
             if(values[2]!=NULL)
               fprintf(f,"UPDATE CollectionDB.LiteralDataDomain \n"
-                      "set uom = (SELECT id from CollectionDB.PrimitiveDatatypes WHERE name=$q$%s$q$ \n WHERE id = \n"
+                      "set uom = (SELECT id from CollectionDB.PrimitiveUOM WHERE uom=$q$%s$q$) \n WHERE id = \n"
                       "  (SELECT last_value FROM CollectionDB.ows_DataDescription_id_seq);\n ",
                       values[2]->value);
@@ -299 +299 @@
               getMap(tmpio->content,"AllowedValues")
             };
+            map* values0[4]={
+              getMap(tmp->defaults->content,"dataType"),
+              getMap(tmp->defaults->content,"value"),
+              getMap(tmp->defaults->content,"uom"),
+              getMap(tmp->defaults->content,"AllowedValues")
+            };
             char *fields[20]={
               "default_value",
@@ -305 +311 @@
             fprintf(f,"INSERT INTO CollectionDB.LiteralDataDomain"
                     " (def,data_type_id) VALUES \n(false,");
-            fprintf(f,"(SELECT id from CollectionDB.PrimitiveDatatypes"
-                    " where name = '%s'));\n",values[0]->value);
+            if(values[0]!=NULL)
+              fprintf(f,"(SELECT id from CollectionDB.PrimitiveDatatypes"
+                      " where name = '%s'));\n",values[0]->value);
+            else
+              fprintf(f,"(SELECT id from CollectionDB.PrimitiveDatatypes"
+                      " where name = '%s'));\n",values0[0]->value);
             if(values[1]!=NULL)
               fprintf(f,"UPDATE CollectionDB.LiteralDataDomain \n"
@@ -312 +322 @@
                       "  ((SELECT last_value FROM CollectionDB.ows_DataDescription_id_seq));\n ",
                       fields[0],values[1]->value);
+            if(values[2]!=NULL)
+              fprintf(f,"UPDATE CollectionDB.LiteralDataDomain \n"
+                      "set uom = (SELECT id from CollectionDB.PrimitiveUOM WHERE uom=$q$%s$q$) \n WHERE id = \n"
+                      "  (SELECT last_value FROM CollectionDB.ows_DataDescription_id_seq);\n ",
+                      values[2]->value);
+            if(type!=NULL)
             fprintf(f,"INSERT INTO CollectionDB.%sDataDescriptionAssignment"
                     " (%s_id,data_description_id) VALUES "