dridk / sqlite2duckdb

convert sqlite database to duckdb database
MIT License
8 stars 0 forks source link

CONSTRAINTS not export from sqlite to duckdb #1

Open Victordeleusse opened 2 months ago

Victordeleusse commented 2 months ago

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.

dridk commented 1 week ago

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

Victordeleusse commented 1 week ago

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

dridk commented 1 week ago

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