Получаю ошибку при правильных отступах - unindent does not match any outer indentation level

[Artem20012022]

Пишу код, везде ставлю один или два таба в качестве отступов, но все равно ругается на отступы. Где у меня ошибка?

if __name__ == '__main__':
    print("start =", datetime.datetime.now())
    sm.start_procedure()
    for query in ch_queries["tables_clearing"]:
        CH_CLIENT.execute(query, settings=settings)
    kpi_months = pd.DataFrame(CH_CLIENT.execute(ch_queries["months_range"]["kpi"], settings=settings))[0].to_list()
    for month in kpi_months:
        query = ch_queries["monthly_insert"]["kpi"].replace('{{{month}}}', str(month))
        CH_CLIENT.execute(query, settings=settings)
    fact_months = pd.DataFrame(CH_CLIENT.execute(ch_queries["months_range"]["fact"], settings=settings))[0].to_list()
    for month in fact_months:
        query = ch_queries["monthly_insert"]["fact"].replace('{{{month}}}', str(month))
        CH_CLIENT.execute(query, settings=settings)
    df = pd.DataFrame(CH_CLIENT.execute(ch_queries['final_calculation'], settings=settings))
    df_csv = df.to_csv(sep='^', index=False, header=False, quoting=3)
    print("end =", datetime.datetime.now())
    print(df)
    sm.end_procedure()

 

[Ципихович Эндрю]

код то не весь, ругается:
NameError: name 'datetime' is not defined

 

[Artem20012022]

Вот весь. Мне надо ввести print(df) чтобы понять загружается ли что нибудь в базу

import vertica_python

from clickhouse_driver.client import Client

from config import CH_CREDS, VERTICA_CREDS, Schema, KPI_Version

from sql_queries_kpi_vertica import QUERIES as vertica_queries

from sql_queries_kpi_ch import QUERIES as ch_queries

import pandas as pd

import datetime

import send_message_slack as sm



settings = {'max_memory_usage': 200000000000}

CH_CLIENT = Client(**CH_CREDS)



if __name__ == '__main__':

   print("start =", datetime.datetime.now())

   sm.start_procedure()

   for query in ch_queries["tables_clearing"]:

      CH_CLIENT.execute(query, settings=settings)

   kpi_months = pd.DataFrame(CH_CLIENT.execute(ch_queries["months_range"]["kpi"], settings=settings))[0].to_list()

   for month in kpi_months:

      query = ch_queries["monthly_insert"]["kpi"].replace('{{{month}}}', str(month))

      CH_CLIENT.execute(query, settings=settings)

   fact_months = pd.DataFrame(CH_CLIENT.execute(ch_queries["months_range"]["fact"], settings=settings))[0].to_list()

   for month in fact_months:

      query = ch_queries["monthly_insert"]["fact"].replace('{{{month}}}', str(month))

      CH_CLIENT.execute(query, settings=settings)

   df = pd.DataFrame(CH_CLIENT.execute(ch_queries['final_calculation'], settings=settings))

   df_csv = df.to_csv(sep='^', index=False, header=False, quoting=3)

   print("end =", datetime.datetime.now())

    print(df)

    sm.end_procedure()

  """  cols = tuple(df.columns)

    with vertica_python.connect(**VERTICA_CREDS) as connection:

        cur = connection.cursor('')

        cur.execute(truncate table {{{Schema}}}.DM_Supplier_Daily_KPI;.replace('{{{Schema}}}', Schema))

        cur.copy(COPY {{{Schema}}}.DM_Supplier_Daily_KPI

                    from stdin DELIMITER '^'  ENCLOSED BY '\'

                    .replace('{{{Schema}}}', Schema).format(cols),

                 df_csv)

        connection.commit()

    print("insert dm =", datetime.datetime.now())

    i = 0

    with vertica_python.connect(**VERTICA_CREDS) as connection:

        for script in vertica_queries:

            script = script.replace('{{{KPI_Version}}}', KPI_Version)

            script = script.replace('{{{Schema}}}', Schema)

            i += 1

            print(i, datetime.datetime.now())

            cur = connection.cursor()

            cur.execute(script)

            connection.commit()

    print("end =", datetime.datetime.now())

    print('finish')

    sm.end_procedure() """

 

[regnor]

Вот весь. Мне надо ввести print(df) чтобы понять загружается ли что нибудь в базу

import vertica_python

from clickhouse_driver.client import Client

from config import CH_CREDS, VERTICA_CREDS, Schema, KPI_Version

from sql_queries_kpi_vertica import QUERIES as vertica_queries

from sql_queries_kpi_ch import QUERIES as ch_queries

import pandas as pd

import datetime

import send_message_slack as sm



settings = {'max_memory_usage': 200000000000}

CH_CLIENT = Client(**CH_CREDS)



if __name__ == '__main__':

   print("start =", datetime.datetime.now())

   sm.start_procedure()

   for query in ch_queries["tables_clearing"]:

      CH_CLIENT.execute(query, settings=settings)

   kpi_months = pd.DataFrame(CH_CLIENT.execute(ch_queries["months_range"]["kpi"], settings=settings))[0].to_list()

   for month in kpi_months:

      query = ch_queries["monthly_insert"]["kpi"].replace('{{{month}}}', str(month))

      CH_CLIENT.execute(query, settings=settings)

   fact_months = pd.DataFrame(CH_CLIENT.execute(ch_queries["months_range"]["fact"], settings=settings))[0].to_list()

   for month in fact_months:

      query = ch_queries["monthly_insert"]["fact"].replace('{{{month}}}', str(month))

      CH_CLIENT.execute(query, settings=settings)

   df = pd.DataFrame(CH_CLIENT.execute(ch_queries['final_calculation'], settings=settings))

   df_csv = df.to_csv(sep='^', index=False, header=False, quoting=3)

   print("end =", datetime.datetime.now())

    print(df)

    sm.end_procedure()

  """  cols = tuple(df.columns)

    with vertica_python.connect(**VERTICA_CREDS) as connection:

        cur = connection.cursor('')

        cur.execute(truncate table {{{Schema}}}.DM_Supplier_Daily_KPI;.replace('{{{Schema}}}', Schema))

        cur.copy(COPY {{{Schema}}}.DM_Supplier_Daily_KPI

                    from stdin DELIMITER '^'  ENCLOSED BY '\'

                    .replace('{{{Schema}}}', Schema).format(cols),

                 df_csv)

        connection.commit()

    print("insert dm =", datetime.datetime.now())

    i = 0

    with vertica_python.connect(**VERTICA_CREDS) as connection:

        for script in vertica_queries:

            script = script.replace('{{{KPI_Version}}}', KPI_Version)

            script = script.replace('{{{Schema}}}', Schema)

            i += 1

            print(i, datetime.datetime.now())

            cur = connection.cursor()

            cur.execute(script)

            connection.commit()

    print("end =", datetime.datetime.now())

    print('finish')

    sm.end_procedure() """

если это то что вы запускаете, то отступы у вас не одинаковые...
и в кавычках в конце у вас что? если вы думаете, что закомментировали это, то нет...

 

[Ципихович Эндрю]

юзайте Пайчарм там волнистой красной линией проблемные места подчеркнёт