83dafb8a08
Enum table is generated below the Tables tree. Enums cannot be queried since I don't know what I would want them to query so right now its just for viewing. However, enum types are now displayed properly in the table tree. I still don't know how strong the support will be for other kinds of DBs that aren't PSQL.
47 lines
1.6 KiB
JavaScript
47 lines
1.6 KiB
JavaScript
/*
|
|
* This file contains the functions that are used to toggle the visibility of the fields
|
|
* in the tree view of the tables.
|
|
*
|
|
* This file also contains the functions that are used to generate quick queries for the
|
|
* tables.
|
|
*
|
|
* This file also contains the functions that are used to toggle the visibility of the
|
|
* enum values in the tree view of the tables.
|
|
*/
|
|
function ToggleFields(id) {
|
|
const fields = document.getElementById(`fields-${id}`);
|
|
const button_svg = document.getElementById(`icon-${id}`);
|
|
if (fields.classList.contains("hidden")) {
|
|
fields.classList.remove("hidden");
|
|
button_svg.setAttribute("transform", "rotate(0)");
|
|
} else {
|
|
fields.classList.add("hidden");
|
|
button_svg.setAttribute("transform", "rotate(-90)");
|
|
}
|
|
}
|
|
|
|
function LoadTableQuery(table) {
|
|
const sql = document.getElementById("sql")
|
|
sql.value = `SELECT * FROM ${table};`;
|
|
sql.dispatchEvent(new Event("input", { bubbles: true }));
|
|
}
|
|
|
|
function LoadTableQueryWithFields(table, fields) {
|
|
const sql = document.getElementById("sql")
|
|
sql.value = `SELECT ${fields} FROM ${table};`;
|
|
sql.dispatchEvent(new Event("input", { bubbles: true }));
|
|
}
|
|
|
|
function ToggleEnumValues(id) {
|
|
const enum_values = document.getElementById(`enum-values-${id}`);
|
|
const button_svg = document.getElementById(`icon-enum-${id}`);
|
|
|
|
if (enum_values.classList.contains("hidden")) {
|
|
enum_values.classList.remove("hidden");
|
|
button_svg.setAttribute("transform", "rotate(0)");
|
|
} else {
|
|
enum_values.classList.add("hidden");
|
|
button_svg.setAttribute("transform", "rotate(-90)");
|
|
}
|
|
}
|