clientTests.cpp 10.6 KB
Newer Older
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 <gtest/gtest.h>
17
#include <taoserror.h>
18 19 20 21 22 23 24
#include <iostream>
#pragma GCC diagnostic ignored "-Wwrite-strings"

#pragma GCC diagnostic ignored "-Wunused-function"
#pragma GCC diagnostic ignored "-Wunused-variable"
#pragma GCC diagnostic ignored "-Wsign-compare"

25
#include "../inc/clientInt.h"
26
#include "taos.h"
27
#include "tglobal.h"
28 29

namespace {
30 31 32 33 34 35 36 37 38 39 40 41 42
void showDB(TAOS* pConn) {
  TAOS_RES* pRes = taos_query(pConn, "show databases");
  TAOS_ROW  pRow = NULL;

  TAOS_FIELD* pFields = taos_fetch_fields(pRes);
  int32_t     numOfFields = taos_num_fields(pRes);

  char str[512] = {0};
  while ((pRow = taos_fetch_row(pRes)) != NULL) {
    int32_t code = taos_print_row(str, pRow, pFields, numOfFields);
    printf("%s\n", str);
  }
}
43 44 45 46 47 48 49
}  // namespace

int main(int argc, char** argv) {
  testing::InitGoogleTest(&argc, argv);
  return RUN_ALL_TESTS();
}

50
TEST(testCase, driverInit_Test) { taos_init(); }
H
Haojun Liao 已提交
51

52
TEST(testCase, connect_Test) {
H
Haojun Liao 已提交
53
  TAOS* pConn = taos_connect("localhost", "root", "taosdata", NULL, 0);
54 55 56 57
  assert(pConn != NULL);
  taos_close(pConn);
}

58
TEST(testCase, create_user_Test) {
H
Haojun Liao 已提交
59
  TAOS* pConn = taos_connect("localhost", "root", "taosdata", NULL, 0);
60 61 62 63 64 65 66 67 68 69 70 71
  assert(pConn != NULL);

  TAOS_RES* pRes = taos_query(pConn, "create user abc pass 'abc'");
  if (taos_errno(pRes) != TSDB_CODE_SUCCESS) {
    printf("failed to create user, reason:%s\n", taos_errstr(pRes));
  }

  taos_free_result(pRes);
  taos_close(pConn);
}

TEST(testCase, create_account_Test) {
H
Haojun Liao 已提交
72
  TAOS* pConn = taos_connect("localhost", "root", "taosdata", NULL, 0);
73 74 75 76 77 78 79 80 81 82 83 84
  assert(pConn != NULL);

  TAOS_RES* pRes = taos_query(pConn, "create account aabc pass 'abc'");
  if (taos_errno(pRes) != TSDB_CODE_SUCCESS) {
    printf("failed to create user, reason:%s\n", taos_errstr(pRes));
  }

  taos_free_result(pRes);
  taos_close(pConn);
}

TEST(testCase, drop_account_Test) {
H
Haojun Liao 已提交
85
  TAOS* pConn = taos_connect("localhost", "root", "taosdata", NULL, 0);
86 87 88 89 90 91 92 93 94 95
  assert(pConn != NULL);

  TAOS_RES* pRes = taos_query(pConn, "drop account aabc");
  if (taos_errno(pRes) != TSDB_CODE_SUCCESS) {
    printf("failed to create user, reason:%s\n", taos_errstr(pRes));
  }

  taos_free_result(pRes);
  taos_close(pConn);
}
96

97
TEST(testCase, show_user_Test) {
H
Haojun Liao 已提交
98
  TAOS* pConn = taos_connect("localhost", "root", "taosdata", NULL, 0);
99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115
  assert(pConn != NULL);

  TAOS_RES* pRes = taos_query(pConn, "show users");
  TAOS_ROW pRow = NULL;

  TAOS_FIELD* pFields = taos_fetch_fields(pRes);
  int32_t numOfFields = taos_num_fields(pRes);

  char str[512] = {0};
  while((pRow = taos_fetch_row(pRes)) != NULL) {
    int32_t code = taos_print_row(str, pRow, pFields, numOfFields);
    printf("%s\n", str);
  }

  taos_close(pConn);
}

116
TEST(testCase, drop_user_Test) {
H
Haojun Liao 已提交
117
  TAOS* pConn = taos_connect("localhost", "root", "taosdata", NULL, 0);
118 119 120 121 122 123 124 125 126 127 128
  assert(pConn != NULL);

  TAOS_RES* pRes = taos_query(pConn, "drop user abc");
  if (taos_errno(pRes) != TSDB_CODE_SUCCESS) {
    printf("failed to create user, reason:%s\n", taos_errstr(pRes));
  }

  taos_free_result(pRes);
  taos_close(pConn);
}

129
TEST(testCase, show_db_Test) {
H
Haojun Liao 已提交
130
  TAOS* pConn = taos_connect("localhost", "root", "taosdata", NULL, 0);
131
//  assert(pConn != NULL);
132 133 134 135 136 137 138 139 140 141 142 143 144 145 146

  TAOS_RES* pRes = taos_query(pConn, "show databases");
  TAOS_ROW pRow = NULL;

  TAOS_FIELD* pFields = taos_fetch_fields(pRes);
  int32_t numOfFields = taos_num_fields(pRes);

  char str[512] = {0};
  while((pRow = taos_fetch_row(pRes)) != NULL) {
    int32_t code = taos_print_row(str, pRow, pFields, numOfFields);
    printf("%s\n", str);
  }

  taos_close(pConn);
}
H
Haojun Liao 已提交
147

148
TEST(testCase, create_db_Test) {
H
Haojun Liao 已提交
149
  TAOS* pConn = taos_connect("localhost", "root", "taosdata", NULL, 0);
H
Haojun Liao 已提交
150
  assert(pConn != NULL);
H
Haojun Liao 已提交
151

152 153 154
  TAOS_RES* pRes = taos_query(pConn, "create database abc1");
  if (taos_errno(pRes) != 0) {
    printf("error in create db, reason:%s\n", taos_errstr(pRes));
H
Haojun Liao 已提交
155 156
  }

157 158
  TAOS_FIELD* pFields = taos_fetch_fields(pRes);
  ASSERT_TRUE(pFields == NULL);
H
Haojun Liao 已提交
159

160 161
  int32_t numOfFields = taos_num_fields(pRes);
  ASSERT_EQ(numOfFields, 0);
H
Haojun Liao 已提交
162

H
Haojun Liao 已提交
163 164 165 166 167 168
  taos_free_result(pRes);

  pRes = taos_query(pConn, "create database abc1");
  if (taos_errno(pRes) != 0) {
    printf("error in create db, reason:%s\n", taos_errstr(pRes));
  }
H
Haojun Liao 已提交
169 170 171
  taos_close(pConn);
}

172
TEST(testCase, create_dnode_Test) {
H
Haojun Liao 已提交
173
  TAOS* pConn = taos_connect("localhost", "root", "taosdata", NULL, 0);
174 175 176 177 178 179 180 181 182 183 184 185 186 187 188 189 190 191
  assert(pConn != NULL);

  TAOS_RES* pRes = taos_query(pConn, "create dnode abc1");
  if (taos_errno(pRes) != 0) {
    printf("error in create dnode, reason:%s\n", taos_errstr(pRes));
  }

  TAOS_FIELD* pFields = taos_fetch_fields(pRes);
  ASSERT_TRUE(pFields == NULL);

  int32_t numOfFields = taos_num_fields(pRes);
  ASSERT_EQ(numOfFields, 0);

  taos_free_result(pRes);
  taos_close(pConn);
}

TEST(testCase, drop_dnode_Test) {
H
Haojun Liao 已提交
192
  TAOS* pConn = taos_connect("localhost", "root", "taosdata", NULL, 0);
193 194 195 196 197 198 199 200 201 202 203 204 205 206 207 208 209
  assert(pConn != NULL);

  TAOS_RES* pRes = taos_query(pConn, "drop dnode 2");
  if (taos_errno(pRes) != 0) {
    printf("error in drop dnode, reason:%s\n", taos_errstr(pRes));
  }

  TAOS_FIELD* pFields = taos_fetch_fields(pRes);
  ASSERT_TRUE(pFields == NULL);

  int32_t numOfFields = taos_num_fields(pRes);
  ASSERT_EQ(numOfFields, 0);

  taos_free_result(pRes);
  taos_close(pConn);
}

210
TEST(testCase, use_db_test) {
H
Haojun Liao 已提交
211
  TAOS* pConn = taos_connect("localhost", "root", "taosdata", NULL, 0);
212
  assert(pConn != NULL);
H
Haojun Liao 已提交
213

214 215 216 217
  TAOS_RES* pRes = taos_query(pConn, "use abc1");
  if (taos_errno(pRes) != 0) {
    printf("error in use db, reason:%s\n", taos_errstr(pRes));
  }
H
Haojun Liao 已提交
218 219

  TAOS_FIELD* pFields = taos_fetch_fields(pRes);
220
  ASSERT_TRUE(pFields == NULL);
H
Haojun Liao 已提交
221

222 223
  int32_t numOfFields = taos_num_fields(pRes);
  ASSERT_EQ(numOfFields, 0);
H
Haojun Liao 已提交
224 225 226 227

  taos_close(pConn);
}

228
TEST(testCase, drop_db_test) {
H
Haojun Liao 已提交
229
  TAOS* pConn = taos_connect("localhost", "root", "taosdata", NULL, 0);
H
Haojun Liao 已提交
230 231
  assert(pConn != NULL);

232 233 234 235 236
  showDB(pConn);

  TAOS_RES* pRes = taos_query(pConn, "drop database abc1");
  if (taos_errno(pRes) != 0) {
    printf("failed to drop db, reason:%s\n", taos_errstr(pRes));
H
Haojun Liao 已提交
237 238
  }
  taos_free_result(pRes);
239 240

  showDB(pConn);
241 242 243 244 245 246

  pRes = taos_query(pConn, "create database abc1");
  if (taos_errno(pRes) != 0) {
    printf("create to drop db, reason:%s\n", taos_errstr(pRes));
  }
  taos_free_result(pRes);
H
Haojun Liao 已提交
247 248 249
  taos_close(pConn);
}

H
Haojun Liao 已提交
250
 TEST(testCase, create_stable_Test) {
H
Haojun Liao 已提交
251
  TAOS* pConn = taos_connect("localhost", "root", "taosdata", NULL, 0);
H
Haojun Liao 已提交
252 253 254 255 256 257 258 259 260 261 262 263 264 265 266 267 268 269 270 271 272 273 274 275 276 277 278 279
  assert(pConn != NULL);

  TAOS_RES* pRes = taos_query(pConn, "create database abc1");
  if (taos_errno(pRes) != 0) {
    printf("error in create db, reason:%s\n", taos_errstr(pRes));
  }
  taos_free_result(pRes);

  pRes = taos_query(pConn, "use abc1");
  if (taos_errno(pRes) != 0) {
    printf("error in use db, reason:%s\n", taos_errstr(pRes));
  }
  taos_free_result(pRes);

  pRes = taos_query(pConn, "create stable st1(ts timestamp, k int) tags(a int)");
  if (taos_errno(pRes) != 0) {
    printf("error in create stable, reason:%s\n", taos_errstr(pRes));
  }

  TAOS_FIELD* pFields = taos_fetch_fields(pRes);
  ASSERT_TRUE(pFields == NULL);

  int32_t numOfFields = taos_num_fields(pRes);
  ASSERT_EQ(numOfFields, 0);

  taos_free_result(pRes);
  taos_close(pConn);
}
280 281

TEST(testCase, create_table_Test) {
H
Haojun Liao 已提交
282
  //  TAOS* pConn = taos_connect("localhost", "root", "taosdata", NULL, 0);
283 284 285 286 287 288 289 290 291 292
  //  assert(pConn != NULL);
  //
  //  TAOS_RES* pRes = taos_query(pConn, "use abc1");
  //  taos_free_result(pRes);
  //
  //  pRes = taos_query(pConn, "create table tm0(ts timestamp, k int)");
  //  taos_free_result(pRes);
  //
  //  taos_close(pConn);
}
H
Haojun Liao 已提交
293

294 295 296
TEST(testCase, create_ctable_Test) {}

TEST(testCase, show_stable_Test) {
H
Haojun Liao 已提交
297
  TAOS* pConn = taos_connect("localhost", "root", "taosdata", NULL, 0);
298 299
  assert(pConn != NULL);

300 301 302 303 304 305 306 307 308 309 310 311 312
  TAOS_RES* pRes = taos_query(pConn, "use abc1");
  if (taos_errno(pRes) != 0) {
    printf("failed to use db, reason:%s\n", taos_errstr(pRes));
  }
  taos_free_result(pRes);

  pRes = taos_query(pConn, "show stables");
  if (taos_errno(pRes) != 0) {
    printf("failed to show stables, reason:%s\n", taos_errstr(pRes));
    taos_free_result(pRes);
    ASSERT_TRUE(false);
  }

H
Haojun Liao 已提交
313 314 315 316 317 318 319 320 321
  TAOS_ROW pRow = NULL;
  TAOS_FIELD* pFields = taos_fetch_fields(pRes);
  int32_t numOfFields = taos_num_fields(pRes);

  char str[512] = {0};
  while((pRow = taos_fetch_row(pRes)) != NULL) {
    int32_t code = taos_print_row(str, pRow, pFields, numOfFields);
    printf("%s\n", str);
  }
322

323
  taos_free_result(pRes);
324 325 326 327
  taos_close(pConn);
}

TEST(testCase, show_vgroup_Test) {
H
Haojun Liao 已提交
328
  TAOS* pConn = taos_connect("localhost", "root", "taosdata", NULL, 0);
329 330 331 332 333 334 335 336 337 338 339 340 341 342 343 344 345 346 347 348 349 350 351 352 353 354 355 356
  assert(pConn != NULL);

  TAOS_RES* pRes = taos_query(pConn, "use abc1");
  if (taos_errno(pRes) != 0) {
    printf("failed to use db, reason:%s\n", taos_errstr(pRes));
  }
  taos_free_result(pRes);

  pRes = taos_query(pConn, "show vgroups");
  if (taos_errno(pRes) != 0) {
    printf("failed to show vgroups, reason:%s\n", taos_errstr(pRes));
    taos_free_result(pRes);
    ASSERT_TRUE(false);
  }

  TAOS_ROW pRow = NULL;

  TAOS_FIELD* pFields = taos_fetch_fields(pRes);
  int32_t numOfFields = taos_num_fields(pRes);

  char str[512] = {0};
  while((pRow = taos_fetch_row(pRes)) != NULL) {
    int32_t code = taos_print_row(str, pRow, pFields, numOfFields);
    printf("%s\n", str);
  }

  taos_free_result(pRes);

357 358 359
  taos_close(pConn);
}

360
TEST(testCase, drop_stable_Test) {
H
Haojun Liao 已提交
361
  TAOS* pConn = taos_connect("localhost", "root", "taosdata", NULL, 0);
H
Haojun Liao 已提交
362 363
  assert(pConn != NULL);

364 365 366 367
  TAOS_RES* pRes = taos_query(pConn, "create database abc1");
  if (taos_errno(pRes) != 0) {
    printf("error in creating db, reason:%s\n", taos_errstr(pRes));
  }
368 369
  taos_free_result(pRes);

370 371 372 373 374
  pRes = taos_query(pConn, "use abc1");
  if (taos_errno(pRes) != 0) {
    printf("error in using db, reason:%s\n", taos_errstr(pRes));
  }
  taos_free_result(pRes);
H
Haojun Liao 已提交
375

376 377 378 379
  pRes = taos_query(pConn, "drop stable st1");
  if (taos_errno(pRes) != 0) {
    printf("failed to drop stable, reason:%s\n", taos_errstr(pRes));
  }
H
Haojun Liao 已提交
380

381
  taos_free_result(pRes);
H
Haojun Liao 已提交
382 383
  taos_close(pConn);
}
384 385

//TEST(testCase, show_table_Test) {
H
Haojun Liao 已提交
386
//  TAOS* pConn = taos_connect("localhost", "root", "taosdata", NULL, 0);
387 388 389 390 391 392 393 394 395 396
//  assert(pConn != NULL);
//
//  TAOS_RES* pRes = taos_query(pConn, "use abc1");
//  taos_free_result(pRes);
//
//  pRes = taos_query(pConn, "show tables");
//  taos_free_result(pRes);
//
//  taos_close(pConn);
//}