问将在线SQLite数据库从谷歌驱动器加载到Swift中的iOS应用程序

EN

import UIKit
import SQLite

class ViewController: UIViewController, UIPickerViewDelegate, UIPickerViewDataSource, UITextFieldDelegate {

    var database: Connection!
    let boxesTable = Table("boxes1")
    let ID = Expression<Int>("ID")
    let SNO = Expression<String>("Serial_Number")
    let condition = Expression<String>("Condition")

    override func viewDidLoad() {
        super.viewDidLoad()
        do{
           let doucumentDirectory = try FileManager.default.url(for: .documentDirectory, in: .userDomainMask, appropriateFor: nil, create: true)
            let fileUrl = doucumentDirectory.appendingPathComponent("boxes1").appendingPathExtension("sqlite3")
            let database = try Connection(fileUrl.path)
            self.database = database
        }catch{
            print(error)
        }

        let createTable = self.boxesTable.create { (table) in
            table.column(self.ID, primaryKey: true)
            table.column(self.SNO, unique: true)
            table.column(self.condition)
        }

        do{
            try self.database.run(createTable)
            print("Created Table")
        }catch{
            print(error)
        }
}