/* * Copyright (c) 2019 TAOS Data, Inc. * * This program is free software: you can use, redistribute, and/or modify * it under the terms of the GNU Affero General Public License, version 3 * or later ("AGPL"), as published by the Free Software Foundation. * * This program is distributed in the hope that it will be useful, but WITHOUT * ANY WARRANTY; without even the implied warranty of MERCHANTABILITY or * FITNESS FOR A PARTICULAR PURPOSE. * * You should have received a copy of the GNU Affero General Public License * along with this program. If not, see . */ #include #include #include #include #include #include "httpJson.h" #include "restHandle.h" #include "restJson.h" void restBuildSqlAffectRowsJson(HttpContext *pContext, HttpSqlCmd *cmd, int affect_rows) { JsonBuf *jsonBuf = httpMallocJsonBuf(pContext); if (jsonBuf == NULL) return; // data row array begin httpJsonItemToken(jsonBuf); httpJsonToken(jsonBuf, JsonArrStt); httpJsonItemToken(jsonBuf); httpJsonInt(jsonBuf, affect_rows); // data row array end httpJsonToken(jsonBuf, JsonArrEnd); cmd->numOfRows = affect_rows; } void restStartSqlJson(HttpContext *pContext, HttpSqlCmd *cmd, TAOS_RES *result) { JsonBuf *jsonBuf = httpMallocJsonBuf(pContext); if (jsonBuf == NULL) return; TAOS_FIELD *fields = taos_fetch_fields(result); int num_fields = taos_num_fields(result); httpInitJsonBuf(jsonBuf, pContext); httpWriteJsonBufHead(jsonBuf); // object begin httpJsonToken(jsonBuf, JsonObjStt); // status, and data httpJsonItemToken(jsonBuf); httpJsonPair(jsonBuf, REST_JSON_STATUS, REST_JSON_STATUS_LEN, REST_JSON_SUCCESS, REST_JSON_SUCCESS_LEN); // head begin httpJsonItemToken(jsonBuf); httpJsonPairHead(jsonBuf, REST_JSON_HEAD, REST_JSON_HEAD_LEN); // head array begin httpJsonItemToken(jsonBuf); httpJsonToken(jsonBuf, JsonArrStt); if (num_fields == 0) { httpJsonItemToken(jsonBuf); httpJsonString(jsonBuf, REST_JSON_AFFECT_ROWS, REST_JSON_AFFECT_ROWS_LEN); } else { for (int i = 0; i < num_fields; ++i) { httpJsonItemToken(jsonBuf); httpJsonString(jsonBuf, fields[i].name, (int)strlen(fields[i].name)); } } // head array end httpJsonToken(jsonBuf, JsonArrEnd); // data begin httpJsonItemToken(jsonBuf); httpJsonPairHead(jsonBuf, REST_JSON_DATA, REST_JSON_DATA_LEN); // data array begin httpJsonItemToken(jsonBuf); httpJsonToken(jsonBuf, JsonArrStt); } bool restBuildSqlJson(HttpContext *pContext, HttpSqlCmd *cmd, TAOS_RES *result, int numOfRows) { JsonBuf *jsonBuf = httpMallocJsonBuf(pContext); if (jsonBuf == NULL) return false; cmd->numOfRows += numOfRows; int num_fields = taos_num_fields(result); TAOS_FIELD *fields = taos_fetch_fields(result); for (int i = 0; i < numOfRows; ++i) { TAOS_ROW row = taos_fetch_row(result); // data row array begin httpJsonItemToken(jsonBuf); httpJsonToken(jsonBuf, JsonArrStt); for (int i = 0; i < num_fields; i++) { httpJsonItemToken(jsonBuf); if (row[i] == NULL) { httpJsonString(jsonBuf, "NULL", 4); continue; } switch (fields[i].type) { case TSDB_DATA_TYPE_BOOL: case TSDB_DATA_TYPE_TINYINT: httpJsonInt(jsonBuf, *((int8_t *)row[i])); break; case TSDB_DATA_TYPE_SMALLINT: httpJsonInt(jsonBuf, *((int16_t *)row[i])); break; case TSDB_DATA_TYPE_INT: httpJsonInt(jsonBuf, *((int32_t *)row[i])); break; case TSDB_DATA_TYPE_BIGINT: httpJsonInt64(jsonBuf, *((int64_t *)row[i])); break; case TSDB_DATA_TYPE_FLOAT: httpJsonFloat(jsonBuf, *((float *)row[i])); break; case TSDB_DATA_TYPE_DOUBLE: httpJsonDouble(jsonBuf, *((double *)row[i])); break; case TSDB_DATA_TYPE_BINARY: case TSDB_DATA_TYPE_NCHAR: httpJsonStringForTransMean(jsonBuf, row[i], fields[i].bytes); break; case TSDB_DATA_TYPE_TIMESTAMP: // httpJsonInt64(jsonBuf, *((int64_t *)row[i])); // httpTimeToString(*((int64_t *)row[i]), timeBuf, 32); // httpJsonString(jsonBuf, timeBuf, strlen(timeBuf)); httpJsonTimestamp(jsonBuf, *((int64_t *)row[i])); break; default: break; } } // data row array end httpJsonToken(jsonBuf, JsonArrEnd); } httpTrace("context:%p, fd:%d, ip:%s, user:%s, total rows:%lld retrieved", pContext, pContext->fd, pContext->ipstr, pContext->user, cmd->numOfRows); return true; } bool restBuildSqlTimeJson(HttpContext *pContext, HttpSqlCmd *cmd, TAOS_RES *result, int numOfRows) { JsonBuf *jsonBuf = httpMallocJsonBuf(pContext); if (jsonBuf == NULL) return false; cmd->numOfRows += numOfRows; int num_fields = taos_num_fields(result); TAOS_FIELD *fields = taos_fetch_fields(result); for (int i = 0; i < numOfRows; ++i) { TAOS_ROW row = taos_fetch_row(result); // data row array begin httpJsonItemToken(jsonBuf); httpJsonToken(jsonBuf, JsonArrStt); for (int i = 0; i < num_fields; i++) { httpJsonItemToken(jsonBuf); if (row[i] == NULL) { httpJsonString(jsonBuf, "NULL", 4); continue; } switch (fields[i].type) { case TSDB_DATA_TYPE_BOOL: case TSDB_DATA_TYPE_TINYINT: httpJsonInt(jsonBuf, *((int8_t *)row[i])); break; case TSDB_DATA_TYPE_SMALLINT: httpJsonInt(jsonBuf, *((int16_t *)row[i])); break; case TSDB_DATA_TYPE_INT: httpJsonInt(jsonBuf, *((int32_t *)row[i])); break; case TSDB_DATA_TYPE_BIGINT: httpJsonInt64(jsonBuf, *((int64_t *)row[i])); break; case TSDB_DATA_TYPE_FLOAT: httpJsonFloat(jsonBuf, *((float *)row[i])); break; case TSDB_DATA_TYPE_DOUBLE: httpJsonDouble(jsonBuf, *((double *)row[i])); break; case TSDB_DATA_TYPE_BINARY: case TSDB_DATA_TYPE_NCHAR: httpJsonStringForTransMean(jsonBuf, row[i], fields[i].bytes); break; case TSDB_DATA_TYPE_TIMESTAMP: httpJsonInt64(jsonBuf, *((int64_t *)row[i])); // httpTimeToString(*((int64_t *)row[i]), timeBuf, 32); // httpJsonString(jsonBuf, timeBuf, strlen(timeBuf)); // httpJsonTimestamp(jsonBuf, *((int64_t *)row[i])); break; default: break; } } // data row array end httpJsonToken(jsonBuf, JsonArrEnd); } return true; } void restStopSqlJson(HttpContext *pContext, HttpSqlCmd *cmd) { JsonBuf *jsonBuf = httpMallocJsonBuf(pContext); if (jsonBuf == NULL) return; // data array end httpJsonToken(jsonBuf, JsonArrEnd); // rows httpJsonItemToken(jsonBuf); httpJsonPairHead(jsonBuf, REST_JSON_ROWS, REST_JSON_ROWS_LEN); httpJsonInt64(jsonBuf, cmd->numOfRows); // object end httpJsonToken(jsonBuf, JsonObjEnd); httpWriteJsonBufEnd(jsonBuf); }