import pandas as pd
from pandas.testing import assert_frame_equal
import pytest


def assert_dataframes_equals(expected, actual):
    assert expected.shape==actual.shape
    assert set(expected.columns) == set(actual.columns)
    columns_order = list(expected.columns)
    a = actual[columns_order].sort_values(by=list(actual.columns)).reset_index(drop=True)
    e = expected[columns_order].sort_values(by=list(actual.columns)).reset_index(drop=True)
    assert_frame_equal(e, a, check_dtype=False)


def get_expected_and_actual(df):
    actual_query_string = df.df_sql_convert_table.get_sql_string()
    actual_columns = df.df_sql_convert_table.columns
    datetime_columns = [c for c in actual_columns.keys() if actual_columns[c].dtype == 'DATETIME']

    df_actual = pd.read_sql_query(actual_query_string, pytest.sql_connection, parse_dates=datetime_columns)
    df_expected = df.df_pandas

    return df_expected, df_actual

def assert_(df):
    df_expected, df_actual = get_expected_and_actual(df)

    # i = df_expected.new_value != df_actual.new_value
    # a=df_expected[i][:3]
    # b=df_expected[i][:3]

    assert_dataframes_equals(df_expected, df_actual)
