OOQL language dump

exports/imports/compares OBEROn data to/from dump files


export - extract the application schema / the user tools / the object instances to a file

  dump export [feature] Dump_AdminOption AdminPatternList [[ !/not ]image] [full][verbose]                                   ExportFile_Option;

  dump export for
AdminPatternList Dump_UserFrameworkOption [full] AdminPatternList [verbose]                                   ExportFile_Option;

  dump export object
ObjectNamePattern { Dump_ObjectOption } [verbose] ExportFile_Option;


import
- load and import the application schema / the user tools / the object instances from a file

  dump
import [ feature ] Dump_AdminOption AdminPatternList [ [ !/not ] image ]
                                   { Dump_CommitOption } [verbose] ImportFile_Option [force];

  dump import for
AdminPatternList Dump_UserFrameworkOption AdminPatternList
                                   { Dump_CommitOption } [verbose] ImportFile_Option;

  dump import object
ObjectNamePattern { Dump_ObjectOption } {Dump_CommitOption} [verbose]                                    ImportFile_Option;


compare
- compare the application schema definitions from a dump file previously extracted

  dump compare
[ feature ] Dump_AdminOption AdminPatternList [ [ !/not ] image ] [ resume ]                                  [ verbose ]  ImportFile_Option [ LogFile_Option ];


expand
- retrieve all the application schema definitions directly related to other

  dump expand
[ feature ] Dump_AdminOption AdminPatternList [xml | json] [verbose] ExportFile_Option;


Dump_AdminOption
all
Dump_AdminElement { , Dump_AdminElement }

Dump_AdminElement
objectspace
filespace
localarea
field
class
linktype
user
team
assignment
filetype
program
webservice
lifecycle
workflow
menu
command
form
view
autonumber
query
graph
metricsystem
unitmeasure

Dump_UserFrameworkOption
all
Dump_AdminUserElement { , Dump_AdminUserElement }

Dump_AdminUserElement
query
objectgroup
view

ObjectNamePattern
AdminPatternList GenericPatternList GenericPatternList

Dump_ObjectOption
objectspace AdminPatternList
objectgroup AdminName [ user AdminName ]
!image
!file
history
!stage
!links

Dump_CommitOption
overwrite
resume
commit NUMBER


KEYWORDs
commit defines the number of imported objects for each database transaction (default = 1)
feature take into account the administration features
file takes into account the object attachments (enabled as default)
for expresses the user (pattern) list for user tools extraction/import
force this flag allows to ignore some errors during the administration object creation/update
history takes into account the object history (disabled as default)
image takes into account the object icons (enabled as default)
links takes into account the object links (enabled as default)
object expresses the patterns for object instance extraction/import
objectgroup extracts / imports objects from/into a user objectgroup
objectspace used to filter object instances
overwrite force the object overwrite if it already exists
resume continues the import process if an error occurs
stage takes into account the object stage information (enabled as default)
verbose show more information during the process
xml set the export format as xml


SAMPLES


dump export feature all * exportfile "c:/dumpfiles/Admin.xml" xml ;

dump export for 'name.surname' query Q*,T* exportfile "c:/dumpfiles/userAdmin.txt";

dump export object C* * * objectspace OS01 history !file exportfile "c:/dumpfiles/Objects.xml";

dump export object C* * 00 objectgroup OG001 user 'name.surname' exportfile "c:/dumpfiles/Objects.xml";


dump import class,linktype C* image resume overwrite commit 5 importfile "c:/dumpfiles/Admin.xml" force ;

dump import for 'name.surname' all * resume overwrite importfile "c:/dumpfiles/userAdmin.xml";

dump import object SR-* * * history !file resume overwrite importfile "c:/dumpfiles/Objects.xml";

dump compare field * image resume importfile "c:/dumpfiles/Admin.xml" logfile "c:/dumpfiles/Diff.txt" ;

dump compare autonumber,field * resume importfile "c:/dumpfiles/Admin.xml" ;

dump compare feature all * image resume importfile "c:/dumpfiles/Admin.xml" ;

dump expand class * xml exportfile "c:/dumpfiles/Expand.xml" ;


common syntax

Common_GetBasicOption
Common_GetBasicToken [ as IDENTIFIER ]

Common_GetBasicToken
id  
name  
origdate  
moddate  
moduser  
description  
svnrev  
hidden  
image  
imagedata  
feature[ AdminName ] [. Feature_GetBasicOption]
feature[] [. Feature_GetBasicOption]
feature [. Feature_GetBasicOption]
application [. Menu_GetBasicOption]
super  
admintype  

Edit_Operator
add
remove

Edit_RefOperator
addbefore AdminName set
addafter AdminName set
add
remove
movebefore
moveafter

Edit_AddOperator
addbefore AdminName define
addafter AdminName define
append

Edit_MoveOperator
movebefore
moveafter

Event_Type
action
check

AdminPatternList
AdminNamePattern {, AdminNamePattern}

AdminNamePattern
*
PATTERNIDENTIFIER
STRINGVAL
AdminName

GenericPatternList
GenericPattern {, GenericPattern}

GenericPattern
*
IDENTIFIER
PATTERNIDENTIFIER
GenericValue

AdminActor
user AdminName
team AdminName
assignment AdminName

AdminName
IDENTIFIER
QUOTED_STRING
SQUOTED_STRING

GenericValue
DATETIME
GenericNumber
GenericString
BOOLEANVAL

GenericString
STRINGVAL
QUOTED_STRING
SQUOTED_STRING

GenericNumber
NUMBER
REALNUMBER

Filter_Option
moddate Date_Range
application AdminNamePattern

Date_Range
=  DATETIME  
!= DATETIME
 
<  DATETIME
 
>  DATETIME
 
<= DATETIME
 
>= DATETIME
 
in [ DATETIME , DATETIME ]
 
in ( DATETIME , DATETIME ]
 
in [ DATETIME , DATETIME )
 
in ( DATETIME , DATETIME )  

Token_Option
token { Token_Separator { Token_Separator } }
token Token_Separator

Token_Separator
QUOTED_STRING
SQUOTED_STRING
IDENTIFIER
STRINGVAL
json
json-
json+
xml
xml-
xml+

ExportFile_Option
exportfile FileName [append] [xml | json ]

ImportFile_Option
importfile FileName [xml | json |emxxml]

LogFile_Option
logfile FileName [append]

FileName
QUOTED_STRING
SQUOTED_STRING

basic elements
grammar rules
[ ] = optional element - only one item is allowed : ( 0 or 1 )
{ } = optional element - more than one is allowed : ( 0 or N )
/ = alternative
= one of ...
   
  all bold texts represent keywords or command syntax

IDVAL
#<5 dec digits [ 0-9 ]>-<8 hex digits [ 0-9 A-F ]>
  example:
  #00020-34F2A80E

COMMENT
// <any character until the end of the line(\n \r)>
  example:
  // My single line comment

LONGCOMMENT
/* <any character> */
 

example:
  /* My multi line comment starts here
  continue here
  and finish here */


DATETIME
<year 4 digits>[ - /. ]<month 2 digits>[ - /. ]<day 2 digits>
  examples:
   2009-12-23    2009/03/19   2009.11.14
<year 4 digits>[ - /. ]<month 2 digits>[ - /. ]<day 2 digits> <hours>:<minutes>:[<seconds>]
  examples:
   2009-12-23 10:23   2009/03/19 16:03:34  2009.11.14 00:20:04

NUMBER
[+-]<decimal digits [ 0-9 ]>
  examples:
   -1203   +276   25

BOOLEANVAL
true / false

REALNUMBER
[+-]<decimal digits [ 0-9 ]>.<decimal digits [ 0-9 ]>[E(+-)<esponent [0-9]>]
  example:
   -37.837   +2.3874   13.887   1.4862E-04

QUOTED_STRING
"<any character>"
  example:
   "my quoted string"

SQUOTED_STRING
'<any character>'
  example:
   'my single quoted string'

IDENTIFIER
<one or more of [ a-z A-Z ]><zero or more of [ a-z A-Z 0-9 _ ]>
  example:
   Var1    object_Name_02

VARIABLE
$<one o more of [ a-z A-Z 0-9 ]><zero or more of [ a-z A-Z 0-9 _ ]>
 

example:
   $1   $var_02    $1b


STRINGVAL
<one or more of [ a-z A-Z 0-9 -_ $ ? @ | ~ % & / = : + \ # ' ]>
  a string not recognized as identifier

PATTERNIDENTIFIER
<a string with * (match 0 or more characters) and ? (match 1 character) wildcards>
  example:
   mypa*er?_ide?ti*

© 2008-2015 MS Enterprise Solutions | Website Templates by IceTemplates.com
Please Read: Privacy Policy and Terms of Use