#!/usr/bin/python3
"""8-model_state_fetch_first"""
import sys
from sqlalchemy import create_engine, Column, Integer, String
from sqlalchemy.orm import sessionmaker
from sqlalchemy.ext.declarative import declarative_base
from model_state import Base, State
Base = declarative_base()
if __name__ == "__main__":
engine = create_engine('mysql+mysqldb://{}:{}@localhost/{}'
.format(sys.argv[1], sys.argv[2], sys.argv[3]))
Base.metadata.create_all(engine)
Session = sessionmaker(bind=engine)
session = Session()
states_name = session.query(State.name, State.id).all()
new_state = State()
new_state.id = len(states_name) + 1
new_state.name = "Louisiana"
print(new_state.id)
session.add(new_state)
session.commit()
session.close()
#!/usr/bin/python3
"""Start link class to table in database
"""
import sys
from sqlalchemy.orm.session import Session
from model_state import Base, State
from sqlalchemy.orm import sessionmaker
from sqlalchemy import (create_engine)
if __name__ == "__main__":
engine = create_engine('mysql+mysqldb://{}:{}@localhost/{}'.format(
sys.argv[1], sys.argv[2], sys.argv[3]),
pool_pre_ping=True)
Base.metadata.create_all(engine)
Session = sessionmaker(bind=engine)
session = Session()
lou_state = session.query(State.name, State.id).all()
popeyes = State()
popeyes.id = len(lou_state) + 1
popeyes.name = 'Louisiana'
print(popeyes.id)
session.add(popeyes)
session.commit()
session.close()
