[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Savannah-hackers] savannah.gnu.org: submission of xsql
From: |
patrick |
Subject: |
[Savannah-hackers] savannah.gnu.org: submission of xsql |
Date: |
Fri, 19 Jul 2002 20:52:55 -0400 |
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:
- [Savannah-hackers] savannah.gnu.org: submission of xsql,
patrick <=