<filename>operation/sql_function/get_max.py<gh_stars>1-10
from os import system

from operation.connector import conn
from statement.sqlStatement import getSqlStatement as get_sql_statment


def get_max_salary():
    system('clear')
    print('\t\n GET MAX SALARY \t\n')

    connect = conn()
    db_cursor = connect.cursor()

    db_cursor.execute(get_sql_statment('max'))

    data_result = db_cursor.fetchall()

    for data in enumerate(data_result, start=1):
        print(data[0],'\tName : ', data[1][0])
        print('\tSalary: ', data[1][1])
        print('\n')

    db_cursor.close()
    connect.close()

<filename>operation/sql_function/get_max.py<gh_stars>1-10
from os import system

from operation.connector import conn
from statement.sqlStatement import getSqlStatement as get_sql_statment


def get_max_salary():
    system('clear')
    print('\t\n GET MAX SALARY \t\n')

    connect = conn()
    db_cursor = connect.cursor()

    db_cursor.execute(get_sql_statment('max'))

    data_result = db_cursor.fetchall()

    for data in enumerate(data_result, start=1):
        print(data[0],'\tName : ', data[1][0])
        print('\tSalary: ', data[1][1])
        print('\n')

    db_cursor.close()
    connect.close()
