Questions tagged data
Datasets, factories, rows and cleanup.
28 questions
Example threads. These questions and answers were written by the SDODS team to document real problems and how to fix them. The people named are illustrative, not real users. Questions asked on this site are marked new.
A cleanup DELETE returned 404 and the scenario still passed — is that intended?
We register cleanups the way the guide shows: The records are not being deleted. Looking at the run detail, the cleanup ran and the request 404'd, and the scenario is green. Two…
asked by Zeynep ArslanThe UI says saved and no row is written — how do I assert on the database?
We keep getting the same class of bug: the form submits, the toast says saved, the UI shows the new item from local state, and nothing was persisted. It survives every UI…
asked by Hsu Wei-lin12k rows of reference data: commit the CSV or import it into a db dataset?
Our pricing rules are about twelve thousand rows and they change roughly weekly, on a schedule that has nothing to do with our release schedule. Today they are a committed CSV,…
asked by Paulo Mendes335 of 390 scenarios failed at -w 4 with the user pool exhausted, and doctor is all green
Full regression at four workers. 55 passed, 335 failed, and nearly all of the failures are this: The passes are all scenarios that need no user, or need @user:admin, which…
asked by Chandra PillaiPool leased an account whose username is the literal ${TEST_MEMBER_EMAIL} and auth rejected it
Local runs only. CI has been green throughout, which is why this took a day. projects/mybotbox/data/staging/users.csv: The failure is not from SDODS. It is from the auth…
asked by Ingrid SolbergOne viewer account, twelve read-only scenarios, and the suite behaves as if -w 1
A partner gives us exactly one viewer account and will not create more — it is their system, their policy, and no amount of asking has moved it. Twelve scenarios carry…
asked by Rasha Halabiusers.poolSize is 4 and now a row that exists in the CSV is not in the pool
envs/staging.yaml has: data/staging/users.csv has five rows. Row five is visual_user, role standard. The name is in the file, spelled the same, and the role exists. Raising…
asked by Rasha HalabiDoes ${VAR} in a CSV dataset resolve from .env.staging, or only from the shell?
Our data/common/users.csv has a password column holding ${TEST_MEMBER_PASSWORD} so the value is not in the repo. It works on my machine, where the variable is exported. On a…
asked by Rasha Halabiproducts.json must contain an array of rows (or { rows: [...] }) — mine is keyed by sku
The export from our catalogue service is an object keyed by sku, which is the shape everything downstream of it expects: Pointing a dataset at it gives: Odd part: sdods data…
asked by Koen Vermeulensdods auth capture --index 3 says Role "admin" has 2 user(s); index 3 does not exist
The CSV has six rows and the admin I want is on the fourth one, so index 3 by my counting. Where does "2 user(s)" come from?
asked by Tanvi BhattCONFIG_INVALID: Project demo-shop has no data.userPool configured, but data.sources.users exists
Added @user:standard to a scenario. The run stops before the first step: The confusing part is that data.sources.users is declared and works — Given I load dataset "users" row 0…
asked by Sergio Alcaraz@data:users errors with "is not a declared dataset (logins, posts)" after a rename
We renamed the dataset from users to logins in the yaml and updated the steps. Lint now fails on the tags we forgot: Easy enough to fix, but it raises a question — the scenario…
asked by Tobi SchraderDataset uses type "db" but @sdods/db is not available — is the package optional or not?
We keep the test workspace deliberately thin — the runner and nothing else — because it is installed on machines that only ever execute suites. One scenario reads reference rows…
asked by Anouk de VriesCancelled a run with ctrl-c and now every pool account looks leased
Killed a run halfway through. The next run fails immediately-ish with: Nothing is running. .sdods/leases/demo-shop/staging/ has four .lock files in it, each with an owner and a…
asked by Bruno TeixeiraEvery checkout scenario spends 40 seconds registering a user through the sign-up form first
Thirteen checkout scenarios, and each one starts by filling in the six-field registration form, confirming an email, and setting a password. That is about forty seconds before…
asked by Fiona McAllisterDoes @data:orders load the dataset, or do I still need the Given step?
Tagged a scenario @data:orders on the assumption that it would put the columns in scope the way @user:standard puts an account in scope. The scenario runs, lint is clean, and the…
asked by Bea LindqvistDataset table needs env.db in envs/staging.yaml — which database is it asking for?
Added a db dataset for our reference data: Works on local, fails on staging: We already have a database configured — DATABASE_URL is set in CI and sdods db status is happy. So…
asked by Helle BorgWhat is the accepted way to delete the records a scenario created?
Our regression suite has left about nine hundred posts behind in the sandbox and the list endpoint is getting slow. Right now the deletes are in an after-hook in our own step…
asked by Thom VasseurNo row in dataset "users" where role = "admin" and the value is in the file
grep -c admin on the CSV says 1. The column is spelled role. I have restarted, cleared .sdods, and read the line about forty times.
asked by Yusuf Demirauth list says the cached state is fresh but the recording opens logged out
Starting a recording with --user standard drops me on the sign-in page, but the cache insists it has a good state: Eighteen minutes old, and we never touched auth.maxAgeMinutes,…
asked by Renata KohlHow do people keep real passwords out of a users.csv that has to be committed?
Our pool CSV has a plaintext password column and security review flagged it, fairly. Options I can see are all bad: Is there a fourth thing?
asked by Ify AdeyemiFactory "user" not found, hint says Known factories: (none), but the file exports it
projects/shop/data/factories.ts exists and exports a user. The hint even names the file it says I should create.
asked by Lars VinterAll 4 user(s) with role "standard" are leased — passes locally, four failures in CI
Suite is green on my machine and fails in CI, and the difference is the worker count. Local: CI runs the same thing with -w 8. Four scenarios pass, four sit there for what looks…
asked by Owen BrackleyDataset "users" has 3 row(s); row 5 does not exist (0-based) — is the header counted?
I wrote Given I load dataset "users" row 5 because the account I want is on line 5 of the spreadsheet. Got: Three rows? The file has four lines. And when I tried row 1 earlier it…
asked by Gio CastellanoUSER_POOL_EXHAUSTED: No users with role "admin" in dataset "users" (env staging)
Tagged a scenario @user:admin and the run fails before a browser even opens: There is definitely an admin in the CSV, I am looking at it. Roles in the file are standard,…
asked by Elsa NymanScenario Outline with 20 Examples rows, or a CSV dataset? What do reviewers expect here
We have a shipping tax table: twenty countries, each with a rate and an expected label on the confirmation page. I wrote it as a Scenario Outline and the feature file is now a…
asked by Jide OkonkwoNo data file for "data/{env}/users.csv" in env "staging" when the common file exists
Declared like this: There is no data/staging/ directory, which is fine, that was the plan — every environment was supposed to fall back to the common file. And there is a common…
asked by Annika SolheimDATASET_NOT_FOUND says my dataset is not declared, but the CSV is right there
Trying to drive the login scenarios from a CSV instead of an Examples table. The file is at projects/demo-shop/data/common/users.csv and previewing it works: Six rows, columns…
asked by Dinuka Perera