@malloydata/malloy-tests NPM

Tests

By default, tests run against BigQuery, Postgres, and DuckDB.

Tests can also be run against a specific database, using the MALLOY_DATABASE or MALLOY_DATABASES environment variable, such as: MALLOY_DATABASES=bigquery,postgres npm run test

Setting up postgres:

Setup for Postgres Test Data

Assumes that postgres has been installed via nix (installs but doesn't configure).

ADD to environment: export PGHOST=localhost

postgres_init.sh - builds a database as the current user in .tmp/data/malloytestdb. Starts server runing on localhost:5432 copies the test data in malloytest-postgres.sql.gz into the database.

postgres_start.sh - starts the postgres server, once it has been installed (use after a reboot, for example)

postgres_stop.sh - stops the postgres server

state_fact.sql - example file on how to insert data from json

Setting up DuckDB:

Building test database for duckdb

At top-level, run npx ts-node scripts/build_duckdb_test_database.ts
A file called duckdb_test.db should be created in the test/data/duckdb folder - tests will automatically look there.

@jest/globals @malloydata/db-bigquery @malloydata/db-duckdb @malloydata/db-postgres @malloydata/db-snowflake @malloydata/db-trino @malloydata/malloy @malloydata/render jsdom luxon madge

@everything-registry/sub-chunk-573

0.0.144-dev240503230218

5 days ago

0.0.144-dev240503150037

6 days ago

0.0.144-dev240426151705

13 days ago

0.0.144-dev240426181908

12 days ago

0.0.144

12 days ago

0.0.144-dev240419201335

19 days ago

0.0.143

19 days ago

0.0.143-dev240418162623

20 days ago

0.0.143-dev240419025427

20 days ago

0.0.143-dev240417161322

21 days ago

0.0.143-dev240416173709

22 days ago

0.0.142-dev240412191256

26 days ago

0.0.143-dev240413151958

26 days ago

0.0.142-dev240413014741

26 days ago

0.0.142

26 days ago

0.0.141-dev240410234123

28 days ago

0.0.142-dev240411154213

28 days ago

0.0.141-dev240410194001

28 days ago

0.0.141

28 days ago

0.0.140-dev240409200123

29 days ago

0.0.141-dev240409210957

29 days ago

0.0.140-dev240409204232

29 days ago

0.0.140

29 days ago

0.0.140-dev240408232557

1 month ago

0.0.139-dev240408225335

1 month ago

0.0.138-dev240408220220

1 month ago

0.0.139-dev240408224944

1 month ago

0.0.138

1 month ago

0.0.138-dev240405133532

1 month ago

0.0.138-dev240404145618

1 month ago

0.0.138-dev240405003346

1 month ago

0.0.138-dev240404154020

1 month ago

0.0.138-dev240404233606

1 month ago

0.0.138-dev240404193102

1 month ago

0.0.138-dev240403210403

1 month ago

0.0.138-dev240403142727

1 month ago

0.0.138-dev240403155507

1 month ago

0.0.138-dev240403210124

1 month ago

0.0.138-dev240402220928

1 month ago

0.0.138-dev240402021905

1 month ago

0.0.138-dev240402170711

1 month ago

0.0.138-dev240402223657

1 month ago

0.0.138-dev240402185231

1 month ago

0.0.138-dev240401131656

1 month ago

0.0.138-dev240401194552

1 month ago

0.0.138-dev240402171233

1 month ago

0.0.138-dev240401005446

1 month ago

0.0.138-dev240331204754

1 month ago

0.0.138-dev240331175328

1 month ago

0.0.137-dev240328161656

1 month ago

0.0.138-dev240328203849

1 month ago

0.0.138-dev240329233445

1 month ago

0.0.138-dev240328202038

1 month ago

0.0.137

1 month ago

0.0.137-dev240328004426

1 month ago

0.0.137-dev240327175808

1 month ago

0.0.137-dev240327002044

1 month ago

0.0.136-dev240327000050

1 month ago

0.0.135-dev240326225108

1 month ago

0.0.136-dev240326234246

1 month ago

0.0.136

1 month ago

0.0.135

1 month ago

0.0.135-dev240325191847

1 month ago

0.0.135-dev240326020414

1 month ago

0.0.135-dev240326154530

1 month ago

0.0.135-dev240322221435

2 months ago

0.0.135-dev240322231911

2 months ago

0.0.135-dev240322225529

2 months ago

0.0.135-dev240322231539

2 months ago

0.0.135-dev240321191203

2 months ago

0.0.134-dev240321184648

2 months ago

0.0.134

2 months ago

0.0.133-dev240320200749

2 months ago

0.0.134-dev240320210539

2 months ago

0.0.133

2 months ago

0.0.133-dev240319171426

2 months ago

0.0.132-dev240318200933

2 months ago

0.0.133-dev240318205756

2 months ago

0.0.132

2 months ago

0.0.132-dev240318200424

2 months ago

0.0.132-dev240315233415

2 months ago

0.0.132-dev240314225140

2 months ago

0.0.131-dev240314162352

2 months ago

0.0.131-dev240314202359

2 months ago

0.0.131-dev240314214542

2 months ago

0.0.131

2 months ago

0.0.131-dev240314214525

2 months ago

0.0.130-dev240311142713

2 months ago

0.0.130-dev240311153734

2 months ago

0.0.130-dev240311202005

2 months ago

0.0.130-dev240311192728

2 months ago

0.0.131-dev240312162310

2 months ago

0.0.130-dev240311164559

2 months ago

0.0.129-dev240311140438

2 months ago

0.0.131-dev240314002549

2 months ago

0.0.129

2 months ago

0.0.130-dev240312011825

2 months ago

0.0.130

2 months ago

0.0.131-dev240312174126

2 months ago

0.0.128-dev240311005120

2 months ago

0.0.129-dev240311012659

2 months ago

0.0.128

2 months ago

0.0.128-dev240309204213

2 months ago

0.0.127-dev240309202055

2 months ago

0.0.127

2 months ago

0.0.127-dev240308180053

2 months ago

0.0.127-dev240307031210

2 months ago

0.0.127-dev240306172007

2 months ago

0.0.127-dev240305191049

2 months ago

0.0.126-dev240305182920

2 months ago

0.0.126

2 months ago

0.0.126-dev240221165840

3 months ago

0.0.125

3 months ago

0.0.125-dev240220210757

3 months ago

0.0.125-dev240215152634

3 months ago

0.0.125-dev240212182722

3 months ago

0.0.125-dev240213000017

3 months ago

0.0.125-dev240212230553

3 months ago

0.0.124

3 months ago

0.0.124-dev240212180839

3 months ago

0.0.123-dev240209222024

3 months ago

0.0.124-dev240210014322

3 months ago

0.0.124-dev240209232446

3 months ago

0.0.123

3 months ago

0.0.123-dev240209210150

3 months ago

0.0.123-dev240209165819

3 months ago

0.0.123-dev240209030627

3 months ago

0.0.123-dev240208155844

3 months ago

0.0.123-dev240207191052

3 months ago

0.0.123-dev240208001444

3 months ago

0.0.123-dev240207164302

3 months ago

0.0.123-dev240207162055

3 months ago

0.0.123-dev240205203120

3 months ago

0.0.123-dev240205203117

3 months ago

0.0.123-dev240205152128

3 months ago

0.0.122-dev240203152115

3 months ago

0.0.123-dev240203154014

3 months ago

0.0.122

3 months ago

0.0.122-dev240202181129

3 months ago

0.0.121-dev240202151833

3 months ago

0.0.121-dev240202151212

3 months ago

0.0.121

3 months ago

0.0.121-dev240202151424

3 months ago

0.0.121-dev240202013951

3 months ago

0.0.121-dev240201150428

3 months ago

0.0.120

3 months ago

0.0.120-dev240131223846

3 months ago

0.0.120-dev240131220338

3 months ago

0.0.120-dev240131220357

3 months ago

0.0.120-dev240131220408

3 months ago

0.0.120-dev240125201336

3 months ago

0.0.119-dev240124182419

4 months ago

0.0.119-dev240124192531

4 months ago

0.0.119

4 months ago

0.0.119-dev240124170348

4 months ago

0.0.120-dev240124220942

4 months ago

0.0.119-dev240123183113

4 months ago

0.0.119-dev240118211537

4 months ago

0.0.119-dev240118215411

4 months ago

0.0.118

4 months ago

0.0.118-dev240115220450

4 months ago

0.0.119-dev240116200529

4 months ago

0.0.118-dev240111190911

4 months ago

0.0.118-dev240111234914

4 months ago

0.0.117-dev240111173451

4 months ago

0.0.117

4 months ago

0.0.117-dev240110181238

4 months ago

0.0.117-dev240110202509

4 months ago

0.0.117-dev240110184814

4 months ago

0.0.116

4 months ago

0.0.117-dev240108172820

4 months ago

0.0.116-dev240105181617

4 months ago

0.0.116-dev240105162843

4 months ago

0.0.116-dev240104225124

4 months ago

0.0.116-dev240104000530

4 months ago

0.0.116-dev231227024817

4 months ago

0.0.116-dev231227010910

4 months ago

0.0.116-dev231225141229

5 months ago

0.0.116-dev231218202606

5 months ago

0.0.116-dev231213173224

5 months ago

0.0.116-dev231212233120

5 months ago

0.0.114-dev231212213708

5 months ago

0.0.115-dev231212215809

5 months ago

0.0.115

5 months ago

0.0.114

5 months ago

0.0.115-dev231212231346

5 months ago

0.0.113-dev231212022743

5 months ago

0.0.113-dev231212171917

5 months ago

0.0.114-dev231212181223

5 months ago

0.0.113

5 months ago

0.0.112-dev231208224321

5 months ago

0.0.112-dev231208150120

5 months ago

0.0.112

5 months ago

0.0.113-dev231208230337

5 months ago

0.0.112-dev231207161601

5 months ago

0.0.112-dev231206204526

5 months ago

0.0.112-dev231206183653

5 months ago

0.0.112-dev231206174321

5 months ago

0.0.112-dev231206194739

5 months ago

0.0.112-dev231205212322

5 months ago

0.0.112-dev231205222129

5 months ago

0.0.112-dev231205142923

5 months ago

0.0.111

5 months ago

0.0.111-dev231204174349

5 months ago

0.0.111-dev231204222306

5 months ago

0.0.111-dev231204215446

5 months ago

0.0.111-dev231204165238

5 months ago

0.0.111-dev231202012106

5 months ago

0.0.110

5 months ago

0.0.110-dev231202010113

5 months ago

0.0.110-dev231201203407

5 months ago

0.0.110-dev231201203211

5 months ago

0.0.109

5 months ago

0.0.109-dev231201200713

5 months ago

0.0.109-dev231201200035

5 months ago

0.0.109-dev231201191617

5 months ago

0.0.109-dev231201181643

5 months ago

0.0.109-dev231130215708

5 months ago

0.0.108

5 months ago

0.0.108-dev231130212751

5 months ago

0.0.108-dev231130212526

5 months ago

0.0.108-dev231129223342

5 months ago

0.0.107

5 months ago

0.0.107-dev231129215946

5 months ago

0.0.107-dev231129172332

5 months ago

0.0.107-dev231128211314

5 months ago

0.0.106

5 months ago

0.0.106-dev231128205401

5 months ago

0.0.106-dev231128154457

5 months ago

0.0.105

5 months ago

0.0.105-dev231127225419

5 months ago

0.0.105-dev231127212430

5 months ago

0.0.105-dev231127184813

5 months ago

0.0.105-dev231127183208

5 months ago

0.0.105-dev231127164722

5 months ago

0.0.105-dev231124203430

6 months ago

0.0.105-dev231122194042

6 months ago

0.0.104

6 months ago

0.0.104-dev231120193457

6 months ago

0.0.104-dev231117214047

6 months ago

0.0.104-dev231117205713

6 months ago

0.0.104-dev231116200719

6 months ago

0.0.104-dev231116021318

6 months ago

0.0.103

6 months ago

0.0.103-dev231116011753

6 months ago

0.0.103-dev231115200636

6 months ago

0.0.103-dev231115190229

6 months ago

0.0.103-dev231115182100

6 months ago

0.0.102-dev231115181615

6 months ago

0.0.102

6 months ago

0.0.102-dev231115164346

6 months ago

0.0.102-dev231115033625

6 months ago

0.0.102-dev231115031800

6 months ago

0.0.102-dev231115025421

6 months ago

0.0.102-dev231114232519

6 months ago

0.0.102-dev231114180859

6 months ago

0.0.102-dev231114175649

6 months ago

0.0.102-dev231114174821

6 months ago

0.0.101

6 months ago

0.0.101-dev231114022000

6 months ago

0.0.101-dev231114015212

6 months ago

0.0.101-dev231110221413

6 months ago

0.0.101-dev231110211921

6 months ago

0.0.101-dev231110210501

6 months ago

0.0.101-dev231109201517

6 months ago

0.0.101-dev231109174033

6 months ago

0.0.101-dev231107220340

6 months ago

0.0.101-dev231107171050

6 months ago

0.0.100

6 months ago

0.0.100-dev231107164904

6 months ago

0.0.100-dev231107154720

6 months ago

0.0.100-dev231106210358

6 months ago

0.0.100-dev231106185812

6 months ago

0.0.100-dev231106165927

6 months ago

0.0.100-dev231103021229

6 months ago

0.0.100-dev231103010043

6 months ago

0.0.99

6 months ago

0.0.99-dev231103002421

6 months ago

0.0.99-dev231102201226

6 months ago

0.0.99-dev231102185815

6 months ago

0.0.99-dev231102173733

6 months ago

0.0.99-dev231102165615

6 months ago

0.0.99-dev231101201548

6 months ago

0.0.99-dev231031203613

6 months ago

0.0.98

6 months ago

0.0.98-dev231027234207

6 months ago

0.0.98-dev231027183449

6 months ago

0.0.98-dev231026211435

7 months ago

0.0.98-dev231026204054

7 months ago

0.0.98-dev231026204034

7 months ago

0.0.98-dev231026200137

7 months ago

0.0.97

7 months ago

0.0.97-dev231026193050

7 months ago

0.0.97-dev231026184251

7 months ago

0.0.97-dev231026002200

7 months ago

0.0.96

7 months ago

0.0.96-dev231025215824

7 months ago

0.0.96-dev231025215721

7 months ago

0.0.96-dev231025212541

7 months ago

0.0.96-dev231025173405

7 months ago

0.0.96-dev231024223919

7 months ago

0.0.95

7 months ago

0.0.95-dev231024220124

7 months ago

0.0.95-dev231019211822

7 months ago

0.0.94

7 months ago

0.0.94-dev231019191922

7 months ago

0.0.94-dev231019191913

7 months ago

0.0.94-dev231019135725

7 months ago

0.0.94-dev231018171714

7 months ago

0.0.94-dev231018163737

7 months ago

0.0.94-dev231018002545

7 months ago

0.0.94-dev231013165652

7 months ago

0.0.94-dev231011004826

7 months ago

0.0.94-dev231007180531

7 months ago

0.0.94-dev231006230622

7 months ago

0.0.94-dev231006134059

7 months ago

0.0.94-dev231005020107

7 months ago

0.0.94-dev231004153443

7 months ago

0.0.93

7 months ago

0.0.93-dev231004150027

7 months ago

0.0.93-dev231003232925

7 months ago

0.0.92

7 months ago

0.0.92-dev231003230104

7 months ago

0.0.92-dev231003222131

7 months ago

0.0.91

7 months ago

0.0.91-dev231003150049

7 months ago

0.0.90

7 months ago

0.0.90-dev231003020143

7 months ago

0.0.89

7 months ago

0.0.89-dev231003012946

7 months ago

0.0.89-dev231003010614

7 months ago

0.0.88-dev231003001139

7 months ago

0.0.88

7 months ago

0.0.88-dev231002235732

7 months ago

0.0.88-dev231002231014

7 months ago

0.0.88-dev230928193543

7 months ago

0.0.87

7 months ago

0.0.87-dev230928173500

7 months ago

0.0.86-dev230927172239

7 months ago

0.0.86-dev230923002041

8 months ago

0.0.86-dev230922233440

8 months ago

0.0.86-dev230922170928

8 months ago

0.0.86-dev230921221205

8 months ago

0.0.86-dev230920165629

8 months ago

0.0.85

8 months ago

0.0.85-dev230920161552

8 months ago

0.0.84-dev230920141302

8 months ago

0.0.84-dev230920123739

8 months ago

0.0.83

8 months ago

0.0.83-dev230919230232

8 months ago

0.0.83-dev230914211456

8 months ago

0.0.83-dev230913012343

8 months ago

0.0.82

8 months ago

0.0.82-dev230912235413

8 months ago

0.0.82-dev230912232244

8 months ago

0.0.82-dev230912225720

8 months ago

0.0.82-dev230912221500

8 months ago

0.0.82-dev230910221541

8 months ago

0.0.81-dev230910215758

8 months ago

0.0.81

8 months ago

0.0.81-dev230910215631

8 months ago

0.0.81-dev230910202545

8 months ago

0.0.81-dev230910191735

8 months ago

0.0.81-dev230909153000

8 months ago

0.0.80

8 months ago

0.0.80-dev230908173159

8 months ago

0.0.80-dev230907183434

8 months ago

0.0.80-dev230907131802

8 months ago

0.0.80-dev230906224042

8 months ago

0.0.80-dev230906223653

8 months ago

0.0.80-dev230905212201

8 months ago

0.0.80-dev230905175719

8 months ago

0.0.80-dev230903192621

8 months ago

0.0.80-dev230901211057

8 months ago

0.0.80-dev230830211713

8 months ago

0.0.80-dev230824170739

9 months ago

0.0.80-dev230822210650

9 months ago

0.0.79

9 months ago

0.0.79-dev230822184259

9 months ago

0.0.79-dev230822044438

9 months ago

0.0.79-dev230818134709

9 months ago

0.0.79-dev230818014736

9 months ago

0.0.78

9 months ago

0.0.78-dev230818012917

9 months ago

0.0.78-dev230818010117

9 months ago

0.0.78-dev230817214653

9 months ago

0.0.77

9 months ago

0.0.77-dev230817211501

9 months ago

0.0.77-dev230817205230

9 months ago

0.0.77-dev230817204655

9 months ago

0.0.76

9 months ago

0.0.76-dev230816000522

9 months ago

0.0.75-dev230815234740

9 months ago

0.0.75

9 months ago

0.0.75-dev230815215630

9 months ago

0.0.75-dev230815210351

9 months ago

0.0.75-dev230815181420

9 months ago

0.0.75-dev230815172342

9 months ago

0.0.74

9 months ago

0.0.74-dev230815162117

9 months ago

0.0.74-dev230812015425

9 months ago

0.0.73-dev230812013643

9 months ago

0.0.73

9 months ago

0.0.73-dev230812013509

9 months ago

0.0.72-dev230812013008

9 months ago

0.0.71

9 months ago

0.0.72-dev230812010035

9 months ago

0.0.71-dev230811223904

9 months ago

0.0.71-dev230811214741

9 months ago

0.0.71-dev230810221955

9 months ago

0.0.70

9 months ago

0.0.70-dev230810215741

9 months ago

0.0.70-dev230810160240

9 months ago

0.0.70-dev230810160210

9 months ago

0.0.70-dev230810153156

9 months ago

0.0.70-dev230809223439

9 months ago

0.0.69

9 months ago

0.0.69-dev230809221417

9 months ago

0.0.69-dev230808200646

9 months ago

0.0.68

9 months ago

0.0.68-dev230808194809

9 months ago

0.0.68-dev230808000650

9 months ago

0.0.67

9 months ago

0.0.67-dev230807234746

9 months ago

0.0.66-dev230807232724

9 months ago