[Savannah-hackers] savannah.gnu.org: submission of xsql

[patrick]

A package was submitted to savannah.gnu.org.
This mail was sent to address@hidden, address@hidden


Patrick Lacson <address@hidden> described the package as follows:
License: lgpl
Other License: 
Package: xsql
System name: xsql
This package wants to apply for inclusion in the GNU project

Description:
In a nutshell XSql allows developers to populate a database with data.
XSql relies on resource files that are used for populating columns like:

email
address
state
first_name
last_name
...

XSql is capable of creating almost any type of column as long as a proper
resource file is supplied.

XSql does support IDENTITY columns, such as those commonly used for primary
keys in tables.  For example

<sqltable name=\"kimchi_users\" rows=\"1000\" delimiter=\";\">

  <column identity=\"true\">
    <name>id</name>
    <type>int</type>
  </column>

  <column resourcefile=\"resources/first_names.list\">
    <name>first_name</name>
    <type>varchar(30)</type>
  </column>

  <column resourcefile=\"resources/sur_names.list\">
    <name>last_name</name>
    <type>varchar(50)</type>
  </column>

</sqltable>

This sqlschema.xml would create a table called \"kimchi_users\", insert
1000 rows, and use the delimiter \";\" to separate insert statements. For
the column first_name, a resource file of \"resources/first_names.list\" would
be used to look up names to populate this column.  Same goes for \"last_names.\"

The resulting table would look like:

CREATE TABLE kimchi_users (
id int,
first_name varchar(30),
last_name varchar(50)
)

The resulting insert would look like:

INSERT INTO kimchi_users
VALUES(1,\'Patrick\',\'Lacson\');

INSERT INTO kimchi_users
VALUES(1,\'John\',\'Smith\');
...


Other Software Required:


Other Comments: