There is a database that is handled by a Java application. DB contains two tables. The first table is users. It consists of name, surname, date of birth, gender and department. The second table is the departments. Consists of department number and name. You need to fill this database with test data so that it has several departments and in each department several dozen users. This type of name is Name11, LastName11; Name 21, Surname21, etc. With what tools can this be done?

Closed due to the fact that the essence of the question is not clear to the participants of the D-side , cheops , aleksandr barakin , dirkgntly , insolor Aug 21 '16 at 12:13 .

Try to write more detailed questions. To get an answer, explain what exactly you see the problem, how to reproduce it, what you want to get as a result, etc. Give an example that clearly demonstrates the problem. If the question can be reformulated according to the rules set out in the certificate , edit it .

  • What is "test data"? as usual lorem ipsum and images lorem pixel - user33274
  • describe in more detail or transfer the question to экстрасенсы.stackoverflow.com - dirkgntly
  • @dDevil, corrected the question. - jisecayeyo
  • @Geyan, added a question. - jisecayeyo
  • one
    @jisecayeyo take any generator and .... generate .... to fill the test data java not needed. - Alexey Shimansky

1 answer 1

For example, you can use the online service Generatedata.com or mockaroo.com

You just need to specify the type of columns, their names and in what format to export (SQLs, HTML, Excel, XML, CSV).

Example of Generatedata :

enter image description here

will generate:

enter image description here

Datagenerator and Test Data Generator For MySQL Databases - programs that will help generate data.

You can also use the method of self- joining tables on our favorite ruSO. True, the data here will be copied and will not be much unique for each line (unlike the data generated through the utilities described above)