[ic] Advice needed for IC/eBay API integration

[Grant]

> >
> > > Grant wrote:
> > >
> > > >I'm now very close to being finished with the IC/eBay API
> integration.
> > > >eBay's developer testing site was broken for about 10 days
> or so, but it
> > > >started working again a couple days ago and I should be done
> > > very soon.  The
> > > >integration will consist of something like this:
> > > >
> > > >- 5 UserTags
> > > >- 7 jobs files
> > > >- 7 jobs directives
> > > >- 1 new page
> > > >- 1 new variable table entry
> > > >- new fields in transactions and inventory tables
> > > >- new ebay table
> > > >- log_transaction modifications
> > > >
> > > >It will be going up at Kevin Walsh's site (
> www.interchange.rtfm.info )
> > > >along with detailed info on how it all works and how to use it.
> > > Of course,
> > > >I will post here when I have it up.
> > > >
> > > >So I guess that was an update.
> > > >
> > > >Anyway, I'm facing an important decision in the design of the
> > > whole thing,
> > > >and I'd really appreciate some advice on it.  Basically, I
> could change
> > > >around the way it works and make it quite a bit cleaner and more
> > > extensible,
> > > >but it would require adding every item listed on eBay as an
> > > entry in the new
> > > >ebay table.  That could really get to be a lot of entries that
> > > aren't being
> > > >used for anything unless the item ends up being sold.  Should I:
> > > >
> > > >a) not write every listed item as an entry in the ebay table and
> > > sacrifice
> > > >some cleanliness and extensibility
> > > >b) write every listed item as an entry in the ebay table,
> but delete each
> > > >record that isn't needed after the listing has ended
> > > >c) write every listed item as an entry in the ebay table and not
> > > worry about
> > > >the bloated database
> > > >
> > > >I'm leaning toward b.  If you agree, how can a record be
> deleted from a
> > > >table without going through the UI?
> > > >
> > > >- Grant
> > > >
> > > >_______________________________________________
> > > >interchange-users mailing list
> > > >interchange-users at icdevgroup.org
> > > >http://www.icdevgroup.org/mailman/listinfo/interchange-users
> > > >
> > > >
> > > Could you not have a cron entry that calls a script/sql
> command to take
> > > care of making everything clean?  That way, if somebody wants to keep
> > > everything, they just don't run the script.  Other people
> that want the
> > > database cleaned up, would be able to schedule it for whenever the
> > > server has a light load on it.
> > >
> > > Nicholas Cook
> >
> > That sounds like a good idea, but what IC commands can be used to remove
> > certain entries from a DBM database?
>
> I suppose that $Db{ebay}->delete_record("0815") would work on DBM tables
> as well.
>
> Bye
> 	Racke

Which method do you think is better between the one you mention and using
the query tag with DELETE?

- Grant