Contents

[<<back](README.md)

# Test SQL and database

**Exercise**

* Ask students to make a Sqlite Database. Create a table called `characters` with `name` varchar, and `rol` varchar.
* Database example:

```
❯ sqlite3 examples/24-test-sql/database_01.db

sqlite> .schema characters
CREATE TABLE characters ( name varchar(255), rol varchar(255));

sqlite> select * from characters;
Obiwan|Jedi
```

* Query example:

```
❯ cat examples/24-test-sql/query_01.sql

select * from characters where rol='Jedi';
```

**Teuton test**

* Define targets:

```ruby
group "Test SQL and database" do
  database = "#{get(:folder)}/#{get(:database)}"
  query = "#{get(:folder)}/#{get(:query)}"

  target "Database schema"
  run "sqlite3 #{database} '.schema characters'"
  expect "name varchar", "rol varchar"

  target "Query Jedi"
  run "sqlite3 #{database} '.read #{query}'"
  expect "Obiwan", "Jedi"
end
```

* Configure params:

```yaml
---
global:
  folder: examples/24-test-sql
cases:
- tt_members: student_1_name
  database: database_01.db
  query: query_01.sql
```

**Test output**

```
❯ teuton examples/24-test-sql                                   

CASE RESULTS
+------+----------------+-------+-------+
| CASE | MEMBERS        | GRADE | STATE |
| 01   | student_1_name | 100.0 | ✔     |
+------+----------------+-------+-------+
```

Version data entries

14 entries across 14 versions & 1 rubygems

Version	Path
teuton-2.9.2	docs/learn/24-test-sql.md
teuton-2.9.1	docs/learn/24-test-sql.md
teuton-2.9.0	docs/learn/24-test-sql.md
teuton-2.8.0	docs/learn/24-test-sql.md
teuton-2.7.3	docs/learn/24-test-sql.md
teuton-2.7.2	docs/learn/24-test-sql.md
teuton-2.7.1	docs/learn/24-test-sql.md
teuton-2.7.0	docs/learn/24-test-sql.md
teuton-2.6.0	docs/learn/24-test-sql.md
teuton-2.5.0	docs/learn/24-test-sql.md
teuton-2.4.5	docs/learn/24-test-sql.md
teuton-2.4.4	docs/learn/24-test-sql.md
teuton-2.4.3	docs/learn/24-test-sql.md
teuton-2.4.2	docs/learn/24-test-sql.md