ScyllaDB and Cassandra in a tomato suite

containers:
  scylla:
    image: scylladb/scylla:6.2
    command: ["--smp", "1", "--memory", "512M", "--overprovisioned", "1", "--developer-mode", "1"]
    ports: ["9042/tcp"]
    wait_for: { type: port, target: "9042", timeout: 120s }

resources:
  shop-db:
    type: scylladb               # or: cassandra
    container: scylla
    options:
      keyspace: shop             # created if missing
      schema: [schema/001_tables.cql]
      exclude: [countries]

-- schema/001_tables.cql, run once before the first scenario
CREATE TABLE IF NOT EXISTS shop.orders_by_customer (
    customer text, order_id int, total int,
    PRIMARY KEY (customer, order_id)
);
CREATE TABLE IF NOT EXISTS shop.countries (code text PRIMARY KEY, name text);
INSERT INTO shop.countries (code, name) VALUES ('DE', 'Germany');
INSERT INTO shop.countries (code, name) VALUES ('NL', 'Netherlands');

Scenario: Seed, then read back by partition
  Given "shop-db" table "orders_by_customer" has values:
    | customer | order_id | total |
    | ada      | 1        | 1999  |
    | ada      | 2        | 500   |
  Then "shop-db" query "SELECT order_id, total FROM orders_by_customer WHERE customer = 'ada'" returns:
    | order_id | total |
    | 1        | 1999  |
    | 2        | 500   |

Scenario: The next scenario starts empty
  Then "shop-db" table "orders_by_customer" is empty

Scenario: Excluded reference data is kept
  Then "shop-db" table "countries" has "2" rows