Add option to exclude or include objects #143
Description
Please if possible add an option to exclude (problematic) objects.
I just had a DB that fails conversion because of a trully buggy CREATE TABLE on source. But I can live with that table.
If such option existed, I would use it like:
sqlite3mysql ... --exclude-objects scrobble_buffer,other_table,other_index ...For reference, the buggy Navidrome table it is trying to convert has following schema:
CREATE TABLE scrobble_buffer
(
user_id varchar not null
constraint scrobble_buffer_user_id_fk
references user
on update cascade on delete cascade,
service varchar not null,
media_file_id varchar not null
constraint scrobble_buffer_media_file_id_fk
references media_file
on update cascade on delete cascade,
play_time datetime not null,
enqueue_time datetime not null default current_timestamp, id varchar not null default '',
constraint scrobble_buffer_pk
unique (user_id, service, media_file_id, play_time, user_id)
);The problem is a duplicate user_id in the constraint scrobble_buffer_pk. Apparently SQLite doesn't have issues with this kind of inconsistencies. But MariaDB wont allow it. So if you want to handle this kind of inconsistencies in the tool too...
If you want, I can send you my full SQLite database so you'll have a real world thing to test on.