[ic] Change the way Interchange reads table fields?

Ron Phipps rphipps at reliant-solutions.com
Sat Sep 3 00:16:35 EDT 2005


> From: interchange-users-bounces at icdevgroup.org
[mailto:interchange-users-
> bounces at icdevgroup.org] On Behalf Of Mike Heins
> Sent: Friday, September 02, 2005 11:41 AM
> 
> Quoting Bryan Gmyrek (bryangmyrek at yahoo.com):
> > Hi,
> >
> > Just want to throw an idea out there and see if anyone else thinks
it's
> a good one.
> > I'd like to be able to add fields and in general edit my tables from
say
> within the mysql command
> > line interface.  However, this then requires changing the file in
> dbconfig/mysql/tablename.mysql
> > and also messing with the products/tablename.txt file if I added a
new
> field.
> > My idea is to have IC read the database information at startup with
a
> command like
> >
> > mysql> show fields from products;
> >
+--------------------+---------------+------+-----+---------+-------+
> > | Field              | Type          | Null | Key | Default | Extra
|
> >
+--------------------+---------------+------+-----+---------+-------+
> > | sku                | varchar(15)   |      | PRI |         |
|
> > | category           | varchar(64)   |      | MUL |         |
|
> > ..
> >
> > Then it can read the Field, Type, Null, Key ... columns in and
configure
> the datbase based on
> > that.
> >
> > Does anyone else think this is a good idea?  Can IC already do this
and
> I just don't know ;)
> 
> Interchange does this already.
> 
>     DatabaseAuto  dbi:mysql:database=foo;user=bar;pass=baz
> 
> Try it sometime.
> 

Hey Mike,

So with this config there would be no reason to create .mysql and .txt
files anymore?

Thanks!
-Ron



More information about the interchange-users mailing list