Tools for database testing

An open source tool for easier database testing
March 9, 2022 – 08:29 am
Which database tools for testing should we choose?

Don't break any yarns.18F is dedicated to spreading modern software techniques like rigorous automated testing throughout the federal government; we want to showcase how solid testing enables rapid, high-quality development.

When the product is based on a large relational database, this poses a dilemma: the full production dataset is too unwieldy to duplicate to the test and development environments. Projects are typically tested against small hand-written test databases instead, but those simple constructs can’t duplicate the quirks and complexities of the production data set — and the most subtle application bugs will only be revealed when applied to those quirks.

Using a small subset of real production data is the ideal, but for relational databases that’s hard to accomplish — the mesh of foreign key relationships between tables can make extracting a limited yet valid subset of its tuples feel like trying to cut a little sweater out of a big sweater without snipping any yarns.

rdbms-subsetter postgresql://:@/proddb postgresql://:@/testdb 0.001

It should work against any database that SQLAlchemy supports. It guarantees referential integrity “upward” — every child record will have its required parent record. It also fills records “downward, ” providing child records for each parent record … but within limits (optionally tuned with -children) to avoid requiring the entire production database.

Available options include:

-logarithmic Determine the desired number of rows logarithmically, so that a proportionally smaller number of rows is taken from larger tables.rdbms-subsetter in action Using -logarithmic with fractions between 0.3 to 0.5 seems to produce reasonable results. -children set the number of child records per parent record to attempt to include (default 3) -force force rows of particular interest, with all their child and descendant records, into the test database -schema Include this schema in the results (otherwise, only pulls rows from the connection's default schema)

Like any open source project, we welcome your bug reports, feature requests, and code contributions. Since we’re 18F, filing any bugs you find — and optionally writing tests for them, or even fixing them — is not just encouraged, it’s downright patriotic. (cue inspiring music)

For open source enthusiasts, the potential to release work as open source projects is exciting and motivating. At 18F, our Default to Open policy means that releasing our work isn’t a favor to beg management for. It’s our everyday way of working — no questions asked and no hoops to jump through — and one of the joys of being on the 18F team.

good deeds and such good thoughts, good words, good deeds meaning good deeds movie cast 30 good deeds for ramadan pope francis good deeds ramadan good deeds example of good deeds good deeds ideas simple good deeds good deeds movie download good deeds full movie youtube hadith on good deeds good deeds inc good deeds good words good thoughts tyler perrys good deeds trailer good deeds pictures the good deeds man has done before athletes doing good deeds good deeds get you laid, remember that! ways to do good deeds everyday good deeds good deeds soundtrack songs good deeds belfast, maine good deeds in islam no good deeds dvd all good deeds good deeds quotes sayings my good deeds good thoughts good words good deeds quote watch good deeds online 100 good deeds bracelet example of good deeds 10 good deeds good deeds society minneapolis good deeds trailer subtitulado good deeds kids can do short stories on good deeds no good deeds movie time watch good deeds movie online free no download can good deeds get you to heaven good deeds for free the good deeds trailer good deeds to do for strangers doing good deeds collage no good deeds torrent stories of good deeds good deeds tyler perry full movie bible verse about doing good deeds in secret police good deeds spur one another on to love and good deeds our good deeds are like filthy rags good deeds thrift store outdo one another in love and good deeds what does the bible say about doing good deeds tyler perry's good deeds cast tyler perry no good deeds tyler perry good deeds movie police officers doing good deeds 2020 blessing good deeds quotes good deeds soundtrack watch tyler perry good deeds online free thandie newton good deeds hillary good deeds good thoughts, good words, good deeds three good deeds by vivian vande velde examples of good deeds for kids good deeds movie part 1 watch good deeds for free free good deeds don't do good deeds to be seen doing good deeds in secret islam good deeds movie poster keep doing good deeds good thoughts good words and good deeds tyler perry good deeds movie online
Related Posts