DatabaseUtil.h 989 B

123456789101112131415161718192021222324252627
  1. //
  2. // DatabaseUtil.h
  3. // YYDebugDatabase
  4. //
  5. // Created by wentian on 17/8/11.
  6. // Copyright © 2017年 wentian. All rights reserved.
  7. //
  8. #import <Foundation/Foundation.h>
  9. #import "NSMutableDictionary+safe.h"
  10. #import "NSMutableArray+safe.h"
  11. @interface DatabaseUtil : NSObject
  12. + (instancetype)shared;
  13. - (BOOL)openDatabase:(NSString*)dbPath;
  14. - (BOOL)closeDatabase;
  15. - (NSArray*)allTables;
  16. - (NSArray*)tableInfo:(NSString*)tableName;
  17. - (NSDictionary*)rowsInTable:(NSString*)tableName;
  18. - (BOOL)updateRecordInDatabase:(NSString*)database tableName:(NSString*)tableName data:(NSDictionary*)data condition:(NSDictionary*)condition;
  19. - (BOOL)deleteRecordInDatabase:(NSString *)database tableName:(NSString *)tableName condition:(NSDictionary *)condition limit:(NSString *)limit;
  20. - (NSDictionary*)executeQueryInDatabase:(NSString*)database tableName:(NSString*)tableName operator:(NSString*)operator query:(NSString*)query;
  21. - (NSDictionary*)userDefaultData;
  22. - (NSDictionary*)getAppInfoData;
  23. @end