def connect_to_db(): db_name = pref.dbname_local db_user = pref.user_local db_password = pref.password_local db_localhost = pref.host_local db_port = pref.port_local cur, conn = pref.connect_to_db(db_name, db_user, db_password, db_localhost, db_port) return cur, conn
def main_work(): db_name = psql_preferences.dbname_local db_user = psql_preferences.user_local db_password = psql_preferences.password_local db_localhost = psql_preferences.host_local db_port = psql_preferences.port_local cur, conn = psql_preferences.connect_to_db(db_name, db_user, db_password, db_localhost, db_port) try: # добавление оценок событиям filling_rating_table(cur) conn.commit() except Exception as inst: print inst finally: psql_preferences.disconnect_from_db(cur, conn)