int ZCE_General_Config_Table::counter(unsigned int table_id,
unsigned int startno,
unsigned int numquery,
unsigned int *rec_count)
{
sql_counter(table_id, startno, numquery);
ZCE_SQLite_STMTHdl stmt_handler(sqlite_handler_);
int ret = 0;
ret = stmt_handler.prepare(sql_string_);
if (ret != 0)
{
return ret;
}
bool hash_result = false;
ret = stmt_handler.execute_stmt_sql(hash_result);
if (ret != 0)
{
return ret;
}
if (false == hash_result)
{
return -1;
}
stmt_handler >> *rec_count;
return 0;
}
int id_counter::sql_data(char* buf,int size) const
{
int origin_size = size,len=0 ;
int first_flag = 1 ;
if(dirty[0])
{
if(first_flag==0) {memcpy(buf,",",1); buf+= 1 ; size-= 1 ;}
len =sql_tid(buf,size);
buf += len ; size -= len ;first_flag=0;
}
if(dirty[1])
{
if(first_flag==0) {memcpy(buf,",",1); buf+= 1 ; size-= 1 ;}
len =sql_sid(buf,size);
buf += len ; size -= len ;first_flag=0;
}
if(dirty[2])
{
if(first_flag==0) {memcpy(buf,",",1); buf+= 1 ; size-= 1 ;}
len =sql_counter(buf,size);
buf += len ; size -= len ;first_flag=0;
}
if(dirty[3])
{
if(first_flag==0) {memcpy(buf,",",1); buf+= 1 ; size-= 1 ;}
len =sql_step(buf,size);
buf += len ; size -= len ;first_flag=0;
}
if(dirty[4])
{
if(first_flag==0) {memcpy(buf,",",1); buf+= 1 ; size-= 1 ;}
len =sql_remark(buf,size);
buf += len ; size -= len ;first_flag=0;
}
return origin_size - size ;
}
