Mailing-List: contact dev-help@metamodel.incubator.apache.org; run by ezmlm
Precedence: bulk
Reply-To: dev@metamodel.incubator.apache.org
Received-SPF: pass (nike.apache.org: domain of i.am.kasper.sorensen@gmail.com
 designates 74.125.82.47 as permitted sender)
MIME-Version: 1.0
In-Reply-To: 
 <CA+U3tt-GM1YLBBu71WY3Pvt7eq5Pq_7-qidsmzDqPJSaxerGXQ@mail.gmail.com>
References: 
 <CAOk1a-SA0CeMW6cxH8=LxMJSE-naZhA3agp2G35hoHN89Q8Qyg@mail.gmail.com>
	<CA+U3tt_nj8+Yq5EP3yMRLOJXuZiFJHxVTDkwEjh1WFt4zB9Fug@mail.gmail.com>
	<CAOk1a-SMPAXB48Cu23jcZu+eHXvN9d-+p=1UrYxCMkmo+buZTg@mail.gmail.com>
	<CA+U3tt-GM1YLBBu71WY3Pvt7eq5Pq_7-qidsmzDqPJSaxerGXQ@mail.gmail.com>
Date: Wed, 16 Jul 2014 23:12:29 +0200
Message-ID: 
 <CA+U3tt9gmDKJBtpJ4-c=htNtKWS2Wr6hS-CG8uRVVdYJRDE_Dw@mail.gmail.com>
Subject: Re: Create a CSV in a empty file
From: =?UTF-8?Q?Kasper_S=C3=B8rensen?= <i.am.kasper.sorensen@gmail.com>
To: "dev@metamodel.incubator.apache.org" <dev@metamodel.incubator.apache.org>
Content-Type: multipart/alternative; boundary=047d7b343d6c56da9504fe55fb6f

--047d7b343d6c56da9504fe55fb6f
Content-Type: text/plain; charset=UTF-8
Content-Transfer-Encoding: quoted-printable

Hmm actually I just now realized that you can completely omit the Drop
Table part ... if you use create table on an empty file, it will simply
create the header.


2014-07-16 23:10 GMT+02:00 Kasper S=C3=B8rensen <i.am.kasper.sorensen@gmail=
.com>:

> Yes, you do that while creating the table. Like this:
>
>         CsvDataContext dc =3D ...;
>         dc.executeUpdate(new UpdateScript() {
>             @Override
>             public void run(UpdateCallback callback) {
>                 callback.dropTable(dc.getDefaultSchema().getTable(0));
>
>                 callback.createTable(dc.getDefaultSchema(),
> "newtable").withColumn("foo").withColumn("bar").execute();
>             }
>         });
>
> (replace with your own column names of course)
>
>
> 2014-07-16 23:04 GMT+02:00 J=C3=BAnior <fjunior87@gmail.com>:
>
> Hi Kasper,
>>
>> thanks for your reply, but what about the columns?
>>
>> Do I need to add columns to this newly created table?
>>
>> Att.
>>
>>
>> 2014-07-16 18:00 GMT-03:00 Kasper S=C3=B8rensen <
>> i.am.kasper.sorensen@gmail.com>:
>>
>> > Hi there,
>> >
>> > There is a little known trick to get around that issue, so I guess it'=
s
>> a
>> > very fair question.
>> >
>> > The trick is to first do a drop table, and then a new create table.
>> >
>> > When MM is initialized with an existing empty file, it will determine
>> that
>> > there IS a table, since the file is there, but that table has no
>> columns,
>> > because the file does not define any columns. Maybe it's a bit silly -=
 I
>> > actually think that's worth discussing ... But the reason it is there
>> is I
>> > guess to indicate that at least the file is there, it's not a
>> non-existing
>> > file (in which case there would not be any table).
>> >
>> > Best regards,
>> > Kasper
>> >
>> >
>> > 2014-07-16 21:37 GMT+02:00 J=C3=BAnior <fjunior87@gmail.com>:
>> >
>> > > Hi,
>> > >
>> > > I'm trying to use the metamodel to write on an empty csv,
>> > >
>> > > But I'm getting errors saying that there is no column.
>> > >
>> > > I was able to do that calling create table with a different name fro=
m
>> the
>> > > file.
>> > > Then added the columns.
>> > >
>> > > I worked, but it created the header line with the column names, woul=
d
>> it
>> > be
>> > > possible to do that without adding the column names in the csv file?
>> > >
>> > > Att.
>> > > --
>> > > Francisco Ribeiro
>> > > *SCEA|SCJP|SCWCD|IBM Certified SOA Associate*
>> > >
>> >
>>
>>
>>
>> --
>> Francisco Ribeiro
>> *SCEA|SCJP|SCWCD|IBM Certified SOA Associate*
>>
>
>

--047d7b343d6c56da9504fe55fb6f--