Name

SQLDSN — default DSN string used for SQL database connections

SYNOPSIS

DSN

DESCRIPTION

This variable specifies the default DSN to be used in SQL database connections.

VARIABLE TYPE

Catalog variable

EXAMPLES

Example: Setting SQLDSN for Postgres

Variable SQLDSN dbi:Pg:database=MYDBNAME

Example: Setting SQLDSN for MySQL

Variable SQLDSN dbi:mysql:database=MYDBNAME

NOTES

No magic is happening here, mind you. Your "template", the demo catalog, or some piece of code must — at some point — refer to the SQLDSN variable explicitly. Interchange does not somehow do this by itself.

See the DSN glossary entry for complete discussion.

AVAILABILITY

SQLDSN is available in Interchange versions:

4.6.0-5.9.0 (git-head)

SOURCE

Interchange 5.9.0:

Source: lib/Vend/Ship/QueryUPS.pm
Line 305 (context shows lines 295-309 in calculate():41)

To aggregate by 1, use .999999.

=item cache_table

Set to the name of a table (default ups_cache) which can cache the
calls so repeated calls for the same values will not require repeated
calls to UPS.

Table needs to be set up with:

Database   ups_cache        ship/ups_cache.txt         __SQLDSN__
Database   ups_cache        AUTO_SEQUENCE  ups_cache_seq
Database   ups_cache        DEFAULT_TYPE varchar(12)
Database   ups_cache        INDEX  weight origin zip shipmode country


AUTHORS

Interchange Development Group

SEE ALSO

DocBook! Interchange!