Simple (testing/QA) data generator for tables.
Populator tries to guess what to insert into the table. It finds if the requested value is number. text, or primary key and its size.
Specify the amount of record to be created.
If it's checked, the data population will continue after error.
If it's unchecked the process will stop right after the first error.
Why there could be errors? It's simple. Sqlite doesn't supply any way to check e.g. constraints, or trigger modification on table before the statement run. So the error can be raised for example when you want to add already presented number into autoincrement column etc.
Setup every column with custom action. Column actions are prepared depending their data type and/or size.
Insert MAX()+1 for current number based column. Values inserted are unique, so it should be used for Primary Keys, Autonumber columns and columns with unique indexes.
Insert pseudo random number into column. If there is a size settings for this column (e.g. NUMBER(3)) the size is used.
Insert random text string into column. If there is a size settings for this column (e.g. VARCHAR2(3)) the size is used.
Insert text string with custom prefix. For example set the prefix as "testvalue_" then you'll get sequence of values: "testvalue_1", "testvalue_1", ..., "testvalue_N".
Insert custom constant value for all new records for current column.
Skip this column. No data will be inserted except default values for columns.
Remember that constraints are still active in the table. E.g. when you set a NOT NULL constrained column with Ignore Column option, you'll get a Constraint Violated error.