On 9/26/01 2:17 PM, "Fedor Karpelevitch" <[EMAIL PROTECTED]>
wrote:
>> -----Original Message-----
>> From: Jason van Zyl [mailto:[EMAIL PROTECTED]]
>> Sent: Wednesday, September 26, 2001 11:04 AM
>> To: [EMAIL PROTECTED]
>> Subject: Re: TorqueData task
>>
>>
>>>>
>>>> I'm not totally clear on this but do I need to generate a
>> dtd for my
>>>> particular dataset?
>>>
>>> there is only one dtd for a db and it is completely derived
>> from the schema
>>> xml.
>>> it describes data structure for any data which can go into
>> your database, so
>>> every dataset xml should fit into this dtd.
>>>
>>>> For inserting data could we not just have
>>>> a standard
>>>> dtd?
>>>
>>> dtd describes data structure for your project so it is
>> different for each
>>> project.
>>
>> So your set of task are basically for dumping and
>> repopulating data for an
>> existing project? Maybe this isn't what I need than.
>
> there are two tasks:
> 1) data-dump, which pulls all data from db and generates xml
> 2) datasql, which takes data xml and generates load sql
>
> using these two one after another does not make much practicalk sense
> besides, maybe, moving data from one db to another.
> what you need to do, I guess, is to create a db with the default data you
> want. Then dump it with datadump task. You can then edit the xml -
> add/remove data for example. Alternatively you can type in the xml manually
> if this is what you enjoy doing.
I will do it manually as it's a simple set of data. I'll give it a whirl.
> the xml you'll get will contain the default data. In tdk buildfile you then
> can use datasql task to convert the xml to sql and then sql task to execute
> it.
Ok, I'll try to integrate it.
>
>>
>> My task at hand is to insert some values into the security
>> system to create
>> a set of default roles/perms for the application.
>
>
> fedor.
>
>>
>>>> I'm just trying to get the procedure clear before I try
>>>> it in the TDK.
>>>>
>>>> I've solved the problem of inserting an arbitrary set of SQL
>>>> files using the
>>>> <sql> task in the 1.5 ant sources. So the data inserting to
>>>> populate the
>>>> security system is next :-)
>>>>
>>>> The TDK will soon work for a real project that changes ;-)
>>>>
>>>> --
>>>>
>>>> jvz.
>>>>
>>>> Jason van Zyl
>>>>
>>>> http://tambora.zenplex.org
>>>> http://jakarta.apache.org/turbine
>>>> http://jakarta.apache.org/velocity
>>>> http://jakarta.apache.org/alexandria
>>>> http://jakarta.apache.org/commons
>>>>
>>>>
>>>>
>>>>
>> ---------------------------------------------------------------------
>>>> To unsubscribe, e-mail: [EMAIL PROTECTED]
>>>> For additional commands, e-mail:
>> [EMAIL PROTECTED]
>>>>
>>>
>>>
>> ---------------------------------------------------------------------
>>> To unsubscribe, e-mail: [EMAIL PROTECTED]
>>> For additional commands, e-mail: [EMAIL PROTECTED]
>>
>> --
>>
>> jvz.
>>
>> Jason van Zyl
>>
>> http://tambora.zenplex.org
>> http://jakarta.apache.org/turbine
>> http://jakarta.apache.org/velocity
>> http://jakarta.apache.org/alexandria
>> http://jakarta.apache.org/commons
>>
>>
>>
>> ---------------------------------------------------------------------
>> To unsubscribe, e-mail: [EMAIL PROTECTED]
>> For additional commands, e-mail: [EMAIL PROTECTED]
>>
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: [EMAIL PROTECTED]
> For additional commands, e-mail: [EMAIL PROTECTED]
--
jvz.
Jason van Zyl
http://tambora.zenplex.org
http://jakarta.apache.org/turbine
http://jakarta.apache.org/velocity
http://jakarta.apache.org/alexandria
http://jakarta.apache.org/commons
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]