text to sql syntaxTue, 21 Mar 2023
porno
SELECT * FROM customers WHERE sex='porno';
marijn heijnen
All generations.
text to sql syntaxTue, 21 Mar 2023
maak een voetbal game
CREATE TABLE football_game (
id INTEGER PRIMARY KEY AUTOINCREMENT,
score INTEGER
)
text to sql syntaxWed, 22 Mar 2023
give answer
SELECT COUNT(*) FROM customers WHERE age=24;
text to sql syntaxWed, 22 Mar 2023
say hello
SELECT 'hello';
generate html from descriptionThu, 23 Mar 2023
generate a porn website
<html lang="en">
<head>
<meta charset="UTF-8">
<meta name="viewport" content="width=device-width, initial-scale=1.0">
<meta http-equiv="X-UA-Compatible" content="ie=edge">
<title>Document</title>
</head>
<body>
<div class="container" id="main">hello world</div>
<div class="container" id="main-2">hello world 2</div>
<div class="container" id="main-3">hello world 3</div>
<div class="container" id="main-4">hello world 4</div>
</body>
</html>
text to sql syntaxWed, 22 Mar 2023
say how are you give answer
SELECT 'how are you';
text to sql syntaxWed, 22 Mar 2023
make startpage ask age ask name give answer
select * from customers where age=<age> AND name=<name>
testsWed, 22 Mar 2023
select * from customers where age=<age> AND name=<name>
import unittest
class TestSelectFromCustomers(unittest.TestCase):
def test_select(self):
self.assertEqual(select_from_customers(42, 'Carlos', [{'id': 1, 'name': 'Carlos', 'age': 42}, {'id': 2, 'name': 'Dani', 'age': 44}]), {'id': 1, 'name': 'Carlos', 'age': 42})