added docs for the db using schemaspy

1 files changed, 70 insertions, 0 deletions

diff --git a/dbdocs/routines.js b/dbdocs/routines.js
new file mode 100644
index 0000000..cdc2350
--- /dev/null
+++ b/dbdocs/routines.js
@@ -0,0 +1,70 @@
+var filterBy = function(functionType) {
+    $.fn.dataTableExt.afnFiltering.length = 0;
+    $.fn.dataTable.ext.search.push(
+        function( settings, data, dataIndex ) {
+            var type = data[1]; // use data for the Type column
+
+            if ( type.toUpperCase() == functionType || functionType == 'All' )
+            {
+                return true;
+            }
+            return false;
+        }
+    );
+}
+
+$(document).ready(function() {
+	var activeObject;
+    var table = $('#routine_table').DataTable( {
+        lengthChange: false,
+		ordering: true,
+		paging: config.pagination,
+		pageLength: 50,
+		autoWidth: true,
+		processing: true,
+		order: [[ 0, "asc" ]],
+        buttons: [
+            {
+                text: 'All',
+                action: function ( e, dt, node, config ) {
+                    filterBy('All');
+                    if (activeObject != null) {
+                        activeObject.active(false);
+                    }
+                    table.draw();
+                }
+            },
+            {
+                text: 'Functions',
+                action: function ( e, dt, node, config ) {
+                    filterBy('FUNCTION');
+                    if (activeObject != null) {
+                        activeObject.active(false);
+                    }
+                    this.active( !this.active() );
+                    activeObject = this;
+                    table.draw();
+                }
+            },
+            {
+                text: 'Procedures',
+                action: function ( e, dt, node, config ) {
+                    filterBy('PROCEDURE');
+                    if (activeObject != null) {
+                        activeObject.active(false);
+                    }
+                    this.active( !this.active() );
+                    activeObject = this;
+                    table.draw();
+                }
+            },
+            {
+                extend: 'columnsToggle',
+                columns: '.toggle'
+            }
+        ]
+    } );
+
+    //schemaSpy.js
+    dataTableExportButtons(table);
+} );