SupabaseS
Supabase•12mo ago
Hong

Failure in simple db test

I was following the db test instructions. I simply did superbase test db

public.Feedback is a db table I set up on the supabase.com

begin;
select plan(1); 

-- Test for existence of required columns
SELECT has_column(
    'public',
    'Feedback',
    'id',
    'id column should exist'
);

select * from finish();
rollback;


I got this failure message,

WARN: no seed files matched pattern: supabase/seed.sql
Connecting to local database...
./database/feedback.test.sql .. 
# Failed test 1: "id column should exist"
# Looks like you failed 1 test of 1
Failed 1/1 subtests 

Test Summary Report
-------------------
./database/feedback.test.sql (Wstat: 0 Tests: 1 Failed: 1)
  Failed test:  1
Files=1, Tests=1,  0 wallclock secs ( 0.00 usr +  0.00 sys =  0.00 CPU)
Result: FAIL
error running container: exit 1
Try rerunning the command with --debug to troubleshoot the error.


Is it that I cannot test against the online table, but I must use a local table? or any other reasons?
Was this page helpful?