用Vapor在SQLite数据库中手动创建数据

import Vapor
import FluentSQLite

final class User: SQLiteModel {
    var id: Int?
    var name: String

    init(id: Int? = nil, name: String) {
        self.id = id
        self.name = name
    }
}

extension User: Migration { }

import Vapor
import FluentSQLite

struct CreateUser: Migration {
    typealias Database = SQLiteDatabase

    static func prepare(on connection: SQLiteConnection) -> Future<Void> {
        return Database.create(User.self, on: connection) { builder in
            builder.field(for: \.id, isIdentifier: true)
            builder.field(for: \.name)
        }
    }

    static func revert(on connection: SQLiteConnection) -> Future<Void> {
        return Database.delete(User.self, on: connection)
    }
}

import Vapor
import FluentSQLite

public func configure(_ config: inout Config, _ env: inout Environment, _ services: inout Services) throws {
    // ...

    // Register providers
    try services.register(FluentSQLiteProvider())

    // Configure database
    var databases = DatabasesConfig()
    let sqlite = try SQLiteDatabase(storage: .memory)
    databases.add(database: sqlite, as: .sqlite)
    services.register(databases)

    // Configure migrations
    var migrations = MigrationConfig()
    migrations.add(model: User.self, database: .sqlite)
    migrations.add(migration: CreateUser.self, database: .sqlite)
    services.register(migrations)

    // ...
}