Google Firestore & Datatables integration

demarily

This may not be the best approach but I don't have many examples. I'm trying to load an empty table then in the initComplete option add the data, remove the data and/or modify the data. Below is an example of just adding a row using a querySnapshot.

var routeStepsRef = db.collection("routes").doc(objModel.routeId()).collection("routeSteps").onSnapshot(function (querySnapshot) {
    querySnapshot.docChanges().forEach(function (change) {
        switch (change.type) {
            case "added":
                $table.row.add(change.doc.data()).draw(false);
                console.log("New address: ", change.doc.data());
                break;
            case "modified":
                console.log("Modified address: ", change.doc.data());
                break;
            case "removed":
                console.log("Removed address: ", change.doc.data());
                break;
        }
    });
});

Again this would happen inside the initComplete or at least after the table loads with no data... It would be awesome if someone knows of a plugin or something to use these two library's together.

allan

I'm not aware of a library that will do this for you I'm afraid. That you have looks okay - although depending on what change.doc.data() gives you, you might need to use rows.add().

What does change.doc.data() give?

Allan

demarily

The "added" case adds each object as they come in. The "modified" and "removed" cases only affect one object at a time. I think i just need to start the columns over and build back up again.

demarily

Do I have to have a data or ajax option? I would like the data loading to happen after the table initializes.

allan

No - you don't need either the ajax or data option. If neither are given, DataTables will attempt to load the data from the HTML - which could be empty and then you can use the API to add rows.

You do need to know the column information when you initialise the DataTable - you can't dynamically add and remove columns at this time.

Allan