Swiftpack.co - saicu/VaporDataTables as Swift Package

Swiftpack.co is a collection of thousands of indexed Swift packages. Search packages.
See all packages published by saicu.
saicu/VaporDataTables 1.0.4
Generate AJAX endpoints for populating DataTables from your Fluent models
โญ๏ธ 5
๐Ÿ•“ 4 weeks ago
.package(url: "https://github.com/saicu/VaporDataTables.git", from: "1.0.4")


Vapor 3.x Swift 5.x


Generate AJAX endpoints for populating DataTables from your Fluent models with one line of code.

Feature Status Notes
Easy Setup through Fluent Model โœ… Postgres, MySQL, SQLite
Sorting โœ…
Pagination โœ…
Search โœ… Use % as wildcard
Filtering โœ… Use % as wildcard, x-y for range (see screenshot below)
Joins โŒ Joining other Models



dependencies: [
    .package(url: "https://github.com/saicu/VaporDataTables.git", from: "1.0.0")


targets: [
    target(name: "App", dependencies: ["DataTables"])

Configure your package.swift to use VaporDataTables.


routes.swift (or similar, eg RouteCollection)

import Vapor
import DataTables

public func routes(_ router: Router) throws {
    router.dataTables(Todo.self, expose: [\Todo.id, \Todo.title], at: "todos", "dataTables")

This creates a route for the model Todo at /todos/dataTables.

Expose propertys of your model by passing their KeyPaths in the same order as the HTML table columns.

You can also pass a DateFormatter for custom display/filtering of your dates.

let dateFormatter = DateFormatter()
dateFormatter.dateFormat = "yyyy-MM-dd"
router.dataTables(Todo.self, expose: [\Todo.id, \Todo.title], dateFormatter: dateFormatter, at: "todos", "dataTables")


<!DOCTYPE html>
        <title>DataTables Example</title>
        <link rel="stylesheet" type="text/css" href="https://cdn.datatables.net/1.10.19/css/jquery.dataTables.min.css">
        <table id="myTable">

        <script type="text/javascript" src="https://code.jquery.com/jquery-3.4.1.min.js"></script>
        <script type="text/javascript" src="https://cdn.datatables.net/1.10.19/js/jquery.dataTables.min.js"></script>
            let config = {
                "processing": true,
                "serverSide": true,
                "ajax": {
                    "url": "/todos/dataTables", // change this to your new url
                    "type": "POST",
                    "contentType": "application/json",
                    "data": function(d) {
                        return JSON.stringify(d);

            var table = $('#myTable').DataTable(config);

            // optional: add filter input to each column, connect their event
            $('#myTable tfoot th').each(function () {
                var title = $(this).text();
                $(this).html( '<input type="text" style="width: 100%" placeholder="Filter '+title+'" />' );

            table.columns().every( function () {
                var self = this;

                $( 'input', this.footer() ).on( 'keyup change clear', function () {
                    if ( self.search() !== this.value ) {
                            .search( this.value )

You'll need to configure DataTables to make a POST request in JSON format, see the example config in the script part above (don't forget to change the url).


Voilรก, your server-side proccessed table with sorting, filtering, pagination and full-text search is all set up.

alt text


Stars: 5
Last commit: 4 weeks ago
Advertisement: IndiePitcher.com - Cold Email Software for Startups

Swiftpack is being maintained by Petr Pavlik | @ptrpavlik | @swiftpackco | API | Analytics