/********************************************************************************
 *      Copyright:  (C) 2020 LingYun IoT System Studio
 *                  All rights reserved.
 *
 *       Filename:  sqlite_cli.h
 *    Description:  This head file is for client to save TLV packet in sqlite.
 *
 *        Version:  1.0.0(2020年05月13日)
 *         Author:  Guo Wenxue <guowenxue@gmail.com>
 *      ChangeLog:  1, Release initial version on "2020年05月13日 12时14分23秒"
 *                 
 ********************************************************************************/
#ifndef  _SQLITE_CLI_H_
#define  _SQLITE_CLI_H_

#include "sqlite3.h"
#include "tlv_pack.h"

#define SQL_COMMAND_LEN        256

/*  description: open or create sqlite database if not exist 
 *   input args:  
 *              $db_file: sqlite database file name
 * return value: <0: failure   0:ok
 * */
extern int clidb_init(const char *db_file);


/*  description: close sqlite database handler
 * return value: none
 */
extern void clidb_term(void);


/*  description: push TLV packet into database
 *   input args:
 *               $pack:  tlv packet pointer 
 * return value: <0: failure   0:ok
 */
extern int clidb_push_tlvpack(tlv_buf_t *pack);


/*  description: pop one TLV packet from database
 *   input args: 
 *               $pack:  tlv packet pointer 
 *               $id:    item ID pointer, which can be used as key when remove
 * return value: <0: failure   0:ok
 */
extern int clidb_pop_tlvpack(tlv_buf_t *pack, int *id);


/*  description: remove sepcified TLV packet from database
 *   input args: 
 *               $id:    remove item ID
 * return value: <0: failure   0:ok
 */
extern int clidb_del_tlvpack(int id);


#endif   /* ----- #ifndef _SQLITE_CLI_H_  ----- */