# -*- coding: utf-8 -*-

from api.rdb import db_cursor


# noinspection PyUnusedLocal,PyUnusedLocal,PyUnusedLocal,PyUnusedLocal
def test(empty_database, create_and_delete_user):
    with db_cursor() as cursor:
        cursor.execute(
            "SELECT column_name, data_type FROM INFORMATION_SCHEMA.COLUMNS WHERE table_name ='user_blocked'"
        )
        column_names = set(name for name, _ in cursor.fetchall())

        assert 5 == len(column_names)

        assert 'id' in column_names
        assert 'created_at' in column_names
        assert 'updated_at' in column_names

        assert 'recipient_username_id' in column_names
        assert 'blocked_username_id' in column_names

# -*- coding: utf-8 -*-

from api.rdb import db_cursor


# noinspection PyUnusedLocal,PyUnusedLocal,PyUnusedLocal,PyUnusedLocal
def test(empty_database, create_and_delete_user):
    with db_cursor() as cursor:
        cursor.execute(
            "SELECT column_name, data_type FROM INFORMATION_SCHEMA.COLUMNS WHERE table_name ='user_blocked'"
        )
        column_names = set(name for name, _ in cursor.fetchall())

        assert 5 == len(column_names)

        assert 'id' in column_names
        assert 'created_at' in column_names
        assert 'updated_at' in column_names

        assert 'recipient_username_id' in column_names
        assert 'blocked_username_id' in column_names

# -*- coding: utf-8 -*- # noinspection PyUnusedLocal,PyUnusedLocal,PyUnusedLocal,PyUnusedLocal