Esempi in Python per SQLRunner.execute_update_file

Esempio n. 1

File: test_index.py Progetto: learn-co-students/sql-basic-operations-lab-data-science

def test_update_jupiter():
    sql_runner = SQLRunner()
    table = sql_runner.execute_alter_file()
    table_values = sql_runner.execute_insert_file()
    update = sql_runner.execute_update_file()
    result = 68

    assert table_values.execute(
        "SELECT num_of_moons FROM planets WHERE name = 'Jupiter';").fetchone(
        )[0] == result

Esempio n. 2

File: test_update.py Progetto: znob/sql-sports-leagues-lab-nyc-career-ds-102218

import unittest, sys
from sql_runner import SQLRunner
sys.path.insert(0, '..')
from queries import *

sql_runner = SQLRunner()
cursor = sql_runner.execute_create_file()
cursor = sql_runner.execute_insert_file()
cursor = sql_runner.execute_update_file()


class TestUpdateTables(unittest.TestCase):
    def test_metta_world_peace(self):
        self.assertEqual(
            cursor.execute(
                "SELECT name FROM players WHERE id = 1;").fetchone()[0],
            "Metta World Peace")

    def test_chad_ochocinco(self):
        self.assertEqual(
            cursor.execute(
                "SELECT name FROM players WHERE id = 4;").fetchone()[0],
            "Chad OchoCinco")