# Class: FixtureCteBuilder

Defined in: packages/core/src/transformers/FixtureCteBuilder.ts:21

Constructors

Constructor

new FixtureCteBuilder(): FixtureCteBuilder

Returns

FixtureCteBuilder

Methods

fromSQL()

static fromSQL(sql): FixtureTableDefinition[]

Defined in: packages/core/src/transformers/FixtureCteBuilder.ts:28

Creates fixture definitions from a SQL string containing DDL (CREATE TABLE) and INSERT statements.

Parameters

sql

string

The SQL string containing DDL and INSERTs.

Returns

FixtureTableDefinition[]

An array of FixtureTableDefinition objects.

---

fromJSON()

static fromJSON(jsonDefinitions): FixtureTableDefinition[]

Defined in: packages/core/src/transformers/FixtureCteBuilder.ts:57

Converts JSON fixture definitions to FixtureTableDefinition format. Accepts an object where keys are table names and values contain columns and rows.

Parameters

jsonDefinitions

Record<string, { columns: object[]; rows?: Record<string, any&gt;[]; }>

Object with table definitions

Returns

FixtureTableDefinition[]

Array of FixtureTableDefinition

Example

const json = {
  users: {
    columns: [
      { name: 'id', type: 'integer' },
      { name: 'name', type: 'text' }
    ],
    rows: [
      { id: 1, name: 'Alice' },
      { id: 2, name: 'Bob' }
    ]
  }
};
const fixtures = FixtureCteBuilder.fromJSON(json);

---

buildFixtures()

static buildFixtures(fixtures): CommonTable[]

Defined in: packages/core/src/transformers/FixtureCteBuilder.ts:94

Builds CommonTable representations for the provided fixtures.

Parameters

fixtures

FixtureTableDefinition[]

Returns

CommonTable[]