mirror of
https://github.com/lucaspalomodevelop/sqlite-analyzer.git
synced 2026-03-13 00:07:27 +00:00
122 lines
4.3 KiB
HTML
122 lines
4.3 KiB
HTML
<!DOCTYPE html>
|
|
<html lang="en">
|
|
|
|
<head>
|
|
<meta charset="UTF-8">
|
|
<meta name="viewport" content="width=device-width, initial-scale=1.0">
|
|
<link rel="stylesheet" href="{{ url_for('static', filename='../static/css/style.css') }}">
|
|
<link rel="stylesheet" href="{{ url_for('static', filename='../static/css/tabs.css') }}">
|
|
<title>SQL Analyzer</title>
|
|
</head>
|
|
|
|
<body>
|
|
<header>
|
|
<h1>SQL Analyzer</h1>
|
|
</header>
|
|
|
|
<main>
|
|
|
|
<!-- Tab links -->
|
|
<div class="tab">
|
|
<button class="tablinks" onclick="openTab(event, 'sqlite')">sqlite</button>
|
|
<button class="tablinks" onclick="openTab(event, 'mysql')">mysql</button>
|
|
</div>
|
|
|
|
<!-- Tab content -->
|
|
<div id="sqlite" class="tabcontent">
|
|
<div id="dropArea" ondragover="handleDragOver(event)" ondragleave="handleDragLeave(event)"
|
|
ondrop="handleDrop(event)">
|
|
Drag & Drop Datei hierhin oder <input type="file" id="fileInput" style="display: none;"
|
|
onchange="handleFiles(this.files)"> klicken, um hochzuladen.
|
|
</div>
|
|
<center><button class="button" id="toggleFormButton" onclick="toggleForm()">DB Hochladen</button></center>
|
|
|
|
<form id="uploadForm" class="closed" method="post" enctype="multipart/form-data" action="/sqlite">
|
|
<input type="file" name="file" id="fileInput" onchange="submitForm()">
|
|
</form>
|
|
|
|
{% if error %}
|
|
<p>{{ error }}</p>
|
|
{% endif %}
|
|
|
|
{% if table_data %}
|
|
{% for table_name, data in table_data.items() %}
|
|
<h2>{{ table_name }}</h2>
|
|
<table>
|
|
<tr>
|
|
{% for column_name in data[0] %}
|
|
<th>{{ column_name }}</th>
|
|
{% endfor %}
|
|
</tr>
|
|
{% for row in data %}
|
|
<tr>
|
|
{% for value in row %}
|
|
<td>{{ value }}</td>
|
|
{% endfor %}
|
|
</tr>
|
|
{% endfor %}
|
|
</table>
|
|
{% endfor %}
|
|
<script>
|
|
document.getElementById('toggleFormButton').click();
|
|
</script>
|
|
{% endif %}
|
|
|
|
{% if er_model %}
|
|
<h2>ER-Modell</h2>
|
|
<img src="{{ url_for('show_er_model', filename=er_model) }}" alt="ER-Modell">
|
|
{% endif %}
|
|
|
|
<input id="sql_input" type="text" placeholder="SELECT * FROM test;">
|
|
<center><button id="execute_button">Ausühren</button></center>
|
|
|
|
</div>
|
|
|
|
<div id="mysql" class="tabcontent">
|
|
<h2>MySQL</h2>
|
|
<p>Hier können Sie MySQL-Datenbankabfragen durchführen.</p>
|
|
|
|
<form id="mysqlConnectionForm" method="post" action="/mysql">
|
|
<input type="text" name="host" placeholder="Host">
|
|
<input type="text" name="user" placeholder="Benutzername">
|
|
<input type="password" name="password" placeholder="Passwort">
|
|
<button type="submit">Verbinden</button>
|
|
</form>
|
|
|
|
<form id="mysqlForm" method="post">
|
|
<input type="text" name="query" placeholder="Geben Sie Ihre SQL-Abfrage ein">
|
|
<button type="submit">Abfrage ausführen</button>
|
|
</form>
|
|
|
|
{% if mysql_result %}
|
|
<h3>Abfrageergebnis</h3>
|
|
<table>
|
|
<tr>
|
|
{% for column_name in mysql_result[0] %}
|
|
<th>{{ column_name }}</th>
|
|
{% endfor %}
|
|
</tr>
|
|
{% for row in mysql_result %}
|
|
<tr>
|
|
{% for value in row %}
|
|
<td>{{ value }}</td>
|
|
{% endfor %}
|
|
</tr>
|
|
{% endfor %}
|
|
</table>
|
|
{% endif %}
|
|
|
|
</div>
|
|
|
|
<footer style="background-color: #007bff; color: #ffffff; text-align: center; width: 100%;">
|
|
© fingadumbledore 2024 Version 0.1
|
|
© lucaspalomodevelop 2025 Version 0.2
|
|
</footer>
|
|
<button class="dark-mode-button" onclick="toggleDarkMode()">🌙</button>
|
|
<script src="/static/js/index.js"></script>
|
|
</main>
|
|
|
|
<script src="/static/js/tabs.js" defer> </script>
|
|
</body>
|
|
|
|
</html> |