clientTests.cpp 9.5 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) {
53 54 55 56 57
  TAOS* pConn = taos_connect("ubuntu", "root", "taosdata", NULL, 0);
  assert(pConn != NULL);
  taos_close(pConn);
}

58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95
TEST(testCase, create_user_Test) {
  TAOS* pConn = taos_connect("ubuntu", "root", "taosdata", NULL, 0);
  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) {
  TAOS* pConn = taos_connect("ubuntu", "root", "taosdata", NULL, 0);
  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) {
  TAOS* pConn = taos_connect("ubuntu", "root", "taosdata", NULL, 0);
  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) {
98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115
  TAOS* pConn = taos_connect("ubuntu", "root", "taosdata", NULL, 0);
  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) {
117 118 119 120 121 122 123 124 125 126 127 128
  TAOS* pConn = taos_connect("ubuntu", "root", "taosdata", NULL, 0);
  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) {
130
  TAOS* pConn = taos_connect("ubuntu", "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("ubuntu", "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 163 164 165

  taos_close(pConn);
}

166
TEST(testCase, use_db_test) {
H
Haojun Liao 已提交
167
  TAOS* pConn = taos_connect("ubuntu", "root", "taosdata", NULL, 0);
168
  assert(pConn != NULL);
H
Haojun Liao 已提交
169

170 171 172 173
  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 已提交
174 175

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

178 179
  int32_t numOfFields = taos_num_fields(pRes);
  ASSERT_EQ(numOfFields, 0);
H
Haojun Liao 已提交
180 181 182 183

  taos_close(pConn);
}

184
TEST(testCase, drop_db_test) {
H
Haojun Liao 已提交
185 186 187
  TAOS* pConn = taos_connect("ubuntu", "root", "taosdata", NULL, 0);
  assert(pConn != NULL);

188 189 190 191 192
  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 已提交
193 194
  }
  taos_free_result(pRes);
195 196

  showDB(pConn);
197 198 199 200 201 202

  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 已提交
203 204 205
  taos_close(pConn);
}

206 207
// TEST(testCase, create_stable_Test) {
//  TAOS* pConn = taos_connect("ubuntu", "root", "taosdata", NULL, 0);
H
Haojun Liao 已提交
208
//  assert(pConn != NULL);
209 210 211 212 213 214 215 216 217 218 219 220 221 222 223 224 225 226 227 228 229 230 231 232 233 234 235 236 237 238 239 240 241 242 243 244 245 246 247 248
//
//  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);
//}

TEST(testCase, create_table_Test) {
  //  TAOS* pConn = taos_connect("ubuntu", "root", "taosdata", NULL, 0);
  //  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 已提交
249

250 251 252 253 254 255
TEST(testCase, create_ctable_Test) {}

TEST(testCase, show_stable_Test) {
  TAOS* pConn = taos_connect("ubuntu", "root", "taosdata", NULL, 0);
  assert(pConn != NULL);

256 257 258 259 260 261 262 263 264 265 266 267 268
  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 已提交
269
  TAOS_ROW pRow = NULL;
270

H
Haojun Liao 已提交
271 272 273 274 275 276 277 278
  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);
  }
279

280
  taos_free_result(pRes);
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
  taos_close(pConn);
}

TEST(testCase, show_vgroup_Test) {
  TAOS* pConn = taos_connect("ubuntu", "root", "taosdata", NULL, 0);
  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);

315 316 317
  taos_close(pConn);
}

318
TEST(testCase, drop_stable_Test) {
H
Haojun Liao 已提交
319 320 321
  TAOS* pConn = taos_connect("ubuntu", "root", "taosdata", NULL, 0);
  assert(pConn != NULL);

322 323 324 325
  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));
  }
326 327
  taos_free_result(pRes);

328 329 330 331 332
  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 已提交
333

334 335 336 337
  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 已提交
338

339
  taos_free_result(pRes);
H
Haojun Liao 已提交
340 341
  taos_close(pConn);
}
342 343 344 345 346 347 348 349 350 351 352 353 354

//TEST(testCase, show_table_Test) {
//  TAOS* pConn = taos_connect("ubuntu", "root", "taosdata", NULL, 0);
//  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);
//}