René's URL Explorer Experiment

{"@context":"https://schema.org","@type":"DiscussionForumPosting","headline":"For an sqlite table with a primary key that is AUTOINCREMENTED sqlautocode will fail (sqlite_sequence issue)","articleBody":"```\n In sqlite, when you create an autoincremented key, a sqlite_sequence table is created automatically. The problem is that this table has no primary key making sqlalchmey and sqlautocode fail with \"sqlalchemy.exc.ArgumentError: Mapper Mapper|Temporal|sqlite_sequence could not assemble any primary key columns for mapped table 'sqlite_sequence'\".\n\n The bigger problem is, however, that when you're trying to generate a declarative model (using the -d flag), the table filtering option is not working - or more accurately is not even handled.\n\nSimple schema:\nCREATE TABLE builds (\n            id INTEGER PRIMARY KEY AUTOINCREMENT,\n            repository TEXT,\n            revision TEXT,\n        );\n\nAnd try:\nsqlautocode -d -t builds sqlite:///builds.db\n\nI've attached a superficial fix for whoever needs it (python 2.6)\n\n```\n\nOriginal issue reported on code.google.com by `catalin....@gmail.com` on 26 Dec 2010 at 8:52\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":3},"url":"https://github.com/30/sqlautocode/issues/30"}