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

CONSTRAINTS not export from sqlite to duckdb #1

Open
Victordeleusse opened this issue Sep 5, 2024 · 3 comments
Open

CONSTRAINTS not export from sqlite to duckdb #1

Victordeleusse opened this issue Sep 5, 2024 · 3 comments

Comments

@Victordeleusse
Copy link

Hello there.
After having used sqlite2duckdb, i have tried to get my constraints from the database through the command

query_pkey = """

                SELECT kcu.table_name, kcu.column_name

                FROM information_schema.table_constraints AS tc

                JOIN information_schema.key_column_usage AS kcu

                ON tc.constraint_name = kcu.constraint_name

                WHERE tc.constraint_type = 'PRIMARY KEY'"""

primary_keys = con.execute(query_pkey).fetchall()

But unfortunatly the constraints from the sqlite database haven't been transferred to the duckdb database.

@Victordeleusse Victordeleusse changed the title information_schema.table_constraints and key_column_usage always list "memory" for table_catalog on attached databases - CONSTRAINTS are not then well export CONSTRAINTS not export from sqlite to duckdb Sep 5, 2024
@dridk
Copy link
Owner

dridk commented Oct 23, 2024

Yes, sorry.. I didn't yet implement constraint. I am on it.

@Victordeleusse
Copy link
Author

@dridk if you need any help on this it would be an honnor to contribute ;) !

@dridk
Copy link
Owner

dridk commented Oct 28, 2024

Of course, you can create au pull requests if you want. It will be helpful

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

2 participants