Method assertTasks

cli/api/dbadapters/execution_sql.ts:207–219

(
    assertion: dataform.IAssertion,
    projectConfig: dataform.IProjectConfig,
  )

  }

  public assertTasks(
    assertion: dataform.IAssertion,
    projectConfig: dataform.IProjectConfig,
  ): Tasks {
    const tasks = new Tasks();
    const target = assertion.target;
    // Create the view to check syntax of assertion
    tasks.add(Task.statement(this.createOrReplaceView(target, assertion.query)));

    // Add assertion check
    tasks.add(Task.assertion(`select sum(1) as row_count from ${this.resolveTarget(target)}`));
    return tasks;
  }

  public dropIfExists(target: dataform.ITarget, type: dataform.TableMetadata.Type) {
    return `drop ${this.tableTypeAsSql(type)} if exists ${this.resolveTarget(target)}`;