//
//  PhotoLocalStorage.swift
//  PaiAi
//
//  Created by LISA on 2017/4/19.
//  Copyright © 2017年 yb. All rights reserved.
//

import UIKit
//import ObjectMapper
//import SQLite
//
//public struct PhotoLocalStorage {
//
//    let photoId = Expression<String>("photoId")
//    let photoInfo = Expression<Data>("photoInfo")
//    let creatAt = Expression<TimeInterval>("creatAt")
//
//    static let instance = PhotoLocalStorage()
//    var db: Connection?
//
//    init() {
//        db = try? Connection(path)
//    }
//
//    private let path: String = {
//        let path = NSSearchPathForDirectoriesInDomains(.documentDirectory, .userDomainMask, true).first ?? ""
//        let finalPath = path.appending("/group_photo.db")
////        printLog(finalPath)
//        return finalPath
//    }()
//
//    func query(group_id: String) -> [PhotoItem]? {
////        let table = Table(group_id.digestString(algorithm: .md5))
////        do {
////            guard let photos = try db?.prepare(table) else {
////                return nil
////            }
////            return photos.compactMap({ (photo) -> PhotoItem? in
////               let data = photo[photoInfo]
////                guard let dict = NSKeyedUnarchiver.unarchiveObject(with: data) as? [String: AnyObject] else {
////                    return nil
////                }
////                return PhotoItem(data: dict)
////            })
////        } catch {
////            return nil
////        }
//        return nil
//    }
//
//    func saveDataToLocal(models: [PhotoItem], group_id: String) {
////        let table = Table(group_id.digestString(algorithm: .md5))
////        do {
////            try db?.transaction {
////                try db?.run(table.create(ifNotExists: true, block: { (table) in
////                    table.column(photoId, unique: true)
////                    table.column(photoInfo)
////                    table.column(creatAt)
////                }))
////
////                for model in models {
////                    let data = NSKeyedArchiver.archivedData(withRootObject: model.toJSON())
////                    let insert = table.insert(or: .replace,
////                                              photoInfo <- data,
////                                              creatAt <- (model.create_at.timeIntervalSince1970) ,
////                                              photoId <- model.photo_id)
////                   _ = try db?.run(insert)
////                }
////
////            }
////        } catch {
////        }
//    }
//
//    func updateLocalData(PhotoItem: PhotoItem) {
////        let table = Table(PhotoItem.group_id.digestString(algorithm: .md5)).filter(photoId == PhotoItem.photo_id)
////        let photoData = NSKeyedArchiver.archivedData(withRootObject: PhotoItem.toJSON())
////        do {
////            try db?.run(table.update(photoInfo <- photoData))
////        } catch {
////
////        }
//    }
//
//    func removeLocalData(group_id: String) {
////        removeGroupInfoRecent(groupId: group_id)
////        let table = Table(group_id.digestString(algorithm: .md5))
////        _ = table.drop(ifExists: true)
//    }
//}