Re: [mv] Getting flypage to recognize item codes?

[Ken Berland <ken@hero.com>]

The products.asc file is _not_ necessary if you're running SQL. If you
have an sql source (dsn) in your catalog.cfg, and no corresponding table
in the database minivend tries to create a table and import the data from
the .asc file.

The key and column_def fields that specify what kinds of data to make the
columns are kinda unecessary.  You can create the table in mysql _first_
and then start minivend.  You specify indexes inside sql also, to speed
searches. (see your mysql docs).

Remember the great --log option on safe_mysqld and the tail -f the
{host}.log file to see everything that minivend is doing in sql.

On Thu, 16 Dec 1999, Christopher P. Lindsey wrote:

> ******    message to minivend-users from "Christopher P. Lindsey" <lindsey@mallorn.com>     ******
> 
> > I'll take a quick stab because I made this mistake too :P
> 
> It's good to know that I'm not alone...  :)
> 
> > Are you editing the products.asc file in /home/minivend or the one in the 
> > directory you installed your catalog to (usually ~/catalogs/simple)
> > 
> > The correct one is the one in the installed dir (~/catalogs/simple/)  You 
> > can spend all day changing the one in /home/minivend and get nowhere.  The 
> > other thing to check is the ownership and permissions of your products.asc 
> > file.  If  none of those are it, drop me another line and I'll see if I can 
> > help ya.
> 
> This is something I'm confused about.  Is products.asc still needed for
> SQL-based databases?  I know that the database definition has products.asc
> specified (
> 
>    Database   products   products.asc  dbi:mysql:nursery:mysql:3306
>    .. (some stuff deleted)
>    Database   products   COLUMN_DEF    code=char(10) PRIMARY KEY
>    Database   products   COLUMN_DEF    price=float, discount=float
>    Database   products   NUMERIC       price=float, discount
> 
> ), but why?  Or do I also have to keep a local ASCII copy of the database
> (this seems wrong to me, as the usefulness of SQL interfaces seems to 
> be lost).  The database already exists from other applications, so I
> don't want products.asc to do any kind of importing.  
> 
> Am I way off-base?  Is products.asc needed?
> 
> Confused Chris
> -
> To unsubscribe from the list, DO NOT REPLY to this message.  Instead, send
> email with 'UNSUBSCRIBE minivend-users' in the body to Majordomo@minivend.com.
> Archive of past messages: http://www.minivend.com/minivend/minivend-list
>