iauditorcli/issues.m at master · mdsecresearch/iauditorcli · GitHub

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
//
//  LibiAuditor
//
//  Created by Dominic Chell on 13/02/2012.
//  Copyright (c) 2012 MDSec Consulting Ltd. All rights reserved.
//

#import "issues.h"

@implementation issues

+(void)list:(NSString *)dbPath;
{
    sqlite3 * iaDatabase;
    NSFileManager *filemgr = [NSFileManager defaultManager];

    if ([filemgr fileExistsAtPath: dbPath ] == YES)
    {
        const char *dbpath = [dbPath UTF8String];
        if (sqlite3_open(dbpath, &iaDatabase) == SQLITE_OK)
        {
            const char *sql_stmt = "SELECT name,description FROM ISSUES";
            sqlite3_stmt *detailStmt;
            if (sqlite3_prepare_v2(iaDatabase,sql_stmt,-1,&detailStmt,NULL)==SQLITE_OK)
            {
                int i=0;
                while(sqlite3_step(detailStmt) == SQLITE_ROW)
                {
                    printf("\t\e[31mIssue %d:\e[37m %s\n\tDescription: %s\n",i, (char *)sqlite3_column_text(detailStmt,0), (char *)sqlite3_column_text(detailStmt,1));
                    i++;
                }
            }
            else printf("ERROR: Unable to execute SQL");

            sqlite3_close(iaDatabase);
        } else {
            printf("ERROR: Unable to open iAuditor database");
        }
    }
}

@end