def test_connect_to_postgres(self):
session = Client().session()
session2 = Client().session()
assert session is session2, 'multiple engines were created'
eq_(session.execute('select 1').fetchall(), [(1, )])
'filename': item['tag'],
'tag_name': tag})
session = Client().session()
metadata = MetaData(bind=Client()._engine)
temp_image_tag = Table(
'temp_image_tags',
metadata,
Column('tag_name', String, primary_key=True),
Column('filename', String, primary_key=True),
prefixes=['temporary'],
)
metadata.create_all()
session.execute(temp_image_tag.insert(image_tags))
session.execute(Image.__table__.insert(images))
session.execute(Tag.__table__.insert(tags))
#I can't figure out how to make sqlalchemy generate this query! :(
session.execute("""
insert into image_tag (image_id, tag_id) (
select
image.image_id,
tag.tag_id
from
temp_image_tags
inner join image using (filename)
inner join tag on tag.name = temp_image_tags.tag_name
)
""")
