condenser

condenser copied to clipboard

Writing subset to SQL file instead of to destination DB

2

Hi folks! This looks like a wonderful tool! I'm currently using [Jailer](https://github.com/Wisser/Jailer) to create DB subsets. That works fine, but you have to create the configuration using a GUI and...

DonDebonair

ignore some columns on copy_rows

1

Hi, is there a way to disable some table columns from `config.json` on copy_rows step? MySQL has **generated columns** feature. See docs [here](https://dev.mysql.com/doc/refman/5.7/en/create-table-generated-columns.html). So we can't insert or update value...

csonuryilmaz

Insert gives foreign key constraint error when correct dependency breaks are listed

1

Hi, I have a database with multiple foreign key constraints between tables, and a table that has self dependencies. I was able to fix the self dependency issue by listing...

ryan-riopelle

access denied on 'tonic_subset_temp_db_...'

2

Attempt to run direct_subset on two local MySQL databases, with a user that has all privileges on both source and target DBs, I get this: ```Traceback (most recent call last):...

abartov

subset_downstream generates incorrect SELECT queries if target table has multiple fk references

3

I noticed this just now while testing this tool against a client's database. They have several tables that each contain 2 columns that are referenced in foreign key relationships. Consider...

mjvotaw

Measuring Loss of Data when cutting an edge to remove a cycle

1

Greetings, I was reading the following article on subsetting: https://www.tonic.ai/blog/condenser-a-database-subsetting-tool I don't exactly understand what the faults are at dropping a cycle from a database. Of course, one loses data...

raresboza

Condenser hanging -- debugging options?

1

I've created a [public gist](https://gist.github.com/SimonGoring/c8f03f7c09ec77d0f5c71438ca9235f1) with my config file and a link to a dump of the database I'm applying condenser against. The issue I'm running into is that condenser...

SimonGoring

Bundling as package?

2

Hi, this is probably more of a feature request, but I've just found this project and it is exactly what I needed to help with the [Neotoma Paleoecology Database](https://neotomadb.org), to...

SimonGoring

PostgreSQL sequences need to be reset after subsetter is completed

2

Hey Tonic devs, I've been using your awesome tool for a couple of months now, and it's been so great to use! Something I noticed though is that after a...

binarydev

zoidyzoidzoid