yes, and I made sure the Frontbase plugin was removed. Also, I did a Wonder svn up before trying to make sure I was completely up to date.
Ted --- On Sat, 10/16/10, David Holt <[email protected]> wrote: > From: David Holt <[email protected]> > Subject: Re: help with ERAttachments > To: "Theodore Petrosky" <[email protected]> > Cc: "David Holt" <[email protected]>, "Mike Schrag" <[email protected]>, > "[email protected]" <[email protected]> > Date: Saturday, October 16, 2010, 12:11 PM > Did you create Migration0 using the > Postgresql plugin? > > On 2010-10-16, at 8:18 AM, Theodore Petrosky <[email protected]> > wrote: > > > postgresql and ERAttachmentMigrations > > > > if I understand correctly, > > > > //from the tutorial file. > > > > @Override > > public void > upgrade(EOEditingContext editingContext, > ERXMigrationDatabase database) throws Throwable { > > > ERXMigrationTable personTable = > database.newTableNamed("person"); > > > personTable.newIntegerColumn("erattachmentid", true); > > > personTable.newLargeStringColumn("firstname", true); > > > personTable.newIntegerColumn("id", false); > > > personTable.newLargeStringColumn("lastname", true); > > > personTable.create(); > > > personTable.setPrimaryKey("id"); > > > > > personTable.addForeignKey("erattachmentid", "ERAttachment", > "id"); > > } > > > > Because of the correct setup of the Properties file, > this should create both the "Person" and ERAttachment > tables? Either I don't get this part or something is left > out. > > > > I had to factor out the: > > > > personTable.newIntegerColumn("erattachmentid", true); > > personTable.addForeignKey("erattachmentid", > "ERAttachment", "id"); > > > > then create a second migration "Tutorial1" with: > > > > package your.app.model.migrations; > > > > import > er.attachment.migrations.ERAttachmentMigration; > > > > > > public class Tutorial1dontuse extends > ERAttachmentMigration { > > public Tutorial1dontuse() { > > super("person", > "erattachmentid", true); > > } > > } > > > > Is this my problem with an incorrect setup? Or a setup > problem with postgresql? > > > > Obviously, I got it to work, but the implication of > the tutorial is that I shouldn't have needed to do the > second step. > > > > Ted > > > > > > > > > > > > --- On Sat, 10/16/10, Mike Schrag <[email protected]> > wrote: > > > > From: Mike Schrag <[email protected]> > > Subject: Re: help with ERAttachments > > To: "David Holt" <[email protected]> > > Cc: [email protected], > "Theodore Petrosky" <[email protected]> > > Date: Saturday, October 16, 2010, 10:46 AM > > > > re: "/attachments" appending to your path: > > if > (!filesystemPath.contains("${")) { > filesystemPath = filesystemPath + > "/attachments/${hash}/${pk}${ext}"; } > > if you don't specify any variables in your path, it > appends them for you ... if you were to set your filesystem > path to "/tmp/erattachments/${hash}/${pk}${ext}, it > wouldn't. > > ms > > On Oct 15, 2010, at 5:05 PM, David Holt wrote: > > The screencast is now live thanks to Pascal. > > http://wocommunity.org/podcasts/ERAttachment-Tutorial.mov > > David > > On 2010-10-15, at 9:15 AM, David Holt wrote: > > Hello Theodore, > > On 2010-10-15, at 5:13 AM, Theodore Petrosky wrote: > > Thank you. this is perfect. (almost) of course I use > only postgresql and there are differences. like I had to > factor out of the migration0 anything dealing with the > erattachment table and create a second migration with: > > > > Just swap in the database plugin you need for your > database and get rid of the FrontBase plugin from the > classpath. > > Rerun the creation of Migration0 from EntityModeler > and replace the version that is in the project. That should > get you the tables you need in the format your database > uses. > > > > public class Tutorial1 extends ERAttachmentMigration > { > > public Tutorial1() { > > super("person", > "erattachmentid", true); > > } > > } > > > > and of course postgresql wants to fold all > table/entities to lowercase. > > > > now I can work backwards and understand what is > happening. > > > > Questions: > > > > I see you set in the properties: > > > > Watch the screen cast :-) which should be available > pretty soon. I am just making it available for Pascal to > post now.Also read the package overview as Kieran and Amedeo > suggested. It explains all the settings that are used > below.http://webobjects.mdimension.com/hudson/job/Wonder53/javadoc/er/attachment/package-summary.html > > > > er.attachment.Person.photo.tempFolder = /tmp > > er.attachment.Person.photo.maxSize = 2097152 > > > > Max file size allowed for upload > > er.attachment.Person.photo.storageType = file > > > > file, db or S3 > > er.attachment.Person.photo.file.overwrite = false > > > > > > > > > > > _______________________________________________ Do not post admin requests to the list. They will be ignored. Webobjects-dev mailing list ([email protected]) Help/Unsubscribe/Update your Subscription: http://lists.apple.com/mailman/options/webobjects-dev/archive%40mail-archive.com This email sent to [email protected]
