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)
