FFDBTransaction.h 2.5 KB

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