1 files changed, 117 insertions, 0 deletions
diff --git a/dbdocs/column.js b/dbdocs/column.js
new file mode 100644
index 0000000..3807132
--- /dev/null
+++ b/dbdocs/column.js
@@ -0,0 +1,117 @@
+var filterBy = function(tableType) {
+$.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 == tableType || tableType=='All' )
+        {
+            return true;
+        }
+        return false;
+    }
+);
+}
+
+$(document).ready(function() {
+	var activeObject;
+    var table = $('#column_table').DataTable( {
+        deferRender: true,
+		data: tableData,
+        columns: [
+            { data: "tableName" },
+            { data: "tableType" },
+            { data: "name" },
+            { data: "type" },
+            { data: "length" },
+            { data: "nullable" },
+            { data: "autoUpdated" },
+            { data: "defaultValue" },
+            { data: "comments" }
+        ],
+        columnDefs: [
+            {
+                targets: 0,
+                render: function ( data, type, row, meta ) {
+                    return '<a href="tables/'+data+'.html" target="_top">'+data+'</a>';
+                }
+            },
+            {
+                targets: 2,
+                createdCell: function(td, cellData, rowData, row, col) {
+                    if (rowData.keyTitle.length > 0) {
+                        $(td).prop('title', rowData.keyTitle);
+                    }
+                    if (rowData.keyClass.length > 0) {
+                        $(td).addClass(rowData.keyClass);
+                    }
+                }
+            },
+            {
+                targets: 5,
+                createdCell: function(td, cellData, rowData, row, col) {
+                    if (cellData == '√') {
+                        $(td).prop('title', "nullable");
+                    }
+                }
+            },
+            {
+                targets: 6,
+                createdCell: function(td, cellData, rowData, row, col) {
+                    if (cellData == '√') {
+                        $(td).prop('title', "Automatically updated by the database");
+                    }
+                }
+            }
+        ],
+        lengthChange: false,
+		paging: config.pagination,
+		pageLength: 50,
+		autoWidth: true,
+		order: [[ 2, "asc" ]],		
+		buttons: [ 
+					{
+						text: 'All',
+						action: function ( e, dt, node, config ) {
+							filterBy('All');
+							if (activeObject != null) {
+								activeObject.active(false);
+							}
+							table.draw();
+						}
+					},
+					{
+						text: 'Tables',
+						action: function ( e, dt, node, config ) {
+							filterBy('Table');
+							if (activeObject != null) {
+								activeObject.active(false);
+							}
+							this.active( !this.active() );
+							activeObject = this;
+							table.draw();
+						}
+					},
+					{
+						text: 'Views',
+						action: function ( e, dt, node, config ) {
+							filterBy('View');
+							if (activeObject != null) {
+								activeObject.active(false);
+							}
+							this.active( !this.active() );
+							activeObject = this;
+							table.draw();
+						}
+					},
+					{
+						extend: 'columnsToggle',
+						columns: '.toggle'
+					}
+				]
+					
+    } );
+
+    //schemaSpy.js
+    dataTableExportButtons(table);
+} );