Re: what am i doing wrong with this qualifier
Re: what am i doing wrong with this qualifier
- Subject: Re: what am i doing wrong with this qualifier
- From: Ramsey Gurley <email@hidden>
- Date: Wed, 26 Jan 2011 14:47:37 -0500
Hi John,
I just tried it on a clean db and that appears to be the case.
Whether I use newDateColumn or newTimestampColumn I'm getting
CREATE TABLE StockReservation (created timestamp NOT NULL, expiration
timestamp...
Do you happen to know where it's failing to generate the right type?
Is it a postgresql specific problem, or is the same with migrations on
other dbs?
Oddly, now the migrations are doing timestamp without timezone...
which is what I expected. Somehow the ones I generated on a different
database a few days ago created "with timezone". (>.<) Gotta love
timestamps.
Ramsey
On Jan 26, 2011, at 2:09 PM, John Huss wrote:
I don't think there is any way currently to use migrations to create
a column with external type "date". You have to write SQL or modify
the PostgresqlPlugIn.
John
On Wed, Jan 26, 2011 at 1:04 PM, Theodore Petrosky
<email@hidden> wrote:
Ramsey,
I tried the newDateColumn and I got a :
timestamp without time zone
however I was expecting a date column. Am I missing something?
Ted
--- On Wed, 1/26/11, Ramsey Gurley <email@hidden> wrote:
> From: Ramsey Gurley <email@hidden>
> Subject: Re: what am i doing wrong with this qualifier
> To: "Theodore Petrosky" <email@hidden>
> Cc: "WebObjects Development" <email@hidden>
> Date: Wednesday, January 26, 2011, 9:39 AM
> No, you're doing it right. I haven't
> had a chance to update the
> migration templates yet. I need to add a migration
> method for time
> and make sure that works too. For now, just change
> that to a
> newDateColumn method yourself. I believe it should work
> fine.
>
> Ramsey
>
> On Jan 26, 2011, at 9:31 AM, Theodore Petrosky wrote:
>
> > sorry, I didn't copy the list.
> >
> > Great, I will experiment but I did try to add a
> JodaLocalDate
> >
> > I used the prototype and got
> >
> > Prototype: jodaLocalDate
> > External Type: date
> > Class: org.joda.time.LocalDate
> > Value Class: org.joda.time.LocalDate
> > Value Type: D
> >
> > Factory and Conversion method jodaLoalDate
> >
> > but when I asked for the Migrations I got:
> >
> > securitySettingsTable.newBlobColumn("c_a_date",
> false);
> >
> > a new blob column? I expected a date column. Do I need
> to do
> > something more?
> >>
> >> Ted
> >>
> >>
> >> --- On Wed, 1/26/11, Ramsey Gurley <email@hidden>
> >> wrote:
> >>
> >>> From: Ramsey Gurley <email@hidden>
> >>> Subject: Re: what am i doing wrong with this
> >> qualifier
> >>> To: "Theodore Petrosky" <email@hidden>
> >>> Cc: "WebObjects Development" <email@hidden>
> >>> Date: Wednesday, January 26, 2011, 8:43 AM
> >>>
> >>> On Jan 26, 2011, at 6:47 AM, Theodore Petrosky
> wrote:
> >>>
> >>>>
> >>>> Postgresql supports dates without
> timestamp, I
> >> wish I
> >>> knew how to do this in webobject java. (But
> still call
> >> them
> >>> dates so I can do date math.)
> >>>
> >>> If you are using a very recent version of 54
> Wonder
> >>> (committed in the last week), there are new
> date
> >> prototypes
> >>> using Joda time classes instead of
> NSTimestamps. Joda
> >> allows
> >>> for datetimes, dates, and times without a
> timezone.
> >>> Joda simplifies date math quite a bit too.
> >>>
> >>> Ramsey
> >>
> >>
> >>
> >>
> >
> >
> >
> > _______________________________________________
> > Do not post admin requests to the list. They will be
> ignored.
> > Webobjects-dev mailing list (email@hidden)
> > Help/Unsubscribe/Update your Subscription:
> >
> > This email sent to email@hidden
> >
>
>
_______________________________________________
Do not post admin requests to the list. They will be ignored.
Webobjects-dev mailing list (email@hidden)
Help/Unsubscribe/Update your Subscription:
This email sent to email@hidden
_______________________________________________
Do not post admin requests to the list. They will be ignored.
Webobjects-dev mailing list (email@hidden)
Help/Unsubscribe/Update your Subscription:
This email sent to email@hidden
_______________________________________________
Do not post admin requests to the list. They will be ignored.
Webobjects-dev mailing list (email@hidden)
Help/Unsubscribe/Update your Subscription:
This email sent to email@hidden