Latest 0.0.7
Homepage https://github.com/TonyReet/AutoSQLite.swift
License MIT
Platforms ios 8.0
Dependencies SQLite.swift
Authors

AutoSQLite.swift

SQLite.swift的封装,使用swift的反射原理,Model直接存储.获取. 无需再转换,增删改查. 脱离sql语句,不需要添加相关的绑定操作,直接完成转换。

AutoSQLiteSwift AutoSQLiteSwift

png

使用方法

    1. 导入

A. Pod导入

  pod 'AutoSQLiteSwift'

B. 引入source目录下的文件文件:

SQLiteModel.swift
SQLiteDataBase.swift
SQLiteDataBaseTool.swift
SQLMirrorModel.swift
SQLPropertyModel.swift

创建model继承SQLiteModel即可
    1. 使用以下方法
        // 创建dataBase,
        var manager = SQLiteDataBase.createDB("testDataBaseName")
        // 插入
        manager.insert(object: testModel, intoTable: "testTableName")

        或者

        SQLiteDataBase.insert(object: testModel, intoTable: "testTableName")
        // 删除
        manager.delete(testModel, fromTable: "testTableName")

        或者

        SQLiteDataBase.deleteModel(testModel, fromTable: "testTableName")
        // 更新
        testModel.name = "Reet"

        manager.update(testModel, fromTable: "testTableName")

        或者

        SQLiteDataBase.update(testModel, fromTable: "testTableName")
        // 查询
        guard let results = manager.select(testModel, fromTable: "testTableName") else {
            print("没有查询到数据")
            return
        }

        for result in results {
            print("查询的数据(result)")
        }

        或者

        let results = SQLiteDataBase.select(testModel, fromTable: "testTableName")

        if results.count > 0{
            for result in results {
                print("查询的数据(result)")
            }
        }else {
            print("没有查询到数据")
        }

upgrade

19.4.23

新增字段时,直接在表里面添加,避免报错

有任何疑问或建议. 欢迎在github或微博里issue我.
微博:@TonyReet

Latest podspec

{
    "name": "AutoSQLiteSwift",
    "version": "0.0.7",
    "license": {
        "type": "MIT",
        "file": "LICENSE"
    },
    "summary": "u81eau52a8u89e3u6790",
    "homepage": "https://github.com/TonyReet/AutoSQLite.swift",
    "authors": {
        "TonyReet": "[email protected]"
    },
    "source": {
        "git": "https://github.com/TonyReet/AutoSQLite.swift.git",
        "tag": "0.0.7"
    },
    "platforms": {
        "ios": "8.0"
    },
    "swift_version": "4.0",
    "source_files": "Source/*.swift",
    "dependencies": {
        "SQLite.swift": [
            "~> 0.11.5"
        ]
    }
}

Pin It on Pinterest

Share This