from sqlalchemy import create_engine, Column, Integer, String
from sqlalchemy.orm import sessionmaker
from sqlalchemy.ext.declarative import declarative_base

engine = create_engine('sqlite:///my_resume.sqlite', echo=True)
Session = sessionmaker(bind=engine)
Base = declarative_base()

class Resume(Base):
    __tablename__ = 'resume_table'
    id = Column(Integer, primary_key=True)
    question = Column(String)
    answer = Column(String)

Base.metadata.create_all(engine)

def resume():
    name = input('What`s your name?: ')
    birthday = input('What`s your date of birth: ')
    work_experience = input('What was your work experience?: ')
    phone_number = input('What is your phone number?: ')
    address = input('What is your address?: ')
    print(f'Name - {name}'
          f'\nBirthday - {birthday}'
          f'\nWork experience - {work_experience}'
          f'\nPhone number - {phone_number}'
          f'\nAddress - {address}')
    resume_text(name, birthday, work_experience, phone_number, address)

def resume_text(name, birthday, work_experience, phone_number, address):
    session = Session()
    session.add(Resume(question='Name', answer=name))
    session.add(Resume(question='Birthday', answer=birthday))
    session.add(Resume(question='Work experience', answer=work_experience))
    session.add(Resume(question='Phone number', answer=phone_number))
    session.add(Resume(question='Address', answer=address))
    session.commit()
    session.close()

try:
    first_y_or_n = input('Want to start?: ')
    if first_y_or_n == 'y':
        resume()
    elif first_y_or_n == 'n':
        print('Exit...')
except Exception as exc:
    print(f'Error {exc}')