<reponame>AnthonyNg404/61A<filename>lab/lab13/tests/cyber-monday-part1.py
test = {
  'name': 'cyber-monday-part1',
  'points': 1,
  'suites': [
    {
      'cases': [
        {
          'code': r"""
          sqlite> SELECT category, ROUND(average_price) FROM average_prices;
          computer|109.0
          games|350.0
          phone|90.0
          """,
          'hidden': False,
          'locked': False
        }
      ],
      'ordered': False,
      'scored': True,
      'setup': r"""
      sqlite> .read lab13.sql
      """,
      'teardown': '',
      'type': 'sqlite'
    }
  ]
}

test = {
  'name': 'cyber-monday-part1',
  'points': 1,
  'suites': [
    {
      'cases': [
        {
          'code': r"""
          sqlite> SELECT category, ROUND(average_price) FROM average_prices;
          computer|109.0
          games|350.0
          phone|90.0
          """,
          'hidden': False,
          'locked': False
        }
      ],
      'ordered': False,
      'scored': True,
      'setup': r"""
      sqlite> .read lab13.sql
      """,
      'teardown': '',
      'type': 'sqlite'
    }
  ]
}
sqlite> SELECT category, ROUND(average_price) FROM average_prices;           computer|109.0           games|350.0           phone|90.0 sqlite> .read lab13.sql