NCDatabase.swift 18 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538539540541542543544545546547548549550551552553554555556557558559560561562563564565566567568569570571572
  1. //
  2. // NCDatabase.swift
  3. // Nextcloud
  4. //
  5. // Created by Marino Faggiana on 06/05/17.
  6. // Copyright © 2017 Marino Faggiana. All rights reserved.
  7. //
  8. // Author Marino Faggiana <marino.faggiana@nextcloud.com>
  9. // Author Henrik Storch <henrik.storch@nextcloud.com>
  10. //
  11. // This program is free software: you can redistribute it and/or modify
  12. // it under the terms of the GNU General Public License as published by
  13. // the Free Software Foundation, either version 3 of the License, or
  14. // (at your option) any later version.
  15. //
  16. // This program is distributed in the hope that it will be useful,
  17. // but WITHOUT ANY WARRANTY; without even the implied warranty of
  18. // MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
  19. // GNU General Public License for more details.
  20. //
  21. // You should have received a copy of the GNU General Public License
  22. // along with this program. If not, see <http://www.gnu.org/licenses/>.
  23. //
  24. import UIKit
  25. import RealmSwift
  26. import NCCommunication
  27. protocol DateCompareable {
  28. var dateKey: Date { get }
  29. }
  30. class tableAccount: Object, NCUserBaseUrl {
  31. @objc dynamic var account = ""
  32. @objc dynamic var active: Bool = false
  33. @objc dynamic var address = ""
  34. @objc dynamic var alias = ""
  35. @objc dynamic var autoUpload: Bool = false
  36. @objc dynamic var autoUploadCreateSubfolder: Bool = false
  37. @objc dynamic var autoUploadDirectory = ""
  38. @objc dynamic var autoUploadFileName = ""
  39. @objc dynamic var autoUploadFull: Bool = false
  40. @objc dynamic var autoUploadImage: Bool = false
  41. @objc dynamic var autoUploadVideo: Bool = false
  42. @objc dynamic var autoUploadWWAnPhoto: Bool = false
  43. @objc dynamic var autoUploadWWAnVideo: Bool = false
  44. @objc dynamic var backend = ""
  45. @objc dynamic var backendCapabilitiesSetDisplayName: Bool = false
  46. @objc dynamic var backendCapabilitiesSetPassword: Bool = false
  47. @objc dynamic var businessSize: String = ""
  48. @objc dynamic var businessType = ""
  49. @objc dynamic var city = ""
  50. @objc dynamic var country = ""
  51. @objc dynamic var displayName = ""
  52. @objc dynamic var email = ""
  53. @objc dynamic var enabled: Bool = false
  54. @objc dynamic var groups = ""
  55. @objc dynamic var language = ""
  56. @objc dynamic var lastLogin: Int64 = 0
  57. @objc dynamic var locale = ""
  58. @objc dynamic var mediaPath = ""
  59. @objc dynamic var organisation = ""
  60. @objc dynamic var password = ""
  61. @objc dynamic var phone = ""
  62. @objc dynamic var quota: Int64 = 0
  63. @objc dynamic var quotaFree: Int64 = 0
  64. @objc dynamic var quotaRelative: Double = 0
  65. @objc dynamic var quotaTotal: Int64 = 0
  66. @objc dynamic var quotaUsed: Int64 = 0
  67. @objc dynamic var role = ""
  68. @objc dynamic var storageLocation = ""
  69. @objc dynamic var subadmin = ""
  70. @objc dynamic var twitter = ""
  71. @objc dynamic var urlBase = ""
  72. @objc dynamic var user = ""
  73. @objc dynamic var userId = ""
  74. @objc dynamic var userStatusClearAt: NSDate?
  75. @objc dynamic var userStatusIcon: String?
  76. @objc dynamic var userStatusMessage: String?
  77. @objc dynamic var userStatusMessageId: String?
  78. @objc dynamic var userStatusMessageIsPredefined: Bool = false
  79. @objc dynamic var userStatusStatus: String?
  80. @objc dynamic var userStatusStatusIsUserDefined: Bool = false
  81. @objc dynamic var website = ""
  82. @objc dynamic var zip = ""
  83. // HC
  84. @objc dynamic var hcIsTrial: Bool = false
  85. @objc dynamic var hcTrialExpired: Bool = false
  86. @objc dynamic var hcTrialRemainingSec: Int64 = 0
  87. @objc dynamic var hcTrialEndTime: NSDate?
  88. @objc dynamic var hcAccountRemoveExpired: Bool = false
  89. @objc dynamic var hcAccountRemoveRemainingSec: Int64 = 0
  90. @objc dynamic var hcAccountRemoveTime: NSDate?
  91. @objc dynamic var hcNextGroupExpirationGroup = ""
  92. @objc dynamic var hcNextGroupExpirationGroupExpired: Bool = false
  93. @objc dynamic var hcNextGroupExpirationExpiresTime: NSDate?
  94. @objc dynamic var hcNextGroupExpirationExpires = ""
  95. override static func primaryKey() -> String {
  96. return "account"
  97. }
  98. }
  99. class tableActivity: Object, DateCompareable {
  100. var dateKey: Date { date as Date }
  101. @objc dynamic var account = ""
  102. @objc dynamic var idPrimaryKey = ""
  103. @objc dynamic var action = "Activity"
  104. @objc dynamic var date = NSDate()
  105. @objc dynamic var idActivity: Int = 0
  106. @objc dynamic var app = ""
  107. @objc dynamic var type = ""
  108. @objc dynamic var user = ""
  109. @objc dynamic var subject = ""
  110. @objc dynamic var subjectRich = ""
  111. let subjectRichItem = List<tableActivitySubjectRich>()
  112. @objc dynamic var icon = ""
  113. @objc dynamic var link = ""
  114. @objc dynamic var message = ""
  115. @objc dynamic var objectType = ""
  116. @objc dynamic var objectId: Int = 0
  117. @objc dynamic var objectName = ""
  118. @objc dynamic var note = ""
  119. @objc dynamic var selector = ""
  120. @objc dynamic var verbose: Bool = false
  121. override static func primaryKey() -> String {
  122. return "idPrimaryKey"
  123. }
  124. }
  125. class tableActivityLatestId: Object {
  126. @objc dynamic var account = ""
  127. @objc dynamic var mostRecentlyLoadedActivityId: Int = 0
  128. override static func primaryKey() -> String {
  129. return "account"
  130. }
  131. }
  132. class tableActivityPreview: Object {
  133. @objc dynamic var account = ""
  134. @objc dynamic var filename = ""
  135. @objc dynamic var idPrimaryKey = ""
  136. @objc dynamic var idActivity: Int = 0
  137. @objc dynamic var source = ""
  138. @objc dynamic var link = ""
  139. @objc dynamic var mimeType = ""
  140. @objc dynamic var fileId: Int = 0
  141. @objc dynamic var view = ""
  142. @objc dynamic var isMimeTypeIcon: Bool = false
  143. override static func primaryKey() -> String {
  144. return "idPrimaryKey"
  145. }
  146. }
  147. class tableActivitySubjectRich: Object {
  148. @objc dynamic var account = ""
  149. @objc dynamic var idActivity: Int = 0
  150. @objc dynamic var idPrimaryKey = ""
  151. @objc dynamic var id = ""
  152. @objc dynamic var key = ""
  153. @objc dynamic var link = ""
  154. @objc dynamic var name = ""
  155. @objc dynamic var path = ""
  156. @objc dynamic var type = ""
  157. override static func primaryKey() -> String {
  158. return "idPrimaryKey"
  159. }
  160. }
  161. class tableAvatar: Object {
  162. @objc dynamic var date = NSDate()
  163. @objc dynamic var etag = ""
  164. @objc dynamic var fileName = ""
  165. @objc dynamic var loaded: Bool = false
  166. override static func primaryKey() -> String {
  167. return "fileName"
  168. }
  169. }
  170. class tableCapabilities: Object {
  171. @objc dynamic var account = ""
  172. @objc dynamic var jsondata: Data?
  173. override static func primaryKey() -> String {
  174. return "account"
  175. }
  176. }
  177. class tableChunk: Object {
  178. @objc dynamic var account = ""
  179. @objc dynamic var chunkFolder = ""
  180. @objc dynamic var fileName = ""
  181. @objc dynamic var index = ""
  182. @objc dynamic var ocId = ""
  183. @objc dynamic var size: Int64 = 0
  184. override static func primaryKey() -> String {
  185. return "index"
  186. }
  187. }
  188. class tableComments: Object, DateCompareable {
  189. var dateKey: Date { creationDateTime as Date }
  190. @objc dynamic var account = ""
  191. @objc dynamic var actorDisplayName = ""
  192. @objc dynamic var actorId = ""
  193. @objc dynamic var actorType = ""
  194. @objc dynamic var creationDateTime = NSDate()
  195. @objc dynamic var isUnread: Bool = false
  196. @objc dynamic var message = ""
  197. @objc dynamic var messageId = ""
  198. @objc dynamic var objectId = ""
  199. @objc dynamic var objectType = ""
  200. @objc dynamic var path = ""
  201. @objc dynamic var verb = ""
  202. override static func primaryKey() -> String {
  203. return "messageId"
  204. }
  205. }
  206. class tableDirectEditingCreators: Object {
  207. @objc dynamic var account = ""
  208. @objc dynamic var editor = ""
  209. @objc dynamic var ext = ""
  210. @objc dynamic var identifier = ""
  211. @objc dynamic var mimetype = ""
  212. @objc dynamic var name = ""
  213. @objc dynamic var templates: Int = 0
  214. }
  215. class tableDirectEditingEditors: Object {
  216. @objc dynamic var account = ""
  217. @objc dynamic var editor = ""
  218. let mimetypes = List<String>()
  219. @objc dynamic var name = ""
  220. let optionalMimetypes = List<String>()
  221. @objc dynamic var secure: Int = 0
  222. }
  223. class tableDirectory: Object {
  224. @objc dynamic var account = ""
  225. @objc dynamic var colorFolder: String?
  226. @objc dynamic var e2eEncrypted: Bool = false
  227. @objc dynamic var etag = ""
  228. @objc dynamic var favorite: Bool = false
  229. @objc dynamic var fileId = ""
  230. @objc dynamic var ocId = ""
  231. @objc dynamic var offline: Bool = false
  232. @objc dynamic var permissions = ""
  233. @objc dynamic var richWorkspace: String?
  234. @objc dynamic var serverUrl = ""
  235. override static func primaryKey() -> String {
  236. return "ocId"
  237. }
  238. }
  239. class tableE2eEncryption: Object {
  240. @objc dynamic var account = ""
  241. @objc dynamic var authenticationTag: String?
  242. @objc dynamic var fileName = ""
  243. @objc dynamic var fileNameIdentifier = ""
  244. @objc dynamic var fileNamePath = ""
  245. @objc dynamic var key = ""
  246. @objc dynamic var initializationVector = ""
  247. @objc dynamic var metadataKey = ""
  248. @objc dynamic var metadataKeyIndex: Int = 0
  249. @objc dynamic var mimeType = ""
  250. @objc dynamic var serverUrl = ""
  251. @objc dynamic var version: Int = 1
  252. override static func primaryKey() -> String {
  253. return "fileNamePath"
  254. }
  255. }
  256. class tableE2eEncryptionLock: Object {
  257. @objc dynamic var account = ""
  258. @objc dynamic var date = NSDate()
  259. @objc dynamic var fileId = ""
  260. @objc dynamic var serverUrl = ""
  261. @objc dynamic var e2eToken = ""
  262. override static func primaryKey() -> String {
  263. return "fileId"
  264. }
  265. }
  266. class tableExternalSites: Object {
  267. @objc dynamic var account = ""
  268. @objc dynamic var icon = ""
  269. @objc dynamic var idExternalSite: Int = 0
  270. @objc dynamic var lang = ""
  271. @objc dynamic var name = ""
  272. @objc dynamic var type = ""
  273. @objc dynamic var url = ""
  274. }
  275. class tableGPS: Object {
  276. @objc dynamic var latitude = ""
  277. @objc dynamic var location = ""
  278. @objc dynamic var longitude = ""
  279. @objc dynamic var placemarkAdministrativeArea = ""
  280. @objc dynamic var placemarkCountry = ""
  281. @objc dynamic var placemarkLocality = ""
  282. @objc dynamic var placemarkPostalCode = ""
  283. @objc dynamic var placemarkThoroughfare = ""
  284. }
  285. class tableLocalFile: Object {
  286. @objc dynamic var account = ""
  287. @objc dynamic var etag = ""
  288. @objc dynamic var exifDate: NSDate?
  289. @objc dynamic var exifLatitude = ""
  290. @objc dynamic var exifLongitude = ""
  291. @objc dynamic var exifLensModel: String?
  292. @objc dynamic var favorite: Bool = false
  293. @objc dynamic var fileName = ""
  294. @objc dynamic var ocId = ""
  295. @objc dynamic var offline: Bool = false
  296. override static func primaryKey() -> String {
  297. return "ocId"
  298. }
  299. }
  300. class tableMetadata: Object, NCUserBaseUrl {
  301. override func isEqual(_ object: Any?) -> Bool {
  302. if let object = object as? tableMetadata {
  303. return self.fileId == object.fileId && self.account == object.account
  304. && self.path == object.path && self.fileName == object.fileName
  305. } else {
  306. return false
  307. }
  308. }
  309. @objc dynamic var account = ""
  310. @objc dynamic var assetLocalIdentifier = ""
  311. @objc dynamic var checksums = ""
  312. @objc dynamic var chunk: Bool = false
  313. @objc dynamic var classFile = ""
  314. @objc dynamic var commentsUnread: Bool = false
  315. @objc dynamic var contentType = ""
  316. @objc dynamic var creationDate = NSDate()
  317. @objc dynamic var dataFingerprint = ""
  318. @objc dynamic var date = NSDate()
  319. @objc dynamic var directory: Bool = false
  320. @objc dynamic var deleteAssetLocalIdentifier: Bool = false
  321. @objc dynamic var downloadURL = ""
  322. @objc dynamic var e2eEncrypted: Bool = false
  323. @objc dynamic var edited: Bool = false
  324. @objc dynamic var etag = ""
  325. @objc dynamic var etagResource = ""
  326. @objc dynamic var ext = ""
  327. @objc dynamic var favorite: Bool = false
  328. @objc dynamic var fileId = ""
  329. @objc dynamic var fileName = ""
  330. @objc dynamic var fileNameView = ""
  331. @objc dynamic var fileNameWithoutExt = ""
  332. @objc dynamic var hasPreview: Bool = false
  333. @objc dynamic var iconName = ""
  334. @objc dynamic var iconUrl = ""
  335. @objc dynamic var isExtractFile: Bool = false
  336. @objc dynamic var livePhoto: Bool = false
  337. @objc dynamic var mountType = ""
  338. @objc dynamic var name = ""
  339. @objc dynamic var note = ""
  340. @objc dynamic var ocId = ""
  341. @objc dynamic var ownerId = ""
  342. @objc dynamic var ownerDisplayName = ""
  343. @objc public var lock = false
  344. @objc public var lockOwner = ""
  345. @objc public var lockOwnerEditor = ""
  346. @objc public var lockOwnerType = 0
  347. @objc public var lockOwnerDisplayName = ""
  348. @objc public var lockTime: Date?
  349. @objc public var lockTimeOut: Date?
  350. @objc dynamic var path = ""
  351. @objc dynamic var permissions = ""
  352. @objc dynamic var quotaUsedBytes: Int64 = 0
  353. @objc dynamic var quotaAvailableBytes: Int64 = 0
  354. @objc dynamic var resourceType = ""
  355. @objc dynamic var richWorkspace: String?
  356. @objc dynamic var serverUrl = ""
  357. @objc dynamic var session = ""
  358. @objc dynamic var sessionError = ""
  359. @objc dynamic var sessionSelector = ""
  360. @objc dynamic var sessionTaskIdentifier: Int = 0
  361. @objc dynamic var sharePermissionsCollaborationServices: Int = 0
  362. let sharePermissionsCloudMesh = List<String>()
  363. let shareType = List<Int>()
  364. @objc dynamic var size: Int64 = 0
  365. @objc dynamic var status: Int = 0
  366. @objc dynamic var subline: String?
  367. @objc dynamic var trashbinFileName = ""
  368. @objc dynamic var trashbinOriginalLocation = ""
  369. @objc dynamic var trashbinDeletionTime = NSDate()
  370. @objc dynamic var uploadDate = NSDate()
  371. @objc dynamic var url = ""
  372. @objc dynamic var urlBase = ""
  373. @objc dynamic var user = ""
  374. @objc dynamic var userId = ""
  375. override static func primaryKey() -> String {
  376. return "ocId"
  377. }
  378. }
  379. extension tableMetadata {
  380. var fileExtension: String { (fileNameView as NSString).pathExtension }
  381. var isPrintable: Bool {
  382. classFile == NCCommunicationCommon.typeClassFile.image.rawValue || ["application/pdf", "com.adobe.pdf"].contains(contentType) || contentType.hasPrefix("text/")
  383. }
  384. /// Returns false if the user is lokced out of the file. I.e. The file is locked but by somone else
  385. func canUnlock(as user: String) -> Bool {
  386. return !lock || (lockOwner == user && lockOwnerType == 0)
  387. }
  388. }
  389. class tablePhotoLibrary: Object {
  390. @objc dynamic var account = ""
  391. @objc dynamic var assetLocalIdentifier = ""
  392. @objc dynamic var creationDate: NSDate?
  393. @objc dynamic var idAsset = ""
  394. @objc dynamic var modificationDate: NSDate?
  395. @objc dynamic var mediaType: Int = 0
  396. override static func primaryKey() -> String {
  397. return "idAsset"
  398. }
  399. }
  400. class tableShare: Object {
  401. @objc dynamic var account = ""
  402. @objc dynamic var canEdit: Bool = false
  403. @objc dynamic var canDelete: Bool = false
  404. @objc dynamic var date: NSDate?
  405. @objc dynamic var displaynameFileOwner = ""
  406. @objc dynamic var displaynameOwner = ""
  407. @objc dynamic var expirationDate: NSDate?
  408. @objc dynamic var fileName = ""
  409. @objc dynamic var fileParent: Int = 0
  410. @objc dynamic var fileSource: Int = 0
  411. @objc dynamic var fileTarget = ""
  412. @objc dynamic var hideDownload: Bool = false
  413. @objc dynamic var idShare: Int = 0
  414. @objc dynamic var itemSource: Int = 0
  415. @objc dynamic var itemType = ""
  416. @objc dynamic var label = ""
  417. @objc dynamic var mailSend: Bool = false
  418. @objc dynamic var mimeType = ""
  419. @objc dynamic var note = ""
  420. @objc dynamic var parent: String = ""
  421. @objc dynamic var password: String = ""
  422. @objc dynamic var path = ""
  423. @objc dynamic var permissions: Int = 0
  424. @objc dynamic var sendPasswordByTalk: Bool = false
  425. @objc dynamic var serverUrl = ""
  426. @objc dynamic var shareType: Int = 0
  427. @objc dynamic var shareWith = ""
  428. @objc dynamic var shareWithDisplayname = ""
  429. @objc dynamic var storage: Int = 0
  430. @objc dynamic var storageId = ""
  431. @objc dynamic var token = ""
  432. @objc dynamic var uidFileOwner = ""
  433. @objc dynamic var uidOwner = ""
  434. @objc dynamic var url = ""
  435. @objc dynamic var userClearAt: NSDate?
  436. @objc dynamic var userIcon = ""
  437. @objc dynamic var userMessage = ""
  438. @objc dynamic var userStatus = ""
  439. override static func primaryKey() -> String {
  440. return "idShare"
  441. }
  442. }
  443. class tableTag: Object {
  444. @objc dynamic var account = ""
  445. @objc dynamic var ocId = ""
  446. @objc dynamic var tagIOS: Data?
  447. override static func primaryKey() -> String {
  448. return "ocId"
  449. }
  450. }
  451. class tableTip: Object {
  452. @Persisted(primaryKey: true) var tipName = ""
  453. }
  454. class tableTrash: Object {
  455. @objc dynamic var account = ""
  456. @objc dynamic var classFile = ""
  457. @objc dynamic var contentType = ""
  458. @objc dynamic var date = NSDate()
  459. @objc dynamic var directory: Bool = false
  460. @objc dynamic var fileId = ""
  461. @objc dynamic var fileName = ""
  462. @objc dynamic var filePath = ""
  463. @objc dynamic var hasPreview: Bool = false
  464. @objc dynamic var iconName = ""
  465. @objc dynamic var size: Int64 = 0
  466. @objc dynamic var trashbinFileName = ""
  467. @objc dynamic var trashbinOriginalLocation = ""
  468. @objc dynamic var trashbinDeletionTime = NSDate()
  469. override static func primaryKey() -> String {
  470. return "fileId"
  471. }
  472. }
  473. class tableUserStatus: Object {
  474. @objc dynamic var account = ""
  475. @objc dynamic var clearAt: NSDate?
  476. @objc dynamic var clearAtTime: String?
  477. @objc dynamic var clearAtType: String?
  478. @objc dynamic var icon: String?
  479. @objc dynamic var id: String?
  480. @objc dynamic var message: String?
  481. @objc dynamic var predefined: Bool = false
  482. @objc dynamic var status: String?
  483. @objc dynamic var userId: String?
  484. }
  485. class tableVideo: Object {
  486. @objc dynamic var account = ""
  487. @objc dynamic var duration: Int64 = 0
  488. @objc dynamic var ocId = ""
  489. @objc dynamic var time: Int64 = 0
  490. @objc dynamic var codecNameVideo: String?
  491. @objc dynamic var codecNameAudio: String?
  492. @objc dynamic var codecAudioChannelLayout: String?
  493. @objc dynamic var codecAudioLanguage: String?
  494. @objc dynamic var codecMaxCompatibility: Bool = false
  495. @objc dynamic var codecQuality: String?
  496. override static func primaryKey() -> String {
  497. return "ocId"
  498. }
  499. }