dbi2ntvml

Basic DBI to XML converter for use with NexTrieve.

Usage

 dbi2ntvml [-i id] [-e text] [-d date] [-a title] [-t title] [-E defaulinputencoding] [-n] [-b] -c connectstring [-u user] [-p password] -s select

Parameters

 -i field to use as "id" (default: "id")
 -e field to use as "text" (default: "text")
 -d following parameters should be considered as date attributes
 -a following parameters should be considered as standard attributes
 -t following parameters should be considered as text-types

 -c connectstring to connect to database
 -u user to access the database (ask user if not specified)
 -p password (ask user if not specified)
 -s SELECT statement to be used

 -E specify encoding to assume
 -n do not output <?xml..?> processor instruction
 -b do not output <ntv:docseq> container (bare XML)

Example

 dbi2ntvml -a id title -t title \
  -c 'DBI:mysql:database=test;host=localhost' -u 'test' -p '' \
  -s 'SELECT ID as id,title,taxt as text FROM table'

Create NTVML from selecting records from the table "table" in the database "test", using the MySQL server running on the localhost with user name 'test' and an empty password. Create NTVML with "id" and "title" as attribute, and "title" as text-type as well. Use the default field names for "id" and "text".

AUTHOR

Elizabeth Mattijsen, <liz@dijkmat.nl>.

Please report bugs to <perlbugs@dijkmat.nl>.

COPYRIGHT

Copyright (c) 1995-2002 Elizabeth Mattijsen <liz@dijkmat.nl>. All rights reserved. This program is free software; you can redistribute it and/or modify it under the same terms as Perl itself.

SEE ALSO

http://www.nextrieve.com and the NexTrieve::xxx modules.