extension Database {
    func selectAll<M: SQLiteModel>(modelType: M.Type) throws -> [M] {
        return try selectFrom(
            modelType.modelName,
            block: M.init
        )
    }

    func select<M: SQLiteModel>(modelType: M.Type, withId id: M.ID.WrappedType) throws -> M? {
        return try selectFrom(M.modelName, whereExpr: "id=\(id)", block: M.init).first
    }

    func create<M: SQLiteModel>(model: M) throws -> M.ID.WrappedType {
        return try insertInto(M.modelName, values: model.asDictionary()) as! M.ID
    }

    func delete<M: SQLiteModel>(modelType: M.Type, withId id: M.ID.WrappedType) throws -> M? {
        let model = try select(modelType: modelType, withId: id)
        try deleteFrom(M.modelName, rowIds: [id])
        return model
    }
}