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