JDDatabaseManager.h

//
//  JDDatabaseManager.h
//  Augmented Reality Tractor Maintenance
//
//  Created by Hildebrand, Tanner J on 10/25/14.
//  Copyright (c) 2014 Intelligent Solutions Group. All rights reserved.
//

#ifndef JDDATABASEMANAGER_H
#define JDDATABASEMANAGER_H

#import <Foundation/Foundation.h>
#import <sqlite3.h>

#define DATABASEDEBUGON 0

enum JDDATATYPE {
    JDDATA_STRING,
    JDDATA_INTEGER,
    JDDATA_TEXT,
    JDDATA_REAL,
    JDDATA_RAWSTRING
};

enum JDATAORDER {
    JDATAORDER_ASC,
    JDATAORDER_DESC
};

@interface JDFieldArray : NSArray

-(BOOL) addGetField:(NSString *)fieldName withType:(enum JDDATATYPE)dataType;

-(BOOL) addSetField:(NSString *)fieldName 
    withValue:(NSObject *)value withType:(enum JDDATATYPE)dataType;

-(unsigned long) size;

-(NSString *) getFieldAt:(unsigned long)index;

-(NSObject *) getValueAt:(unsigned long)index;

-(long) getTypeAt: (unsigned long)index;

-(NSObject *) getValueFor:(NSString *)field;

-(void) changeValueFor:(NSString *)field toObject:(NSObject *)object;

-(NSInteger) count;

@end


@interface JDDatabaseManager : NSObject
-(instancetype)initWithDatabaseFilename:(NSString *)dbFilename;

// this is the stuff we care about

-(instancetype)init;

-(sqlite3 *)getAppCoreDB;

-(sqlite3 *)getDatabase: (NSString *)databaseName;

-(BOOL) setAppCoreEntry: (NSString *)opt withValue:(NSString *)value 
    andEnable:(BOOL)enabled;

-(BOOL) addAppCoreEntry: (NSString *)opt withValue:(NSString *)value 
    andEnable:(BOOL)enabled;

-(NSString *) getAppCoreEntry: (NSString *)opt;

-(BOOL) removeAppCoreDatabase;

-(BOOL) removeDatabase: (NSString *)databaseName;

-(BOOL) createTable: (NSString *)tableName withFields:(NSArray *)fields;

-(BOOL) setEntries:(JDFieldArray *)opts
           inTable:(NSString *)table
        whereField:(NSString *)field
         isEqualTo:(NSObject *)testObj
            ofType:(enum JDDATATYPE)dataType;

-(BOOL) setEntries:(JDFieldArray *)opts
           inTable:(NSString *)table
        whereField:(NSString *)field
         isEqualTo:(NSObject *)testObj
            ofType:(enum JDDATATYPE)dataType
            withID:(NSNumber *)entryID;

-(BOOL) addEntries: (JDFieldArray *)opts inTable:(NSString *)table;

-(NSMutableArray *) getEntries:(JDFieldArray *)opts inTable:(NSString *)table;

-(NSMutableArray *) getEntries: (JDFieldArray *)opts
                       inTable:(NSString *)table
                    whereField:(NSString *)field
                     isEqualTo:(NSObject *)testObj
                        ofType:(enum JDDATATYPE)dataType;

-(NSMutableArray *) getEntries: (JDFieldArray *)opts
                       inTable:(NSString *)table
                    whereField:(NSString *)field
                     isEqualTo:(NSObject *)testObj
                        ofType:(enum JDDATATYPE)dataType
                     withLimit:(int)limit;


-(NSMutableArray *) getEntries: (JDFieldArray *)opts
                       inTable:(NSString *)table
                    whereField:(NSString *)field
                     isEqualTo:(NSObject *)testObj
                        ofType:(enum JDDATATYPE)dataType
                     withLimit:(int)limit
                     withOrder:(enum JDATAORDER)orderType
                   orderColumn:(NSString *)orderColumn
                   groupColumn:(NSString *)groupColumn;

-(NSMutableArray *)getEntries:(JDFieldArray *)opts
                      inTable:(NSString *)table
                   whereField:(NSString *)field
                    isEqualTo:(NSObject *)equalObj
                       ofType:(enum JDDATATYPE)equalType
                     isLikeTo:(NSObject *)likeObj
                       ofType:(enum JDDATATYPE)likeType;


//  A Constant for my use
extern NSString * const AppCoreDB;

@end

#endif

---