René's URL Explorer Experiment

{"@context":"https://schema.org","@type":"DiscussionForumPosting","headline":"sqlautocode generates foreign keys but not relation information","articleBody":"```\nWhat steps will reproduce the problem?\n1. With attached sql create a MySQL db\n2. run sqlautocode -d mysql://localhost/dbname -o model.py\n\nWhat is the expected output? What do you see instead?\nExpected: generated relation definitions \nInstead got:\nsamples = Table(u'samples', metadata,\n    Column(u'id', SMALLINT(), primary_key=True, nullable=False),\n    Column(u'name', VARCHAR(length=45, convert_unicode=False, assert_unicode=None, unicode_error=None, _warn_on_bytestring=False), nullable=False),\n    Column(u'experiment_id', SMALLINT(), ForeignKey('experiments.id'), nullable=False),\n    Column(u'timepoint_id', SMALLINT(), ForeignKey('timepoints.id'), nullable=False),\n)\n\nsamples2conditions = Table(u'samples2conditions', metadata,\n    Column(u'condition_id', SMALLINT(), ForeignKey('conditions.id'), primary_key=True, nullable=False),\n    Column(u'sample_id', SMALLINT(), ForeignKey('samples.id'), primary_key=True, nullable=False),\n)\n\nclass Condition(DeclarativeBase):\n    __tablename__ = 'conditions'\n\n    #column definitions\n    experiment_id = Column(u'experiment_id', SMALLINT(), ForeignKey('experiments.id'), nullable=False)\n    id = Column(u'id', SMALLINT(), primary_key=True, nullable=False)\n    name = Column(u'name', VARCHAR(length=45, convert_unicode=False, assert_unicode=None, unicode_error=None, _warn_on_bytestring=False), nullable=False)\n\n    #relation definitions\n\n\nclass Experiment(DeclarativeBase):\n    __tablename__ = 'experiments'\n\n    #column definitions\n    id = Column(u'id', SMALLINT(), primary_key=True, nullable=False)\n    name = Column(u'name', VARCHAR(length=45, convert_unicode=False, assert_unicode=None, unicode_error=None, _warn_on_bytestring=False), nullable=False)\n\n    #relation definitions\n\n\nclass Sample(DeclarativeBase):\n    __table__ = samples\n\n\n    #relation definitions\n\n\nclass Timepoint(DeclarativeBase):\n    __tablename__ = 'timepoints'\n\n    #column definitions\n    experiment_id = Column(u'experiment_id', SMALLINT(), ForeignKey('experiments.id'), nullable=False)\n    id = Column(u'id', SMALLINT(), primary_key=True, nullable=False)\n    name = Column(u'name', VARCHAR(length=45, convert_unicode=False, assert_unicode=None, unicode_error=None, _warn_on_bytestring=False), nullable=False)\n\n    #relation definitions\n\n\n\n\n\nWhat version of the product are you using? On what operating system?\n* MySQL 5.1.47\n* archlinux\n* sqlautocode 0.6b1 (with issue27 patch)\n* sqlalchemy 0.6.5\n* python 2.7\n\n\n\nAnyone any clue why these don't show up?\n\nKenny\n```\n\nOriginal issue reported on code.google.com by `kennybil...@gmail.com` on 10 Jan 2011 at 3:56\n","author":{"url":"https://github.com/GoogleCodeExporter","@type":"Person","name":"GoogleCodeExporter"},"datePublished":"2015-12-02T03:31:35.000Z","interactionStatistic":{"@type":"InteractionCounter","interactionType":"https://schema.org/CommentAction","userInteractionCount":5},"url":"https://github.com/31/sqlautocode/issues/31"}