[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
Re: [Savannah-hackers] savannah.gnu.org: submission of xsql
From: |
Loic Dachary |
Subject: |
Re: [Savannah-hackers] savannah.gnu.org: submission of xsql |
Date: |
Mon, 22 Jul 2002 08:53:52 +0200 |
Hi,
Could you please submit your project again with a URL to the
current distribution ?
Thanks in advance,
address@hidden writes:
>
> 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:
>
>
--
Loic Dachary http://www.dachary.org/ address@hidden
12 bd Magenta http://www.senga.org/ address@hidden
75010 Paris T: 33 1 42 45 07 97 address@hidden
GPG Public Key: http://www.dachary.org/loic/gpg.txt