int dInsert_CONDResult(char* szAlm, char* szMsg, int dLen, unsigned char ucTAMID, unsigned char ucTAFID)
{
int dRet;
char szIQuery[1024], szCQuery[1024];
st_almsts *palm;
//memset( szIQuery, 0x00, 1024 );
//memset( szCQuery, 0x00, 1024 );
palm = (st_almsts*)szAlm;
getInsertQuery(szIQuery, szAlm, szMsg, ucTAMID, ucTAFID);
if( (dRet = db_insert(&stMySQL, szIQuery)) < 0 ){
switch( db_errno(&stMySQL) ){
case E_DB_NOT_CONNECT:
log_print(LOGN_WARN, LH"FAILED IN connect DB",LT);
break;
case E_DB_TABLE_NOT_EXIST:
getCreateQuery(szCQuery);
if( (dRet = db_create(&stMySQL, szCQuery)) == 0 ){
if( (dRet = db_insert(&stMySQL, szIQuery)) < 0 ){
log_print(LOGN_CRI, LH"ERROR IN db_insert(SYS_COND_MSG), dRet=%d\nQuery=%s",
LT, dRet,szIQuery);
return dRet;
}
log_print(LOGN_CRI, LH"SUCCESS IN db_created(SYS_COND_MSG)",LT);
}
log_print(LOGN_CRI, LH"ERROR IN db_create(SYS_COND_MSG), dRet=%d",
LT, dRet);
break;
case E_DB_DUPLICATED_ENTRY:
log_print(LOGN_WARN, LH"FAILED IN db_insert(DUPLICATED)",LT);
vErrPrint(szAlm, szMsg, ucTAMID, ucTAFID);
return 0;
break;
default:
log_print(LOGN_CRI, LH"FAILED IN db_insert(), dRet=%d", LT, dRet);
vErrPrint(szAlm, szMsg, ucTAMID, ucTAFID);
break;
}
return dRet;
}
log_print(LOGN_DEBUG,"SUCCESS INSERT COND MSG TO DB\nQuery=%s",szIQuery);
return 0;
}
bool StageInfo::insertStageInfo(){
return executeNonQuery(getInsertQuery());
}
