/* * 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 . */ // TAOS asynchronous API example // this example opens multiple tables, insert/retrieve multiple tables // it is used by TAOS internally for one performance testing // to compiple: gcc -o asyncdemo asyncdemo.c -ltaos #include #include #include #include #include #include int points = 5; int numOfTables = 3; int tablesProcessed = 0; int64_t st, et; typedef struct { int id; TAOS *taos; char name[16]; time_t timeStamp; int value; int rowsInserted; int rowsTried; int rowsRetrieved; } STable; void taos_insert_call_back(void *param, TAOS_RES *tres, int code); void taos_select_call_back(void *param, TAOS_RES *tres, int code); void taos_error(TAOS *taos); int main(int argc, char *argv[]) { TAOS *taos; struct timeval systemTime; int i; char sql[1024] = { 0 }; char prefix[20] = { 0 }; char db[128] = { 0 }; STable *tableList; if (argc != 5) { printf("usage: %s server-ip dbname rowsPerTable numOfTables\n", argv[0]); exit(0); } // a simple way to parse input parameters if (argc >= 3) strcpy(db, argv[2]); if (argc >= 4) points = atoi(argv[3]); if (argc >= 5) numOfTables = atoi(argv[4]); size_t size = sizeof(STable) * (size_t)numOfTables; tableList = (STable *)malloc(size); memset(tableList, 0, size); taos_init(); taos = taos_connect(argv[1], "root", "taosdata", NULL, 0); if (taos == NULL) taos_error(taos); printf("success to connect to server\n"); sprintf(sql, "drop database %s", db); taos_query(taos, sql); sprintf(sql, "create database %s", db); if (taos_query(taos, sql) != 0) taos_error(taos); sprintf(sql, "use %s", db); if (taos_query(taos, sql) != 0) taos_error(taos); strcpy(prefix, "asytbl_"); for (i = 0; i < numOfTables; ++i) { tableList[i].id = i; tableList[i].taos = taos; sprintf(tableList[i].name, "%s%d", prefix, i); sprintf(sql, "create table %s%d (ts timestamp, volume bigint)", prefix, i); if (taos_query(taos, sql) != 0) taos_error(taos); } gettimeofday(&systemTime, NULL); for (i = 0; i < numOfTables; ++i) tableList[i].timeStamp = (time_t)(systemTime.tv_sec) * 1000 + systemTime.tv_usec / 1000; printf("success to create tables, press any key to insert\n"); getchar(); printf("start to insert...\n"); gettimeofday(&systemTime, NULL); //st = systemTime.tv_sec * 1000000 + systemTime.tv_usec; for (i = 0; irowsTried++; if (code < 0) { printf("%s insert failed, code:%d, rows:%d\n", pTable->name, code, pTable->rowsTried); } else if (code == 0) { printf("%s not inserted\n", pTable->name); } else { pTable->rowsInserted++; } if (pTable->rowsTried < points) { // for this demo, insert another record sprintf(sql, "insert into %s values(now+%da, %d)", pTable->name, pTable->rowsTried, pTable->rowsTried); taos_query_a(pTable->taos, sql, taos_insert_call_back, (void *)pTable); } else { printf("%d rows data are inserted into %s\n", points, pTable->name); tablesProcessed++; if (tablesProcessed >= numOfTables) { gettimeofday(&systemTime, NULL); et = systemTime.tv_sec * 1000000 + systemTime.tv_usec; printf("%lld mseconds to insert %d data points\n", (et - st) / 1000, points*numOfTables); } } } void taos_retrieve_call_back(void *param, TAOS_RES *tres, int numOfRows) { STable *pTable = (STable *)param; struct timeval systemTime; if (numOfRows > 0) { for (int i = 0; irowsRetrieved += numOfRows; // retrieve next batch of rows taos_fetch_rows_a(tres, taos_retrieve_call_back, pTable); } else { if (numOfRows < 0) printf("%s retrieve failed, code:%d\n", pTable->name, numOfRows); taos_free_result(tres); printf("%d rows data retrieved from %s\n", pTable->rowsRetrieved, pTable->name); tablesProcessed++; if (tablesProcessed >= numOfTables) { gettimeofday(&systemTime, NULL); et = systemTime.tv_sec * 1000000 + systemTime.tv_usec; printf("%lld mseconds to query %d data rows\n", (et - st) / 1000, points * numOfTables); } } } void taos_select_call_back(void *param, TAOS_RES *tres, int code) { STable *pTable = (STable *)param; if (code == 0 && tres) { // asynchronous API to fetch a batch of records taos_fetch_rows_a(tres, taos_retrieve_call_back, pTable); // taos_fetch_row_a is a less efficient way to retrieve records since it call back app for every row // taos_fetch_row_a(tres, taos_fetch_row_call_back, pTable); } else { printf("%s select failed, code:%d\n", pTable->name, code); exit(1); } }