#include #include #include #include #include "sqlite3.h" #define MAX_QUERY_LENGTH 2048 /* From http://www.sqlite.org/quickstart.html */ static int callback(void *NotUsed, int argc, char **argv, char **azColName){ int i; for(i=0; i < argc; i++) { printf("%s = %s\n", azColName[i], argv[i] ? argv[i] : "NULL"); } printf("\n"); return 0; } int main (int argc, const char * argv[]) { sqlite3 *db; char *errMsg; int rc; const char *mpsDatabasePath; const char *linkNodeIdString; char query[MAX_QUERY_LENGTH]; /* Handle arguments */ if (argc < 2) { fprintf(stderr, "Usage: %s PathToDatabase [LinkNodeID]\n\n", argv[0]); return 1; } mpsDatabasePath = argv[1]; /* Open database */ rc = sqlite3_open(mpsDatabasePath, &db); if( rc ) { fprintf(stderr, "Can't open database: %s\n", sqlite3_errmsg(db)); sqlite3_close(db); return 2; } /* Prepare query */ if (argc >= 3) { linkNodeIdString = argv[2]; snprintf(query, MAX_QUERY_LENGTH, "SELECT ZPVDEVICETYPE lnPvDeviceType,\ ZPVAREA lnPvArea,\ ZPVPOSITION lnPvPosition,\ ZLINKNODEID linkNodeId\ FROM ZLINKNODE\ WHERE ZLINKNODEID = %ld", strtol(linkNodeIdString, NULL, 10)); rc = sqlite3_exec(db, query, callback, 0, &errMsg); if( rc!=SQLITE_OK ) { fprintf(stderr, "SQL error: %s\n", errMsg); sqlite3_free(errMsg); } snprintf(query, MAX_QUERY_LENGTH, "select lnic.ZNAME name,\ lnic.ZPVDEVICETYPE pvDeviceType,\ lnic.ZPVAREA pvArea,\ lnic.ZPVPOSITION pvPosition,\ lnic.ZPVATTRIBUTE pvAttribute,\ lnic.ZINPUTCARD card,\ lnic.ZINPUTCARDCHANNEL channel,\ debounce.ZTIMEINMICROSECONDS debounceInMicroSec,\ debounce.ZENUM debounceEnum\ from ZLINKNODEINPUTCHANNEL lnic left outer join ZDEBOUNCETIME debounce\ on lnic.ZDEBOUNCETIME = debounce.Z_PK\ where lnic.ZLINKNODE = (select Z_PK\ from ZLINKNODE\ where ZLINKNODEID = %ld)", strtol(linkNodeIdString, NULL, 10)); } else { snprintf(query, MAX_QUERY_LENGTH, "SELECT ZPVDEVICETYPE lnPvDeviceType,\ ZPVAREA lnPvArea,\ ZPVPOSITION lnPvPosition,\ ZLINKNODEID linkNodeId\ FROM ZLINKNODE"); } /* Execute query */ rc = sqlite3_exec(db, query, callback, 0, &errMsg); if( rc!=SQLITE_OK ) { fprintf(stderr, "SQL error: %s\n", errMsg); sqlite3_free(errMsg); } /* Close database */ sqlite3_close(db); return 0; }