Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

pwiz foreign key regex for sqlite #300

Closed
coleifer opened this issue Feb 1, 2014 · 0 comments
Closed

pwiz foreign key regex for sqlite #300

coleifer opened this issue Feb 1, 2014 · 0 comments

Comments

@coleifer
Copy link
Owner

coleifer commented Feb 1, 2014

Recent changes to the definition of foreign keys has caused pwiz to break when introspecting peewee-created sqlite tables.

Here is the table definition from peewee 2.1.6:

CREATE TABLE "fkpk" (
    "col_types_id" INTEGER NOT NULL PRIMARY KEY REFERENCES "coltypes" ("f11") 
);

Here it is for 2.2.0, broken:

CREATE TABLE "fkpk" (
    "col_types_id" INTEGER NOT NULL PRIMARY KEY, 
    FOREIGN KEY ("col_types_id") REFERENCES "coltypes" ("f11")
);
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

1 participant