stream_demo.c 3.6 KB
Newer Older
L
Liu Jicong 已提交
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22
/*
 * 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 <assert.h>
#include <stdio.h>
#include <string.h>
#include <time.h>
#include "taos.h"

int32_t init_env() {
L
fix  
Liu Jicong 已提交
23
  TAOS* pConn = taos_connect("localhost", "root", "taosdata", NULL, 0);
L
Liu Jicong 已提交
24 25 26 27
  if (pConn == NULL) {
    return -1;
  }

28
  TAOS_RES* pRes = taos_query(pConn, "create database if not exists abc1 vgroups 2");
L
Liu Jicong 已提交
29 30 31 32 33 34
  if (taos_errno(pRes) != 0) {
    printf("error in create db, reason:%s\n", taos_errstr(pRes));
    return -1;
  }
  taos_free_result(pRes);

35
#if 0
L
Liu Jicong 已提交
36 37 38 39 40 41
  pRes = taos_query(pConn, "create database if not exists abc2 vgroups 20");
  if (taos_errno(pRes) != 0) {
    printf("error in create db, reason:%s\n", taos_errstr(pRes));
    return -1;
  }
  taos_free_result(pRes);
42
#endif
L
Liu Jicong 已提交
43

L
Liu Jicong 已提交
44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70
  pRes = taos_query(pConn, "use abc1");
  if (taos_errno(pRes) != 0) {
    printf("error in use db, reason:%s\n", taos_errstr(pRes));
    return -1;
  }
  taos_free_result(pRes);

  pRes = taos_query(pConn, "create stable if not exists st1 (ts timestamp, k int) tags(a int)");
  if (taos_errno(pRes) != 0) {
    printf("failed to create super table st1, reason:%s\n", taos_errstr(pRes));
    return -1;
  }
  taos_free_result(pRes);

  pRes = taos_query(pConn, "create table if not exists tu1 using st1 tags(1)");
  if (taos_errno(pRes) != 0) {
    printf("failed to create child table tu1, reason:%s\n", taos_errstr(pRes));
    return -1;
  }
  taos_free_result(pRes);

  pRes = taos_query(pConn, "create table if not exists tu2 using st1 tags(2)");
  if (taos_errno(pRes) != 0) {
    printf("failed to create child table tu2, reason:%s\n", taos_errstr(pRes));
    return -1;
  }
  taos_free_result(pRes);
71 72 73 74 75 76 77 78

  pRes = taos_query(pConn, "create table if not exists tu3 using st1 tags(3)");
  if (taos_errno(pRes) != 0) {
    printf("failed to create child table tu3, reason:%s\n", taos_errstr(pRes));
    return -1;
  }
  taos_free_result(pRes);

L
Liu Jicong 已提交
79 80 81 82
  return 0;
}

int32_t create_stream() {
L
Liu Jicong 已提交
83
  printf("create stream\n");
L
Liu Jicong 已提交
84
  TAOS_RES* pRes;
L
fix  
Liu Jicong 已提交
85
  TAOS*     pConn = taos_connect("localhost", "root", "taosdata", NULL, 0);
L
Liu Jicong 已提交
86 87 88 89 90 91 92 93 94 95 96
  if (pConn == NULL) {
    return -1;
  }

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

L
Liu Jicong 已提交
97
  /*const char* sql = "select min(k), max(k), sum(k) from tu1";*/
98
  /*const char* sql = "select min(k), max(k), sum(k) as sum_of_k from st1";*/
L
Liu Jicong 已提交
99
  /*const char* sql = "select sum(k) from tu1 interval(10m)";*/
100
  /*pRes = tmq_create_stream(pConn, "stream1", "out1", sql);*/
L
Liu Jicong 已提交
101 102 103
  pRes = taos_query(pConn,
                    "create stream stream1 trigger max_delay 10s watermark 10s into outstb as select _wstart start, "
                    "count(k) from st1 partition by tbname interval(20s) ");
L
Liu Jicong 已提交
104
  if (taos_errno(pRes) != 0) {
L
fix  
Liu Jicong 已提交
105
    printf("failed to create stream stream1, reason:%s\n", taos_errstr(pRes));
L
Liu Jicong 已提交
106 107 108 109 110 111 112 113 114 115 116 117 118
    return -1;
  }
  taos_free_result(pRes);
  taos_close(pConn);
  return 0;
}

int main(int argc, char* argv[]) {
  int code;
  if (argc > 1) {
    printf("env init\n");
    code = init_env();
  }
L
Liu Jicong 已提交
119
  create_stream();
L
Liu Jicong 已提交
120
}