[ic] Change the way Interchange reads table fields?
Mike Heins
mike at perusion.com
Fri Sep 2 14:40:46 EDT 2005
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
More information about the interchange-users
mailing list