databene benerator

databene benerator is a framework for creating realistic and valid high-volume test data, used for testing (unit/integration/load) and showcase setup.

Metadata constraints are imported from systems and/or configuration files. Data can be imported from and exported to files and systems, anonymized or generated from scratch. Domain packages provide reusable generators for creating domain-specific data as names and addresses internationalized in language and region. It is strongly customizable with plugins and configuration options.

This software is released under a dual license - GPL and commercial.

What is new in this release:

• This version fixes several major bugs and adds the feature of retrieving data from a specific tab in an Excel document.

What is new in version 0.7.5:

• Address.state resolves to a state object instead of the state id string. Use address.state.name and address.state.id to access state details
• dataset based generators support a fallback to other datasets belonging to the same superset
• variable causes NPE in empty loop
• WeightedLongGenerator always generates 0
• AddressGenerator always uses the same city
• US cities do not have a state assigned
• Brazil cities do not have a state assigned
• Swiss addresses do not have a street name that matches the canton's language
• all are German
• Some French street names in Switzerland have typos
• No error message if an update fails because of non-existent PK
• #3483733: PhoneNumberGenerator produces NPE
• #3483708: benerator fails to parse benerator.xml out of the box
• #3483739: Suffix .ben.xml is not respected
• #3429438: Wrong lineSeparator using SQLEntityExporter

What is new in version 0.7.1:

• This version fixes dependency inconsistencies which prevented users of Benerator 0.7.0 from running it in a Maven project.

What is new in version 0.6.6:

• Improved performance and fixed bugs.
• A memstore utility provides database-like features for tracking intermediary data.
• Simplified the transcoding of data graphs.
• Many smaller improvements from feature requests of Benerator users, e.g. extended formatting features for CSV-/FlatFile-/ScriptedEntityExporter. PersonGenerator and AddressGenerator can now be applied to composite regions like 'europe'.
• A new dependy checker verifies consistency of deployments.
• New DB Sanity features are supported.

What is new in version 0.6.5:

• This is a maintenance version that fixes critical bugs for Windows systems as well as for MySQL and PostgreSQL databases.
• Features were added for processing CSV files without header row.
• All users who are using release 0.6.4 are strongly encouranged to upgrade.

What is new in version 0.6.4:

• Added method to StorageSystem interface: void execute(String command)
• changed mapping JDBC BIGINT -> Java Long
• Introduced shortcut evaluation of && and || in BeneratorScript
• CompanyNameGenerator now generates CompanyName object with property-based access to name details (shortName, fullName, sector, location, legalForm)
• disabled schema validation of descriptor files
• DB Sanity support
• supporting lazy loading of database meta data
• SequenceTableGenerator
• PostalCodeValidator
• Message
• NoiseInducer: converter that induces statistical noise on numbers
• introduced 'catalog' attribute in
• recognition of a database user's default catalog and schema
• conditional evaluation of a descriptor:
• ConsoleExporter can be limited to display only the first n entities of each type fully and to emit only dots later
• new method DBSystem.tableExists(tableName)
• improved recognition of invalid sequence configuration
• Introduced DayGenerator for date generation of 'day' granularity
• database meta data buffering
• supporting central database definitions with 'environment' names, e.g.
• Checking if a setting has been defined:
• explicit error generation and process exit value determination, e.g. No environment specified
• new Converters:
• Char2StringConverter
• EscapingConverter
• Number2CharConverter
• Added org.databene.commons.format.* to default imports
• Automatic recognition of absolute Windows(TM) paths and Unix user home paths
• new consumers:
• BadDataConsumer
• ListConsumer
• Supporting pageSize == 0 (for sub s without own page /transaction handling)
• Supporting standard Java command line params in Project Wizard, e.g. -Duser.language=en -Duser.region=US
• Transcoding feature
• 3089196: The POM for xerces:XercesImpl:jar:2.9.1 is missing
• 3089078: Generated projects do not have an SLF4J binding
• 3089073: Bug in Timestamp format for second resolution
• 3157407: 'dataset' is not applied to StreetNameGenerator
• 3108933: nullQuota is not applied when using a script
• 3075892: Initialization fails with PostgreSQL
• 3075401: boolean value generation problem in postgresql 8.4
• NullPointerException on empty catalog name (PostgreSQL)
• DateTimeGenerator does not respect daylight savings times
• bugs in the demo folders
• time generation offset of DateTimeGenerator
• shutdown hook handling
• decimal number formatting in FlatFileEntityExporter
• big_decimal generation in sequences
• Script-based Distribution support in properties
• bug in evaluating minCount after task execution
• precision support in 'cumulated' sequence
• Empty weighted CSV causes ArrayIndexException
• Benerator Project Wizard crashes when the fields 'encoding', 'locale', 'line separator' or 'dataset' are empty
• Wrong distribution assembly:
• missing database drivers
• duplicate jar and test source

What is new in version 0.5.9 SR1:

• Added org.databene.benerator.primitive to default imports
• bug fixes:
• 2805329 DateTimeGenerator doesn't stop at maxDate
• 2805327 Time generation of DateTimeGenerator
• 2805254 milliseconds setting ignored in DateTimeGenerator
• 2797001 Bug in parsing composite foreign keys
• 2803686 not available in Context
• 2805574 BIGINT generation fails for DB2
• Fixed Country data of Cote d'Ivoire, Guinea, Libya, Monaco, Montserrat, Virgin Islands and Viet Nam

What is new in version 0.5.9:

• Added shell scripts for starting HSQL DB and HSQL Database Manager
• Added org.databene.commons.converter to the default imports
• Now script expressions can be used for all XML attributes in a descriptor file
• Included Jaybird (Firebird JDBC driver) in the distrubtion
• new shell script files hsqldb, hsql-manager und test-shop

What is new in version 0.5.8:

• This release provides many enhancements requested by the community, e.g. importing Excel(TM) sheets, support for the Firebird database, custom decimal separators like ',', female family names (in slavic languages), Russian names, project wizard support for non-database projects and a series of improvements in user convenience. All known bugs are fixed.