[ic] SQL as products database

Jonathan Clark jonc@webmaint.com
Tue, 10 Apr 2001 13:07:40 +0100


>
> > and the file in <catroot>/dbconf/pgsql/ ?
> I don't. But, I think, I don't need it - I whant to connect to database,
> which is exists, and all data are exist.
>

This is now your problem. Interchange will not be able to see your tables
unless you tell it which ones to bind to. It will then do a 'select * from
<table> limit 1' to work out the field names and make them available. You
can specify the data types in the products.pgsql file or it will assume
varchar(255) (I think).

you need something like:

# Interchange database definition
Database  products  products.txt __SQLDSN__
#ifdef SQLUSER
Database  products  USER         __SQLUSER__
#endif
#ifdef SQLPASS
Database  products  PASS         __SQLPASS__
#endif
Database  products  KEY          sku
Database  products  COLUMN_DEF   "sku=VARCHAR(14) NOT NULL PRIMARY KEY"
Database  products  COLUMN_DEF   "description=VARCHAR(128)"
Database  products  COLUMN_DEF   "title=VARCHAR(128)"
Database  products  COLUMN_DEF   "artist=VARCHAR(128)"
Database  products  COLUMN_DEF   "comment=TEXT"
Database  products  COLUMN_DEF   "display=VARCHAR(128)"
Database  products  COLUMN_DEF   "image=VARCHAR(64)"
Database  products  COLUMN_DEF   "price=VARCHAR(12)"
Database  products  COLUMN_DEF   "category=VARCHAR(64)"
Database  products  COLUMN_DEF   "nontaxable=VARCHAR(3)"
Database  products  COLUMN_DEF   "weight=VARCHAR(12)"
Database  products  COLUMN_DEF   "size=VARCHAR(96)"
Database  products  COLUMN_DEF   "color=VARCHAR(96)"
Database  products  COLUMN_DEF   "related=text"
Database  products  COLUMN_DEF   "featured=VARCHAR(32)"
Database  products  ChopBlanks   1

or whatever is appropriate to your data structure.

> > did you remove the products.sql file and restart, which will
> drop and then
> > create your products table, and import your data from products.txt?
> I have NoImport products inventory - I don't want to import data.


this is fine then.

Jonathan.
Webmaint.