From 85db7c5287ae58efc108263f7a40bdbd02de1a82 Mon Sep 17 00:00:00 2001 From: terminaldweller Date: Thu, 21 Jul 2022 10:06:02 +0430 Subject: added docs for the db using schemaspy --- dbdocs/tables/table.js | 85 ++++++++++++++++++++++++++++++++++++++++++++++++++ 1 file changed, 85 insertions(+) create mode 100644 dbdocs/tables/table.js (limited to 'dbdocs/tables/table.js') diff --git a/dbdocs/tables/table.js b/dbdocs/tables/table.js new file mode 100644 index 0000000..a07a96e --- /dev/null +++ b/dbdocs/tables/table.js @@ -0,0 +1,85 @@ +$(document).ready(function() { + anchors.options.visible = 'always'; + anchors.add('h3'); + + var table = $('#standard_table').DataTable( { + lengthChange: false, + ordering: false, + paging: config.pagination, + autoWidth: true, + buttons: [ + { + text: 'Related columns', + action: function ( e, dt, node, config ) { + $(".relatedKey").toggle(); + this.active( !this.active() ); + table.columns.adjust().draw(); + } + }, + { + text: 'Constraint', + action: function ( e, dt, node, config ) { + $(".constraint").toggle(); + this.active( !this.active() ); + table.columns.adjust().draw(); + } + }, + { + extend: 'columnsToggle', + columns: '.toggle' + } + ] + + } ); + dataTableExportButtons(table); + + if ($('#indexes_table').length) { + var indexes = $('#indexes_table').DataTable({ + lengthChange: false, + paging: config.pagination, + ordering: false + }); + dataTableExportButtons(indexes); + } + + if ($('#check_table').length) { + var check = $('#check_table').DataTable( { + lengthChange: false, + paging: config.pagination, + ordering: false + } ); + dataTableExportButtons(check); + } +} ); + + +$(function() { + var $imgs = $('img.diagram, object.diagram'); + $imgs.css("cursor", "move") + $imgs.draggable(); +}); + +$.fn.digits = function(){ + return this.each(function(){ + $(this).text( $(this).text().replace(/(\d)(?=(\d\d\d)+(?!\d))/g, "1 ") ); + }) +} + +$(function() { + $("#recordNumber").digits(); +}); + +var codeElement = document.getElementById("sql-script-codemirror"); +var editor = null; +if (null != codeElement) { + editor = CodeMirror.fromTextArea(codeElement, { + lineNumbers: true, + mode: 'text/x-sql', + indentWithTabs: true, + smartIndent: true, + lineNumbers: true, + matchBrackets: true, + autofocus: true, + readOnly: true + }); +} -- cgit v1.2.3