-
Notifications
You must be signed in to change notification settings - Fork 11
gw_fct_import_dbprices
Edgar Fuste edited this page Nov 2, 2021
·
1 revision
Function to import prices from csv file into database
SELECT gw_fct_import_dbprices($${
"client":{"device":4, "infoType":1, "lang":"ES"},
"feature":{},"data":{}}$$)
{
"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"
}
]
}
}
}
}