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()
