gw_fct_import_dbprices - Giswater/giswater_dbmodel GitHub Wiki

---

Description

Function to import prices from csv file into database

Input example

SELECT gw_fct_import_dbprices($${
"client":{"device":4, "infoType":1, "lang":"ES"},
"feature":{},"data":{}}$$)

Output example

{
  "status": "Accepted",
  "message": {
    "level": 3,
    "text": "Process done successfully"
  },
  "version": "3.5.003",
  "body": {
    "form": {},
    "data": {
      "info": {
        "geometryType": "",
        "values": [
          {
            "id": 710,
            "message": "IMPORT DB PRICES FILE"
          },
          {
            "id": 711,
            "message": "------------------------------"
          },
          {
            "id": 712,
            "message": "Reading values from temp_csv table -> Done"
          },
          {
            "id": 713,
            "message": "Inserting values on plan_price table -> Done"
          },
          {
            "id": 714,
            "message": "Deleting values from temp_csv -> Done"
          },
          {
            "id": 715,
            "message": "Process finished"
          }
        ]
      }
    }
  }
}