gw_fct_setfileinsert - Giswater/giswater_dbmodel GitHub Wiki

---

Description

Function that manages inserts files related to visits.

Input example

SELECT gw_fct_setfileinsert($${
"client":{"device":4, "infoType":1, "lang":"ES"},
"feature":{"featureType":"file", "tableName":"om_visit_event_photo", "id":13, "idName": "id"}, 
"data":{"fields":{"visit_id":13, "hash":"testhash", "url":"urltest", 
"fextension":"png","idval":"file1"},
"deviceTrace":{"xcoord":8597877, "ycoord":5346534, "compass":123}}}$$)	

Output example

{
  "status": "Accepted",
  "message": {
    "status": "Accepted",
    "message": {
      "level": 3,
      "text": "Message passed successfully"
    },
    "version": "3.5.003",
    "body": {
      "form": {},
      "data": {
        "info": {
          "level": 3,
          "status": "Accepted",
          "message": "Function: gw_fct_setinsert - sucessfully inserted. HINT: None."
        }
      }
    }
  },
  "version": {
    "value": "3.5.003"
  },
  "body": {
    "feature": {
      "id": "17484"
    }
  }
}