def print_func(): if (len(argv) != 4): return engine = create_engine('mysql+mysqldb://{}:{}@localhost/{}'.format( argv[1], argv[2], argv[3]), pool_pre_ping=True) Base.metadata.create_all(engine) Session = sessionmaker(bind=engine) session = Session() new_city = City(name="San Francisco") new_city.state = State(name="California") session.add(new_city) session.commit() session.close()
the City “San Francisco” from the database hbtn_0e_100_usa """ import sys from relationship_state import Base, State from relationship_city import City from sqlalchemy import (create_engine) from sqlalchemy.orm import sessionmaker if __name__ == "__main__": engine = create_engine('mysql+mysqldb://{}:{}@localhost:3306/{}' .format(sys.argv[1], sys.argv[2], sys.argv[3])) Base.metadata.create_all(engine) """Session object provides the entrypoint to acquire a Query object """ Session = sessionmaker(bind=engine) session = Session() """Insert a new State object to database """ add_state = State(name="California") add_city = City(name="San Francisco") add_city.state = add_state session.add(add_state) session.add(add_city) session.commit() """query() takes one or more entities and returns a new Query object which will issue mapper queries within the context of this Session """ session.close()
#!/usr/bin/python3 """ Creates the State “California” with the City “San Francisco” """ from sys import argv from relationship_state import Base, State from relationship_city import City from sqlalchemy import create_engine from sqlalchemy.orm import sessionmaker if __name__ == "__main__": engine = create_engine('mysql+mysqldb://{}:{}@localhost/{}'.format( argv[1], argv[2], argv[3]), pool_pre_ping=True) Base.metadata.create_all(engine) Session = sessionmaker(bind=engine) session = Session() state = State(name="California") city = City(name="San Francisco") city.state = state session.add(state) session.add(city) session.commit() session.close()
#!/usr/bin/python3 """ prints the State object with the name passed as argument from the database """ import sys from relationship_state import Base, State from relationship_city import City from sqlalchemy import (create_engine) from sqlalchemy.orm import sessionmaker from sqlalchemy.orm import relationship if __name__ == "__main__": engine = create_engine('mysql+mysqldb://{}:{}@localhost:3306/{}'.format( sys.argv[1], sys.argv[2], sys.argv[3])) Base.metadata.create_all(engine) Session = sessionmaker(bind=engine) session = Session() new_state = State(name='California') new_city = City(name='San Francisco') new_city.state = new_state session.add(new_city, new_state) session.commit()
#!/usr/bin/python3 """Alchemy Query for Relationship""" import sys from relationship_state import Base, State from relationship_city import City from sqlalchemy import (create_engine) from sqlalchemy.orm import sessionmaker from sqlalchemy.orm import relationship 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() my_state = State(name = "California") my_city = City(name = "San Francisco") my_city.state = my_state session.add(my_city, my_state) session.commit() session.close()
#!/usr/bin/python3 """Start link class to table in database """ import sys from sqlalchemy import create_engine from sqlalchemy.orm import sessionmaker from relationship_state import Base, State from relationship_city import City from sqlalchemy.orm import relationship 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() ins_state = State(name="California") ins_city = City(name="San Francisco") ins_city.state = ins_state session.add(ins_state) session.add(ins_city) session.commit() session.close()
#!/usr/bin/python3 """A script that creates the State “California” with the City “San Francisco” from the database hbtn_0e_100_usa """ from sys import argv from sqlalchemy import create_engine from sqlalchemy.orm import sessionmaker from relationship_city import Base, City from relationship_state import State if __name__ == "__main__": # engine = create_engine( # 'mysql+mysqldb://username:password@localhost/database') engine = create_engine('mysql+mysqldb://{}:{}@localhost/{}'.format( argv[1], argv[2], argv[3]), pool_pre_ping=True) Base.metadata.create_all(engine) # connect into the Session class Session = sessionmaker(bind=engine) # to have a conversation with the data base # i have to instantiate a Session session = Session() new_state_with_city = City(name="San Francisco") new_state_with_city.state = State(name="California") session.add(new_state_with_city) session.commit()
#!/usr/bin/python3 'prints the State object with the name passed as argument' from sys import argv import sys from relationship_state import Base, State from sqlalchemy import create_engine from sqlalchemy.orm import sessionmaker from relationship_city import City 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() addstate = State(name='California') addcity = City(name='San Francisco') addcity.state = addstate session.add(addstate) session.add(addcity) session.commit() session.close()