savannah-hackers
[Top][All Lists]
Advanced

[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



reply via email to

[Prev in Thread] Current Thread [Next in Thread]