# pip install MySQL-python
import pymysql

FULL_LINE="jdbc:mysql://77.234.220.70:3306/competencyjpa?serverTimezone=Europe/Moscow"
URL = "jdbc:mysql://77.234.220.70:3306/"
LOGIN = "mastercjpa"
#TODO: it's so safe!!! XD
PASS = "TestPassword"
DB='competencyjpa'
ADDITIONS='serverTimezone=Europe/Moscow'

def main():
    print("starting")
    # getting first-&second- level skills amount
    conn = pymysql.connect(host=URL, user=LOGIN, password=PASS, db=DB)
    cursor = conn.cursor()

    firstSkillsReq = 'SELECT * FROM PROFILE'
    cursor.execute(firstSkillsReq)
    result = cursor.fetchone()
    print(result)

    conn.close()

if __name__ == "main":
    main()