SQL提交正确性测试

导航

已验证详细信息

这些详细信息已由PyPI 验证
维护者
Avatar for datacamp from gravatar.com datacamp Avatar for machow from gravatar.com machow

未验证详细信息

这些详细信息 尚未 由PyPI验证
项目链接
元数据
分类

项目描述

sqlwhat

Build Status PyPI version

sqlwhat 允许您为DataCamp上的交互式SQL练习编写提交正确性测试 (SCT)。

安装

pip install sqlwhat     # install from pypi
make install            # install from source

参考

提出关于SQL解析的问题

请在相应的解析器存储库上提出问题

基本用法

from sqlwhat.State import State    # State holds info needed for tests
from sqlwhat.Reporter import Reporter
from sqlwhat.checks import *       # imports all SCTs
from sqlalchemy import create_engine

code = "SELECT * FROM artists WHERE id < 100"

state = State(
    student_code = code,
    solution_code = code,
    pre_exercise_code = "",
    student_conn = create_engine('sqlite:///'),
    solution_conn = create_engine('sqlite:///'),
    student_result = {'id': [1,2,3], 'name': ['greg', 'jon', 'martha']},
    solution_result = {'id': [1,2,3], 'name': ['toby', 'keith', 'deb']},
    reporter = Reporter()
    )

# test below passes, since code is equal for student and solution
has_equal_ast(state)

# test below raises a TestFail error, since 'name' col of results
# doesn't match between student and solution results
check_result(state)
# shows error data
state.reporter.build_payload()

# can also be done using a chain
from sqlwhat.sct_syntax import Ex
Ex(state).check_result()

运行单元测试

pytest -m "not backend"

如果您还想运行后端测试，您需要设置一个具有访问 (私有) sqlbackend 存储库的 GITHUB_TOKEN 环境变量。之后，您可以

make install
pytest

测试规则

  1. 运行查询是后端的工作
  2. 如果一个测试不运行查询，则不需要后端
  3. 应该很少的测试需要运行查询

构建文档

安装sqlwhat并运行...

cd docs
make html

支持者：