7.0 table changes

Kevin · Post by **Kevin** » Fri Nov 30, 2007 2:16 pm

What table tells me which categories hold which products? In 5.5, that was object_assn but I dont see it now.

For the category tree, I see Categories has a parentID but there's also a CategoryParent tbl. Is this the old "redundant table for recursion" trick?

Did the interface for shipping gateways change at all? I have a custom gateway and I'm hoping the methods/xml didnt change.

tks.

Post by **Logan Rhodehamel** » Fri Nov 30, 2007 6:23 pm

ac_CatalogNodes will tell you which categories have products. This is very similar to object_assn, but with a better name.

The redundant table is there to facilitate category tree / category path lookups. So yes, rather than requiring recursive lookups we can accomplish what we need in a single SQL fetch.

Interface for shipping gateways DEFINITELY changed. Sorry about that. AC55 was XML based. All interfaces in AC7 use strongly typed classes to pass information around. It reduces ambiguity (what XML structure do I use?) and helps us solve problems at compile time rather than troubleshooting at runtime.

If you have an existing interface, I would guess conversion to AC7 will take a lot longer than writing from scratch. It's just that rather than parsing your inputs from XML, you'll get them from a strongly typed object. And same for the outputs, but in reverse!

Kevin · Post by **Kevin** » Fri Nov 30, 2007 8:28 pm

The brains of my shipping gateway is also strongly typed so I should just need to unpack your new parms to make the deeper call.

Either way, gotta do it. I'll just wait for the new sample gateway. There's enough changes that this isnt going to be quick anyway.

tks

AbleMods · Post by **AbleMods** » Sat Dec 01, 2007 12:35 pm

Man I wish I knew what either one of you guys just said...

Kevin · Post by **Kevin** » Mon Dec 03, 2007 9:18 am

I get that alot. :)

Post by **Logan Rhodehamel** » Mon Dec 03, 2007 9:50 am

Logan Rhodehamel wrote:If you have an existing interface, I would guess conversion to AC7 will take a lot longer than writing from scratch.

Wow... I must have been having a bad day. I meant to write the opposite - it should not take very long to convert.

The gateway flow is the same, and I think the method names might even be the same - it's just that we pass .NET objects rather than XML data.

Kevin · Post by **Kevin** » Mon Dec 03, 2007 10:01 am

I knew what ya meant. :)

AbleMods · Post by **AbleMods** » Mon Dec 03, 2007 10:55 am

So did I!

Ok that's not really true, I didn't.