NAME

       eoutil - Command line utility to perform database and EOF oriented tasks.

SYNOPSIS

       eoutil command [command\-options]

DESCRIPTION

       This manual page describes briefly the eoutil command.

       eoutil  is  a command line utility that performs database and Enterprise Objects Framework-related tasks.
       It allows one to connect to data sources, dump data from them or modify model features.

       eoutil supports the following commands, with the corresponding command-options:

       • dump <model> [\-source <source>  [sourcefile]]  \-dest  <dest>  [destfile]  [\-schemaCreate  <options>]
         [\-schemaDrop  <options>]  [\-postI\ nstall] [\-force] [\-connDict <connection dictionary>] [\-entities
         <entities>] [\-excludedEntities <entities>] [\-modelGroup <modelGroup>] [\-ascii]

         This command reads data from <source> and dumps it to <dest>. The dump may include  bits  of  DML  that
         create  bits of database schema. The \-source flag is optional if only schema is to be created (i.e. no
         data is being dumped). The following is a list of possible values for each of the arguments in the com‐
         mand:

         • model -- must be the name of an eomodel or eomodeld file

         • source -- 'plist' (read from stdin unless source file is specified) or 'database' (uses model to con‐
           nect)

         • sourcefile -- name of file to read plist from

         • dest -- 'plist' or 'script' (both are written to stdout unless destfile is specified)  or  'database'
           (uses model to connect)

         • destfile -- name of file to write plist or script

         • options  --  'database',  'tables',  'primaryKeySupport',  'primaryKeyConstraints' or 'foreignKeyCon‐
           straints'

         • postInstall -- looks in the userInfo dictionary for an array of SQL  strings  to  process  after  any
           schema creation and data dumping is done

         • force -- Do not quit processing after database error

         • connDict -- A substitute connection dictionary

         • entities -- a subset of the entities in the model (all are used by default)

         • excludedEntities  --  a  subset of the entities in the model which shall not be used (all are used by
           default)

         • modelGroup -- A list of models to create a model group. (Allows you to use models not in a framework.
           Model names must be absolute paths.)

         • ascii -- Convert all non-ASCII characters to their nearest ASCII equivalents.

       • convert <model> <adaptorName> <connectionDictionary> <outFileName>

         This command converts the type mapping in a model for the data source specified by the connection  dic‐
         tionary URL. The connection dictionary in the new model is set to connectionDictionary.

         • model -- must be the name of an eomodel or eomodeld file

         • adaptorName -- PostgreSQL, FlatFile, etc.

         • connectionDictionary  --  string  in  property  list format representing a dictionary, specifying the
           database name for the data source (required) and username and password  (if  required  by  that  data
           source).

         • outFileName -- the name of a directory to write the converted model

       • connect (<model> | (<adaptorName> <connectionDictionary>))

         This  command attempts to connect to a data source using the adaptor named adaptorName with connection‐
         Dictionary, or using the connection dictionary in model. It returns an exit status of 0  if  successful
         and 1 otherwise. This is primarily useful for scripts.

         • model -- must be the name of an eomodel or eomodeld file

         • adaptorName -- PostgreSQL, FlatFile, etc.

         • connectionDictionary  --  string  in  property  list format representing a dictionary, specifying the
           database name for the data source (required) and username and password  (if  required  by  that  data
           source).

EXAMPLES

       # eoutil dump Movies.eomodeld \-source plist \-dest database \-schemaCreate tables primaryKeySupport for‐
       eignKeyConstraints < MovieData.plist

       Creates the tables in the database, reads data in plist format from,stdin stores the data in the database
       listed  in  the  connection dictionary of model, creates primary key support in the database, and creates
       foreign key constraints corresponding to the relationship definitions.

       # eoutil convert Movies.eomodeld PostgreSQL '{ databaseName = test;  hostName  =  localhost;  userName  =
       postgres; password = postgres; }' M.eomodeld

       Converts types in Movies.eomodeld file to PostgreSQL types and writes the converted model to ./M.eomodel

       # eoutil connect PostgreSQL '{ databaseName = test; hostName = localhost; userName = postgres; password =
       postgres; }'

       Attempts to connect to a PostgreSQL database on host localhost.

SEE ALSO

       GNUstep(7).

AUTHOR

       eoutil was written by Stephane Corthesy <stephane@sente.ch>.

       This manual page was written by Federico Giménez Nieto <fgimenez@coit.es> for the Debian project (but may
       be used by others).

                                                  10 March 2010                                        EOUTIL(1)