Is there a way to export a sample by a table row?

Question

Is there a way to export a sample by a table row?

motishaku opened this issue 2 years ago · 3 comments

hey,
as the title asks, is there a way to export a sample of the db based on the relationships and the data from a single table?
example:
start from table A where the query given is A.id=1, go through all the tables foreign keys, and export the relavent data?

thanks in advance!

Answer 1 · 2023-02-12T19:07:08.000Z

Interesting. I don't think there is currently, sorry. I think you'd need to add --limit= rules for every table's FK where it -> a.id=1.

Answer 2 · 2023-02-12T19:10:00.000Z

Thanks, but i have over 200 tables.
Do you plan by chance to add it one day?
I would, but i never touched Perl, if not, i might create a rust version tho if fine by you

Answer 3 · 2023-02-12T19:42:21.000Z

I'm open to adding that. Need to think about how it would be expressed. I'm a bit swamped currently so prob wouldn't be fast regardless. A rust version would be cool.