def main():
start_mapper()
# create all tables
metadata.create_all(bind=engine)
# initiate repository
user_repo = SqlRepository(session)
user = User("ed", "secret")
profile = Profile("John", "Doe", "*****@*****.**")
user.profile = profile
# add user and profile to database
user_repo.add(user)
# save
session.commit()
# query database
user = user_repo.get(username="******")
print(user, user.profile)
def main():
start_mapper()
metadata.create_all(bind=engine)
service.create_user("john", "secret", "admin")
def main():
start_mapper()
metadata.create_all(bind=engine)
try:
evn = event.NewUserEvent("john", "secret", "admin")
uow = unit_of_work.SqlAlchemyUnitOfWork()
result = messagebuss.handle(evn, uow)
print(result)
except ValueError:
pass
def main():
start_mapper()
# create all the tables
metadata.create_all(bind=engine)
# profile = create_profile("John", "Doe", "*****@*****.**")
# create_user("john", "secret", "admin", profile)
user = get_user_by_username("john")
print(user)
def setUp(self):
from sqlalchemy import create_engine
from sqlalchemy.orm import sessionmaker
# In-memory SQLite DB:
self.engine = create_engine('sqlite:///:memory:', echo=False)
# Create tables:
metadata.create_all(self.engine)
self.connection = self.engine.connect()
# Make a sessionmaker:
self.Session = sessionmaker(bind=self.engine)
self.session = self.Session(bind=self.connection)
def setUp(self):
from sqlalchemy import create_engine
from sqlalchemy.orm import sessionmaker
# In-memory SQLite DB:
self.engine = create_engine('sqlite:///:memory:', echo=False)
# Create tables:
metadata.create_all(self.engine)
self.connection = self.engine.connect()
# Make a sessionmaker:
self.Session = sessionmaker(bind=self.engine)
self.session = self.Session(bind=self.connection)
def main():
start_mapper()
# create all the tables
metadata.create_all(bind=engine)
# initiate uow
uow = SqlAlchemyUnitOfWork()
# user service
create_post("My Blog", "Post 1", ["python", "programming"], uow)
with uow:
blog = uow.repo.get("My Blog")
print("blog", blog)
print("posts", blog.posts)
print("Post 1, tags", blog.posts[0].tags)
def main():
start_mapper()
# create all the tables
metadata.create_all(bind=engine)
order = Order("ORD-1", "John Doe")
line1 = Line(order, "Product-1", 10)
line2 = Line(order, "Product-2", 20)
line3 = Line(order, "Product-3", 12)
# save
uow = SqlAlchemyUnitOfWork()
with uow:
uow.repo.add(order)
with uow:
order = uow.repo.get("ORD-1")
print(order.lines)
def main():
start_mapper()
metadata.create_all(bind=engine)
try:
lines = [
model.Line("Product 1", 10, 250),
model.Line("Product 2", 23, 350),
model.Line("Product 3", 14, 150),
]
cmd = command.CreateNewOrder(
firstname="John",
lastname="Doe",
country="Romania",
city="Bucharest",
)
uow = unit_of_work.SqlAlchemyUnitOfWork()
result = messagebus.handle(cmd, uow)
print(result)
except ValueError as err:
print(ValueError)
def in_memory_db():
engine = create_engine('sqlite:///:memory:')
metadata.create_all(engine)
return engine
def the_db():
# engine = create_engine('sqlite+pysqlite:///test.db', echo=True)
engine = create_engine('sqlite+pysqlite:///:memory:', echo=True)
metadata.create_all(engine)
return engine
# Foundation, Inc., 51 Franklin Street, Fifth Floor, Boston, MA 02110-1301
# USA
from sqlalchemy import create_engine
engine = create_engine('sqlite:///:memory:', echo=True)
#engine = create_engine('sqlite:///:memory:')
#engine = create_engine('sqlite:///test.sql', echo=True)
# Verify the connection to the DB:
engine.execute("select 1").scalar()
from orm import metadata
from firehose.model import Analysis, Issue, Failure, Info
# Create tables:
metadata.create_all(engine)
############################################################################
# Make a sessionmaker:
from sqlalchemy.orm import sessionmaker
Session = sessionmaker(bind=engine)
############################################################################
# Make a session:
session = Session()
# Use them
def simple_tests():
def postgres_db():
engine = create_engine(config.get_postgres_uri())
wait_for_postgres_to_come_up(engine)
metadata.create_all(engine)
return engine
def in_memory_db():
engine = create_engine('sqlite://', echo=True)
metadata.create_all(engine)
return engine
def sqllite_db():
engine = create_engine(config.get_sqllite_uri())
wait_for_sqllite_to_come_up(engine)
metadata.create_all(engine)
return engine
