def test_join_pk_collapse_explicit(self):

        meta = MetaData()
        a = Table('a', meta, Column('id', Integer, primary_key=True),
                  Column('x', Integer))
        b = Table('b', meta, Column('id', Integer, ForeignKey('a.id'),
                                    primary_key=True), Column('x', Integer))
        c = Table('c', meta, Column('id', Integer, ForeignKey('b.id'),
                                    primary_key=True), Column('x', Integer))
        d = Table('d', meta, Column('id', Integer, ForeignKey('c.id'),
                                    primary_key=True), Column('x', Integer))
        print(list(a.join(b, a.c.x == b.c.id).primary_key))
        assert list(a.join(b, a.c.x == b.c.id).primary_key) == [a.c.id]
        assert list(b.join(c, b.c.x == c.c.id).primary_key) == [b.c.id]
        assert list(a.join(b).join(c, c.c.id == b.c.x).primary_key) \
            == [a.c.id]
        assert list(b.join(c, c.c.x == b.c.id).join(d).primary_key) \
            == [b.c.id]
        assert list(b.join(c, c.c.id == b.c.x).join(d).primary_key) \
            == [b.c.id]
        assert list(
            d.join(
                b,
                d.c.id == b.c.id).join(
                c,
                b.c.id == c.c.x).primary_key) == [
            b.c.id]
        assert list(a.join(b).join(c, c.c.id
                                   == b.c.x).join(d).primary_key) == [a.c.id]
        assert list(a.join(b, and_(a.c.id == b.c.id, a.c.x
                                   == b.c.id)).primary_key) == [a.c.id]
Return string with x number of spaces
dataset/ETHPy150Open zzzeek/sqlalchemy/test/sql/test_selectable.py/PrimaryKeyTest.test_join_pk_collapse_explicit--crossover with--dataset/ETHPy150Open travishathaway/python-ach/ach/data_types.py/Ach.make_space