simpleblog migration problem
simpleblog migration problem
- Subject: simpleblog migration problem
- From: Theodore Petrosky <email@hidden>
- Date: Thu, 12 Jan 2012 02:51:29 -0800 (PST)
Interesting, I downloaded, imported the source, and switched the database to postgresql. I could not add another 'role' because of a pk violation.
when i examined the tables I found that the role_seq listed a last_value of 1. it should have been 2. so I did a:
select setval('role_seq', 2);
and voila, I can create roles.
the error was in the migrations (for postgresql)
ERXJDBCUtilities.executeUpdate(database.adaptorChannel(), "INSERT INTO Role (roleDescription, id) VALUES ('Admin', 1)", true);
when you specify the id's value, it prevents the value from incrementing the sequence. so either remove the explicit id or do the setval.
ERXJDBCUtilities.executeUpdate(database.adaptorChannel(), "INSERT INTO Role (roleDescription) VALUES ('Admin')", true);
I don't know the implications for other databases.
Ted
--- On Thu, 12/15/11, David Holt <email@hidden> wrote:
> From: David Holt <email@hidden>
> Subject: Re: stumbling around with D2W
> To: "Theodore Petrosky" <email@hidden>
> Cc: "Ramsey Gurley" <email@hidden>, email@hidden
> Date: Thursday, December 15, 2011, 12:25 PM
> This example is in the SimpleBlog
> rules for assigning roles to a Person with checkboxes. It's
> not exactly the same as you've asked for, but it was handy
> :-)
>
> https://github.com/daveeed/SimpleBlog
>
> 50 : (task = 'edit' and entity.name = 'Person' and
> propertyKey = 'roles') => toManyUIStyle = "checkbox"
> [com.webobjects.directtoweb.Assignment]
> 80 : (task = 'edit' and entity.name = 'Person' and
> propertyKey = 'roles') => componentName =
> "ERD2WEditToManyRelationship"
> [com.webobjects.directtoweb.Assignment]
> 100 : (entity.name = 'Person' and propertyKey = 'roles')
> => keyWhenRelationship = "roleDescription"
> [com.webobjects.directtoweb.Assignment]
>
> The propertyKey 'roles' could be a relationship or a method
> such as that you have below on your EmploymentTitle EO.
>
> David
>
>
> On 2011-12-15, at 8:41 AM, Theodore Petrosky wrote:
>
> > Is there an example out there? I feel totally lost, I
> don't understand where to begin.
> >
> > I hesitate asking for this kind of low level help.
> >
> > I feel like a fish out of water.
> >
> > Ted
> >
> > --- On Thu, 12/15/11, Ramsey Gurley <email@hidden>
> wrote:
> >
> >> From: Ramsey Gurley <email@hidden>
> >> Subject: Re: stumbling around with D2W
> >> To: "Theodore Petrosky" <email@hidden>
> >> Cc: email@hidden
> >> Date: Thursday, December 15, 2011, 10:28 AM
> >> Hi Ted,
> >>
> >> componentName = ERD2WEditToOneRelationship
> >> restrictedChoiceKey = object.currentTitles
> >>
> >> Then create a method on your object returning an
> array of
> >> current employment titles like you have below.
> >>
> >> Ramsey
> >>
> >> On Dec 15, 2011, at 8:03 AM, Theodore Petrosky
> wrote:
> >>
> >>> OK so this is a real newbie thing.
> >>>
> >>> In my Wonder app, I would:
> >>>
> >>> create a list of entries to populate a popup
> >>>
> >>> employmentTitleList =
> >>
> EmploymentTitle.fetchEmploymentTitles(newEmployeeEC,
> >> EmploymentTitle.IS_CURRENT.eq(true),
> >> EmploymentTitle.ORDERING_INT.ascs());
> >>>
> >>> I don't understand how to do this in an Edit
> page in
> >> D2W.
> >>>
> >>> Is there anything like this in an example?
> >>>
> >>> Ted
> >>>
> _______________________________________________
> >>> 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