FFDBSafeOperation.h 2.2 KB

12345678910111213141516171819202122232425262728293031323334353637383940414243444546474849505152535455565758596061626364656667686970717273747576777879808182838485868788899091929394
  1. //
  2. // FFDBSafeOperation.h
  3. // FFDB
  4. //
  5. // Created by Fidetro on 2017/5/15.
  6. // Copyright © 2017年 Fidetro. All rights reserved.
  7. //
  8. // https://github.com/Fidetro/FFDB
  9. #import <Foundation/Foundation.h>
  10. @class FFDataBaseModel;
  11. @interface FFDBSafeOperation : NSObject
  12. /**
  13. select all object
  14. @param dbClass by class
  15. @return class objects
  16. */
  17. + (NSArray <__kindof FFDataBaseModel *>*)selectObjectWithFFDBClass:(Class)dbClass;
  18. /**
  19. select object by format
  20. @param dbClass by class
  21. @param format Like sqlstatement rule, example: where name = 'fidetro' and age = '21'
  22. @return class objects
  23. */
  24. + (NSArray <__kindof FFDataBaseModel *>*)selectObjectWithFFDBClass:(Class)dbClass
  25. format:(NSString *)format;
  26. /**
  27. insert object
  28. @param objectList Need to insert the array of objects
  29. */
  30. + (void)insertObjectList:(NSArray <__kindof FFDataBaseModel *>*)objectList;
  31. /**
  32. update object
  33. @param objectList Need to update the array of objects
  34. */
  35. + (void)updateObjectList:(NSArray<__kindof FFDataBaseModel *> *)objectList;
  36. /**
  37. update object by format
  38. @param dbClass Need to update the class
  39. @param format Like sqlstatement rule, example: set age = '24' where name = 'fidetro'
  40. @return update successfully
  41. */
  42. + (BOOL)updateObjectWithFFDBClass:(Class)dbClass
  43. format:(NSString *)format;
  44. /**
  45. delete object
  46. @param objectList Need to delete the array of objects
  47. */
  48. + (void)deleteObjectList:(NSArray<__kindof FFDataBaseModel *> *)objectList;
  49. /**
  50. delete object by format
  51. @param dbClass Need to update the class
  52. @param format format Like sqlstatement rule, example: where name = 'fidetro' and age = '21'
  53. @return delete successfully
  54. */
  55. + (BOOL)deleteObjectWithFFDBClass:(Class)dbClass
  56. format:(NSString *)format;
  57. /**
  58. custom query SQL
  59. @param toClass return toClass Object
  60. @param format SQL statement exmaple:select * from person
  61. @return return this class Objects
  62. */
  63. + (NSArray <__kindof FFDataBaseModel *>*)selectDBToClass:(Class)toClass
  64. SQLStatementWithFormat:(NSString *)format;
  65. /**
  66. custom update
  67. @param format SQL statement
  68. @return isSuccess
  69. */
  70. + (BOOL)updateDBWithSQLStatementWithFormat:(NSString *)format;
  71. @end