webconfig/apps/sql_api.h

#ifndef __SQL_API_H__
#define __SQL_API_H__

#include "json-c/json.h"
#include "json-c/json_util.h"


#define SQL_NAME	"./device_db.db"
#define MAX_TXET_LEN	10240

int init_device_db(void);
int insert_device_item(char*device_id,char*device_name,uint8_t device_addr,char *application_id);
int delete_device_by_device_id( char*device_id );
int update_device_by_device_id(char*device_id,char*device_name,uint8_t device_addr,char *application_id);
int update_tab_item_by_device_id(char*device_id,char *attr_id, char *attr_value);
//int update_tab_item_by_device_addr(uint8_t device_addr,char *attr_id, char *attr_value);
int update_tab_item_by_device_addr(uint8_t device_addr,char *attr_id, char *attr_value, uint8_t application_id);
int select_all_device(struct json_object **rsp_obj);
//int select_device_id_by_device_addr(uint8_t device_addr,uint8_t *device_id);
int select_device_id_by_device_addr(uint8_t device_addr,uint8_t *device_id, uint8_t application_id);
//int select_attr_by_device_addr(uint16_t *buffer, uint8_t device_addr, char*attr_id);
int select_attr_by_device_addr(uint16_t *buffer, uint8_t device_addr, char*attr_id, uint8_t application_id);



#endif