clientMain.c 27.1 KB
Newer Older
L
Liu Jicong 已提交
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16
/*
 * Copyright (c) 2019 TAOS Data, Inc. <jhtao@taosdata.com>
 *
 * 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 <http://www.gnu.org/licenses/>.
 */

#include "catalog.h"
17
#include "clientInt.h"
18
#include "clientLog.h"
L
Liu Jicong 已提交
19
#include "clientStmt.h"
L
Liu Jicong 已提交
20
#include "os.h"
H
Haojun Liao 已提交
21
#include "query.h"
L
Liu Jicong 已提交
22
#include "scheduler.h"
23
#include "tglobal.h"
L
Liu Jicong 已提交
24 25 26
#include "tmsg.h"
#include "tref.h"
#include "trpc.h"
S
version  
Shengliang Guan 已提交
27
#include "version.h"
28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43

#define TSC_VAR_NOT_RELEASE 1
#define TSC_VAR_RELEASED    0

static int32_t sentinel = TSC_VAR_NOT_RELEASE;

int taos_options(TSDB_OPTION option, const void *arg, ...) {
  static int32_t lock = 0;

  for (int i = 1; atomic_val_compare_exchange_32(&lock, 0, 1) != 0; ++i) {
    if (i % 1000 == 0) {
      tscInfo("haven't acquire lock after spin %d times.", i);
      sched_yield();
    }
  }

L
Liu Jicong 已提交
44
  int ret = taos_options_imp(option, (const char *)arg);
45 46 47 48 49 50
  atomic_store_32(&lock, 0);
  return ret;
}

// this function may be called by user or system, or by both simultaneously.
void taos_cleanup(void) {
H
Haojun Liao 已提交
51
  tscInfo("start to cleanup client environment");
52 53 54 55 56

  if (atomic_val_compare_exchange_32(&sentinel, TSC_VAR_NOT_RELEASE, TSC_VAR_RELEASED) != TSC_VAR_NOT_RELEASE) {
    return;
  }

H
Haojun Liao 已提交
57 58
  int32_t id = clientReqRefPool;
  clientReqRefPool = -1;
59 60
  taosCloseRef(id);

H
Haojun Liao 已提交
61
  cleanupTaskQueue();
62

63 64
  id = clientConnRefPool;
  clientConnRefPool = -1;
65 66
  taosCloseRef(id);

67 68
  hbMgrCleanUp();

D
dapan1121 已提交
69
  catalogDestroy();
D
dapan1121 已提交
70
  schedulerDestroy();
H
Haojun Liao 已提交
71

D
dapan1121 已提交
72 73
  rpcCleanup();

H
Haojun Liao 已提交
74
  tscInfo("all local resources released");
75
  taosCleanupCfg();
76
  taosCloseLog();
77 78
}

L
Liu Jicong 已提交
79
setConfRet taos_set_config(const char *config) {
80 81 82 83 84
  // TODO
  setConfRet ret = {SET_CONF_RET_SUCC, {0}};
  return ret;
}

85
TAOS *taos_connect(const char *ip, const char *user, const char *pass, const char *db, uint16_t port) {
S
Shengliang Guan 已提交
86
  tscDebug("try to connect to %s:%u, user:%s db:%s", ip, port, user, db);
H
Haojun Liao 已提交
87 88 89
  if (user == NULL) {
    user = TSDB_DEFAULT_USER;
  }
90

H
Haojun Liao 已提交
91 92 93
  if (pass == NULL) {
    pass = TSDB_DEFAULT_PASS;
  }
94

L
Liu Jicong 已提交
95
  return taos_connect_internal(ip, user, pass, NULL, db, port, CONN_TYPE__QUERY);
96 97
}

L
Liu Jicong 已提交
98
void taos_close(TAOS *taos) {
99 100 101 102
  if (taos == NULL) {
    return;
  }

H
Haojun Liao 已提交
103
  STscObj *pTscObj = (STscObj *)taos;
L
Liu Jicong 已提交
104
  tscDebug("0x%" PRIx64 " try to close connection, numOfReq:%d", pTscObj->id, pTscObj->numOfReqs);
105

D
dapan1121 已提交
106
  taosRemoveRef(clientConnRefPool, pTscObj->id);
107 108
}

109 110 111 112 113
int taos_errno(TAOS_RES *tres) {
  if (tres == NULL) {
    return terrno;
  }

114 115 116 117
  if (TD_RES_TMQ(tres)) {
    return 0;
  }

L
Liu Jicong 已提交
118
  return ((SRequestObj *)tres)->code;
119 120
}

121
const char *taos_errstr(TAOS_RES *res) {
122
  if (res == NULL) {
L
Liu Jicong 已提交
123
    return (const char *)tstrerror(terrno);
124 125
  }

126 127 128 129 130
  if (TD_RES_TMQ(res)) {
    return "success";
  }

  SRequestObj *pRequest = (SRequestObj *)res;
131
  if (NULL != pRequest->msgBuf && (strlen(pRequest->msgBuf) > 0 || pRequest->code == TSDB_CODE_RPC_FQDN_ERROR)) {
132 133
    return pRequest->msgBuf;
  } else {
L
Liu Jicong 已提交
134
    return (const char *)tstrerror(pRequest->code);
135
  }
136 137 138
}

void taos_free_result(TAOS_RES *res) {
D
stmt  
dapan1121 已提交
139 140 141
  if (NULL == res) {
    return;
  }
142

L
Liu Jicong 已提交
143 144 145
  if (TD_RES_QUERY(res)) {
    SRequestObj *pRequest = (SRequestObj *)res;
    destroyRequest(pRequest);
L
Liu Jicong 已提交
146 147 148 149 150 151
  } else if (TD_RES_TMQ(res)) {
    SMqRspObj *pRsp = (SMqRspObj *)res;
    if (pRsp->rsp.blockData) taosArrayDestroyP(pRsp->rsp.blockData, taosMemoryFree);
    if (pRsp->rsp.blockDataLen) taosArrayDestroy(pRsp->rsp.blockDataLen);
    if (pRsp->rsp.blockTags) taosArrayDestroy(pRsp->rsp.blockTags);
    if (pRsp->rsp.blockTagSchema) taosArrayDestroy(pRsp->rsp.blockTagSchema);
L
Liu Jicong 已提交
152 153
    if (pRsp->rsp.withTbName) taosArrayDestroyP(pRsp->rsp.blockTbName, taosMemoryFree);
    if (pRsp->rsp.withSchema) taosArrayDestroyP(pRsp->rsp.blockSchema, (FDelete)tDeleteSSchemaWrapper);
L
Liu Jicong 已提交
154 155
    pRsp->resInfo.pRspMsg = NULL;
    doFreeReqResultInfo(&pRsp->resInfo);
L
Liu Jicong 已提交
156
  }
157 158
}

L
Liu Jicong 已提交
159
int taos_field_count(TAOS_RES *res) {
H
Haojun Liao 已提交
160 161 162 163
  if (res == NULL) {
    return 0;
  }

L
Liu Jicong 已提交
164
  SReqResultInfo *pResInfo = tscGetCurResInfo(res);
H
Haojun Liao 已提交
165 166 167
  return pResInfo->numOfCols;
}

L
Liu Jicong 已提交
168
int taos_num_fields(TAOS_RES *res) { return taos_field_count(res); }
H
Haojun Liao 已提交
169 170 171 172 173 174

TAOS_FIELD *taos_fetch_fields(TAOS_RES *res) {
  if (taos_num_fields(res) == 0) {
    return NULL;
  }

L
Liu Jicong 已提交
175
  SReqResultInfo *pResInfo = tscGetCurResInfo(res);
176
  return pResInfo->userFields;
H
Haojun Liao 已提交
177 178
}

179 180 181 182 183 184 185 186
static void syncQueryFn(void* param, void* res, int32_t code) {
  SSyncQueryParam* pParam = param;
  pParam->pRequest = res;
  pParam->pRequest->code = code;

  tsem_post(&pParam->sem);
}

187 188 189 190 191
TAOS_RES *taos_query(TAOS *taos, const char *sql) {
  if (taos == NULL || sql == NULL) {
    return NULL;
  }

192
  STscObj* pTscObj = (STscObj*)taos;
193 194 195 196 197 198 199 200 201 202

#if SYNC_ON_TOP_OF_ASYNC
  SSyncQueryParam* param = taosMemoryCalloc(1, sizeof(struct SSyncQueryParam));
  tsem_init(&param->sem, 0, 0);

  taos_query_a(pTscObj, sql, syncQueryFn, param);
  tsem_wait(&param->sem);

  return param->pRequest;
#else
203 204 205 206 207 208 209 210 211
  size_t sqlLen = strlen(sql);
  if (sqlLen > (size_t)TSDB_MAX_ALLOWED_SQL_LEN) {
    tscError("sql string exceeds max length:%d", TSDB_MAX_ALLOWED_SQL_LEN);
    terrno = TSDB_CODE_TSC_EXCEED_SQL_LIMIT;
    return NULL;
  }

  return execQuery(pTscObj, sql, sqlLen);
#endif
212
}
213

214 215
TAOS_ROW taos_fetch_row(TAOS_RES *res) {
  if (res == NULL) {
216 217 218
    return NULL;
  }

L
Liu Jicong 已提交
219 220 221 222 223 224 225
  if (TD_RES_QUERY(res)) {
    SRequestObj *pRequest = (SRequestObj *)res;
    if (pRequest->type == TSDB_SQL_RETRIEVE_EMPTY_RESULT || pRequest->type == TSDB_SQL_INSERT ||
        pRequest->code != TSDB_CODE_SUCCESS || taos_num_fields(res) == 0) {
      return NULL;
    }

226
#if SYNC_ON_TOP_OF_ASYNC
227
    return doAsyncFetchRow(pRequest, true, true);
228
#else
229
    return doFetchRows(pRequest, true, true);
230
#endif
L
Liu Jicong 已提交
231 232

  } else if (TD_RES_TMQ(res)) {
L
Liu Jicong 已提交
233 234 235 236 237 238 239
    SMqRspObj      *msg = ((SMqRspObj *)res);
    SReqResultInfo *pResultInfo;
    if (msg->resIter == -1) {
      pResultInfo = tmqGetNextResInfo(res, true);
    } else {
      pResultInfo = tmqGetCurResInfo(res);
    }
240

L
Liu Jicong 已提交
241
    if (pResultInfo->current < pResultInfo->numOfRows) {
L
Liu Jicong 已提交
242 243
      doSetOneRowPtr(pResultInfo);
      pResultInfo->current += 1;
L
Liu Jicong 已提交
244 245
      return pResultInfo->row;
    } else {
L
Liu Jicong 已提交
246 247 248 249 250
      pResultInfo = tmqGetNextResInfo(res, true);
      if (pResultInfo == NULL) return NULL;
      doSetOneRowPtr(pResultInfo);
      pResultInfo->current += 1;
      return pResultInfo->row;
L
Liu Jicong 已提交
251 252
    }
  } else {
253
    // assert to avoid un-initialization error
L
Liu Jicong 已提交
254 255 256
    ASSERT(0);
  }
  return NULL;
257
}
H
Haojun Liao 已提交
258

L
Liu Jicong 已提交
259
int taos_print_row(char *str, TAOS_ROW row, TAOS_FIELD *fields, int num_fields) {
H
Haojun Liao 已提交
260 261 262 263 264 265 266 267 268 269 270 271 272 273 274 275 276 277 278 279 280 281 282 283 284 285 286 287 288 289 290 291 292 293 294 295 296 297 298 299 300 301 302 303 304 305 306 307 308 309 310 311 312 313 314 315 316 317
  int32_t len = 0;
  for (int i = 0; i < num_fields; ++i) {
    if (i > 0) {
      str[len++] = ' ';
    }

    if (row[i] == NULL) {
      len += sprintf(str + len, "%s", TSDB_DATA_NULL_STR);
      continue;
    }

    switch (fields[i].type) {
      case TSDB_DATA_TYPE_TINYINT:
        len += sprintf(str + len, "%d", *((int8_t *)row[i]));
        break;

      case TSDB_DATA_TYPE_UTINYINT:
        len += sprintf(str + len, "%u", *((uint8_t *)row[i]));
        break;

      case TSDB_DATA_TYPE_SMALLINT:
        len += sprintf(str + len, "%d", *((int16_t *)row[i]));
        break;

      case TSDB_DATA_TYPE_USMALLINT:
        len += sprintf(str + len, "%u", *((uint16_t *)row[i]));
        break;

      case TSDB_DATA_TYPE_INT:
        len += sprintf(str + len, "%d", *((int32_t *)row[i]));
        break;

      case TSDB_DATA_TYPE_UINT:
        len += sprintf(str + len, "%u", *((uint32_t *)row[i]));
        break;

      case TSDB_DATA_TYPE_BIGINT:
        len += sprintf(str + len, "%" PRId64, *((int64_t *)row[i]));
        break;

      case TSDB_DATA_TYPE_UBIGINT:
        len += sprintf(str + len, "%" PRIu64, *((uint64_t *)row[i]));
        break;

      case TSDB_DATA_TYPE_FLOAT: {
        float fv = 0;
        fv = GET_FLOAT_VAL(row[i]);
        len += sprintf(str + len, "%f", fv);
      } break;

      case TSDB_DATA_TYPE_DOUBLE: {
        double dv = 0;
        dv = GET_DOUBLE_VAL(row[i]);
        len += sprintf(str + len, "%lf", dv);
      } break;

      case TSDB_DATA_TYPE_BINARY:
      case TSDB_DATA_TYPE_NCHAR: {
L
Liu Jicong 已提交
318
        int32_t charLen = varDataLen((char *)row[i] - VARSTR_HEADER_SIZE);
H
Haojun Liao 已提交
319 320 321 322 323 324 325 326 327 328 329 330 331 332 333 334 335 336 337 338
        if (fields[i].type == TSDB_DATA_TYPE_BINARY) {
          assert(charLen <= fields[i].bytes && charLen >= 0);
        } else {
          assert(charLen <= fields[i].bytes * TSDB_NCHAR_SIZE && charLen >= 0);
        }

        memcpy(str + len, row[i], charLen);
        len += charLen;
      } break;

      case TSDB_DATA_TYPE_TIMESTAMP:
        len += sprintf(str + len, "%" PRId64, *((int64_t *)row[i]));
        break;

      case TSDB_DATA_TYPE_BOOL:
        len += sprintf(str + len, "%d", *((int8_t *)row[i]));
      default:
        break;
    }
  }
L
Liu Jicong 已提交
339
  str[len] = 0;
H
Haojun Liao 已提交
340 341 342

  return len;
}
343

L
Liu Jicong 已提交
344
int *taos_fetch_lengths(TAOS_RES *res) {
345 346 347 348
  if (res == NULL) {
    return NULL;
  }

L
Liu Jicong 已提交
349 350
  SReqResultInfo *pResInfo = tscGetCurResInfo(res);
  return pResInfo->length;
351 352
}

353
TAOS_ROW *taos_result_block(TAOS_RES *res) {
L
Liu Jicong 已提交
354
  if (res == NULL) {
355 356 357 358 359 360 361 362
    terrno = TSDB_CODE_INVALID_PARA;
    return NULL;
  }

  if (taos_is_update_query(res)) {
    return NULL;
  }

L
Liu Jicong 已提交
363 364
  SReqResultInfo *pResInfo = tscGetCurResInfo(res);
  return &pResInfo->row;
365 366
}

367
// todo intergrate with tDataTypes
368 369
const char *taos_data_type(int type) {
  switch (type) {
L
Liu Jicong 已提交
370 371 372 373 374 375 376 377 378 379 380 381 382 383 384 385 386 387 388 389 390 391 392 393 394 395 396
    case TSDB_DATA_TYPE_NULL:
      return "TSDB_DATA_TYPE_NULL";
    case TSDB_DATA_TYPE_BOOL:
      return "TSDB_DATA_TYPE_BOOL";
    case TSDB_DATA_TYPE_TINYINT:
      return "TSDB_DATA_TYPE_TINYINT";
    case TSDB_DATA_TYPE_SMALLINT:
      return "TSDB_DATA_TYPE_SMALLINT";
    case TSDB_DATA_TYPE_INT:
      return "TSDB_DATA_TYPE_INT";
    case TSDB_DATA_TYPE_BIGINT:
      return "TSDB_DATA_TYPE_BIGINT";
    case TSDB_DATA_TYPE_FLOAT:
      return "TSDB_DATA_TYPE_FLOAT";
    case TSDB_DATA_TYPE_DOUBLE:
      return "TSDB_DATA_TYPE_DOUBLE";
    case TSDB_DATA_TYPE_VARCHAR:
      return "TSDB_DATA_TYPE_VARCHAR";
      //    case TSDB_DATA_TYPE_BINARY:          return "TSDB_DATA_TYPE_VARCHAR";
    case TSDB_DATA_TYPE_TIMESTAMP:
      return "TSDB_DATA_TYPE_TIMESTAMP";
    case TSDB_DATA_TYPE_NCHAR:
      return "TSDB_DATA_TYPE_NCHAR";
    case TSDB_DATA_TYPE_JSON:
      return "TSDB_DATA_TYPE_JSON";
    default:
      return "UNKNOWN";
397 398
  }
}
399 400 401

const char *taos_get_client_info() { return version; }

X
Xiaoyu Wang 已提交
402
int taos_affected_rows(TAOS_RES *res) {
L
Liu Jicong 已提交
403
  if (res == NULL || TD_RES_TMQ(res)) {
H
Haojun Liao 已提交
404 405 406
    return 0;
  }

L
Liu Jicong 已提交
407 408
  SRequestObj    *pRequest = (SRequestObj *)res;
  SReqResultInfo *pResInfo = &pRequest->body.resInfo;
H
Haojun Liao 已提交
409
  return pResInfo->numOfRows;
X
Xiaoyu Wang 已提交
410
}
411

412
int taos_result_precision(TAOS_RES *res) {
L
Liu Jicong 已提交
413
  if (res == NULL) {
H
Haojun Liao 已提交
414 415
    return TSDB_TIME_PRECISION_MILLI;
  }
416

L
Liu Jicong 已提交
417 418 419 420 421 422 423 424
  if (TD_RES_QUERY(res)) {
    SRequestObj *pRequest = (SRequestObj *)res;
    return pRequest->body.resInfo.precision;
  } else if (TD_RES_TMQ(res)) {
    SReqResultInfo *info = tmqGetCurResInfo(res);
    return info->precision;
  }
  return TSDB_TIME_PRECISION_MILLI;
425
}
426 427 428 429 430 431 432 433 434 435 436 437 438 439 440 441

int taos_select_db(TAOS *taos, const char *db) {
  STscObj *pObj = (STscObj *)taos;
  if (pObj == NULL) {
    terrno = TSDB_CODE_TSC_DISCONNECTED;
    return TSDB_CODE_TSC_DISCONNECTED;
  }

  if (db == NULL || strlen(db) == 0) {
    terrno = TSDB_CODE_TSC_INVALID_INPUT;
    return terrno;
  }

  char sql[256] = {0};
  snprintf(sql, tListLen(sql), "use %s", db);

L
Liu Jicong 已提交
442 443
  TAOS_RES *pRequest = taos_query(taos, sql);
  int32_t   code = taos_errno(pRequest);
444 445 446 447 448 449 450 451 452 453

  taos_free_result(pRequest);
  return code;
}

void taos_stop_query(TAOS_RES *res) {
  if (res == NULL) {
    return;
  }

L
Liu Jicong 已提交
454 455
  SRequestObj *pRequest = (SRequestObj *)res;
  int32_t      numOfFields = taos_num_fields(pRequest);
456 457 458 459 460 461

  // It is not a query, no need to stop.
  if (numOfFields == 0) {
    return;
  }

D
dapan1121 已提交
462
  schedulerFreeJob(pRequest->body.queryJob);
463 464 465
}

bool taos_is_null(TAOS_RES *res, int32_t row, int32_t col) {
L
Liu Jicong 已提交
466
  SReqResultInfo *pResultInfo = tscGetCurResInfo(res);
467 468 469 470
  if (col >= pResultInfo->numOfCols || col < 0 || row >= pResultInfo->numOfRows || row < 0) {
    return true;
  }

L
Liu Jicong 已提交
471
  SResultColumn *pCol = &pResultInfo->pCol[col];
472 473 474 475 476
  if (IS_VAR_DATA_TYPE(pResultInfo->fields[col].type)) {
    return (pCol->offset[row] == -1);
  } else {
    return colDataIsNull_f(pCol->nullbitmap, row);
  }
477 478
}

L
Liu Jicong 已提交
479
bool taos_is_update_query(TAOS_RES *res) { return taos_num_fields(res) == 0; }
480

L
Liu Jicong 已提交
481
int taos_fetch_block(TAOS_RES *res, TAOS_ROW *rows) {
H
Haojun Liao 已提交
482
  int32_t numOfRows = 0;
L
Liu Jicong 已提交
483
  /*int32_t code = */ taos_fetch_block_s(res, &numOfRows, rows);
H
Haojun Liao 已提交
484 485 486
  return numOfRows;
}

L
Liu Jicong 已提交
487 488
int taos_fetch_block_s(TAOS_RES *res, int *numOfRows, TAOS_ROW *rows) {
  if (res == NULL) {
489 490
    return 0;
  }
L
Liu Jicong 已提交
491 492
  if (TD_RES_QUERY(res)) {
    SRequestObj *pRequest = (SRequestObj *)res;
493

L
Liu Jicong 已提交
494 495
    (*rows) = NULL;
    (*numOfRows) = 0;
H
Haojun Liao 已提交
496

L
Liu Jicong 已提交
497 498 499 500
    if (pRequest->type == TSDB_SQL_RETRIEVE_EMPTY_RESULT || pRequest->type == TSDB_SQL_INSERT ||
        pRequest->code != TSDB_CODE_SUCCESS || taos_num_fields(res) == 0) {
      return 0;
    }
501

502
    doFetchRows(pRequest, false, true);
503

L
Liu Jicong 已提交
504 505 506
    // TODO refactor
    SReqResultInfo *pResultInfo = &pRequest->body.resInfo;
    pResultInfo->current = pResultInfo->numOfRows;
507

L
Liu Jicong 已提交
508 509 510 511
    (*rows) = pResultInfo->row;
    (*numOfRows) = pResultInfo->numOfRows;
    return pRequest->code;
  } else if (TD_RES_TMQ(res)) {
L
Liu Jicong 已提交
512
    SReqResultInfo *pResultInfo = tmqGetNextResInfo(res, true);
L
Liu Jicong 已提交
513
    if (pResultInfo == NULL) return -1;
H
Haojun Liao 已提交
514

L
Liu Jicong 已提交
515 516 517
    pResultInfo->current = pResultInfo->numOfRows;
    (*rows) = pResultInfo->row;
    (*numOfRows) = pResultInfo->numOfRows;
H
Haojun Liao 已提交
518
    return 0;
L
Liu Jicong 已提交
519 520 521
  } else {
    ASSERT(0);
    return -1;
H
Haojun Liao 已提交
522
  }
L
Liu Jicong 已提交
523
}
H
Haojun Liao 已提交
524

L
Liu Jicong 已提交
525 526
int taos_fetch_raw_block(TAOS_RES *res, int *numOfRows, void **pData) {
  if (res == NULL) {
H
Haojun Liao 已提交
527 528
    return 0;
  }
529

530
  if (TD_RES_TMQ(res)) {
L
Liu Jicong 已提交
531
    SReqResultInfo *pResultInfo = tmqGetNextResInfo(res, false);
L
Liu Jicong 已提交
532 533 534 535
    if (pResultInfo == NULL) {
      (*numOfRows) = 0;
      return 0;
    }
H
Haojun Liao 已提交
536

L
Liu Jicong 已提交
537 538 539 540
    pResultInfo->current = pResultInfo->numOfRows;
    (*numOfRows) = pResultInfo->numOfRows;
    (*pData) = (void *)pResultInfo->pData;
    return 0;
541
  }
L
Liu Jicong 已提交
542

543 544 545 546 547
  SRequestObj *pRequest = (SRequestObj *)res;

  if (pRequest->type == TSDB_SQL_RETRIEVE_EMPTY_RESULT || pRequest->type == TSDB_SQL_INSERT ||
      pRequest->code != TSDB_CODE_SUCCESS || taos_num_fields(res) == 0) {
    return 0;
L
Liu Jicong 已提交
548
  }
549 550 551 552 553 554 555 556 557 558

  doFetchRows(pRequest, false, false);

  SReqResultInfo *pResultInfo = &pRequest->body.resInfo;

  pResultInfo->current = pResultInfo->numOfRows;
  (*numOfRows) = pResultInfo->numOfRows;
  (*pData) = (void *)pResultInfo->pData;

  return 0;
559 560
}

H
Haojun Liao 已提交
561
int *taos_get_column_data_offset(TAOS_RES *res, int columnIndex) {
L
Liu Jicong 已提交
562
  if (res == NULL) {
H
Haojun Liao 已提交
563 564 565
    return 0;
  }

L
Liu Jicong 已提交
566
  int32_t numOfFields = taos_num_fields(res);
H
Haojun Liao 已提交
567 568 569 570
  if (columnIndex < 0 || columnIndex >= numOfFields || numOfFields == 0) {
    return 0;
  }

L
Liu Jicong 已提交
571 572
  SReqResultInfo *pResInfo = tscGetCurResInfo(res);
  TAOS_FIELD     *pField = &pResInfo->userFields[columnIndex];
H
Haojun Liao 已提交
573 574 575 576
  if (!IS_VAR_DATA_TYPE(pField->type)) {
    return 0;
  }

L
Liu Jicong 已提交
577
  return pResInfo->pCol[columnIndex].offset;
H
Haojun Liao 已提交
578 579
}

L
Liu Jicong 已提交
580
int taos_validate_sql(TAOS *taos, const char *sql) { return true; }
581

582
void taos_reset_current_db(TAOS *taos) {
H
Haojun Liao 已提交
583 584 585 586 587
  if (taos == NULL) {
    return;
  }

  resetConnectDB(taos);
588 589
}

590 591 592 593 594
const char *taos_get_server_info(TAOS *taos) {
  if (taos == NULL) {
    return NULL;
  }

L
Liu Jicong 已提交
595
  STscObj *pTscObj = (STscObj *)taos;
596 597 598
  return pTscObj->ver;
}

599 600 601 602 603 604 605 606 607 608 609 610 611 612 613 614 615 616 617 618 619 620 621 622 623 624 625 626 627 628 629 630 631 632 633 634 635 636 637 638 639 640
typedef struct SqlParseWrapper {
  SParseContext* pCtx;
  SCatalogReq    catalogReq;
  SRequestObj*   pRequest;
  SQuery*        pQuery;
} SqlParseWrapper;

void retrieveMetaCallback(SMetaData* pResultMeta, void* param, int32_t code) {
  SqlParseWrapper *pWrapper = (SqlParseWrapper*) param;
  SQuery* pQuery = pWrapper->pQuery;
  SRequestObj* pRequest = pWrapper->pRequest;

  if (code != TSDB_CODE_SUCCESS) {
    goto _error;
  }

  code = qAnalyseSqlSemantic(pWrapper->pCtx, &pWrapper->catalogReq, pResultMeta, pQuery);
  if (code != TSDB_CODE_SUCCESS) {
    goto _error;
  }

  if (pQuery->haveResultSet) {
    setResSchemaInfo(&pRequest->body.resInfo, pQuery->pResSchema, (pQuery)->numOfResCols);
    setResPrecision(&pRequest->body.resInfo, (pQuery)->precision);
  }

  TSWAP(pRequest->dbList, (pQuery)->pDbList);
  TSWAP(pRequest->tableList, (pQuery)->pTableList);

  taosMemoryFree(pWrapper);
  launchAsyncQuery(pRequest, pQuery);
  return;

  _error:
  taosMemoryFree(pWrapper);
  tscError("0x%" PRIx64 " error occurs, code:%s, return to user app, reqId:%" PRIx64, pRequest->self, tstrerror(code),
           pRequest->requestId);
  pRequest->code = code;
  pRequest->body.queryFp(pRequest->body.param, pRequest, code);
}

// todo add retry before return user's callback
641
void taos_query_a(TAOS *taos, const char *sql, __taos_async_fn_t fp, void *param) {
642 643
  ASSERT(fp != NULL);

644
  if (taos == NULL || sql == NULL) {
645 646
    terrno = TSDB_CODE_INVALID_PARA;
    fp(param, NULL, terrno);
647 648 649
    return;
  }

650 651 652 653 654 655
  size_t sqlLen = strlen(sql);
  if (sqlLen > (size_t)TSDB_MAX_ALLOWED_SQL_LEN) {
    tscError("sql string exceeds max length:%d", TSDB_MAX_ALLOWED_SQL_LEN);
    terrno = TSDB_CODE_TSC_EXCEED_SQL_LIMIT;

    fp(param, NULL, terrno);
656 657 658
    return;
  }

659
  SRequestObj *pRequest = NULL;
660 661 662
  int32_t      retryNum = 0;
  int32_t      code = 0;

663 664 665 666 667 668 669
  //  while (retryNum++ < REQUEST_MAX_TRY_TIMES) {
  code = buildRequest(taos, sql, sqlLen, &pRequest);
  if (code != TSDB_CODE_SUCCESS) {
    terrno = code;
    fp(param, NULL, code);
    return;
  }
670

671 672
  pRequest->body.queryFp = fp;
  pRequest->body.param   = param;
673

674
  STscObj *pTscObj = pRequest->pTscObj;
675

676 677 678 679 680 681 682 683 684 685 686 687 688 689 690 691 692 693 694
  SParseContext* pCxt = taosMemoryCalloc(1, sizeof(SParseContext));
  *pCxt = (SParseContext){.requestId = pRequest->requestId,
                       .acctId = pTscObj->acctId,
                       .db = pRequest->pDb,
                       .topicQuery = false,
                       .pSql = pRequest->sqlstr,
                       .sqlLen = pRequest->sqlLen,
                       .pMsg = pRequest->msgBuf,
                       .msgLen = ERROR_MSG_BUF_DEFAULT_SIZE,
                       .pTransporter = pTscObj->pAppInfo->pTransporter,
                       .pStmtCb = NULL,
                       .pUser = pTscObj->user,
                       .isSuperUser = (0 == strcmp(pTscObj->user, TSDB_DEFAULT_USER)),
                       .async = true,};

  pCxt->mgmtEpSet = getEpSet_s(&pTscObj->pAppInfo->mgmtEp);
  code = catalogGetHandle(pTscObj->pAppInfo->clusterId, &pCxt->pCatalog);
  if (code != TSDB_CODE_SUCCESS) {
    goto _error;
695 696
  }

697 698 699 700 701 702 703 704 705 706 707 708 709
  SQuery *    pQuery = NULL;
  SCatalogReq catalogReq = {0};
  code = qParseSqlSyntax(pCxt, &pQuery, &catalogReq);
  if (code != TSDB_CODE_SUCCESS) {
    goto _error;
  }

  SqlParseWrapper *pWrapper = taosMemoryCalloc(1, sizeof(SqlParseWrapper));
  pWrapper->pCtx = pCxt;
  pWrapper->pQuery = pQuery;
  pWrapper->pRequest = pRequest;
  pWrapper->catalogReq = catalogReq;

710
  code = catalogAsyncGetAllMeta(pCxt->pCatalog, pCxt->pTransporter, &pCxt->mgmtEpSet, pRequest->requestId,
711
                                  &catalogReq, retrieveMetaCallback, pWrapper, &pRequest->body.queryJob);
712

713 714
  if (code != TSDB_CODE_SUCCESS) {
    goto _error;
715 716
  }

717 718 719 720 721 722 723 724 725 726 727 728
  return;

  // todo handle the retry process

  //    if (TSDB_CODE_SUCCESS == code || NEED_CLIENT_HANDLE_ERROR(code)) {
  //      TSWAP(pRequest->dbList, (pQuery)->pDbList);
  //      TSWAP(pRequest->tableList, (pQuery)->pTableList);
  //    }

  _error:
  terrno = code;
  pRequest->code = code;
729
  fp(param, pRequest, code);
730 731
}

732 733 734 735 736 737 738 739 740 741 742 743 744 745 746 747 748 749 750
static void fetchCallback(void* pResult, void* param, int32_t code) {
  SRequestObj* pRequest = (SRequestObj*) param;

  SReqResultInfo* pResultInfo = &pRequest->body.resInfo;

  pResultInfo->pData = pResult;
  pResultInfo->numOfRows = 0;

  if (code != TSDB_CODE_SUCCESS) {
    pRequest->code = code;
    pRequest->body.fetchFp(pRequest->body.param, pRequest, 0);
    return;
  }

  if (pRequest->code != TSDB_CODE_SUCCESS) {
    pRequest->code = code;
    pRequest->body.fetchFp(pRequest->body.param, pRequest, 0);
  }

H
Haojun Liao 已提交
751
  pRequest->code = setQueryResultFromRsp(&pRequest->body.resInfo, (SRetrieveTableRsp*)pResultInfo->pData, true, false);
752 753 754 755 756 757 758 759 760 761 762 763 764
  if (pRequest->code != TSDB_CODE_SUCCESS) {
    pResultInfo->numOfRows = 0;

    pRequest->code = code;
    pRequest->body.fetchFp(pRequest->body.param, pRequest, 0);
  }

  tscDebug("0x%" PRIx64 " fetch results, numOfRows:%d total Rows:%" PRId64 ", complete:%d, reqId:0x%" PRIx64,
           pRequest->self, pResultInfo->numOfRows, pResultInfo->totalRows, pResultInfo->completed, pRequest->requestId);

  pRequest->body.fetchFp(pRequest->body.param, pRequest, pResultInfo->numOfRows);
}

765
void taos_fetch_rows_a(TAOS_RES *res, __taos_async_fn_t fp, void *param) {
766 767 768 769 770 771 772 773 774 775 776 777 778 779 780 781 782 783 784 785 786
  ASSERT (res != NULL && fp != NULL);

  SRequestObj *pRequest = res;
  pRequest->body.fetchFp = fp;

  SReqResultInfo *pResultInfo = &pRequest->body.resInfo;
  if (taos_num_fields(pRequest) == 0) {
    pResultInfo->numOfRows = 0;
    pRequest->body.fetchFp(param, pRequest, pResultInfo->numOfRows);
    return;
  }

  if (pResultInfo->pData == NULL || pResultInfo->current >= pResultInfo->numOfRows) {
    // All data has returned to App already, no need to try again
    if (pResultInfo->completed) {
      pResultInfo->numOfRows = 0;
      pRequest->body.fetchFp(param, pRequest, pResultInfo->numOfRows);
      return;
    }
  }

787
  schedulerAsyncFetchRows(pRequest->body.queryJob, fetchCallback, pRequest);
L
Liu Jicong 已提交
788
}
789

L
Liu Jicong 已提交
790 791 792 793
TAOS_SUB *taos_subscribe(TAOS *taos, int restart, const char *topic, const char *sql, TAOS_SUBSCRIBE_CALLBACK fp,
                         void *param, int interval) {
  // TODO
  return NULL;
794 795 796
}

TAOS_RES *taos_consume(TAOS_SUB *tsub) {
L
Liu Jicong 已提交
797 798
  // TODO
  return NULL;
799 800 801
}

void taos_unsubscribe(TAOS_SUB *tsub, int keepProgress) {
L
Liu Jicong 已提交
802
  // TODO
803 804
}

805 806 807 808 809
int taos_load_table_info(TAOS *taos, const char *tableNameList) {
  // TODO
  return -1;
}

L
Liu Jicong 已提交
810
TAOS_STMT *taos_stmt_init(TAOS *taos) {
D
stmt  
dapan1121 已提交
811
  if (taos == NULL) {
D
stmt  
dapan1121 已提交
812
    tscError("NULL parameter for %s", __FUNCTION__);
D
stmt  
dapan1121 已提交
813 814 815 816 817
    terrno = TSDB_CODE_INVALID_PARA;
    return NULL;
  }

  return stmtInit(taos);
818 819
}

D
stmt  
dapan1121 已提交
820 821
int taos_stmt_prepare(TAOS_STMT *stmt, const char *sql, unsigned long length) {
  if (stmt == NULL || sql == NULL) {
D
stmt  
dapan1121 已提交
822
    tscError("NULL parameter for %s", __FUNCTION__);
D
stmt  
dapan1121 已提交
823 824 825 826
    terrno = TSDB_CODE_INVALID_PARA;
    return terrno;
  }

D
stmt  
dapan1121 已提交
827
  return stmtPrepare(stmt, sql, length);
828 829
}

D
dapan1121 已提交
830
int taos_stmt_set_tbname_tags(TAOS_STMT *stmt, const char *name, TAOS_MULTI_BIND *tags) {
D
stmt  
dapan1121 已提交
831
  if (stmt == NULL || name == NULL) {
D
stmt  
dapan1121 已提交
832
    tscError("NULL parameter for %s", __FUNCTION__);
D
stmt  
dapan1121 已提交
833 834 835 836
    terrno = TSDB_CODE_INVALID_PARA;
    return terrno;
  }

D
stmt  
dapan1121 已提交
837 838 839 840 841 842 843 844 845 846
  int32_t code = stmtSetTbName(stmt, name);
  if (code) {
    return code;
  }

  if (tags) {
    return stmtSetTbTags(stmt, tags);
  }

  return TSDB_CODE_SUCCESS;
847 848
}

D
stmt  
dapan1121 已提交
849 850
int taos_stmt_set_tbname(TAOS_STMT *stmt, const char *name) {
  if (stmt == NULL || name == NULL) {
D
stmt  
dapan1121 已提交
851
    tscError("NULL parameter for %s", __FUNCTION__);
D
stmt  
dapan1121 已提交
852
    terrno = TSDB_CODE_INVALID_PARA;
D
stmt  
dapan1121 已提交
853
    return terrno;
D
stmt  
dapan1121 已提交
854 855
  }

D
stmt  
dapan1121 已提交
856
  return stmtSetTbName(stmt, name);
857 858
}

D
dapan1121 已提交
859 860 861 862 863 864 865 866 867 868 869
int taos_stmt_set_tags(TAOS_STMT *stmt, TAOS_MULTI_BIND *tags) {
  if (stmt == NULL || tags == NULL) {
    tscError("NULL parameter for %s", __FUNCTION__);
    terrno = TSDB_CODE_INVALID_PARA;
    return terrno;
  }

  return stmtSetTbTags(stmt, tags);
}


870
int taos_stmt_set_sub_tbname(TAOS_STMT *stmt, const char *name) { return taos_stmt_set_tbname(stmt, name); }
D
dapan1121 已提交
871

D
dapan1121 已提交
872 873 874 875 876 877 878 879 880 881 882 883 884 885 886 887 888 889 890 891
int taos_stmt_get_tag_fields(TAOS_STMT *stmt, int* fieldNum, TAOS_FIELD_E** fields) {
  if (stmt == NULL || NULL == fieldNum) {
    tscError("NULL parameter for %s", __FUNCTION__);
    terrno = TSDB_CODE_INVALID_PARA;
    return terrno;
  }
  
  return stmtGetTagFields(stmt, fieldNum, fields);
}

int taos_stmt_get_col_fields(TAOS_STMT *stmt, int* fieldNum, TAOS_FIELD_E** fields) {
  if (stmt == NULL || NULL == fieldNum) {
    tscError("NULL parameter for %s", __FUNCTION__);
    terrno = TSDB_CODE_INVALID_PARA;
    return terrno;
  }
  
  return stmtGetColFields(stmt, fieldNum, fields);
}

D
dapan1121 已提交
892
int taos_stmt_bind_param(TAOS_STMT *stmt, TAOS_MULTI_BIND *bind) {
D
stmt  
dapan1121 已提交
893
  if (stmt == NULL || bind == NULL) {
D
stmt  
dapan1121 已提交
894
    tscError("NULL parameter for %s", __FUNCTION__);
D
stmt  
dapan1121 已提交
895
    terrno = TSDB_CODE_INVALID_PARA;
D
stmt  
dapan1121 已提交
896
    return terrno;
D
stmt  
dapan1121 已提交
897
  }
898

D
stmt  
dapan1121 已提交
899 900 901 902 903
  if (bind->num > 1) {
    tscError("invalid bind number %d for %s", bind->num, __FUNCTION__);
    terrno = TSDB_CODE_INVALID_PARA;
    return terrno;
  }
904

D
stmt  
dapan1121 已提交
905
  return stmtBindBatch(stmt, bind, -1);
906 907
}

D
dapan1121 已提交
908
int taos_stmt_bind_param_batch(TAOS_STMT *stmt, TAOS_MULTI_BIND *bind) {
D
stmt  
dapan1121 已提交
909
  if (stmt == NULL || bind == NULL) {
D
stmt  
dapan1121 已提交
910
    tscError("NULL parameter for %s", __FUNCTION__);
D
stmt  
dapan1121 已提交
911 912 913 914
    terrno = TSDB_CODE_INVALID_PARA;
    return terrno;
  }

D
stmt  
dapan1121 已提交
915 916
  if (bind->num <= 0 || bind->num > INT16_MAX) {
    tscError("invalid bind num %d", bind->num);
D
stmt  
dapan1121 已提交
917 918 919 920
    terrno = TSDB_CODE_INVALID_PARA;
    return terrno;
  }

D
dapan1121 已提交
921 922 923 924 925 926 927 928
  int32_t insert = 0;
  stmtIsInsert(stmt, &insert);
  if (0 == insert && bind->num > 1) {
    tscError("only one row data allowed for query");
    terrno = TSDB_CODE_INVALID_PARA;
    return terrno;
  }

D
stmt  
dapan1121 已提交
929
  return stmtBindBatch(stmt, bind, -1);
930 931
}

D
dapan1121 已提交
932
int taos_stmt_bind_single_param_batch(TAOS_STMT *stmt, TAOS_MULTI_BIND *bind, int colIdx) {
D
stmt  
dapan1121 已提交
933
  if (stmt == NULL || bind == NULL) {
D
stmt  
dapan1121 已提交
934
    tscError("NULL parameter for %s", __FUNCTION__);
D
stmt  
dapan1121 已提交
935 936 937 938
    terrno = TSDB_CODE_INVALID_PARA;
    return terrno;
  }

D
stmt  
dapan1121 已提交
939
  if (colIdx < 0) {
D
stmt  
dapan1121 已提交
940 941 942 943
    tscError("invalid bind column idx %d", colIdx);
    terrno = TSDB_CODE_INVALID_PARA;
    return terrno;
  }
D
dapan1121 已提交
944 945 946 947 948 949 950 951

  int32_t insert = 0;
  stmtIsInsert(stmt, &insert);
  if (0 == insert && bind->num > 1) {
    tscError("only one row data allowed for query");
    terrno = TSDB_CODE_INVALID_PARA;
    return terrno;
  }
952

D
stmt  
dapan1121 已提交
953
  return stmtBindBatch(stmt, bind, colIdx);
954 955
}

D
stmt  
dapan1121 已提交
956 957
int taos_stmt_add_batch(TAOS_STMT *stmt) {
  if (stmt == NULL) {
D
stmt  
dapan1121 已提交
958
    tscError("NULL parameter for %s", __FUNCTION__);
D
stmt  
dapan1121 已提交
959 960 961 962
    terrno = TSDB_CODE_INVALID_PARA;
    return terrno;
  }

D
stmt  
dapan1121 已提交
963
  return stmtAddBatch(stmt);
964 965
}

D
stmt  
dapan1121 已提交
966 967
int taos_stmt_execute(TAOS_STMT *stmt) {
  if (stmt == NULL) {
D
stmt  
dapan1121 已提交
968
    tscError("NULL parameter for %s", __FUNCTION__);
D
stmt  
dapan1121 已提交
969 970 971 972
    terrno = TSDB_CODE_INVALID_PARA;
    return terrno;
  }

D
stmt  
dapan1121 已提交
973
  return stmtExec(stmt);
974 975
}

976
int taos_stmt_is_insert(TAOS_STMT *stmt, int *insert) {
D
stmt  
dapan1121 已提交
977
  if (stmt == NULL || insert == NULL) {
D
stmt  
dapan1121 已提交
978
    tscError("NULL parameter for %s", __FUNCTION__);
D
stmt  
dapan1121 已提交
979 980 981 982 983
    terrno = TSDB_CODE_INVALID_PARA;
    return terrno;
  }

  return stmtIsInsert(stmt, insert);
984 985
}

986
int taos_stmt_num_params(TAOS_STMT *stmt, int *nums) {
D
stmt  
dapan1121 已提交
987
  if (stmt == NULL || nums == NULL) {
D
stmt  
dapan1121 已提交
988
    tscError("NULL parameter for %s", __FUNCTION__);
D
stmt  
dapan1121 已提交
989 990 991 992 993
    terrno = TSDB_CODE_INVALID_PARA;
    return terrno;
  }

  return stmtGetParamNum(stmt, nums);
994 995
}

D
dapan1121 已提交
996 997 998 999 1000 1001 1002 1003 1004 1005
int taos_stmt_get_param(TAOS_STMT *stmt, int idx, int *type, int *bytes) {
  if (stmt == NULL || type == NULL || NULL == bytes || idx < 0) {
    tscError("invalid parameter for %s", __FUNCTION__);
    terrno = TSDB_CODE_INVALID_PARA;
    return terrno;
  }

  return stmtGetParam(stmt, idx, type, bytes);
}

D
stmt  
dapan1121 已提交
1006
TAOS_RES *taos_stmt_use_result(TAOS_STMT *stmt) {
D
stmt  
dapan1121 已提交
1007
  if (stmt == NULL) {
D
stmt  
dapan1121 已提交
1008
    tscError("NULL parameter for %s", __FUNCTION__);
D
stmt  
dapan1121 已提交
1009
    terrno = TSDB_CODE_INVALID_PARA;
D
stmt  
dapan1121 已提交
1010
    return NULL;
D
stmt  
dapan1121 已提交
1011 1012
  }

D
stmt  
dapan1121 已提交
1013
  return stmtUseResult(stmt);
1014 1015
}

1016
char *taos_stmt_errstr(TAOS_STMT *stmt) { return (char *)stmtErrstr(stmt); }
1017

D
stmt  
dapan1121 已提交
1018
int taos_stmt_affected_rows(TAOS_STMT *stmt) {
D
stmt  
dapan1121 已提交
1019
  if (stmt == NULL) {
D
stmt  
dapan1121 已提交
1020
    tscError("NULL parameter for %s", __FUNCTION__);
D
stmt  
dapan1121 已提交
1021
    terrno = TSDB_CODE_INVALID_PARA;
D
stmt  
dapan1121 已提交
1022
    return 0;
D
stmt  
dapan1121 已提交
1023 1024
  }

D
stmt  
dapan1121 已提交
1025
  return stmtAffectedRows(stmt);
1026 1027
}

D
dapan1121 已提交
1028 1029 1030 1031 1032 1033 1034 1035 1036 1037
int taos_stmt_affected_rows_once(TAOS_STMT *stmt) {
  if (stmt == NULL) {
    tscError("NULL parameter for %s", __FUNCTION__);
    terrno = TSDB_CODE_INVALID_PARA;
    return 0;
  }

  return stmtAffectedRowsOnce(stmt);
}

D
stmt  
dapan1121 已提交
1038 1039
int taos_stmt_close(TAOS_STMT *stmt) {
  if (stmt == NULL) {
D
stmt  
dapan1121 已提交
1040
    tscError("NULL parameter for %s", __FUNCTION__);
D
stmt  
dapan1121 已提交
1041 1042 1043 1044
    terrno = TSDB_CODE_INVALID_PARA;
    return terrno;
  }

D
stmt  
dapan1121 已提交
1045
  return stmtClose(stmt);
D
stmt  
dapan1121 已提交
1046 1047
}