#!/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()