[ts-gen] Renaming Databases

[Bill Pippin]

Ken,

About changing the database name:

> I would like to rename the databases testing and trading (I have many
> other db's in Mysql - these names are too generic) to shim_testing and
> shim_trading.

Great minds think alike ;<)  A colleague has used the same renames.
 
> I have modified sql/setup.sql and the tables get loaded fine ...

This is the hard part, so if you did it correctly, you're almost there.

> ... but it appears that I also have to modify the C source and
> recompile ...

Not so.

> ... I couldn't find any options in .shimrc ...
> Can you tell me all the places I need to modify?

Here's the default .shimrc as shipped:

ShimText        ShimText
DbmsName        mysql
DbmsHost        localhost
TableSet        testing
UserName        shim
Password        0
FeedName        tws
FeedHost        localhost
FeedPort        7496
ClientId        8
HqPeriod        11
Upstream        paper
Currency        USD
Locality        US
LogFiles        log
PollTime        3
ApiLevel        23

Of the name-value pairs above, you want to change the value
for TableSet, on a per session basis to either shim_testing
or shim_trading, as desired.  This should be all you need to
do given your goal and the situation you describe.

Feel free also to change DbmsHost if the database server is not
on the local machine; the mysql user account name, from shim to
whatever you like, although there you would need to go back to
the setup.sql and child scripts to make parallel changes; and
the FeedHost and FeedPort if your IB tws process is elsewhere
on your LAN.

Thanks,

Bill