[ic] Change the way Interchange reads table fields?

[Mike Heins]

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.

-- 
Mike Heins
Perusion -- Expert Interchange Consulting    http://www.perusion.com/
phone +1.765.647.1295  tollfree 800-949-1889 <mike at perusion.com>

Fast, reliable, cheap.  Pick two and we'll talk.  -- unknown