EOUTIL(1)

💖 EOUTIL(1) 💖

okay so bestie, welcome to the eoutil page from the General Commands Manual — yes, that's the same eoutil(1) you're looking for, and yes, it's lowkey iconic for a command-line utility that does database stuff. Sit down, hydrate, let's go 🫶

✨ 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. Short and sweet, we love that for us.

eoutil is a command line utility that performs database and Enterprise Objects Framework-related tasks. It lets you connect to data sources, dump data from them, or modify model features. It's giving middle-management for your database, in the best way. 💅

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

👑 dump

dump <model> [-source <source> [sourcefile]] -dest <dest> [destfile] [-schemaCreate <options>] [-schemaDrop <options>] [-postInstall] [-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 command:

• 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 connect)
• 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 'foreignKeyConstraints'
• 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

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

This command converts the type mapping in a model for the data source specified by the connection dictionary 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

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

This command attempts to connect to a data source using the adaptor named adaptorName with connectionDictionary, 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. (Script girlies, this one's for you. 😌)

• 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 foreignKeyConstraints < 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. One command, so many side quests, and it ate every single one. ✨

# 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). Giving credit where credit is due, always. 👑

ok that's the whole page bestie, no notes, go dump some data responsibly 💖

and that's a wrap on this one, from the General Commands Manual, version EOUTIL(1), dated 10 March 2010 — mwah, bye 🎀🦋