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

[Patrick Lacson]

The project sources are yet to be checked in.  I'm operating under the
assumption that savannah will allow me to check in the sources similar to
sourceforge.net.

Please Advise,
Patrick



On Mon, 22 Jul 2002, Loic Dachary wrote:

>
>       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:
>  >
>  >
>
>