/usr/share/doc/sqliteman/en/ch07s05.html is in sqliteman-doc 1.2.2-0ubuntu6.
This file is owned by root:root, with mode 0o644.
The actual contents of the file can be viewed below.
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 | <html><head><meta http-equiv="Content-Type" content="text/html; charset=UTF-8"><title>Populate Table</title><link rel="stylesheet" href="kde-default.css" type="text/css"><meta name="generator" content="DocBook XSL Stylesheets V1.67.2"><meta name="keywords" content="Sqliteman, SQL, Sqlite, development, database"><link rel="start" href="index.html" title="The Sqliteman Handbook"><link rel="up" href="ch07.html" title="Chapter 7. Features and Dialogs"><link rel="prev" href="ch07s04.html" title="Import Table Data"><link rel="next" href="ch07s06.html" title="View related dialogs"></head><body bgcolor="white" text="black" link="#0000FF" vlink="#840084" alink="#0000FF"><div class="navheader"><table width="100%" summary="Navigation header"><tr><th colspan="3" align="center">Populate Table</th></tr><tr><td width="20%" align="left"><a accesskey="p" href="ch07s04.html">Prev</a> </td><th width="60%" align="center">Chapter 7. Features and Dialogs</th><td width="20%" align="right"> <a accesskey="n" href="ch07s06.html">Next</a></td></tr></table><hr></div><div class="sect1" lang="en"><div class="titlepage"><div><div><h2 class="title" style="clear: both"><a name="populateTable"></a>Populate Table</h2></div></div></div><p>Simple (testing/QA) data generator for tables.</p><p>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.</p><p>
</p><div class="screenshot"><div class="mediaobject"><img src="populateTable.png" alt="Populate Table dialog"></div></div><p>
</p><div class="variablelist"><dl><dt><span class="term">Number of Rows to Populate</span></dt><dd><p>Specify the amount of record to be created.</p></dd><dt><span class="term">Continue on Error</span></dt><dd><p>If it's checked, the data population will continue after error.</p><p>If it's unchecked the process will stop right after the first error.</p><div class="important" style="margin-left: 0.5in; margin-right: 0.5in;"><h3 class="title">Important</h3><p>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.</p></div></dd><dt><span class="term">Column Settings</span></dt><dd><p>Setup every column with custom action. Column actions are
prepared depending their data type and/or size.</p></dd></dl></div><div class="sect2" lang="en"><div class="titlepage"><div><div><h3 class="title"><a name="id2526493"></a>Column Settings</h3></div></div></div><div class="variablelist"><dl><dt><span class="term">Autonumber</span></dt><dd><p>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.</p></dd><dt><span class="term">Random Number</span></dt><dd><p>Insert pseudo random number into column. If there is a size settings for
this column (e.g. NUMBER(3)) the size is used.</p></dd><dt><span class="term">Random Text</span></dt><dd><p>Insert random text string into column. If there is a size settings for
this column (e.g. VARCHAR2(3)) the size is used.</p></dd><dt><span class="term">Prefixed Text</span></dt><dd><p>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".</p></dd><dt><span class="term">Static Value</span></dt><dd><p>Insert custom constant value for all new records for current column.</p></dd><dt><span class="term">Ignore Column</span></dt><dd><p>Skip this column. No data will be inserted except default values for columns.</p><div class="warning" style="margin-left: 0.5in; margin-right: 0.5in;"><h3 class="title">Warning</h3><p>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.</p></div></dd></dl></div></div></div><div class="navfooter"><hr><table width="100%" summary="Navigation footer"><tr><td width="40%" align="left"><a accesskey="p" href="ch07s04.html">Prev</a> </td><td width="20%" align="center"><a accesskey="u" href="ch07.html">Up</a></td><td width="40%" align="right"> <a accesskey="n" href="ch07s06.html">Next</a></td></tr><tr><td width="40%" align="left" valign="top">Import Table Data </td><td width="20%" align="center"><a accesskey="h" href="index.html">Contents</a></td><td width="40%" align="right" valign="top"> View related dialogs</td></tr></table></div></body></html>
|