kvSqlKit.swift

A lightweight SQL query generator for Swift projects.

Examples

Hello world:

import kvSqlKit

// SELECT 'Hello world'
let query = KvSQL.select("Hello world").sql

Simple SELECT

import kvSqlKit

struct Items : KvSqlTable {
    static var id = "items"

    let sku = Column("sku", of: .serial, default: .implicit, constraints: [ .notNull, .primaryKey ])
    let count = Column("count", of: .integer, constraints: [ .notNull ])
}

// SELECT "items".* FROM "items" ORDER BY "items"."count" DESC
let query = KvSQL.select(items.*, from: items).orderBy(items.count.desc()).sql

More Examples

See Tests for more examples.

Supported Platforms

This package is crossplatform.

Getting Started

Swift Tools 5.2+

Package Dependencies:

dependencies: [
    .package(url: "https://github.com/keyvariable/kvSqlKit.swift.git", from: "0.2.0"),
]

Target Dependencies:

dependencies: [
    .product(name: "kvSqlKit", package: "kvSqlKit.swift"),
]

Xcode

Documentation: Adding Package Dependencies to Your App.

Authors

• Svyatoslav Popov (@sdpopov-keyvariable, [email protected]).