Template:Exodus console first steps: Difference between revisions

From NEOSYS Dev Wiki
Jump to navigationJump to search
(Created page with 'Try the following commands. {| !Command !!Comment |- |configexodus ||One time setup of default database and user in postgres (exodus and exodus) |- |<U>EDITING AND C…')
 
No edit summary
 
(4 intermediate revisions by 2 users not shown)
Line 3: Line 3:
{|
{|
!Command !!Comment
!Command !!Comment
|-
|configexodus          ||One time setup of default database and user in postgres (exodus and exodus)
|-
|-
|<U>EDITING AND COMPILING</U>
|<U>EDITING AND COMPILING</U>
Line 15: Line 13:
|-
|-
|edic testsort ||Browse a sample exodus program showing all fundamental database operations including dictionaries and list.
|edic testsort ||Browse a sample exodus program showing all fundamental database operations including dictionaries and list.
|-
|<U>DATABASE OPERATIONS</U>
|-
|-
|compile testsort ||compile the preinstalled test program
|compile testsort ||compile the preinstalled test program
|-
|-
|testsort ||Run it to generate some data and inspect the output
|testsort ||Run it to generate some data and inspect the output
|-
|<U>DATABASE OPERATIONS</U>
|-
|-
|listfiles ||quick tool avoiding need to use any database client
|listfiles ||quick tool avoiding need to use any database client
Line 26: Line 24:
|list myclients         ||text output - no page/column headers just yet sorry
|list myclients         ||text output - no page/column headers just yet sorry
|-
|-
|list myclients (H) ||html output (port of a fully blown LIST replacement in heavy production use since 2000)
|list myclients {H} ||html output (port of a fully blown LIST replacement in heavy production use since 2000)
|-
|-
|list dict_myclients ||NB the underscore after "dict" is *required*. "dict(SPACE)myclients" wont work
|list dict_myclients ||NB the underscore after "dict" is *required*. "dict(SPACE)myclients" wont work
Line 45: Line 43:
|}
|}


If you get the following error then you have not completed the installation of pgexodus.dll function in postgres as described in the section on postgres above.
If you get the following error then you have not completed the installation of the Exodus plugin for Postgres.


PGRES_FATAL_ERROR: ERROR:  function exodus_extract_text(bytea, integer, integer, integer) does not exist
PGRES_FATAL_ERROR: ERROR:  function exodus_extract_text(bytea, integer, integer, integer) does not exist

Latest revision as of 01:50, 3 June 2011

Try the following commands.

Command Comment
EDITING AND COMPILING
edic hello edic=edit+compile+catalog. Creates a skeleton hello.cpp file using nano editor. edic will only compile on exit if saved, so make some change before you exit.
hello Run it
compile hello compile without editing
edic testsort Browse a sample exodus program showing all fundamental database operations including dictionaries and list.
compile testsort compile the preinstalled test program
testsort Run it to generate some data and inspect the output
DATABASE OPERATIONS
listfiles quick tool avoiding need to use any database client
list myclients text output - no page/column headers just yet sorry
list myclients {H} html output (port of a fully blown LIST replacement in heavy production use since 2000)
list dict_myclients NB the underscore after "dict" is *required*. "dict(SPACE)myclients" wont work
list dict_voc if you understand this then you understand your pick
edir myclients SB001 you can edit data or dictionaries directly. edir="edit record"
delete myclients SB001 useful command line tool
createfile tempfile ditto
deletefile tempfile ditto
createindex myclients CLIENT_TYPE speeds up select commands on the indexed fields in the traditional way
deleteindex myclients CLIENT_TYPE filenames are case insensitive, keys and fieldnames are CASE SENSITIVE

If you get the following error then you have not completed the installation of the Exodus plugin for Postgres.

PGRES_FATAL_ERROR: ERROR: function exodus_extract_text(bytea, integer, integer, integer) does not exist