DBManager.h 1.51キロバイト
//
//  DBManager.h
//  SQLite3DBSample
//
//  Created by ドラッサル 亜嵐 on 2016/02/03.
//  Copyright © 2016年 ドラッサル 亜嵐. All rights reserved.
//

#import <Foundation/Foundation.h>

@protocol DBManagerDelegate
@optional
- (void)gotData:(NSString *)data;
@required
@end

@interface DBManager : NSObject
@property (nonatomic,assign) id <DBManagerDelegate> delegate;
@property (nonatomic, strong) NSMutableArray *arrColumnNames;
@property (nonatomic) int affectedRows;
@property (nonatomic) long long lastInsertedRowID;

-(NSArray *)loadDataFromDB:(NSString *)query;
-(void)executeQuery:(NSString *)query;
- (NSArray*)getFirmwareDataList;
- (NSArray*)getEepromTemplateData;
- (bool)saveFirmwareData:(NSString *)uuid
              deviceType:(NSString *)deviceType
             deviceModel:(NSString *)deviceModel
                 version:(NSString *)version
            versionStamp:(NSString *)versionStamp
                    file:(NSString *)file;
- (bool)saveEepromTemplateData:(NSString *)recordId
                    recordName:(NSString *)recordName
                        dataId:(NSString *)dataId
                   deviceModel:(NSString *)dataModel
                      dataType:(NSString *)dataType
                        dataOs:(NSString *)dataOs
                        dataPin:(NSString *)dataPin;
- (bool)deleteFirmwareData:(NSString *)recordId;
- (bool)deleteEepromTemplateData:(NSString *)recordId;

+ (NSString*) createDatabaseIfRequiredAtPath:(NSString*)databasePath;

+ (instancetype)sharedInstance;

@end