Hi your library is using the TinySQLite library but I see it has not upgraded to Swift 3? Is the current version 2.0 support running without any problem?

I get TinySQLite.Error: SQL error or missing database (1) when trying to save a object.

 let database = SwiftyDB(databaseName: "Elements")

        let element = Element()
        element.id = 1
        element.name = "hu"

        database.asyncAddObjects([element]) { (result) -> Void in
            if let error = result.error {
                // Handle error
                print(error)
            }
        }

Add support for arrays?

class Person: NSObject, Storable {
    var person:[Children]
}

class Children: NSObject, Storable {

    var name:String!
    var age:NSNumber!
}

I'm getting this [testapp.Children encodeWithCoder:]: unrecognized selector sent to instance

I am getting a error when i am using bool or integer as data type of a attributes , its save to the data without showing any errors but then i am trying to retrieve the data its give me a error saying NSUnknownKeyException this class is not key value coding-compliant for the key

this is my class

class Message: NSObject,Storable{

    let database: SwiftyDB! = SwiftyDB(databaseName: AppConfig.DATABASE_NAME)

    var id : String?
    var body : String?
    var status : String?
    var timestamp : String?
    var isHide : Bool?
    var location : String?
    var msgType : String?
    var roomId : String?
    var userId : String?

    override required  init() {
        super.init()
    }


    func saveMesssage(shouldUpdate: Bool = false, completionHandler: (success: Bool) -> Void) {
        database.asyncAddObject(self, update: shouldUpdate) { (result) -> Void in
            if let error = result.error {
                print(error)
                completionHandler(success: false)
            }
            else {
                completionHandler(success: true)
            }
        }
    }


}

can anybody tell me what i am doing wrong here

public func addObjects <S: Storable> (objects: [S], update: Bool = true) -> Result<Bool> {
    guard objects.count > 0 else {
        return Result.Success(true)
    }

    do {
        if !(try tableExistsForType(S)) {
            //!!! BUG !!! , if objects is different model, they have different table, 
            createTableForTypeRepresentedByObject(objects.first!)
        }

        let insertStatement = StatementGenerator.insertStatementForType(S.self, update: update)


        try databaseQueue.transaction { (database) -> Void in
            let statement = try database.prepare(insertStatement)

            defer {
                /* If an error occurs, try to finalize the statement */
                let _ = try? statement.finalize()
            }

            for object in objects {
                let data = self.dataFromObject(object)
                try statement.executeUpdate(data)
            }
        }
    } catch let error {
        return Result.Error(error)
    }

    return Result.Success(true)
}

What's wrong with my code, did I do something wrong?

let database = SwiftyDB(databaseName: "gogogo") database.asyncDataForType(SiteRecord.self) { (result) -> Void in }

/Users/zhihuitang/repo/ios/Letsgo/Letsgo/JSBridgeHandler.swift:32:18: Cannot invoke 'asyncDataForType' with an argument list of type '(SiteRecord.Type, (_) -> Void)'

I am using SwiftyDB in conjunction with TinySQLite. On some cases, when I install a new version that adds new columns to my SQLite scheme, it isn't get updated for some reason.

On a new install, we clean up the database. We completely delete all the records, but not the tables.

The app crashes because a couple of columns are missing. I have no idea why.

Added the ability to include a sqlite database in your project, instead of always creating a new database. It checks for in the bundle for the sqlite database, if not found then i proceeds as usual and creates a new sqlite database. This gives the user the ability to include pre-defined data in the sqlite database with his app

class func primaryKeys() -> Set<String> {
    return ["id"]
}

static func save(array: [DisModel]) {
    let database = SwiftyDB(databaseName: "dogtopia")
//        database.deleteObjectsForType(DisModel.self)
    database.addObjects(array, update: true)
 }

As above, even if I put the update parameter is true, add object database is to be repeated.

so i've been trying to filter the query to get all dates within the month, but nothing comes up... if i drop one portion of the filter or the other, it gets me more than what i'm looking for:

` let calendar = NSCalendar(identifier: NSCalendarIdentifierGregorian) let components = NSDateComponents() components.year = dayOfMonth.year components.month = dayOfMonth.month components.day = 1 let dateFrom = calendar?.dateFromComponents(components) print("From: (dateFrom)")

    components.month = dayOfMonth.month + 1
    let dateTo = calendar?.dateFromComponents(components)
    print("To: \(dateTo)")      

    let filter = Filter
    .greaterOrEqual("buttonPressedTimestamp", value: dateFrom)
    .lessOrEqual("buttonPressedTimestamp", value: dateTo)
    let results = database.objectsForType(Event.self, matchingFilter: filter)

`

any suggestions?

Hi, I am trying to execute SwiftyDB in 8.3.3 but it's getting a syntax error and throwing 93 errors in TinySqlite framework. Please tell me what should I do to implement? thank You

Here is my pod file and got TinySQLite Swift Compile Error. I am now ising Xcode 8.3.3 , swift 3.0 . What should I do to fix?

Uncomment the next line to define a global platform for your project

platform :ios, '9.0'

target 'PMTools' do

project 'PMTools.xcodeproj' use_frameworks!

pod ‘SwiftyDB’ pod 'SwiftyJSON' pod 'Timepiece' pod 'SwiftSpinner' pod 'SwiftyUserDefaults' pod 'PayPal-iOS-SDK' pod 'Charts' pod 'Eureka' pod 'SnapKit' end