Main Page | Modules | Alphabetical List | Data Structures | File List | Data Fields | Globals | Related Pages

model_pstmt.h File Reference

Go to the source code of this file.

Defines

#define AWMODEL_BIND_DOUBLE(model, name, index, real)
#define AWMODEL_BIND_DOUBLE(model, name, index, real)
#define AWMODEL_BIND_DOUBLE(model, name, index, real)
#define AWMODEL_BIND_INT(model, name, index, integer)
#define AWMODEL_BIND_INT(model, name, index, integer)
#define AWMODEL_BIND_INT(model, name, index, integer)
#define AWMODEL_BIND_TEXT(model, name, index, text)
#define AWMODEL_BIND_TEXT(model, name, index, text)
#define AWMODEL_BIND_TEXT(model, name, index, text)
#define AWMODEL_DO_COMMIT(model)
#define AWMODEL_DO_COMMIT(model)
#define AWMODEL_DO_COMMIT(model)
#define AWMODEL_DO_ROLLBACK(model)
#define AWMODEL_DO_ROLLBACK(model)
#define AWMODEL_DO_ROLLBACK(model)
#define AWMODEL_GET_PSTMT(model, name)   (model) -> db . stmts . name
#define AWMODEL_GET_PSTMT(model, name)   (model) -> db . stmts . name
#define AWMODEL_GET_PSTMT(model, name)   (model) -> db . stmts . name
#define AWMODEL_LOG_PRIVERROR(model, uid)
#define AWMODEL_LOG_PRIVERROR(model, uid)
#define AWMODEL_LOG_PRIVERROR(model, uid)
#define AWMODEL_LOG_SQLERROR(model, name)
#define AWMODEL_LOG_SQLERROR(model, name)
#define AWMODEL_LOG_SQLERROR(model, name)
#define AWMODEL_LOG_SQLERROR2(model, stmt)
#define AWMODEL_LOG_SQLERROR2(model, stmt)
#define AWMODEL_LOG_SQLERROR2(model, stmt)
#define AWMODEL_PSTMT(name, sqlstring)   aw_model_stmt_t name ;
#define AWMODEL_PSTMT(name, sqlstring)   aw_model_stmt_t name ;
#define AWMODEL_PSTMT(name, sqlstring)   model -> db . stmts . name . sql = sqlstring ;
#define AWMODEL_SET_INT_MBR(model, name, index, mbr)
#define AWMODEL_SET_INT_MBR(model, name, index, mbr)
#define AWMODEL_SET_INT_MBR(model, name, index, mbr)
#define AWMODEL_SET_INT_MBR2(stmt, index, mbr)
#define AWMODEL_SET_INT_MBR2(stmt, index, mbr)
#define AWMODEL_SET_INT_MBR2(stmt, index, mbr)
#define AWMODEL_SET_TEXT(model, name, index, mbr, mbrsize)
#define AWMODEL_SET_TEXT(model, name, index, mbr, mbrsize)
#define AWMODEL_SET_TEXT(model, name, index, mbr, mbrsize)
#define AWMODEL_SET_TEXT_MBR(model, name, index, mbr)
#define AWMODEL_SET_TEXT_MBR(model, name, index, mbr)
#define AWMODEL_SET_TEXT_MBR(model, name, index, mbr)
#define AWMODEL_SET_TEXT_MBR2(stmt, index, mbr)
#define AWMODEL_SET_TEXT_MBR2(stmt, index, mbr)
#define AWMODEL_SET_TEXT_MBR2(stmt, index, mbr)
#define INTERFACE_ALERT_GROUPS   "(select group_id from aw_interface i, aw_node2group n2g where i.id = ? and i.node_id = n2g.node_id) "
#define INTERFACE_ALERT_GROUPS   "(select group_id from aw_interface i, aw_node2group n2g where i.id = ? and i.node_id = n2g.node_id) "
#define INTERFACE_ALERT_GROUPS   "(select group_id from aw_interface i, aw_node2group n2g where i.id = ? and i.node_id = n2g.node_id) "
#define MESSAGE_ALERT_GROUPS   "(select group_id from aw_node n, aw_node2group n2g where (n.username=? or n.nmbname=? or n.snmpname=? or n.ipname=?) and n.id = n2g.node_id) "
#define MESSAGE_ALERT_GROUPS   "(select group_id from aw_node n, aw_node2group n2g where (n.username=? or n.nmbname=? or n.snmpname=? or n.ipname=?) and n.id = n2g.node_id) "
#define MESSAGE_ALERT_GROUPS   "(select group_id from aw_node n, aw_node2group n2g where (n.username=? or n.nmbname=? or n.snmpname=? or n.ipname=?) and n.id = n2g.node_id) "
#define SELECT_USERS_FOR_ALERT(group_select)
#define SELECT_USERS_FOR_ALERT(group_select)
#define SELECT_USERS_FOR_ALERT(group_select)
#define SERVICE_ALERT_GROUPS   "(select group_id from aw_service s, aw_node2group n2g where s.id = ? and s.node_id = n2g.node_id) "
#define SERVICE_ALERT_GROUPS   "(select group_id from aw_service s, aw_node2group n2g where s.id = ? and s.node_id = n2g.node_id) "
#define SERVICE_ALERT_GROUPS   "(select group_id from aw_service s, aw_node2group n2g where s.id = ? and s.node_id = n2g.node_id) "

Functions

 AWMODEL_PSTMT (settings_queryby_kw,"select val, note from aw_settings where kw=?") AWMODEL_PSTMT(settings_update

Define Documentation

#define AWMODEL_BIND_DOUBLE (  model,
name,
index,
real   ) 
 

Value:

{\
  if ( unlikely( sqlite3_bind_double((AWMODEL_GET_PSTMT(model,name)).compiled, (index), (real)) != SQLITE_OK ) ) { \
    AWMODEL_LOG_SQLERROR(model, name); \
    goto sqlerror; \
  }\
}

#define AWMODEL_BIND_DOUBLE (  model,
name,
index,
real   ) 
 

Value:

{\
  if ( unlikely( sqlite3_bind_double((AWMODEL_GET_PSTMT(model,name)).compiled, (index), (real)) != SQLITE_OK ) ) { \
    AWMODEL_LOG_SQLERROR(model, name); \
    goto sqlerror; \
  }\
}

#define AWMODEL_BIND_DOUBLE (  model,
name,
index,
real   ) 
 

Value:

{\
  if ( unlikely( sqlite3_bind_double((AWMODEL_GET_PSTMT(model,name)).compiled, (index), (real)) != SQLITE_OK ) ) { \
    AWMODEL_LOG_SQLERROR(model, name); \
    goto sqlerror; \
  }\
}

#define AWMODEL_BIND_INT (  model,
name,
index,
integer   ) 
 

Value:

{\
  if ( unlikely( sqlite3_bind_int((AWMODEL_GET_PSTMT(model,name)).compiled, (index), (integer)) != SQLITE_OK ) ) { \
    AWMODEL_LOG_SQLERROR(model, name); \
    goto sqlerror; \
  }\
}

#define AWMODEL_BIND_INT (  model,
name,
index,
integer   ) 
 

Value:

{\
  if ( unlikely( sqlite3_bind_int((AWMODEL_GET_PSTMT(model,name)).compiled, (index), (integer)) != SQLITE_OK ) ) { \
    AWMODEL_LOG_SQLERROR(model, name); \
    goto sqlerror; \
  }\
}

#define AWMODEL_BIND_INT (  model,
name,
index,
integer   ) 
 

Value:

{\
  if ( unlikely( sqlite3_bind_int((AWMODEL_GET_PSTMT(model,name)).compiled, (index), (integer)) != SQLITE_OK ) ) { \
    AWMODEL_LOG_SQLERROR(model, name); \
    goto sqlerror; \
  }\
}

#define AWMODEL_BIND_TEXT (  model,
name,
index,
text   ) 
 

Value:

{\
  if ( unlikely( sqlite3_bind_text(AWMODEL_GET_PSTMT(model,name) . compiled, \
                                   (index), (text), strlen(text), SQLITE_STATIC) != SQLITE_OK  ) ) { \
    AWMODEL_LOG_SQLERROR(model, name); \
    goto sqlerror; \
  }\
}

#define AWMODEL_BIND_TEXT (  model,
name,
index,
text   ) 
 

Value:

{\
  if ( unlikely( sqlite3_bind_text(AWMODEL_GET_PSTMT(model,name) . compiled, \
                                   (index), (text), strlen(text), SQLITE_STATIC) != SQLITE_OK  ) ) { \
    AWMODEL_LOG_SQLERROR(model, name); \
    goto sqlerror; \
  }\
}

#define AWMODEL_BIND_TEXT (  model,
name,
index,
text   ) 
 

Value:

{\
  if ( unlikely( sqlite3_bind_text(AWMODEL_GET_PSTMT(model,name) . compiled, \
                                   (index), (text), strlen(text), SQLITE_STATIC) != SQLITE_OK  ) ) { \
    AWMODEL_LOG_SQLERROR(model, name); \
    goto sqlerror; \
  }\
}

#define AWMODEL_DO_COMMIT (  model   ) 
 

Value:

{\
  if ( aw_model_execute_stmt(model, &(model->db.stmts.commit)) != SQLITE_DONE ) \
    aw_log(&(model->mon->logger), AW_ERROR_LOG_LEVEL, "model: %s failed (%s)", \
           __FUNCTION__, sqlite3_errmsg(model->db.state.conn)); \
\
  aw_model_reset_stmt(model, &(model->db.stmts.commit)); \
}

#define AWMODEL_DO_COMMIT (  model   ) 
 

Value:

{\
  if ( aw_model_execute_stmt(model, &(model->db.stmts.commit)) != SQLITE_DONE ) \
    aw_log(&(model->mon->logger), AW_ERROR_LOG_LEVEL, "model: %s failed (%s)", \
           __FUNCTION__, sqlite3_errmsg(model->db.state.conn)); \
\
  aw_model_reset_stmt(model, &(model->db.stmts.commit)); \
}

#define AWMODEL_DO_COMMIT (  model   ) 
 

Value:

{\
  if ( aw_model_execute_stmt(model, &(model->db.stmts.commit)) != SQLITE_DONE ) \
    aw_log(&(model->mon->logger), AW_ERROR_LOG_LEVEL, "model: %s failed (%s)", \
           __FUNCTION__, sqlite3_errmsg(model->db.state.conn)); \
\
  aw_model_reset_stmt(model, &(model->db.stmts.commit)); \
}

#define AWMODEL_DO_ROLLBACK (  model   ) 
 

Value:

{\
  if ( aw_model_execute_stmt(model, &(model->db.stmts.rollback)) != SQLITE_DONE) \
    aw_log(&(model->mon->logger), AW_ERROR_LOG_LEVEL, "model: %s failed (%s)", \
           __FUNCTION__, sqlite3_errmsg(model->db.state.conn)); \
\
  aw_model_reset_stmt(model, &(model->db.stmts.rollback)); \
}

#define AWMODEL_DO_ROLLBACK (  model   ) 
 

Value:

{\
  if ( aw_model_execute_stmt(model, &(model->db.stmts.rollback)) != SQLITE_DONE) \
    aw_log(&(model->mon->logger), AW_ERROR_LOG_LEVEL, "model: %s failed (%s)", \
           __FUNCTION__, sqlite3_errmsg(model->db.state.conn)); \
\
  aw_model_reset_stmt(model, &(model->db.stmts.rollback)); \
}

#define AWMODEL_DO_ROLLBACK (  model   ) 
 

Value:

{\
  if ( aw_model_execute_stmt(model, &(model->db.stmts.rollback)) != SQLITE_DONE) \
    aw_log(&(model->mon->logger), AW_ERROR_LOG_LEVEL, "model: %s failed (%s)", \
           __FUNCTION__, sqlite3_errmsg(model->db.state.conn)); \
\
  aw_model_reset_stmt(model, &(model->db.stmts.rollback)); \
}

#define AWMODEL_GET_PSTMT (  model,
name   )     (model) -> db . stmts . name
 

#define AWMODEL_GET_PSTMT (  model,
name   )     (model) -> db . stmts . name
 

#define AWMODEL_GET_PSTMT (  model,
name   )     (model) -> db . stmts . name
 

#define AWMODEL_LOG_PRIVERROR (  model,
uid   ) 
 

Value:

aw_log(&( (model) -> mon -> logger), AW_ERROR_LOG_LEVEL, "model: %s failed for '%u' (not allowed)", \
         __FUNCTION__, (uid));

#define AWMODEL_LOG_PRIVERROR (  model,
uid   ) 
 

Value:

aw_log(&( (model) -> mon -> logger), AW_ERROR_LOG_LEVEL, "model: %s failed for '%u' (not allowed)", \
         __FUNCTION__, (uid));

#define AWMODEL_LOG_PRIVERROR (  model,
uid   ) 
 

Value:

aw_log(&( (model) -> mon -> logger), AW_ERROR_LOG_LEVEL, "model: %s failed for '%u' (not allowed)", \
         __FUNCTION__, (uid));

#define AWMODEL_LOG_SQLERROR (  model,
name   ) 
 

Value:

aw_log(&( (model) -> mon -> logger), AW_ERROR_LOG_LEVEL, "model: %s failed on '%s'(%s)", \
         __FUNCTION__, (model) -> db . stmts . name . sql , sqlite3_errmsg( (model) -> db . state . conn));

#define AWMODEL_LOG_SQLERROR (  model,
name   ) 
 

Value:

aw_log(&( (model) -> mon -> logger), AW_ERROR_LOG_LEVEL, "model: %s failed on '%s'(%s)", \
         __FUNCTION__, (model) -> db . stmts . name . sql , sqlite3_errmsg( (model) -> db . state . conn));

#define AWMODEL_LOG_SQLERROR (  model,
name   ) 
 

Value:

aw_log(&( (model) -> mon -> logger), AW_ERROR_LOG_LEVEL, "model: %s failed on '%s'(%s)", \
         __FUNCTION__, (model) -> db . stmts . name . sql , sqlite3_errmsg( (model) -> db . state . conn));

#define AWMODEL_LOG_SQLERROR2 (  model,
stmt   ) 
 

Value:

aw_log(&( (model) -> mon -> logger), AW_ERROR_LOG_LEVEL, "model: %s failed on '%s'(%s)", \
         __FUNCTION__, (stmt) -> sql , sqlite3_errmsg( (model) -> db . state . conn));

#define AWMODEL_LOG_SQLERROR2 (  model,
stmt   ) 
 

Value:

aw_log(&( (model) -> mon -> logger), AW_ERROR_LOG_LEVEL, "model: %s failed on '%s'(%s)", \
         __FUNCTION__, (stmt) -> sql , sqlite3_errmsg( (model) -> db . state . conn));

#define AWMODEL_LOG_SQLERROR2 (  model,
stmt   ) 
 

Value:

aw_log(&( (model) -> mon -> logger), AW_ERROR_LOG_LEVEL, "model: %s failed on '%s'(%s)", \
         __FUNCTION__, (stmt) -> sql , sqlite3_errmsg( (model) -> db . state . conn));

#define AWMODEL_PSTMT (  name,
sqlstring   )     aw_model_stmt_t name ;
 

#define AWMODEL_PSTMT (  name,
sqlstring   )     aw_model_stmt_t name ;
 

#define AWMODEL_PSTMT (  name,
sqlstring   )     model -> db . stmts . name . sql = sqlstring ;
 

#define AWMODEL_SET_INT_MBR (  model,
name,
index,
mbr   ) 
 

Value:

{\
 mbr = sqlite3_column_int((AWMODEL_GET_PSTMT(model,name)).compiled, index); \
}

#define AWMODEL_SET_INT_MBR (  model,
name,
index,
mbr   ) 
 

Value:

{\
 mbr = sqlite3_column_int((AWMODEL_GET_PSTMT(model,name)).compiled, index); \
}

#define AWMODEL_SET_INT_MBR (  model,
name,
index,
mbr   ) 
 

Value:

{\
 mbr = sqlite3_column_int((AWMODEL_GET_PSTMT(model,name)).compiled, index); \
}

#define AWMODEL_SET_INT_MBR2 (  stmt,
index,
mbr   ) 
 

Value:

{\
 mbr = sqlite3_column_int(stmt->compiled, index); \
}

#define AWMODEL_SET_INT_MBR2 (  stmt,
index,
mbr   ) 
 

Value:

{\
 mbr = sqlite3_column_int(stmt->compiled, index); \
}

#define AWMODEL_SET_INT_MBR2 (  stmt,
index,
mbr   ) 
 

Value:

{\
 mbr = sqlite3_column_int(stmt->compiled, index); \
}

#define AWMODEL_SET_TEXT (  model,
name,
index,
mbr,
mbrsize   ) 
 

Value:

{\
 const byte_t *txt = (const byte_t *)sqlite3_column_text((AWMODEL_GET_PSTMT(model,name)).compiled, (index)); \
 strncpy((mbr), (txt)?txt:"", (mbrsize)-1);\
 mbr[(mbrsize)-1]=0; /* keep sure terminated */ \
}

#define AWMODEL_SET_TEXT (  model,
name,
index,
mbr,
mbrsize   ) 
 

Value:

{\
 const byte_t *txt = (const byte_t *)sqlite3_column_text((AWMODEL_GET_PSTMT(model,name)).compiled, (index)); \
 strncpy((mbr), (txt)?txt:"", (mbrsize)-1);\
 mbr[(mbrsize)-1]=0; /* keep sure terminated */ \
}

#define AWMODEL_SET_TEXT (  model,
name,
index,
mbr,
mbrsize   ) 
 

Value:

{\
 const byte_t *txt = (const byte_t *)sqlite3_column_text((AWMODEL_GET_PSTMT(model,name)).compiled, (index)); \
 strncpy((mbr), (txt)?txt:"", (mbrsize)-1);\
 mbr[(mbrsize)-1]=0; /* keep sure terminated */ \
}

#define AWMODEL_SET_TEXT_MBR (  model,
name,
index,
mbr   ) 
 

Value:

{\
 AWMODEL_SET_TEXT(model, name, index, mbr, sizeof(mbr)); \
}

#define AWMODEL_SET_TEXT_MBR (  model,
name,
index,
mbr   ) 
 

Value:

{\
 AWMODEL_SET_TEXT(model, name, index, mbr, sizeof(mbr)); \
}

#define AWMODEL_SET_TEXT_MBR (  model,
name,
index,
mbr   ) 
 

Value:

{\
 AWMODEL_SET_TEXT(model, name, index, mbr, sizeof(mbr)); \
}

#define AWMODEL_SET_TEXT_MBR2 (  stmt,
index,
mbr   ) 
 

Value:

{\
 const size_t mbrsize=sizeof(mbr); \
 const byte_t *txt = (byte_t *)sqlite3_column_text(stmt -> compiled, (index)); \
 strncpy((mbr), (txt)?txt:"", (mbrsize)-1);\
 mbr[(mbrsize)-1]=0; /* keep sure terminated */ \
}

#define AWMODEL_SET_TEXT_MBR2 (  stmt,
index,
mbr   ) 
 

Value:

{\
 const size_t mbrsize=sizeof(mbr); \
 const byte_t *txt = (byte_t *)sqlite3_column_text(stmt -> compiled, (index)); \
 strncpy((mbr), (txt)?txt:"", (mbrsize)-1);\
 mbr[(mbrsize)-1]=0; /* keep sure terminated */ \
}

#define AWMODEL_SET_TEXT_MBR2 (  stmt,
index,
mbr   ) 
 

Value:

{\
 const size_t mbrsize=sizeof(mbr); \
 const byte_t *txt = (byte_t *)sqlite3_column_text(stmt -> compiled, (index)); \
 strncpy((mbr), (txt)?txt:"", (mbrsize)-1);\
 mbr[(mbrsize)-1]=0; /* keep sure terminated */ \
}

#define INTERFACE_ALERT_GROUPS   "(select group_id from aw_interface i, aw_node2group n2g where i.id = ? and i.node_id = n2g.node_id) "
 

#define INTERFACE_ALERT_GROUPS   "(select group_id from aw_interface i, aw_node2group n2g where i.id = ? and i.node_id = n2g.node_id) "
 

#define INTERFACE_ALERT_GROUPS   "(select group_id from aw_interface i, aw_node2group n2g where i.id = ? and i.node_id = n2g.node_id) "
 

#define MESSAGE_ALERT_GROUPS   "(select group_id from aw_node n, aw_node2group n2g where (n.username=? or n.nmbname=? or n.snmpname=? or n.ipname=?) and n.id = n2g.node_id) "
 

#define MESSAGE_ALERT_GROUPS   "(select group_id from aw_node n, aw_node2group n2g where (n.username=? or n.nmbname=? or n.snmpname=? or n.ipname=?) and n.id = n2g.node_id) "
 

#define MESSAGE_ALERT_GROUPS   "(select group_id from aw_node n, aw_node2group n2g where (n.username=? or n.nmbname=? or n.snmpname=? or n.ipname=?) and n.id = n2g.node_id) "
 

#define SELECT_USERS_FOR_ALERT (  group_select   ) 
 

Value:

"select g.id as group_id,u.id as user_id,u2g.priorityorder as porder,  "\
"  u.firstname || ' ' || u.lastname as uname                           "\
"  from aw_user u,aw_group g,aw_groupmember u2g                        "\
"  where g.id in                                                       "\
      group_select \
"     and g.deleted = 0                                                "\
"     and g.id = u2g.group_id                                          "\
"     and u2g.user_id = u.id                                           "\
"     and u.active = 1                                                 "\
"     order by group_id asc,porder asc                                 "\

#define SELECT_USERS_FOR_ALERT (  group_select   ) 
 

Value:

"select g.id as group_id,u.id as user_id,u2g.priorityorder as porder,  "\
"  u.firstname || ' ' || u.lastname as uname                           "\
"  from aw_user u,aw_group g,aw_groupmember u2g                        "\
"  where g.id in                                                       "\
      group_select \
"     and g.deleted = 0                                                "\
"     and g.id = u2g.group_id                                          "\
"     and u2g.user_id = u.id                                           "\
"     and u.active = 1                                                 "\
"     order by group_id asc,porder asc                                 "\

#define SELECT_USERS_FOR_ALERT (  group_select   ) 
 

Value:

"select g.id as group_id,u.id as user_id,u2g.priorityorder as porder,  "\
"  u.firstname || ' ' || u.lastname as uname                           "\
"  from aw_user u,aw_group g,aw_groupmember u2g                        "\
"  where g.id in                                                       "\
      group_select \
"     and g.deleted = 0                                                "\
"     and g.id = u2g.group_id                                          "\
"     and u2g.user_id = u.id                                           "\
"     and u.active = 1                                                 "\
"     order by group_id asc,porder asc                                 "\

#define SERVICE_ALERT_GROUPS   "(select group_id from aw_service s, aw_node2group n2g where s.id = ? and s.node_id = n2g.node_id) "
 

#define SERVICE_ALERT_GROUPS   "(select group_id from aw_service s, aw_node2group n2g where s.id = ? and s.node_id = n2g.node_id) "
 

#define SERVICE_ALERT_GROUPS   "(select group_id from aw_service s, aw_node2group n2g where s.id = ? and s.node_id = n2g.node_id) "
 

Function Documentation

AWMODEL_PSTMT (  settings_queryby_kw  ,
"select  val
) 
 

Aware 0.11.1 Copyright (C) 1998-2005 Russell Leighton (russ@elegant-software.com)