openai-sql/webgui/templates/main.html
2023-06-15 08:41:04 +02:00

92 lines
3.8 KiB
HTML

<DOCTYPE html>
<html lang="en">
<head>
<meta charset="UTF-8">
<meta name="viewport"
content="width=device-width, user-scalable=no, initial-scale=1.0, maximum-scale=1.0, minimum-scale=1.0">
<meta http-equiv="X-UA-Compatible" content="ie=edge">
<title>Document</title>
<link rel="stylesheet" type="text/css" href="static/bootstrap-5.3.0-alpha3-dist/css/bootstrap.css">
</head>
<body>
<nav class="navbar navbar-expand-md navbar-light bg-dark-subtle">
<div class="container">
<button class="navbar-toggler" type="button" data-toggle="collapse" data-target="#navbarNav" aria-controls="navbarNav" aria-expanded="false" aria-label="Toggle navigation">
<span class="navbar-toggler-icon"></span>
</button>
<div class="collapse navbar-collapse" id="navbarNav">
<ul class="navbar-nav">
<li class="nav-item active">
<a class="nav-link" href="#">Human to SQL</a>
</li>
<li class="nav-item">
<a class="nav-link" href="#">Setup Database</a>
</li>
<li class="nav-item">
<a class="nav-link" href="#">Setup API Key</a>
</li>
</ul>
</div>
</div>
</nav>
<div class="container mt-3">
<div class="row">
<div class="col">
<!-- Add this form tag to wrap your input field and Convert button -->
<form action="/" method="post">
<label for="textInput">Prompt:</label>
<div class="input-group">
<input type="text" id="textInput" name="textInput" class="form-control" placeholder="Enter prompt">
<div class="input-group-append">
<button class="btn btn-primary" type="submit">Convert</button>
</div>
</div>
</form>
</div>
</div>
<div class="row mt-3">
<div class="col">
<label for="textArea1">Generated SQL:</label>
<textarea id="textArea1" class="form-control" rows="4" placeholder="" disabled="disabled">{{ generated_sql }}</textarea>
<div class="mt-3">
<button class="btn btn-primary" type="button">Paste to shell</button>
</div>
</div>
<div class="col">
<label for="textArea2">SQL Shell:</label>
<textarea id="textArea2" class="form-control" rows="4" placeholder="Enter sql"></textarea>
<div class="mt-3">
<button class="btn btn-primary" type="button">Execute</button>
</div>
</div>
</div>
<div class="row mt-3">
<div class="col">
<p> For x in data, for i in x etc:</p>
<table class="table">
<thead>
<tr>
<th>Column 1</th>
<th>Column 2</th>
<th>Column 3</th>
</tr>
</thead>
<tbody>
<tr>
<td>Data 1</td>
<td>Data 2</td>
<td>Data 3</td>
</tr>
<tr>
<td>Data 4</td>
<td>Data 5</td>
<td>Data 6</td>
</tr>
</tbody>
</table>
</div>
</div>
</div>
</body>
</html>