[ic] Advice needed for IC/eBay API integration

[Stefan Hornburg]

On Fri, 17 Oct 2003 14:30:15 -0700
"Grant" <listbox at email.com> wrote:

> 
> > 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


-- 
LinuXia Systems => http://www.linuxia.de/
Expert Interchange Consulting and System Administration
ICDEVGROUP => http://www.icdevgroup.org/
Interchange Development Team