Method parseModelTest

runtime/parser/parse_model.go:286–316

parseModelTests parses the model tests from the YAML file

(paths []string, name string, data *DataYAML, connector, modelName, assert string)

// parseModelTests parses the model tests from the YAML file
func (p *Parser) parseModelTest(paths []string, name string, data *DataYAML, connector, modelName, assert string) (*runtimev1.ModelTest, []ResourceName, error) {
	// Validate required name field
	if name == "" {
		return nil, nil, fmt.Errorf(`test must have a "name" defined`)
	}

	hasSQL := data.SQL != ""
	hasAssertion := assert != ""

	// Validate that exactly one of "sql" or "assert" is provided
	switch {
	case hasSQL && hasAssertion:
		return nil, nil, fmt.Errorf(`test %q must not have both "sql" and "assert" defined`, name)
	case !hasSQL && !hasAssertion:
		return nil, nil, fmt.Errorf(`test %q must have either "sql" or "assert" defined`, name)
	case hasAssertion:
		// Wrap assertion condition in a SQL query following SQLMesh audit pattern
		// Query for rows that violate the assertion (bad data)
		data.SQL = fmt.Sprintf("SELECT * FROM %s WHERE NOT (%s)", modelName, assert)
	}

	resolver, props, refs, err := p.parseDataYAML(paths, data, connector)
	if err != nil {
		return nil, nil, err
	}
	return &runtimev1.ModelTest{
		Name:               name,
		Resolver:           resolver,
		ResolverProperties: props,
	}, refs, nil
}

// inferSQLRefs attempts to infer table references from the node's SQL.
// The provided node must have a non-empty SQL field.