Home

USER`S MANUAL

Contents

1. Record OL of 11 Goto 1 Figure 69 Data view If it is opened for a view the modification is not allowed Also if a data view for the selected table is already opened only another read only data view can be opened It can also be openned by clicking twice on a table 8 4 5 1 ACTIONS PERMITTED ON THE GRID e Key navegation o Up arrow selects previous record o Down arrow selects next record o Ctrl Home selects the first record o Ctrl End selects the last record o Tab selects next field o Tab Shift selects previous field User s Manual 92 o Clicking on the column header rows will be sorted ascending the first record displayed will be the record with the lowest value for this field Pressing successively on the same field will change the sorting direction e Presentation o The user is able to move the columns by clicking on the column name and dragging it to its new location 8 4 5 2 MENU BAR 8 4 5 2 1 FILE MENU It contains the following menu items for the files management Export d Import 4 Ga Execute Query e Print B Close App Figure 70 Data view file menu Next all the previous menu items will be further explained 8 4 5 2 1 1 EXPORT It contains the following menu items for the files management Comma delimited CSV Tab delimited CSV CSV XML e Comma delimited CSV It opens a dialog box to select a fil
2. With a blue play sign beside the title of the tab The popup menu is as follow its AA 20806 XE gt JE J e File editor display configuration Toggle Comment Line Wrapping Automatic Indent Send to console confirmation Document Lexicon Send File Content to Console Send Selected Text to Console Copy Cut Paste Select All Add file to project Remove file Delete File Set File as Compilable Unset File as Compilable Set File as Main File Unset File as Main File Figure 52 File editor popup menu All these options have been explained before on Chapter 3 The available accessibility shortcuts for File Editor will be further explained in Chapter 12 User s Manual 80 6 TOOLBAR In the toolbar are displayed some items related with files and projects commands defined by user to be run in console and commands defined by user to run external applications B a S P A D consult process listing dbschema pdg strata abolish bet st dearet cd b pwd log nolog verbose noverbose builtins help 3 Acrobat Reader Figure 53 Tool bar Next we further describe each one of the previous components o O Creates a new file e p Opens a file e a Saves current file e 1 Saves all opened files e D Creates a new project j Opens a project PI Saves current projec
3. REPLACE Displays the replace text window on the file editor Write the text to search for Write the text for the replacement Figure 5 Replace window 28 It offers the same options than the search window and also the replace buttons and the replace text field to select the text to use for the replacements e Search text box Here is where user enters the search text e Special You can search for paragraph breaks and tabs by the special marks p and t These special marks can be written in the text box or selected in the Special combo menu e Recents searches This combo menu displays a list which contains all the recent searches that have been executed before When user selects one this appears in the Text box e Replace text box Here is where user enters the replace text e Special You can replace with paragraph breaks and tabs by the special marks p and t These special marks can be written in the text box or selected in the Special combo menu e Recents replaces This combo menu displays a list which contains all the recent replacements that have been executed before When user selects one this appears in the replaces Text box e Options o Case sensitive this option is used to search for and replace strings without having or taking into account the Upper Lowercase o Regular expressions regular expressions search associated with a search pattern More information about Regular Expr
4. 1 1 USER ACIDE a Configurable IDE does require neither special system configurations nor special system requirements because the executable file is attached in its distribution making the execution of ACIDE A Configurable IDE easy and comfortable to the users ACIDE A Configurable IDE is cross platform and has been tested on MS Windows XP Vista 7 Ubuntu Linux 10 04 1 Ubuntu Linux 12 04 and MacOSX Snow Leopard Executables for all of these operating systems are provided The only mandatory requirement is the previous installation of the Java Virtual Machine JVM The user will have to get the JRE installation file with 1 6 and later versions which is available in the following link http www java com es download manual jsp Only with this easy and fast step the user will be able to run ACIDE A Configurable IDE on his computer without problems However in order to fully enjoying all the features of the application such as ACIDE A Configurable IDE grammar configurations two extra tools will have to be also installed javac exe and jar exe Those tools are available in the Java Development Kit JDK installation file which is available in the following link http www oracle com technetwork java javase downloads index html At last in order to visualize the present document it is mandatory for the users to have previously installed any software for PDF files visualization User s Manual 17 1 2 DEV
5. e Ctrl C copies the selected text active field from the grid to the System clipboard e Ctrl V pastes the text stored in the System clipboard in the current position of the active field in the grid e Ctrl X cuts the selected text active field from the grid to the System clipboard e Ctrl F shows the search text window for the Data view e F5 refresh the view of the grid e Ctrl home goes to the first record e Ctrl end goes to the last record e Ctrl H links directly to the present document Shortcuts in Menu configuration e Up arrow selects previous object e Down arrow selects next object e Ctrl Home selects the first object e Ctrl End selects the last object e Tab selects next attribute e Tab Shift selects previous attribute e Esc deselects the selected object User s Manual 119 13 ACIDE VARIABLES The application supports some variables in the Console Panel External Applications Tool Bar and the shell loaded in the console panel such as e activeFile references the current active file in the file editor panel e activeFileName references just the current active name file in the file editor panel e activeFilePath references just the current active path file in the file editor panel without including neither file name nor file extension e activeFileExt references just the current active extension file in the file editor panel e mainFile references th
6. CLEAR CONSOLE BUFFER Only available in the popup menu of the console panel Clears the console panel content and leaves only the last line of the previous buffer content 3 5 6 DATABASE PANEL CONFIGURATION It contains the menu item options for the database panel configuration management Database Panel ek DES Panel Lanquage eL ODBC Panel iL i Figure 37 Database panel menu Then we proceed to describe each component of the menu 3 5 6 1 DES PANEL When this item is selected the database panel in the left lower corner is connected with DES 3 5 6 2 ODBC PANEL When this item is selected the database panel in the left lower corner is connected with ODBC User s Manual 62 3 0 1 GRAPH PANEL CONFIGURATION It contains the configuration menu options for the graph panel Graph Panel Node color Language Node shape gt Menu i Arrow color gt Tool bar i Arrow shape gt 3 5 7 1 NODE COLOR It shows a window where the user can choose the desired color of the nodes 3 5 7 2 NODE SHAPE Graph Panel 4 Node color Language Node shape gt Y Circle Menu i Arrow color Square Shows the list of available shapes can be used in the pdg graph It allows switching between round and square nodes 3 5 7 3 ARROW COLOR Graph Panel Node color Language Node shape gt Menu i Arrow color gt Positive Tool bar t Arrow shape Negative As much for the positive arrows as
7. Maximum line number 3 5 4 6 SEND TO CONSOLE CONFIRMATION If this option is selected when the user sends contents of the active file in the file editor the application will display the following confirmation message If this option is not selected when the user sends contents of the active file in the file editor the application simply sends the contents to the console panel adding each sent line as a separate command in the console panel command record User s Manual 57 3 9 5 CONSOLE CONFIGURATION It contains the menu item options for the console panel configuration management Shell Database Panel Configuration Execute command Console display configuration Line Wrapping Save content into file Document Lexicon Find Ctrl Mayus F Close shell Mi Okt ee Figure 32 Console menu We also explain how to configure console panel externally with XML files in Chapter 15 3 4 3 5 5 1 CONFIGURATION Configures the shell configurations that are loaded in the console panel Change Executable Path Executable Path Exit Command Figure 33 Shell configuration It contains the following components User s Manual 58 e Executable executable file path e Parameters shell is configured with these parameters e Change executable path it is used for especifying a different folder where the executable file is placed e Executable path executable file folder e Exit command exit command for
8. Tables node popup menu 89 ING GE 0 GE 89 sio ee ithe UA ee 90 Table node popup menu 91 DEINE 91 OP EE 92 Data view file menu 93 EEE EN 95 Dala VIEW edit A DE 95 Data view Search window 96 Data view replace windOow 97 Data view number of repnlacemente 97 Data view records NE scr 97 Data view go to menu 98 15 Figure 8 Figure 79 Figure 80 Figure 81 Figure 82 Figure 83 Figure 84 Figure 85 Figure 86 Figure 87 Figure 88 Figure 89 Figure 90 Figure 91 Figure 92 Figure 93 Figure 94 Figure 94 Figure 96 User s Manual Data view view menu 99 Data view sort by Window rarrnrrnnrnarrrnrvanrnernannnnrnarnnnnnernnnnnennnennene 99 Data view hide show Columns 100 BEITE KE IO OO a 101 Data view about US WINdOW rrnrrnnnrnnrrvnrrvnrrnnrnnnrnnernnernnrennnennnnnnen 102 AGa 6 1 sa EE 103 Add foreign EE 103 Add candidate key 104 Add functional dependency occcoccccccocccococonocononononcnoncocanocanenanonones 104 Add integrity Consirainmt 105 Children of table nodes ooccoocccocccoccccncncncncnoccnnconncnnnnncnnconnrnnnnnnnns 106 Create view WINdOW rrnrrnnrrrnnnrnnnrnnnrnnnnnvnnnvnnrnnnennnnnnnnnnnnrnnnsnnnnenn 107 VIEW NOGE sen o0 XP P 109 View node popup menu 109 COMAS Lee 110 SQL and Datalog text nodes occcoccccccccccccnccocnncncnncocnnononononnnnnonnos 111 lt a 111 BELE 910 LED EEE EEE AE 112 SAUE Dr 114 16 1 SYSTEM REQUISITES
9. User s Manual 123 LINE WRAPPING Enables or disables the line wrapping in the file editor SMAXIMUM LINES Asks to the user for the maximum number of lines to send to the console panel SEND CONSOLE CONFIRMATION Enables or disables the confirmation request when user sends contents to console panel o Console submenu CONFIGURE CONSOLE Opens the console configuration window CONSOLE DISPLAY OPTIONS Displays the console display configuration window CONSOLE LINE WRAPPING Enables or disables the console line wrapping SAVE CONSOLE CONTENT Saves the console content into a file DOCUMENT CONSOLE Loads a lexicon configuration into the console panel SEARCH CONSOLE Opens the search in console window CLOSE CONSOLE Closes the console o Database panel submenu DES PANEL Selects the DES conection in database panel ODBC_PANEL Selects the ODBC conection in database panel o Language submenu SPANISH Selects Spanish as language ENGLISH Selects English as language o Menu submenu User s Manual NEW_MENU Displays the new menu configuration window LOAD_ MENU Loads a menu configuration and applies it to application 124 MODIFY_ MENU Displays the menu configuration window for modifying SAVE_MENU Saves the current menu configuration SAVE_MENU_AS Saves the current menu configuration with a different path o Tool bar submenu e Help menu NEW_TOOLBAR Displays th
10. User s Manual 116 e Down arrow goes to next record e Tab goes to next field e Shift Tab goes to previous field e Alt F4 closes the Data view window e Ctrl Z undoes the updates in the grid e Ctrl Y redoes the last undo in the grid e Ctrl C copies the selected text active field from the grid to the System clipboard e Ctrl V pastes the text stored in the System clipboard in the current position of the active field in the grid e Ctrl X cuts the selected text active field from the grid to the System clipboard e Ctrl F shows the search text window for the Data view e F5 refresh the view of the grid e Ctrl home goes to the first record e Ctrl end goes to the last record e Ctrl H links directly to the present document Shortcuts in Menu configuration e Up arrow selects previous object e Down arrow selects next object e Ctrl Home selects the first object e Ctrl End selects the last object e Tab selects next attribute e Tab Shift selects previous attribute e Esc deselects the selected object 12 2 ACCESSIBILITY SHORTCUTS IN SPANISH Shortcuts in File menu e Ctrl N Creates new file e Ctrl O Opens a file User s Manual 117 e Ctrl G Saves active file in the file editor e Ctrl Shift G Saves all files in the file editor e Ctrl P Prints active file in the file editor e Alt X Closes the application Shortcuts in Edit menu
11. there is the configurable toolbar Finally the status bar gives information about some items The complete path of the selected file the selected grammar and lexicon the line and column numbers Caps Lock Scroll Lock Num Lock and current time All these components will be further explained throughout this document 2 3 PROJECTS A project contains the whole status of a session which is defined by all the possible configurations as well as the current display status It consists of files arranged in folders with any tree depth all the configurations for the session lexicon grammar compiler shell language file editor menu and toolbar main GUI arragement panel sizes and opened files in the project and file attributes File attributes identify a file in a project as compilable and or main If a file is compilable then the compiler configuration can be set to compile each of these files If a file is a main file there is only one in the project then it can be used in the compiler configuration or in the toolbar commands The project structure shown in folders is a logical view which may coincide with the physical structure of the OS folders but this is not needed User can include in a given project a file belonging to another tree structure therefore allowing to share files for different projects 2 4 CONFIGURATION The main objetive of this system is to be as highly configurable as possible keeping the con
12. 131 15 3 3 FILE EDITOR CONFIGURATION The File Editor is where user can edit the content of the files It contains a tab pane where the opened files are displayed The File Editor is configured by a label in the XML file that configures the Workbench explained on Chapter 15 3 Inside this label the user can find the information needed to configure File Editor The labels are e fileEditorConfigurationList acts like a Manager explained on Chapter 15 1 including two nested list labels with AcideFileEditorPanelConfiguration objects These objects store information about files which must be shown opened at File Editor next time the application will be opened e selectedFileEditorPanelName the name of the file which is shown at the File Editor e fontName the font name of the text of File Editor e fontStyle font style of the text of File Editor e fontSize font size of the text of File Editor e foregroundColor backgroundColor RGB components of font color and background color e editionMode with false value edition mode is INSERT with true value itis OVERWRITE e automaticindent with true value automatic indent with false value manual indent e maximumLinesToConsole the maximum number of lines that can be sent to the console at the same time e lineWrapping with true value sets on line wrapping with false value sets off line wrapping e sendToConsoleConfirmation with true value system needs con
13. 5 4 1 PREFERENCES Displays the following configuration window DN Preferences F Use spaces in place of TAB In the Preferences window the user can configure the following parameters e Tab Size by default the size of tabbing is 8 but this can be changed for any value between 2 and 64 e Use spaces in place of TAB every time the tab key is pressed it is replaced by the number of spaces which has been specified above 3 5 4 2 FILE EDITOR DISPLAY OPTIONS CONFIGURATION Displays the following configuration window User s Manual 55 Font Monospaced Font PLAIN 12 Accept Ges Figure 30 File editor display options In the configuration window the user can configure the following parameters e Font type e Font size e Font style e Foreground color e Background color e Restore default values applies the default configuration Monospaced font plain size of 12 black with white blackground 3 9 4 3 AUTOMATIC INDENT Enables or disables the automatic indent in the file editor 3 9 4 4 LINE WRAPPING Enables or disables the line wrapping in the file editor 3 5 4 5 MAXIMUM LINE NUMBER TO SEND TO CONSOLE Asks to the user for the maximum number of lines to send to the console panel from the active file in the file editor User s Manual 56 Maximum number of lines to send to the console Ines Input a maximum number of lines to send to the console Figure 31
14. EEE 85 User s Manual 7 Sl DIOS rr etnia 86 8 2 Database NOG sisi aii iii 86 AE ATEN A E 86 A e e e o SEA 86 Soo 87 BUE NNN 87 8 3 ELA A e PA AP 89 8 3 1 Create table with Uatalog 89 8 3 2 Create table with Design view 89 EP A AA e EE EU OO A 90 D PR 90 0 00 HEN rn 90 8 4 TAPE no A E T 90 OL DN 91 Os RENIO oer a cesar mason eaenes A ceew t ante me cteeenorennednneciene vers 91 CODY A 91 oe DOS Mo re 91 A AA O EER 92 8 4 5 1 Actions permitted on the grid rrnrnnrrrnrrrnrrvnrrvarnrannnannnernnernanennnnnnnnn 92 NT 93 041 32 le ENN 93 SE EE EDO oa 93 945212 A 94 User s Manual 8 045213 BEE QUe see seen 94 Ae 95 BA Zo OS eo 95 9 45 22 EN tio 95 EN Ud Oee E TE E E EEA E EE 95 E ana POO Po TI 95 NNN 96 045222 E 96 ESS EEE EEE 96 oO Oe le e EE 96 E e EE 96 8 4 5 2 3 Records menu 97 TN NN 97 ENN NN 98 TDN RANN ee taa 98 TN Ne 98 E SANN 98 EA A N 99 A e oO 99 PNL nde ET 99 049242 NNN 99 025243 Fiker By SONEN Lasser 100 8 4 5 2 4 4 Filter excluding content 100 User s Manual 9 8 4 5 2 4 5 Discard inter 100 845246 Hide Show COMMING vs noi 100 SOE op een eee PP EE 100 8 4 5 2 5 1 Show NO D eiwsecnschenseevesdieetenincamsssetsreesetatebinuinesdxensacedasesieneedunendenyebexnede 101 945 252 NN 101 9o40 ale Beigl Ee EE 102 AG Add Freio KE 103 8 4 8 Add candidate Key ccocccocccocccocccococococononononononononnncnnonnnnnnnnnnninaninan
15. File as Compilable Unset File as Compilable Set File as Main File Unset File as Main File Figure 7 Project menu Next all the previous menu items will be further explained 3 3 1 NEW PROJECT Configures a new project displaying the following configuration window User s Manual 31 Compiler Interpreter configuration Compier Interpreter Figure 8 Project configuration Next the window options are further described e Name indicates the project name e Folder indicates the folder where the project file will be placed If the project file already exists in the folder the application will give the chance to the user to overwrite it or not The project already exists Do you want to overwrite it e Compiler Interpreter options o Compiler selects the compiler configuration for the new project o Interpreter selects the console panel configuratoin for the new project 3 3 2 OPEN PROJECT Open an existing project User s Manual 32 3 3 3 OPEN RECENT PROJECTS Displays a list with the projects that have been already opened in the application and the option to set the list to empty 3 3 4 CLOSE PROJECT Closes the current project and sets the default configuration 3 3 5 SAVE PROJECT Saves the current project configuration into its configuration file 3 3 6 SAVE PROJECT AS Saves the current project configuration into
16. Unset compilable mie 39 e 39 GS E gu Wa 39 3 4 VIEW NE 40 A OC EEE AA 40 42 POENG E 40 TD NN 40 DAN Le 40 EEE POG EEE ERE EE 40 O e D 41 3 5 CONTIGUPAUON CT E 42 3 5 1 Lexicon configuration oocccoccccocncocccconncconononnnonnnnnnnnnnnononnnnnnonannnonnnnaninons 42 User s Manual 3 5 1 1 Newleviceon 42 PTE Le EE 43 DE VPN eee 43 3 5 1 3 1 Reserved words configuration ennoannennennnnnnunnnnnnnnnennennenenenrenne 44 3 5 1 3 2 Delimiters configuration ooocccoccccccccocncocnnconnccononnnnonnnnnonnnnnncnanononoss 45 3513 3 Remarks Configura Mesina ios 46 Ioa e E E lexiCONS one 47 3 5 2 Grammar configuration cooccccccncocccccnnconnccnnnnonnnnonnnnnnnonnnnnnnonanonnnanonoss 49 3521 New e Le associated 49 eee 00 e le nn o e O O A 51 525 Mod da MM sana tibia 51 3 5 2 4 Gavegorammar mne 52 A PENNEN ee 52 95 20 Configure DUNS E 52 5 PE 53 3 5 4 File editor configuration cccooocccccncocccconncccnconnncnnnononononnnonnonnnnnnnnnnononenos 54 o o 55 3 5 4 2 File editor display options configuration nnannannnnnnennenennenennennnnnn 55 3943 E enee el EE 56 394A LIME WIAD DING EN 56 3 5 4 5 Maximum line number to send to console rrrrnrrrnrrrvnrernnrrvnrrvnnrnnnrr 56 3 5 4 6 Send to console confirmation noaneaaneeeneeennnnnnennornenrrnrsrersrrrrrrennene 57 3 5 5 Console configuration oocccoccccccnconnccccnconnnonnnononnonnnonono
17. allows the user to hide the name of columns and their type so only name of the views are showed User s Manual 108 8 7 VIEW NODE This node relates the name and the fields informatino of one view of the selected database e Integrity Constraints Figure 90 View node Its popup menu is as follows Drop vd Rename Jr Copy O Paste Design View Data View Figure 91 View node popup menu 8 7 1 DROP The view will be deleted from the database 8 7 2 RENAME The user can change the name of the view with this action User s Manual 109 8 7 3 COPY The schema of the selected view will be copied to the clipboard 8 7 4 PASTE A new view with the schema of the view copied in the clipboard before will be created 8 7 5 DESIGN VIEW A window with the SQL text of the view will be showed 8 7 6 DATA VIEW It is almost identical to Data view for Tables explained before on Chapter 8 4 5 8 8 COLUMNS NODES The children of this node are all the columns of the selected view Q a string varchar b number integer Figure 92 Columns nodes 8 9 SQL TEXT AND DATALOG TEXT NODES These nodes show the SQL and Datalog commands of the view definition User s Manual 110 HG Databases 5 E des 1 3 Tables D ds a string varchar b number integer Y a string varchar H SQL Text M Ca BSCLECT ALL department max salary FROM employee GROUP BY dep
18. configuration with XML extension into the console panel 3 5 5 7 FIND Displays the search text window for the console panel Options Direction E Case Sensitive 9 Forward Backward Cydic Search Figure 36 Console search window Then we proceed to describe each component of the window e Text box Here is where user enters the search text e Recents This combo menu displays a list which contains all the recent searches that have been executed before When user selects one this appears in the Text box e Options o Case sensitive this option is used to search for strings without having or taking into account the Upper Lowercase o Regular expressions regular expressions search associated with a search pattern More information about Regular Expressions on Chapter 16 o Whole words find whole words only e Direction o Forward searches from the current caret position to the end of the file in the source file editor User s Manual 61 o Backward searches from the current caret position to the beginning of the file in the source file editor o Cyclic searches from the current caret position to the end of the file in the source file editor and star from the beginning until the starting position 3 5 5 8 CLOSE CONSOLE Closes the active shell in the console panel 3 9 0 9 RESET CONSOLE Only available in the popup menu of the console panel Resets the active shell in the console panel 3 5 5 10
19. da of the icon bar 8 4 5 2 4 3 FILTER BY CONTENT Filters the grid by the content of the selected field It also can be done with the SP icon of the icon bar 8 4 5 2 4 4 FILTER EXCLUDING CONTENT Filters records that do not contain the content of the selected field 8 4 5 2 4 5 DISCARD FILTER a Removes the filter It also can be done with the icon et of the icon bar 8 4 5 2 4 6 HIDE SHOW COLUMNS It will display a window with a grid to select the columns visibility Figure 80 Data view hide show columns In case there are hidden columns a message will be displayed at the bottom of the Data View window 8 4 5 2 5 HELP MENU Contains the following menu items User s Manual 100 Show Help Ctrl H About Figure 81 Data view help menu Next the previous menu options are further explained 8 4 5 2 5 1 SHOW HELP Links directly to the user s manual of DES ACIDE 8 4 5 2 5 2 ABOUT US Displays the following window with some extra information about the application User s Manual 101 Operating System OS Independent Java License GNU General Public License GPL Category Integrated Development Environments IDE Version 0 13 Developers Fernando Saenz P rez Team Director Diego Cardiel Freire Juan Jos Ortiz S nchez Figure 82 Data view about us window 8 4 6 ADD PRIMARY KEY A primary key constraint specifies that no two tuples h
20. extensions and lexicon applied to console lexiconAssignerConfiguration explained in Chapter 15 3 5 e lt _recentFilesConfiguration gt inside this label there is a list inside a _list label of Strings with the paths of files opened recently e lt _recentProjectsConfiguration gt inside this label there is a list inside a _list label of Strings with the paths of projects opened recently 15 3 1 MENU CONFIGURATION The Menu Bar is the element situated at the top of Workbench It contains as default the submenus File Edit Project View Configuration and Help The Menu Bar provides user to do the most of actions that are provided in ACIDE A Configurable IDE The root label of this file is lt acide configuration menu AcideMenultemsConfiguration gt to reference the Java class AcideMenultemsConfiguration Inside this label there is only one basic label temsManager This label has two nested list labels Inside of the most nested there are the acide configuration menu AcideMenuSubmenuConfiguration objects that define the basic menus that exit on Menu Bar They have the following nested labels e lt name gt the name of the submenu e lt visible gt with true or false value It sets if submenu is visible or not e lt _erasable gt with true or false value It sets if submenu is erasable or not erasable it is a default submenu e lt image gt for submenus this label is empty User s Manual 129 e
21. key combination Ctrl end e Next Goes to next record It also can be done with the up arrow key e Previous Goes to previous record It also can be done with the down arrow key e Go to record It displays a dialog window where the user will type down the row number he wants go to Go to mem Enter the record number a Cancel 8 4 5 2 3 5 SELECT RECORD Selects the current record from the grid User s Manual 98 8 4 5 2 3 6 SELECT ALL Selects all the records from the grid 8 4 5 2 4 VIEW MENU It contains the following menu items for the common grid editor management Sort by Sort by Column 7 Filter by Content Filter Excluding Content af Discard Filter Hide Show Columns Figure 78 Data view view menu Next all the previous menu items will be further explained 8 4 5 2 4 1 SORT BY It displays a window with a grid to select the table field by which sort the table and the criteria Ascending or Descending Figure 79 Data view sort by window 8 4 5 2 4 2 SORT BY COLUMN It contains the following menu items for the common grid editor management D Ascending Descending User s Manual 99 e Ascending it will order the grid ascending by the selected column It H also can be done with the icon L of the icon bar e Descending it will order the grid ascending by the selected column It 7 also can be done with the icon
22. lt _itemsManager gt it is equal to root itemsManager label It contains all the menu objects that are inside the submenu For the menu items the label is AcideMenultemConfiguration They have the following nested label e lt name gt the name of the item e lt visible gt with true or false value It sets if item is visible or not e lt erasable gt with true or false value It sets if item is erasable or not erasable it is a default item e lt image gt the path of its image icon e e command gt the command will be run when user click on this menu item e lt parameter gt the type of parameter that command needs to run It can be NONE TEXT FILE or DIRECTORY User can insert delete reorder etc AcideMenuObjectConfiguration labels AcideMenuSubmenuConfiguration and AcideMenultemConfiguration both are subclasses of AcideMenuObjectConfiguration inside the root label to manage the configuration of the Menu Bar 15 3 2 TOOLBAR CONFIGURATION The Tool Bar is situated below the Menu Bar In the Tool Bar appear several buttons for typical actions with files and projects It also contains buttons that user configures to send commands to shell and to launch external applications Toolbar configuration is done in toolbarConfig files These files are divided in two parts one part that stores settings of buttons for the toolbar that paste code on the console to be run and other part for configuration of butt
23. proceed to describe each component of the window e Text box Here is where user enters the search text e Special You can search for paragraph breaks and tabs by the special marks p and t These special marks can be written in the text box or selected in the Special combo menu e Recents This combo menu displays a list which contains all the recent searches that have been executed before When user selects one this appears in the Text box e Options o Case sensitive this option is used to search for strings without having or taking into account the Upper Lowercase o Regular expressions regular expressions search associated with a search pattern More information about Regular Expressions in Chapter 16 o Whole words find whole words only Scope o Selected text search within a selected text User s Manual 27 Current document document search starting in a certain position of the active file of File Editor All opened documents searches in all opened files on the file editor Direction o Forward searches from the current caret position to the end of the file in the source file editor Backward searches from the current caret position to the beginning of the file in the source file editor Cyclic searches from the current caret position to the end of the file in the source file editor and star from the beginning until the starting position Progress bar shows the progress of the active search
24. the configuration file as indicated at line number 34 The properties are as follows e Absolute path e Name e Parent e Directory flag e Compilable flag e Main flag User s Manual 134 e Opened flag 15 5 CONFIGURATION OF LEXICONS Lexicons can be configured by manually editing XML files that define them A XML file that defines a lexicon begins with the root label lt acide configuration lexicon AcideLexiconConfiguration gt to reference the class AcideLexiconConfiguration Inside this root label there are seven basic tags e name defines the name of the lexicon e path indicates the relative path of this file e isCompiledOrinterpreted a false value indicates that the lexicon is compiled and true indicates that it is interpreted e _tokenTypeManager it is a Manager explained on Chapter 15 1 of the types of token there are in the lexicon It consists of a list of objects AcideLexiconTokenGroup e validExtensionsManager it is a Manager of valid extensions of files at the lexicon defined in the XML document The extensions are String objects e _delimitersManager it is a Manager of valid delimiters at the lexicon defined in the XML document The delimiters are String objects e remarksManager it is not a common Manager It defines the symbol to mark a line as a comment in the lexicon It has four nested labels o symbol defines the symbol to use to begin a comment line o _isCaseSensi
25. typing Java jar des acide jar User s Manual 18 2 INTRODUCING ACIDE ACIDE A Configurable IDE is a cross platform open source Integrated Development Environment IDE It has been developed by different teams of students coursing Computing Systems and directed by Fernando Saenz P rez Next ACIDE A Configurable IDE features will be further explained 2 1 TECHNOLOGY The implementation of the application has been completely done using Java under Eclipse Version control was kindly provided by Tortoise SVN 2 2 THE MAIN GUI Figure 1 shows the main GUI of ACIDE It consits of four main panels The left panel shows the organistation of the current project the MDI windows in the middle are the opened files which may belong to the project files may be opened without assigning them to the project and in the right side is the graph panel which shows the PDG Below the left panel shows the databases system connected with ACIDE which allows user interaction Beside the shell panel is shown The case shown is the DES console The databases shell project and graph panels can be hidden Also these panels can be switched by a drag and drop action For this purpose the menu bars or the tabbed pane in the File Editor in the panels can be selected using the left mouse button after that the panels can be dragged and released in another Moreover there is no need to work with projects if this flexibility is not needed a re
26. with TXT extension e Accept button initializes the grammar creation process e Cancel button closes the window without applying the changes User s Manual 50 In the moment that the new grammar is created it is not saved until the user selects the save menu option In the case that the user closes the application without saving it the last grammar configuration will be loaded If the user selects to verbose the grammar creation process the following window will be displayed Grammar file generation process Executing ANTLR C Archivos de programa Java jdkl 6 0_ 2l bin java exe cp lib antlr jar antlr Tool grammar g ANTLR execution task completed successfully Executing generated files by ANTLER modification Generated files by ANILE modification successfully Compiling generated files by ANTLR C Archivos de programa Java jdkl 6 0 21 bin javac exe cp classes java d Compilation of generated files by ANTLR task completed successfully Reallocating generated files by ANTLR Reallocation of generated files by ANTLR task completed successfully Generating the jar file Generation of jar file task completed successfully Deleting generated files by ANTLR Deletion of generated files by ANTLR task completed successfully Reallocating the jar file into the configuration folder Reallocation of the jar file into the configuration folder task completed successfully
27. 4 4 DATA BASE Hides or shows the database panel This panel can be also hided clicking the button in the database menu bar 3 4 5 PDG Hides or shows the graph panel This panel can be also hided clicking the button in the PDG menu bar User s Manual 40 3 4 6 DEBUG Hides or shows the debug panel This panel can be also hided clicking the button in the debug menu bar User s Manual 41 3 5 CONFIGURATION MENU It contains all the menu item options for the configuration management of all the modules of the application Lexicon d Grammar amp Compiler File Editor Shell d Database Panel gt Graph Panel Language Menu Tool bar Figure 16 Configuration menu 3 5 1 LEXICON CONFIGURATION It contains all the menu item options for the lexicon configuration management of the application Lexicon New Grammar i Document Lexicon Ctrl Mayus L Compiler Modify Ctrl Mayus X File Editor Default Lexicons Figure 17 Lexicon menu We also explain how to configure lexicons externally with XML files in Chapter 15 5 Next all the previously mentioned options are further explained 3 5 1 1 NEW LEXICON Creates a new lexicon configuration with the name that the user types down in the following window applying it to the active file in the file editor User s Manual 42 Figure 18 New lexicon 3 5 1 2 DOCUMENT LEXICON Loads the lexicon configuration file with
28. 8 3 5 2 GRAMMAR CONFIGURATION It contains the menu item options for the grammar configuration management Grammar New Ctrl Mayus T Y Compiler Load File Editor Modify Shell Save Database Panel Save as Language Set paths Figure 23 Grammar menu Next we further explain each one of the previous menu item options 3 5 2 1 NEW GRAMMAR Creates the new grammar configurations from lexicon categories and grammar rules with EBNF format in the following configuration window User s Manual 49 A New grammar Lexicon Categories Grammar Rules Load Save toad Save Figure 24 New grammar The window has the following components e Lexicon categories panel O Lexicon categories text area shows the content of the lexicon categories plain text file with TXT extension Load button loads the content of the lexicon categories plain text file with TXT extension into the lexicon categories text area Save button saves the content of the lexicon categories text area into a plain text file with TXT extension e Grammar rules panel O Text box of grammar rules shows the content of the grammar rules plain text file with TXT extension Load button loads the content of the grammar rules plain text file with TXT extension into the grammar rules text area Save button saves the content of the grammar rules text area into a plain text file
29. ACIDE A CONFIGURABLE IDE USER S MANUAL VERSION 0 13 INDEX OF CONTENTS e o n aE EEEE E EEE E EEEE SNE 2 MIG GX OF el 13 1 System Bn EGEN 17 1 1 USE AP E sane teu ssusmaseauesahoeesesensie 17 1 2 BILAT 1 0 arininn ae A AA 18 1 3 EXCCUtINO ACIDE eae E orcas 18 2 IWAWOGUCING ACIDE EEE 19 2 1 io AAA O A e 19 22 Th Main NE NE NE 19 2 3 PIOJO Sarabia BS ME NA NE 21 2 4 CONTIGUA eege 21 EE EEr O S 22 3 1 ER EMNE NE NE 22 VE NN 22 gt OP a 22 i NENNE 23 e e o OO EA 23 Slds OSC MO eiii caos 23 EE CIS MO sto acera 23 ANS eE EE 23 User s Manual 2 39 148 SEE 23 EE EEE EE 23 PE 23 EE as 23 3 2 gt AAPP 25 S UI droit dencia 25 LL REN 25 E E ee E 25 J PN or 26 A A 26 326 TONE NNN dai 26 SN MS PA 26 nn A 26 2 E te A o o e oo A 26 3210 RODICE EEE 28 3 3 Fed MENU cuales 31 O dl NEW Dro SO rara icono caos 31 A A PP eee eee ee ee eee eee 32 3 0 ODEN recent projects savanne 33 Se ee EN 33 do NENNE 33 200 AE NON Eee 33 3 3 7 New project nie 33 User s Manual 3 3 3 8 Add all opened ies 33 DI Ada lt n ee eee eee ee 33 SO REMOVE gt ee ree eee ee eee eee 33 SE fa Delete A 0 000 O IA 33 GE A A e ere A 34 do Remove NE AN 34 3 9 14 Compl MOE Egeter EE 35 3 3 14 1 Compilation based on Extension 35 3 3 14 2 Compilation based on Marked files for compilation 36 A Apo a O a o a 38 3310 Setcompllable M eiascicniaa 39 3 3 17
30. Bridge oncobridge G Add Folder RER Remove Folder public Etiquetador E Compile Project Alte onto pew ntologyberusent https fwew owl ontelogies comUntologylig4233760 owl amp Execute Project Alt E Eile famoses cwl v A getInstancedntobridge initWithPellecReasoner Unset File as Zen gqetInstancedatobridge loadintology onto new ArrayList lt OntologyDocument gt false Set File as Main File mainWindow MainWindow getIngtance a Unset File as Main File 3 Databases Fernando Saenz Perez el 2004 2013 og GPD DCH a Please send comments questions ETC to Ternan sip ucm es Web site la http des gourceforge nets This program Comes with ABSOLUTELY NO WARRANTY is jr d free software and you are welcome to redistribute it e under certain conditions Type license for details DES gt C sera Usuario lprorkpacelacide Ejemplo java Class 2 java Grammar bytes Les cor Configuration default 3 20 Numiines 18 INS 12 47 48 Figure 11 Marking files e Next the user configures the compiler options in the compiler configuration as follows User s Manual 36 Figure 12 Compilation by marked files Finally the user selects the Menu Project Compile menu item option User s Manual 37 3 3 15 EXECUTE PROJECT It displays the following configuration window Execution Configuration Executable Path path Arguments argu
31. ELOPER For developers it is mandatory to have previously installed the Java Development Kit JDK with 1 6 and later versions and any software for the edition of the source code The source code has been fully edited with the Eclipse IDE tool which is available in http www eclipse org Furthermore with the ACIDE A Configurable IDE source code distribution the Eclipse project file is available The developer has to import the project file into Eclipse and start the edition fast and simple 1 3 EXECUTING ACIDE User has to unpack the distribution archive file into the directory he wants to instal ACIDE A Configurable IDE which will be referred to as the distribution directory from now Since it is a portable application it needs to be started from its distribution directory which means that the start up directory of the shortcut must be the distribution directory To execute ACIDE A Configurable IDE on the different SOs user only has to run the des_acide jar file to open an instance of the application preconfigured to work with DES At Windows the user only have to do double click in the file He also can create a script or an alias for executing the file at the distribution root typing Java g r des acide jar or to avoid that shell depends on executable Javaw jJar des acide Jar Linux and Linux the user can create a script or an alias for executing the file des_acide jar at the distribution root
32. ER As a Manager it has two nested list labels Inside the last the user can find String objects labels where he can define extensions valid for the lexicon 15 5 3 DELIMITERS MANAGER It is a Manager whose list contains String objects With the strings the user defines the valid delimiters for the lexicon 15 6 COMMANDS HISTORY In ACIDE A Configurable IDE is possible to configure a commands history so that when user starts the application already exits this history similar to when he gets commands entered earlier in the same run User s Manual 136 The XML file that contains the commands history must be saved in the path contiguration console The root label of this file is lt acide configuration console AcideConsoleCommandsConfiguration gt to reference the AcideConsoleCommandsConfiguration class Inside this label user has to define another label of Manager type called commandsManager As usual at Managers there are two nested list Inside the last the user defines by String labels the commands he wants to introduce in the commands history The first command at the list acts like the less recently entered at the console User s Manual 137 16 REGULAR EXPRESSIONS A regular expression often called pattern is an expression that describes a set of strings without listing their elements Most formalizations provide the following constructors a regular expression is a way of representing regular
33. Figure 25 Grammar generation process 3 9 2 2 LOAD GRAMMAR Loads a grammar configuration with JAR extension 3 5 2 3 MODIFY GRAMMAR Displays the same grammar configuration window than the New Grammar menu item option but it contains the lexicon categories and grammar rules text areas filled with their file contents User s Manual 51 acom STAR atom VM ME IN LPAREN expr EPARDI e NVA pg AS isetType Token 3X1P toad Il ze _ Figure 26 Modify grammar 3 5 2 4 SAVE GRAMMAR Saves the current grammar configuration into a file with JAR extension 3 5 2 9 SAVE GRAMMAR AS Saves the current grammar configuration into a file with JAR extension in a different path 3 5 2 6 CONFIGURE PATHS For the creation modification and grammar configurations to hand it is mandatory to define the required tools paths as it was mentioned in the first chapter of the present document It displays the following window User s Manual 52 oom ee Lg java exe path C Program Files x85 Vavaljdk1 7 0 21 binljava exe javac exe path TG C Program Files x86 avaljdk1 7 0 211binljavac exe jar exe path 7 C Program Files x86 Java jdk1 7 0_21 bin jar exe Figure 27 Set paths In each one of the text fields the user will select the path to each one of the required tools The window also contains the following components e Check box if it is selected the application will use the path select
34. LP MENU Contains the following menu items Y ShowHelp Ctrl H Y About Figure 46 Help menu Next the previous menu options are further explained 3 6 1 SHOW HELP Links directly to the present document User s Manual 74 3 6 2 ABOUT US Displays the following window with some extra information about the application D About ACIDE ole Gah Figure 47 About us window User s Manual 75 3 7 INSERTED SUBMENUS As explained in chapters 3 5 9 and 15 3 1 user can insert new submenus in the tool bar Then inside these submenus new inserted submenus and menu items can be defined For each inserted submenu the attributes are e Name the name of the submenu e Visible define if the submenu is visible or not in the application e Erasable define if the submenu is a default submenu not erasable or not is erasable The value of this attribute can not be edited e List list of all the submenus and menu items that the submenu contains e Image for submenus the value of this attribute is empty An example of an inserted submenu is Active File gt listing dbsch Tables MB Dir i cd Log i Is Verbose pwd builtins help ormulation Figure 48 Example of inserted submenu In this example we can see an inserted submenu called DES and defined in the menu bar User s Manual 76 3 8 INSERTED MENU ITEMS As explained in chapters 3 5 9 and 15 3 7 user can insert new
35. Project Path Compiler Path Compiler Arguments File separator File extension Executable path 2 3 4 S Compiler All Files 6 7 8 I Executable arguments 10 Console panel Shell path 11 Console panel Shell directory 12 Console panel exit command 13 Console panel is echo command 14 Console panel parameters 15 Console panel foreground color 16 Console panel background color 17 Console panel Font name 18 Console panel Font style 19 Console panel Font size 20 Console panel buffer size 21 Is explorer panel showed flag 22 Is console panel showed flag 23 Is database panel showed flag 24 Is SE panel showed flag 25 ACIDE A Configurable IDE main 26 ACIDE A Configurable IDE main 27 ACIDE A Configurable IDE main 28 ACIDE A Configurable IDE main 29 ACIDE A Configurable IDE main split 30 ACIDE A Configurable IDE main 31 ACIDE A Congigurable IDE main split 32 Language configuration 33 Database panel configuration 34 Menu configuration 35 Menu new configuration 90 Tool bar Contiguraciton 37 Number of files of the project window window window window window window window width height x coordinate y coordinate left vertical horizontal split right vertical The following lines show the properties of the project files For each file there are seven lines of text storing the file properties Therefore there will be many groups of seven lines in
36. TIONAL DEPENDENCY A functional dependency constraint specifies that given a set of attributes A7 of a relation R they functionally determine another set A2 e each tuple of values of A7 in R is associated with precisely one tuple of values A2 in the same tuple of R To define a functional dependency constraint user has to type fd name of the relation A1 A2 This menu option displays a window where you can write the datalog command to create a functional dependency in the selected table D Add Functional Dependen fd p a b OK Canes E Figure 86 Add functional dependency 8 4 10 ADD INTEGRITY CONSTRAINT A integrity constraint is represented with a rule without head The rule body is an assertion that specifies incosistent data e should this body can be proved an inconsistency is detected and reported to the user Declaring such integrity constraints implies to change your mind w r t usual consistency constraints as domain constraints in SQL For instance to specify that a column c of a table t can take values between two integers one can use the SQL clause CHECK in the creation of the table as follows CREATE TABLE t c INT CHECK c BETWEEN 0 AND 10 In contrast in Datalog user can submit the following constraints User s Manual 104 DN Add Integrity Constraint z 1600 X lt 0 x gt 10 Figure 87 Add integrity constraint Notice that the rule body succeeds for
37. Table contains the delimiter list and it is possible to modify it directly on it 3 5 1 3 3 REMARKS CONFIGURATION Select a color Select type of source Preview Figure 21 Remarks configuration Next we further detail all its components e Comment symbol text field for input the remark symbol e Case sensitive check box for specify if the remark is case sensitive or not e Color selection button for the color selection of the remarks e Font style combo box for the font style selection User s Manual 46 e Preview text field shows a preview of the remarks The lexicon configuration window has in the bottom side the following buttons e Save as saves the current lexicon configuration in other path with XML extension e Apply applies the changes to all the opened files with the current lexicon configuration in the file editor and saves the changes in the configuration file with XML extension e Cancel closes the lexicon configuration window without applying the changes Finally if there are any changes in the current configuration in the previously described panels and the user closes the window with the close button or the ESC key the following dialog will be displayed Lexicon configuration mg mi Do you want to save the changes in the lexicon configuration 3 5 1 4 DEFAULT LEXICONS Shows the default lexicons configuration window User s Manual 47 DN Default Lexicons Co
38. XML extension in the active file in the file editor 3 5 1 3 MODIFY LEXICON Open the lexicon configuration window that contains the following tabs User s Manual 43 3 5 1 3 1 RESERVED WORDS CONFIGURATION ANT ST Hl 1 P D DTD EE AAA EE EE EE EE EE EE EE EE Reserved Word Configuration PERERA SSPE EPP PEPE PEER EERE EEE dd 55 5 05 6 ie iii iii dd dd dd dd dd FEF EE RER ES REES gg gg gg gg dag Select a color Select type of source Normal e Figure 19 Reserved words Next we further describe each one of its components as follows e Add adds a new table reserved word entry e Delete removes a table reserved word entry e Modify modifies a table reserved word entry e Set delimiter style the delimiter list now is also taken as reserved words e Table contains the list with the reserved words groups by types and colors Note it is not allowed to modify the table entries directly on the User s Manual 44 table itself and the changes will not be applied until the modify button is pressed down 3 5 1 3 2 DELIMITERS CONFIGURATION Figure 20 Delimiters configuration Next all its components are further detailed e Input new delimiter text field the user inputs the name of the new delimiter e Add button adds the input delimiter in the text field to the table e Delete button removes selected delimiter from the table User s Manual 45 e
39. a different configuration file 3 3 7 NEW PROJECT FILE Creates a new empty file in the file editor and adds it to the current project configuration after asking to the user for its final destination 3 3 8 ADD ALL OPENED FILES Adds all the opened files in the file editor to the current project configuration Files that already belong to the project will not be included again 3 3 9 ADD FILE Adds the active file in the file editor to the project configuration 3 3 10 REMOVE FILE Removes the file from the project configuration but does not deletes it from disk 3 3 11 DELETE FILE Removes the file from both project configuration and disk previous user confirmation User s Manual 33 3 3 12 ADD FOLDER Adds a new folder to the project in the selected level at the explorer tree and checks that it does not exist another folder with the same name before adding it Figure 9 Add folder If already exists another folder with the same name at the same level at the explorer tree displays the following message and does not add it 3 3 13 REMOVE FOLDER Removes the folder from the project configuration previous user s confirmation User s Manual 34 a A O Are you sure to remove the folder from the project 3 3 14 COMPILE PROJECT The project is compiled with the selected parameters in the compiler configuration window that will be further detailed in the following chapters of the pre
40. artment Datalog Text ds A B group by employee C A D A B max D i Integrity Constraints Figure 93 SQL and Datalog text nodes The user can make double click in this node and a window with this text will appear where user can modify it aoe e ES SELECT ALL department max salary FROM employee GROUP BY department Figure 94 SQL text User s Manual 111 group Pi employee C A D A B max D Figure 95 Datalog text With the popup menu user can show and edit too and copy the definition text User s Manual 112 9 PDG PANEL The graph panel shows the dependencies graph attached to a datalog file An example of the graph panel is as follows parent 2 een The nodes can be located by clicking and dragging them The buttons in the bottom of the panel are used to zoom in and out the graph This effect can also be achieved by scrolling the mouse wheel while pressing CTRL key This graph is highly customized the shape of the nodes the color and end of the arrows can be switched explained in chapter 3 5 5 User s Manual 113 10 DEBUG PANEL 11 STATUS BAR The Status Bar contains some information about the active file the current project and so on It is as follows examples aggregates d Grammar bytes Lexicon Configuration des 23 28 MumLines 8 TNS 00 19 56 Figure 96 Status bar Next we further describe all the components e Pan
41. at the end of its submenu It can exits only one of each default menu object The application will delete the rest e Image the path of the image icon of the menu item The image icons belong only to menu items e Path indicates the location of the menu object inside the menu which contains it e Child rows it is only for menu submenus It indicates the number of row of their childern e Command it is only for menu items It sets the command that the menu item will run The commands that start with a sign are intern commands for ACIDE A Configurable IDE and they are explained on Chapter 14 Commands that not start with are sent to console e With parameters it is only for menu items Indicates the type of parameter which the command needs to run 3 5 9 1 1 BUTTONS PANEL Next we further describe each of the buttons of the configuration window EA Add new menu It will display a window where user can type down the name of the new menu he wants to insert It will be inserted at the end of the menus list e A Delete menu lt will delete the present menu before a confirmation message The default menu can be deleted at Move menu to the left moves the present menu to the left in the menus list e HA Move menu to the right moves the present menu to the left in the menus list Add new submenu adds a new submenu to the menu selected If there is a menu submenu selected the new subme
42. ave the same values for a given set of columns To define a primary key constraint user has to type pk name_of the relation column name _list This menu option displays a window where user can write the datalog command to create a primary key in the selected table User s Manual 102 pk p all Figure 83 Add primary key 8 4 7 ADD FOREIGN KEY A foreign key constraint specifies that the values in a given set of columns of a relation must exist already in the columns declared in the primary key constraint of another relation To define a foreign key constraint in a relation the user has to type S fk name of the target relation name of the column_foreign_key name_of sou rce relation name of source column This menu option displays a window where user can write the datalog command to create a foreign key in the selected table EY Add Foreign Key fk p a q b Figure 84 Add foreign key 8 4 8 ADD CANDIDATE KEY As a primary key a candidate key constraint specifies that no two tuples have the same values for a given set of columns To define a candidate key constraint user has to type ck name_of the relation column name list This menu option displays a window where user can write the datalog command to create a candidate key in the selected table User s Manual 103 D Add Candidate Key ck p a b OK _ Cancel Figure 85 Add candidate key 8 4 9 ADD FUNC
43. bles of this database lts popup menu IS Create Table with Datalog Create Table in Design View Create Table with SQL Paste Hide Details Figure 64 Tables node popup menu 8 3 1 CREATE TABLE WITH DATALOG This option is only enabled if the panel is connected with DES The user can create a table with a Datalog command in a window similar to the window of Execute query action Chapter 8 2 4 8 3 2 CREATE TABLE WITH DESIGN VIEW With this option the user can create a new table usign a design table with four columns to choose name of the field type primary key and not null D Design View new_table Field name Type Figure 65 New table User s Manual 89 With the new rows can be inserted in the design table If you want to make a field part of the primary key you have to mark the checkbox of that column This option make impossible to mark the Disallow nulls option 8 3 3 CREATE TABLE WITH SQL It displays a window like the Execute query Chapter 8 2 4 window where the use can create a table with SQL commands 8 3 4 PASTE This option will create a new table with the schema or with the schema and data that the user has copied before from another table of the panel 8 3 5 HIDE DETAILS This option allows the user to hide the name of columns and their type so only name of the tables are showed 8 4 TABLE NODE If the panel is connected with DES nodes of this type will sho
44. closing the data stream e Command echo indicates if the commands typed in the console panel have to be displayed or not 3 5 5 2 EXECUTE EXTERNAL COMMAND Executes a command into a shell and displays the result in a separate window that looks like Executable C Users Usuario workspace acide des des win des exe Change Executable Path Executable Path C Users Usuario workspace ladde des des win Exit Command o Y Command Echo Command Figure 34 Execute external command 3 5 5 3 CONSOLE DISPLAY CONFIGURATION Displays the following configuration window User s Manual 59 D Console display configuration 77 sfo Choose font foreground color Choose font background color Choose a maximum buffer size 500 Restore Default Configuration Preview Panel Font Monospaced Font PLAIN 12 Figure 35 Console display configuration The user can selects e Font type e Font size e Font color e Background color e Maximum buffer size specifies the maximum number of lines that are displayed in the console panel e Restore default configuration applies the default configuration for the console panel Monospaced font plain size of 12 black with white background 3 5 5 4 LINE WRAPPING Enables and disables the console line wrapping 3 5 5 5 SAVE CONTENT INTO FILE Saves the console content into a file User s Manual 60 3 5 5 6 DOCUMENT LEXICON Loads a lexicon
45. connect the panel with other database The following window is displayed D Open database Figure 59 Open database 8 1 2 REFRESH All the database panel will be refreshed and user will see all the modifications made with it User s Manual 85 8 1 3 CLOSE The database panel will be closed 8 2 DATABASE NODE B Databases CR Figure 60 Database node All the databases opened on this panel are showed in this level of the tree With the contextual menu user can do the following actions Set as Default se Close 4 Refresh nf Execute Query Figure 61 Database node popup menu 8 2 1 SET AS DEFAULT If the shell is connected to DES this option will set this database as the database in use for the following commands 8 2 2 CLOSE It will close the connection with the database User s Manual 86 8 2 3 REFRESH It will refresh the database node 8 2 4 EXECUTE QUERY It will displays a window with a text field to input queries in SQL in the database D Execute Query Figure 62 Execute query When user clicks on OK button the results are showed on the Data View Data View will be further explained in Chapter 8 4 5 Expanding this node there will be three folders below it tables views and integrity constraints User s Manual 87 User s Manual Figure 63 Expanding database node 88 8 3 TABLES NODE The childrens of this node will be all the ta
46. d classic Mac OS uses only lr e la represents a bell or beep that occurs when you print this character e le represents the Esc or Escape e VW represents a page break e lv represents a vertical tab User s Manual 139 e x is used to represent ASCII or ANSII code e lu is used to represent UNICODE characters with its code e d represents a digit from 0 to 9 e w represents any alphanumeric character e Is represents a blank space e ID any character other than a digit from 0 to 9 e W represents any non alphanumeric character e S any character other than a blank e YA represents the beginning of the string Not a character but a position e Z represents the end of the string Not a character but a position e Ib marks the beginning and end of a word e B marks position between two alphanumeric or non alphanumeric characters 16 2 3 THE BRACKETS The function of the brackets in regular expressions is to represent character class grouping characters into groups or classes They are useful when is needed to find one of a group of characters Within the brackets you can use the to specify ranges of characters Additionally the metacharacters lose their meaning and become literal when they are inside the brackets For example as mentioned previously Ad is useful to find any character that represents a digit However this name does not include the dividing the decimal part
47. der the next time he displays a load or save project dialog e javaPath path of java exe e projectConfiguration path to the acideProject file used to configure opened project explained in Chapter 15 4 e consolePanel foregroundColor foreground color for console panel numeric valor e consolePanel parameters parameters that console panel needs 15 3 WORKBENCH CONFIGURATION The workbench is all the space where user works with files lt contains the Menu Bar the Tool Bar the Explorer Panel the File Editor the Console Panel and the Database Panel The XML file that configures the workbench must be saved in the path configuration workbench The root label of this file is lt acide configuration workbench AcideWorkbenchConfiguration gt to reference the Java class AcideWorkBenchConfiguration Inside this root label there are six basic labels e lt workbenchLoaded gt with true value identifies if the configuration XML file has been loaded User s Manual 128 e lt fileEditorConfiguration gt inside this label there are others nested labels with the configuration of the file editor explained in Chapter 15 3 3 e lt _consolePanelConfiguration gt inside this label there are others nested labels with the configuration of the console panel explained in Chapter 15 3 4 e lt lexiconAssignerConfiguration gt inside this label there are others nested labels with the configuration of lexicons for different
48. e A text file will be created with all the records of the grid and all their fields in the order they appear in the grid separated by commas e Tab delimited CSV Same as comma delimited CSV but the separator character between fields is the fab User s Manual 93 e CSV This opens a dialog box where user can write the separator character and proceed to select the file and save the data e XML This opens a dialog box to select a file A XML file will be created with the following structure lt DATA gt lt ROW gt lt col gt vealue lt co1 gt lt ROW gt lt DATA gt 8 4 5 2 1 2 IMPORT It contains the same menu items as Export menu item e Comma delimited CSV This opens a dialog box to select a file For each line of the text file the value that corresponds to the field appears in the grid Each line will be inserted in the table as described before e Tab delimited CSV same as comma delimited CSV but the separator character between fields is the tab e CSV this opens a dialog box where user can write the separator character and proceed to select the file and load the data e XML This opens a dialog box to select a file It will read the XML file with the structure indicated above Each row of data of the XML file will be inserted in the table 8 4 5 2 1 3 EXECUTE QUERY It displays a dialog in which the user will type down the query he wants to perform User s Manual 94 D Create table wi
49. e Ctrl Z Undo the last action e Ctrl Y Redo the last change e Ctrl C Copy the selected text to the System clipboard e Ctrl X Cuts the selected text to the System clipboard e Ctrl V Paste the test in the System clipboard e Ctrl E Select all the text in the active file of the file editor e Ctrl B Opens the search window e Ctrl L Opens the replace window Shortcuts in Project menu e Alt Shift N Creates a new project e Alt Shift O Opens a project e Alt Shift S Save the opened project e Alt Shift A Adds a file to the opened project e Alt C Compiles the opened project e Alt E Executes the opened project Shortcuts in View menu e Alt Shift L Shows the log tab Shortcuts in Configuration menu e Ctrl Shift L Documents lexicon e Ctrl Shift X Modifies the lexicon e Ctrl Shift T Creates a new grammar e Ctrl Shift A Actives line wrapping e Ctrl Shift F Opens the search in console window e Alt S Changes language to Spanish User s Manual 118 e Alt E Changes language to English Shortcuts in Help menu e Ctrl H Shows this document Shortcuts in Data view e Up arrow goes to previous record e Down arrow goes to next record e Tab goes to next field e Shift Tab goes to previous field e Alt F4 closes the Data view window e Ctrl Z undoes the updates in the grid e Ctrl Y redoes the last undo in the grid
50. e file in the file editor panel that has been marked as MAIN file e mainFilePath references the just file path in the file editor panel that has been marked has MAIN file without including neither file name nor file extension e mainFileExt references just the file extension in the file editor panel that has been marked as MAIN file User s Manual 120 14 ACIDE DEFAULT COMMANDS As explained in Chapter 3 5 9 with the menu configuration the user can assign to the application the actions that will be executed when menu items are pressed down All these commands start with The commands assigned by default to ACIDE A Configurable IDE menu items are e File menu O O O NEW_FILE Creates a new file in the file editor OPEN FILE Opens a file in the file editor OPEN ALL FILES Opens all the files of the active project CLOSE_FILE Closes the active file in the file editor CLOSE ALL FILES Closes all files in the file editor SAVE_FILE Saves the active file SAVE_FILE_AS Saves the active file in a different path SAVE ALL FILES Saves all the opened files in the file editor PRINT_FILE Prints the active file in the file editor EXIT_FILE Closes the application e Edit menu O User s Manual UNDO Undoes the last action REDO Redoes the last undone action COPY Copies the selected text to the System clipboard PASTE Pastes the text in the System clipboard CUT Cuts the sel
51. e new toolbar configuration window LOAD_ TOOLBAR Loads a tool bar configuration and applies it to application MODIFY_TOOLBAR Displays the tool bar configuration window for modifying SAVE_TOOLBAR Saves the current tool bar configuration SAVE_TOOLBAR_AS Saves the current tool bar configuration with a different path o SHOW_HELP Opens this document o SHOW_ABOUT_US Displays the About Us window These commands can be assigned to other menu items than are not the default menu items User s Manual 125 15 CONFIGURATION OF ACIDE BY CONFIGURATION DOCUMENTS 15 1 MANAGERS IN XML FILES Frequently in XML configuration files we found labels of the form Manager These labels contain a type of object called Manager that is responsible for handling lists of different types of objects Inside the labels of a Manager there is another label called ist and that in turn holds another label also called list It is inside this label where user introduces the labels of the objects that make up the list he wants to handle with the Manager could be a list of String AcideLexiconTokenGroup etc There are java classes for each of the Managers in XML files which provide methods to manipulate the lists as adding removing or getting items from them Manager Java classes have an ObjectList type field which in turn has an ArrayList field where user stores the list of objects and methods for manipulating that l
52. e with the key combination Ctr F or with the icon of the icon bar 8 4 5 2 2 REPLACE Displays the replace text window of the data view User s Manual 96 D Replace Lea Write the text to search for Recents Write the text for the replacement Figure 74 Data view replace window When a general replacement is performed it displays the following dialog to the user informing of the number of replacements Figure 75 Data view number of replacements 8 4 5 2 3 RECORDS MENU It contains the following menu items for the common grid editor management Delete o sil Refresh F5 Go To Select All Figure 76 Data view records menu Next all the previous menu items will be further explained 8 4 5 2 3 1 NEw Inserts a new record in the grid The values of the new record must be written at the last row of the grid It also can be done clicking in the cell with the icon User s Manual 97 8 4 5 2 3 2 DELETE Deletes the selecetd record from the grid 8 4 5 2 3 3 REFRESH Updates the view of the grid 8 4 5 2 3 4 GOTO It contains the following menu items for the common grid editor management P FirstRecord Ctri Inicio Last Ctrl Fin Net Previous Go to Record Figure 77 Data view go to menu e First record Goes to the first record It also can be done with the key combination Ctrl home e Last Goes to the last record lt also can be done with the
53. ected text to the System clipboard SELECT_ ALL Select all the text in the active file of the file editor TOGGLE COMMENT Comments or uncomments the line according to whether the line is commented or not GO TO LINE Opens a window where user can type down the number of line where he wants to go SEARCH Opens the search window REPLACE Opens the replace window 121 e Project menu O O O O O NEW_PROJECT Creates a new project OPEN PROJECT Opens a project in the application CLOSE PROJECT Closes the opened project in the application SAVE_PROJECT Saves the active project in the application SAVE_PROJECT_AS Saves the active project in the application with a different path ADD_OPENED FILES Adds all opened files in the application to the active project NEW_PROJECT FILE Creates a new file and adds it to the active project ADD FILE Adds the active file in the file editor to current project REMOVE_ FILE Removes the active file in the file editor from the current project DELETE FILE Deletes the active file from the current project and from disk ADD_ FOLDER Adds a folder to the current project REMOVE FOLDER Removes the selected folder from the current project COMPILE Compiles the current project EXECUTE Executes the current project SET_COMPILABLE_FILE Sets compilable the selected file SUNSET_COMPILABLE FILE Unsets compilable the selected file SET_MAIN_FILE Set
54. ed in the text field that corresponds if it is disabled the application will use its Operative System CLASSPATH e Explorer buttons open a dialog window for the files selection 3 5 3 COMPILER The following window will be displayed Figure 28 Compiler configuration The window has the following components User s Manual 53 e Compiler configuration panel o Executable path path that contains the compiler executable file o Compiler arguments arguments for the compiler e Compiler options panel o Compile all the checked files indicates if all the compilable files have to be compiled or not o File separator file separator to separate each one of the files to compile o Extension file extension of the files to compile e Accept button apply the changes e Cancel button close the window and do not apply the changes 3 5 4 FILE EDITOR CONFIGURATION It contains the menu item options for the file editor configuration management File Editor bw Preferences Console y gt File editor display configuration Database Panel Automatic Indent PDG y Ce Line Wrapping Ctrl May s A a Maximum number of lines to send to the console Language V e c Send to console confirmation Figure 29 File editor configuration We also explain how to configure the file editor externally with XML files in Chapter 15 3 3 Next we further detail each one of the previous menu item options User s Manual 54 3
55. el 1 the status message is displayed It shows the path and name of the active file in the File Editor e Panel 2 the syntactic configuration shows the name of the grammar applied to the current project e Panel 3 the lexicon configuration shows the name of the lexicon applied to the current project e Panel 4 shows the line and column where the caret is e Panel 5 BLOQ MAYUS status e Panel 5 BLOQ NUM status e Panel 6 BLOQ SCROLL status e Panel 7 writing mode INSERT or OVERWRITE e Panel 8 the System clock User s Manual 114 12 ACCESSIBILITY SHORTCUTS The application offers some accessibility shortcuts to wrapper common user actions such as e F3 Selected text performs the forward text search with the selected text in the file editor in the console panel or in the data view window e F3 Shift Selected text performs the backward text search with the selected text in the file editor in the console panel or in the data view window e Mouse wheel performs the vertical scroll line by line in the file editor and console panel e Control mouse wheel performs the zoom effect for the font size in the file editor console panel and graph panel e Shift Tab in case a Tab action has been performed undo the action Others accessibility shortcuts depends on the language of the application 12 1 ACCESSIBILITY SHORTCUTS IN ENGLISH Shortcuts in File menu e Ctrl N Creates new file e Ctrl O Op
56. ens a file e Ctrl S Saves active file in the file editor e Ctrl Shift S Saves all files in the file editor e Ctrl P Prints active file in the file editor e Alt X Closes the application Shortcuts in Edit menu e Ctrl Z Undo the last action e Ctrl Y Redo the last change User s Manual 115 e Ctrl C Copy the selected text to the System clipboard e Ctrl X Cuts the selected text to the System clipboard e Ctrl V Paste the test in the System clipboard e Ctrl E Select all the text in the active file of the file editor e Ctrl F Opens the search window e Ctrl R Opens the replace window Shortcuts in Project menu e Alt Shift N Creates a new project e Alt Shift O Opens a project e Alt Shift S Save the opened project e Alt Shift A Adds a file to the opened project e Alt C Compiles the opened project e Alt E Executes the opened project Shortcuts in View menu e Alt Shift L Shows the log tab Shortcuts in Configuration menu e Ctrl Shift L Documents lexicon e Ctrl Shift X Modifies the lexicon e Ctrl Shift T Creates a new grammar e Ctrl Shift A Actives line wrapping e Ctrl Shift F Opens the search in console window e Alt S Changes language to Spanish e Alt E Changes language to English Shortcuts in Help menu e Ctrl H Shows this document Shortcuts in Data view e Up arrow goes to previous record
57. er amy red Database KAES Console K J Databases ancestor grace amy a 3 Se ancestor grace carolIII S mn pr ancestor grace fred 100 2 k ancestor jack carolITI A Debug A ancestor jack fred DD Views Integrity Constraints ancestor tom amy ancestor tom caro1111 ancestor tom Fred ancestor tony c rolIl ancestor tony carol111 Info 16 tuples computed Grammar bytes Lexicon Configuration des L1 MumLines 35 el ING 00531 Figure 1 ACIDE Main GUI e Configuration This entry allows to configure Lexicon for syntax highlight ing Grammar for parsing on the fly Compiler for compiling the project File Editor for changing the display and behavior of the editors Shell the shell in the right bottom panel Database Panel the database panel in the left bottom panel Graph Panel then panel in the right side Language of the GUI Menu for the configuration of the menu bar and Toolbar for the commands which can be displayed either as icons or textual descriptions Tooltips for toolbar commands can be configured e Help This entry contains Show Help and About ACIDE User s Manual 20 In addition there is a fixed toolbar which includes common buttons for the file and project related basic operations New Open Save and Save All this last one only for files Next to the fixed toolbar
58. essions in Chapter 16 o Whole words find whole words only e Scope o Selected text search within a selected text o Current document document search starting in a certain position of the active file of File Editor o All opened documents searches in all opened files on the file editor e Direction o Forward searches from the current caret position to the end of the file in the source file editor User s Manual 29 o Backward searches from the current caret position to the beginning of the file in the source file editor o Cyclic searches from the current caret position to the end of the file in the source file editor and star from the beginning until the starting position e Progress bar shows the progress of the active search or replacement When a general replacement is performed it displays the following dialog to the user informing of the number of replacements f Replace oa GO Total number of replacements 43 Figure 6 Number of replacements User s Manual 30 3 3 PROJECT MENU lt contains the menu items required for the project configurations management New Project Alt Mayus N Open Project Alt Mayus O mner m Geeaeresexe CRIBBIEF er Open Recent Projects e Close Project Save Project Alt Mayus S Save Project As Add Opened Files New file Add File s Alt Mayus A Remove File Delete File Add Folder Remove Folder Compile Project Alt C Execute Project Alt E Set
59. eviousMenuNewConfiguration path to XML file that previously configured AC DE A Configurable IDE menu with the new configuration of version 0 11 Chapter 15 3 7 e consolePanel backgroundColor console panel background color numeric valor e currentMenuConfiguration path to menuConfig file that was configurating ACIDE A Configurable IDE menu with the configuration of older versions e consolePanel shellDirectory path to the folder where the exe of console shell is stored e console Panel shellPath path to the exe file of console shell e consolePanel fontSize size of the font of console e previousToolbarConfiguration path to toolbarConfig file that previously configured ACIDE A Configurable IDE toolbar Chapter 15 3 2 e currentMenuNewConfiguration path to XML file that configures ACIDE A Configurable IDE menu with the new configuration of version 0 11 Chapter 15 3 1 User s Manual 127 e consolePanel isechoCommand true or false to define the behaviour of echo command at console panel e language can be English or Spanish e currentToolbarConfiguration path to toolbarConfig file that configures ACIDE A Configurable IDE toolbar Chapter 15 3 2 e previousMenConfiguration path to menuConfig file that previously configured ACIDE A Configurable IDE menu with the configuration of older versions e lastOpenedProjectDirectory the folder of project was last opened Used to locate the user in the same fol
60. f he wants to save it if the file was previously modified 3 1 6 CLOSE ALL FILES Close all the opened files in the file editor asking to the user if he wants to save them if the files were previously modified 3 1 7 SAVE FILE save the active file in the file editor at the same path that it was previously saved 3 1 8 SAVE FILE AS Save the active file in the file editor into a different path than it was saved before 3 1 9 SAVE ALL FILES Save all files opened in the file editor 3 1 10 PRINT FILE Prints the active file in the file editor 3 1 11 EXIT Closes the application and if any changes have been encountered in the current project configuration displays the following dialog to the user User s Manual 23 O Project not saved do you want to save it Adittionally if any of the opened files in the file editor has been modified it will asked to the user for saving them with the following dialog O File not saved do you want to save it e The user can abort the exit process in any time by cancelling any of the previous dialogs User s Manual 24 3 2 EDIT MENU It contains the following menu items for the common file editor management WY Undo Ctrl Z Redo Ctrl Y Copy Ctrl C F Paste Ctrl V Cut Ctrl X Toggle Comment Select All Ctrl E Change Case Kr Go to line number 29 Find Ctrl F AB Replace Ctrl R Figure 3 Edit Menu Next all the previous
61. figurations easy and portable by means of text files The user can configure the Lexicon Grammar Compiler File Editor Shell Database Panel Graph Panel Language Menu and Toolbar These configurations will be further explained throughout this document User s Manual 21 3 MENU BAR Next we further detail each one of the submenus that AC DE A Configurable IDE as default As is explained in Chapter 3 5 9 the user can insert new menu submenus and items In Chapter 3 7 and Chapter O we explain how to use these objects We also explain how to configure this menu externally with XML files in Chapter 15 3 1 3 1 FILE MENU It contains the following menu items for the files management _ New Ctrl N Open Ctrl 0 Open Recent Files amp Open All Files Close Close All A Save Ctrl 5 A Save As Save All Ctrl Mayus 5 Print Ctrl P Exit Alt X Figure 2 File Menu Next all the previous menu items will be further explained 3 1 1 NEW Creates a new empty file in the file editor 3 1 2 OPEN Open a previously saved file into the file editor User s Manual 22 3 1 3 OPEN RECENT FILES Displays a list which contains all the files that have been opened previously in the file editor and the option to set the list to empty 3 1 4 OPEN ALL FILES Open all the files associated to the current project in the file editor 3 1 5 CLOSE FILE Close the active file in the file editor asking to the user i
62. firmation to send content of file to console With false value file content is sent without confirmation User s Manual 132 15 3 4 CONSOLE PANEL CONFIGURATION At Console Panel content of shell connected with the application is displayed It has two labels e lexiconConfiguration path of lexicon which is used at console e commandsConfiguration path of XML file that contains commands history with which we want to start the console explained in Chapter 15 6 Sdvsvs 15 3 5 LEXICONASSIGNER CONFIGURATION It has three basic labels e list acts like a Manager inside there is a list label with another list label nested It is a list of AcideLexiconAssigner objects These objects describe possible lexicons to use at console They have the following nested labels o description name of lexicon o _extensionList it has a group of nested String labels with the possible extensions for the lexicons o _lexiconConfiguration path of XML file that configures lexicon e consoleLexiconConfiguration path of XML file that configures lexicon which is currently in use e applyLexiconToConsole with true value lexicon is applied to console with false value it is not applied 15 4 PROJECT CONFIGURATION Project configuration is edited in acideProject files In this type of files are arranged in separate lines different project properties These are line by line the following i Project Name User s Manual 133
63. for searching and manipulating text 16 2 DESCRIPTION OF REGULAR EXPRESSIONS 16 2 1 THE DOT The dot is interpreted by the search engine as any character looking for any character NOT including line breaks The dot is used as follows If we search g t in the string gat get got goot the search engine will find gat get got Note that the search engine don t find goot this is because the dot represents a single character and only one 16 2 2 THE BACKSLASH V It is used to tag the next character in the search expression so that it acquires a special meaning or stop having him The backslash is never used by itself but in combination with other characters Used for example in combination with the point lt A this has not its normal meaning and behaves as a literal character In the same way placing a backslash followed by any of the special characters discussed below these do not have special meaning and become literal search characters As mentioned previously the backslash can also give special meaning to characters that do not Below is a list of some of these combinations e t represents a tab e Ir represents the carriage return or return to top the place where the line starts again e In represents the new line character through which a line begins Remember that in Windows is needed a combination of in to start a new line while Unix uses only n an
64. ftguraton 129 15 3 2 Toolbar confguraton 130 15 3 3 File editor CONfIguratiON usiessa a aa 132 15 3 4 Console panel confguraton 133 15 3 5 lexiconAssigner COonfguration 133 15 4 Project configuration xrnnnnnnnennnnvnnnnnnnnnnnnennnnnnnnennnnnnnnennnnnnnnennnnnnnnennnne 133 15 5 Configuration Of lexicOnS arxrannrnnnnnnnnnnnnannnnnnnnennnnnnnnnnnnnennnennnnennnennnne 135 15 5 1 TokenType Manager 136 15 5 2 validExtension Manager 136 User s Manual 11 15 5 3 delimiters Manager 136 15 6 Commands history apr 136 16 Regular EXPres SiO ee 138 16 1 Construction of regular EXpreSSIONS anrrvnrrrnnnnnnnennnnnnnnernnnnnnnennnnnnnnr 138 16 2 Description of regular expressions 00coccconcconcconcconcocnccnncnancnanenanennnennns 139 VL TVEDT Aarre 139 16 2 2 The BACKSLASH Virose aana A AA ESEE 139 1023 TAGBRACKEIS Tr 140 VE TME e WE 140 1625 The DOLLAR SIGN E 141 EG TEC CARET E 141 16 2 7 Parentheses sierra 141 1623 The QUESTION mark sissies eTe 142 18 29 ERNEST de 142 16 210 TEASERI SK NE 142 16211 TEPPE 142 User s Manual 12 INDEX OF FIGURES Figure 1 ACIDE Main Verne 20 FIGUG 2 FIG MEN EE 22 AE ETEN 25 FET TTV 27 Figure 5 Replace window rrarnnrrnnrvarnnrrnarnnnrnernannnernannnnnnernnannannnenannnnnnennnannee 28 Figure 6 Number of repnlacements 30 FIQUre 72 reien 31 Figure 8 Project configuration oocoocccocccocnconcconcconcocncnnncnnnnnnonononnncononnonan
65. gular user may use the system as Is The status of the GUI is remembered for the next time the tool is executed If the tool opens a project its status when it was last saved is restored The menu bar includes some common entries e File For file related operations User s Manual 19 e Edit For clipboard related operations Search Replace Undo Redo Select All and Go To Line e Project For project related operations e View For showing hiding project shell database and graph panels and displaying the log Window arrangements are not possible up to now but usual features are cascading and tiling windows both vertically and horizontally D ACIDE 0 13 DES3 5 Configuration Help File Edit Project View y el Ey Pl PB FB consult process listing dbschema pdg strata abaish bet et dear et cd ls pwd leg moog verbose noverbose bultins help J Acrobat Reader ene K aggregates dl El aggregates ra DES 3 5 j e aggregates sql bom d EJ Gg d H famdy ra Sl famdysd DI repa H ae i agoregates ra 4 aggregates sgl bom d tal tamy E ig fardy ra t Datalog Formiation i Tag zs 5 relop d 6 Optionally declare types T type father father atring child string father tom amy 3 Father jack fred 10 father tony carolll 11 father fred carollit 13 14 Optianally declare types 14 type mother mother string child string 15 mother grace amy l moth
66. igure 50 Project browser popup menu All these options User s Manual have been explained before on Chapter 3 3 78 5 FILE EDITOR PANEL In the file editor panel are displayed all the opened files by tabs Each tab is named by the name of the file it contains aggregates dl H aggregates ra E aggregates sal E bom d x family dl E family ra E family sal E3 relop dl x 3 Aggregates Datalog Formulation Gel employee Name Department Salary 6 emplovee anderson accounting 1200 9 employee andrews accounting 1200 10 employee arlingon accounting 1000 11 employee nolan null null 12 employee norton null null 13 employee randall resources 800 14 employee sanders sales null 15 employee silver sales 1000 16 employee smith 3ales 1000 17 employee steel sales 1020 18 employee sullivan sales null 19 20 1 Number of employees 22 total employees T Figure 51 File editor panel When a file is modified and it is not saved yet its tab is as follows aggregates dl Ed aggregates ra E with a red cross beside the title of the tab When a file is set as compilable file its tab is as follows OG aggregates d Ed aggregates ra EJ with a green play sign beside the title of the tab User s Manual 79 And finally when a file is set as main file its tab is as follows aggregates d EJ aggregates ra D
67. ind a string that is repeated one or more times The expression a zA Z d will find H1 but will not find H User s Manual 142
68. ist To introduce delete reorder etc elements of the list just manually edit the XML document and operate on the labels of each object 15 2 PROPERTIES CONFIGURATION To configure several properties of AC DE A Configurable IDE there is a file called configuration properties stored in configuration In this file are stored properties that are not specified in other files The structure of this file is fixed user can only edit the values for each field but he is not able to add new properties or delete any of the existing The first line of the properties configuration file is FACIDE Configuration The following line shows the date of the last time the user ran this issue of ACIDE A Configurable IDE Displays the following format User s Manual 126 Mon May 27 18 16 32 CEST 2013 The following lines show the property name followed by a and the value assigned to that property with the following structure e consolePanel fontName name of the font of console panel e workbenchConfiguration path to XML file that configures the workbench Chapter 15 3 e lastOpenedFileDirectory the folder was last opened Used to locate the user in the same folder next time e javacPath path of javac exe e jarPath path of jar exe e consolePanel exitCommand exit command for console e ed e consolePanel fontStyle style of the font of console panel e consolePanel bufferSize size of buffer of console panel e pr
69. languages finite or infinite and is constructed using alphabet characters on which the language is defined Regular expressions provide a flexible way to search or recognize strings 16 1 CONSTRUCTION OF REGULAR EXPRESSIONS Specifically regular expressions are built using the operators union concatenation and Kleene closure e Alternation A vertical bar separates alternatives For example red brown joins with red or brown e Quantification A quantifier after a character specifies the frequency with which this can occur The most common quantifiers and o The plus sign indicates that the preceding character must appear at least once For example hello joins hello helloo hellooo etc o The question mark indicates that the preceding character can appear at most once For example S pain joins Spain and pain o The asterisk indicates that the preceding character can appear zero one or more times For example 10 joins 1 10 100 1000 etc e Grouping Parentheses may be used to define the scope and precedence of other operators For example m h ouse is the same as mouse house and in sensitive joins with insensitive and sensitive Builders can be freely combined within the same expression so H ae a del is the same as H a ae a del User s Manual 138 lts most obvious use is to describe a set of strings which is useful in text editors and applications
70. lomal J aos SS FILES gt jresourcesjicons File L SSAVE_FILE L Fie SAVE FILE AS Fie Sa ALL FILES SPRINT FILE 10 Item Print Fie uitm Exit File lS SSI ii em FILE Figure 40 New menu It displays a list of tabs with the names of the menus in the Menu bar For each tab there is a grid with attributes of its menu objects The user can edit directly in the grid the attributes he wants to change except some that are not editable The value it is not assigned until user hits ENTER or changes to other attribute or object Next we further describe each one of the menu objects options e Row the number of the row It is not editable e Type the type of the menu object in this row It can ben fem or Submenu It is not editable this value is assigned when the object is created e Name the name of the menu object It is editable e Visible this value sets if the menu object is visible in the Menu bar or not e Erasable this value indicates if this menu object is a default menu object or not It is not editable The menu objects with erasable value to false are default menu objects These objects have to be always in the Menu bar configuration altough they can be not visible When the application builds the menu it checks if all the default menu objects exit in the configuration If any menu object does not exit the application User s Manual 65 creates it
71. ments Figure 13 Execution menu Next we further detail all the window components e Executable path path of the selected executable e Executable arguments arguments for the selected executable The result of the execution is displayed in the following progress window Project Execution Process This is a test for the project compilation in ACIDE A Configurable IDE Figure 14 Execution process User s Manual 38 3 3 16 SET COMPILABLE FILE Set the active file in the file editor as compilable 3 3 17 UNSET COMPILABLE FILE Unset the active file in the file editor as compilable 3 3 18 SET MAIN FILE Set the active file in the file editor as main 3 3 19 UNSET MAIN FILE Unset the active file in the file editor as main User s Manual 39 3 4 VIEW MENU It contains the menu items for the displaying management of the visible parts of the application and the log visualization Show Log Alt Mayus L Project Browser me we Console Database PDG Debug Figure 15 View menu Next all the previous menu items will be further explained 3 4 1 SHOW LOG Shows the application log in the file editor 3 4 2 PROJECT BROWSER Hides or shows the explorer panel This panel can be also hided clicking the button in the project browser menu bar 3 4 3 CONSOLE Hides or shows the console panel This panel can be also hided clicking the button in the console menu bar 3
72. menu items in the tool bar For each inserted menu item the attributes are e Name the name of the menu item e Visible define if the menu item is visible or not in the application e Erasable define if the menu item is a default menu item not erasable or not is erasable The value of this attribute can not be edited e Image defines the path of the image which is the icon of the menu item e Command defines the command that is sent to console when this menu item is clicked e Parameter defines the type of parameter that the command of this menu item needs None Text File or Directory A example of inserted menu items can be seen in Chapter 3 7 of the present document User s Manual 77 4 PROJECT BROWSER PANEL In the project browser panel are displayed the folders and files of the active project The main files appear with a blue circle beside the compilable files with a green circle and the rest with a grey circle ope Y aggregates di f aggregates ra aggregates sq bom d family dl kd family ra family sql Ad relop dl Figure 49 Project browser panel The popup menu of each file and folder is as follow BE 9090 XX 4 Dat New Project Open Project Save Project Add Opened Files New file Add File s Remove file Delete File Set File as Compilable Unset File as Compilable Set File as Main File Unset File as Main File Add Folder Remove Folder F
73. menu items will be further explained 3 2 1 UNDO Undo the changes in the file editor setting the focus on the file which is the owner of the change 3 2 2 REDO Redo the changes in the file editor setting the focus on the file that is the owner of the change 3 2 3 CoPY Copy the selected text in the active file in the file editor or in the console and put it into the system clipboard User s Manual 25 3 2 4 PASTE Paste the text stored in the system clipboard in the current position of the active file in the file editor or in the console 3 2 5 CUT Cut the selected text in the active file in the file editor or in the console and put it into the system clipboard 3 2 6 TOGGLE COMMENT Comments or uncomments the line according to whether the line is commented or not 3 2 1 SELECT ALL Selects all the content of the active file in the file editor 3 2 8 GO TO LINE It displays a dialog in which the user will type down the number of the line where he wants to place the caret cursor in the active file in the file editor Go to line EE O Input a line number 3 2 9 SEARCH Shows the search text window of the file editor User s Manual 26 Write the text to search for Case Sensitive T Regular Expressions Complete Words Scope Direction Selected Text a Forward a Current Document Backward All Opened Documents Cydic Search Figure 4 Search window Then we
74. n it will display a load window where user can select the image he wants to set as icon of the menu object User s Manual 67 e Add new submenu adds a new submenu to the menu selected If there is a menu submenu selected the new submenu will be inserted inside it If there is a menu item selected the new submenu will be inserted after it In other case the new submenu will be inserted at the end of the list of the root menu e Add new item adds a new menu item to the menu selected If there is a menu submenu selected the new item will be inserted inside it If there is a menu item selected the new item will be inserted after it In other case the new item will be inserted at the end of the list of the root menu e Delete object deletes the selected object after a confirmation message The objects that are not erasable can not be deleted e Move item or submenu to up moves to up the selected menu object e Move item or submenu to down moves down the selected menu object e Send to menu it displays a window with a list of menus where user can send the selected menu object e Insert in submenu it displays a window with a list of submenus inside the present menu where user can insert the selected menu object 3 5 9 1 3 KEY NAVEGATION e Up arrow selects previous object e Down arrow selects next object e Ctrl Home selects the first object e Ctrl End selects the last object e Tab selects next at
75. n the external applications panel tab the table contains the following parameters e Name text to display in the button If this field is empty the application will assign it a number as name by default e Executable path executable path of the command to execute It admits the insertion of ACIDE A Configurable IDE special variables that are further detailed in Chapter 13 of the present document User s Manual 71 e Help text hint text of the button e Image image for the button which can be selected by the option available in the popup menu of the column The tool bar configuration files have too barConfig extension 3 5 10 2 LOAD Loads a tool bar configuration with too barConfig extension 3 5 10 3 MODIFY It displays the following configuration window Figure 45 Modify tool bar It contains the same options than the configuration window displayed by the Contiguration Menu New In this case the window displays the current tool bar configuration loaded in the tables and also with a different window title which contains the name of the current configuration to modify 3 5 10 4 SAVE Saves the current tool bar configuration into a tool bar configuration file with toolbarConfig extension User s Manual 72 3 5 10 5 SAVE AS Saves the current tool bar configuration into a tool bar configuration file with toolbarConfig extension and with a different path User s Manual 73 3 6 HE
76. nennne 54 File editor display options 56 Maximum line number 57 GONSE MEU eege 58 Shell configuration EE 58 Execute external commande 99 Console display configuration coocccoccconcccncocncocncoconanonnnonnncnnnnnonos 60 Console search WINKOW ccoocccocccoccconcococnconnconcnnncnconnnoncnnnanonanennnonnnns 61 Database panel menu 62 Language configuration menu 64 Menu configuration men 64 NOW MONU EEE 65 Object menu POPUP menu 67 MAA EE 69 Tool Bar configuration menu 70 Gl LT 70 IVIOGITY TOO e Te 12 FICO MC OE 14 ADOULUS le e e 15 Example of inserted submen nossensnnennnnsrenrsnrsrrrrsrrerrnrerrnrerrene 76 Project browser Danel 78 Project browser popup MENU ocooccoccoccoccoccociocnocnncnonncononncononncononnnnnos 78 14 Figure 51 Figure 52 Figure 53 Figure 54 Figure 55 Figure 56 Figure 57 Figure 58 Figure 59 Figure 60 Figure 61 Figure 62 Figure 63 Figure 64 Figure 65 Figure 66 Figure 67 Figure 68 Figure 69 Figure 70 Figure 71 Figure 72 Figure 73 Figure 74 Figure 75 Figure 76 Figure 77 User s Manual AA AAA O E ASA 19 File editor POPUP men 80 se EE EE 81 SPRE DONG EE 82 Console panel popup menu 83 BELE len E 84 Databases 010 EE 85 Databases node popup menu 85 DEI Cala tee 85 Database noden 86 Database node popup menu 86 FE XCCUIC 0 We EE 87 Expanding database node occoccccccnccnccconcoconcnnoncononancnnonnnnononnnnanennnos 88
77. nfiguration Window BEI File Editor Configuration Remove File Type Default Lexicon Configuration configuration lexicon java xmil configurationlexicon c xml configuration lexicon des xml configuration lesicon sql xml configuration lexicon ra xml configuration lexicon default xml _ configuration lexicon batch xml configuration lexicon latex xml _ configuration lexiconfbibtex xmi Console Configuration Apply Lexicon Configuration to Console Choose a Lexicon Configuration for the Console configurationlexicon default xml Figure 22 Default lexicons Next we explain each one of its components e File editor configuration contains the elements for the default lexicon configurations management in the file editor o Add file type adds a new default lexicon configuration to the table o Remove file type removes a default lexicon configuration from the table o Table contains the following columns Description Extensions extensions list separed by Note the format txt is not a valid extension Default lexicon configuration e Console configuration contains the elements for the default lexicon configurations management in the console panel o Apply lexicon configuration to the console indicates if the default lexicon configuration has to be applied or not to the console panel o Console lexicon configuration User s Manual 4
78. ng with a lowercase letter When used in conjunction with the brackets for example with the form wl is useful to find any character that is not in the indicated group The above expression can found any character that is not alphanumeric or a space all punctuation and other special characters 16 2 7 PARENTHESES Similarly to the brackets parentheses are used to group characters However there are several differences between groups established by brackets and groups established by parentheses e Special characters keep their meaning within the parentheses e Groups established by parentheses make a label for the search engine that can be used later as denoted below e Used in conjunction with bar enables optional searches For example the regular expression to East West North South of searches texts giving instructions through cardinal points while the regular expression East West North South find east in the word beast failing to fulfill this purpose e Used in conjunction with other special characters listed below provide additional functionality User s Manual 141 16 2 8 THE QUESTION MARK a The question mark has several features in regular expressions The first is to specify which part of the search is optional For example the regular expression S pain can find both pain and Spain In conjunction with parentheses specifies that a larger set
79. nns 103 8 4 9 Add functional dependency 104 8 4 10 Add integrity constraint aan0anaanannennennennennennnnnnnnnennrnnnnnnenrnrrnnnenne 104 8 5 Children of table nodes rrrrranvavvnnvnvrnnnnnvnnnnnnnnnnvevnnnnnernnunernnnnnennnnuennnnnr 106 Oale DOD retiene 106 0 NON 106 8 6 VIES NOOC et 107 OD Ve A ez e A 107 2 e A 107 ME 108 8 7 WHEW oo E 109 OG HO 109 FAE rv 109 a 110 Oo PN 110 EE EEE 110 User s Manual 10 8 7 6 Data STE EEE 110 8 8 COMAS NOdES sara 110 8 9 SQL text and Datalog text nodes rranernnnvnnnnrnnnnnnnnnnnnnnnnnnnnnnnnnennnnnnnnr 110 2 POG Panel E 113 10 BLE 6100 PANG A e o A 114 11 ci E 114 12 ACCESSIDINITY SNOMCUIS c 2 2101cscrerencssncterenenaserenaxetercaancsetasesehexenaxcesresens 115 12 1 Accessibility shortcuts in EngliSh ocoonccnnccnnccnnconncoccconncnanenarenanenars 115 12 2 Accessibility shortcuts in SpaniSh x nnxrnnnnnnnnnnnnnnnnnnnnnennnannnnennnnnnnnr 117 13 elek ENEE 120 14 ACIDE default Commands rrannnnnnnnnnnnnnnvrnnnrrrnnrrnnnernnnrrnnnrennnsrennsnen 121 15 Configuration of ACIDE by configuration documents 126 15 1 Managers in XML files rrnnnrnnnernnnnnnnnnnnnnnnnennnnnnnnennnnnnnnnnnnnnnnnennnnennnnnnnnr 126 15 2 Properties configuration nnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnennnnnnnnennnunnnnr 126 15 3 Workbench CONPGQUIALION oi cccccccesicceseseiccennceessddeeecesseavensaresseelesscerenseeceeds 128 15 3 1 Menu cGon
80. nonononnnoncnonaninoss 58 User s Manual 5 SE ls GN 58 3 5 5 2 Execute external command ccccecceeceeseeseseeceeeseesesseeseeeseeeenaees 59 3 5 5 3 Console display configuration rararnnnrrrnnnrvrnnrrrnnrrrnrernnnrnrnnrrnnnrennn 59 3 5 5 4 Upewrappmg 60 3 5 5 5 Save content into file oocccoocccoconcococnnoncnncconnncanonnnanonananonos 60 29 90 Ree En Pen 61 ND aa 61 3 5 5 8 Close console ocoonccccnnccconococonccccncoconcononnnnonnnonnnnonnnnonannnnannnennnnenaninnos 62 3 5 5 9 Reset console AEN 62 359 10 Clear console DUTET eege 62 3 5 6 Database panel configuration rrnrrnnnrvrnnevnnrrnnnevnnrrnnrrvnernvnrennnrnnnnnnne 62 OE DES Er 62 A ODBC PING ege 62 3 5 7 Graph panel contfguraton 63 le NON 63 JE NOEN 63 Sesh OWE Ne 63 NTE A A 64 3 9 0 Language CONTUFAMON avse tii 64 3 5 9 WMENWCOMMOQUIANON ses egetegtrregE e 64 0 NN 65 GE PSN ege 66 3 5 9 1 2 POP oraciones 67 User s Manual 6 SE kN 68 SEG MOI ie eee 69 SE DI EEE tp 69 NE 69 35 10 Toolbar comiqueros abia 70 A e o 70 SI A 72 SO Age E OT 72 A o Ae 72 AS A 73 3 6 HD 74 Ole NNN 74 SR AUNG 15 3 7 IEN e WE Ta Tu E UC 76 3 8 Inserted menu items o 77 4 Project DIOWSET DANG weccxc sxcserarcxvenexenexenerereneseneseneneveneneaereseneseucnexenexeneness 78 5 File editor panel EN 19 o Kee TEE 81 l Oo po o AE 82 O DAPA DNE eaer 84 8 1 Databases NOTE Luse 84 OLE NN 85 EE US 5 EEE
81. nu will be inserted inside it If there is a menu item selected the new submenu will be inserted after it In other case the new submenu will be inserted at the end of the list of the root menu User s Manual 66 e Add new item adds a new menu item to the menu selected If there is a menu submenu selected the new item will be inserted inside it If there is a menu item selected the new item will be inserted after it In other case the new item will be inserted at the end of the list of the root menu o Delete obiect_ deletes the selected object after a confirmation message The objects that are not erasable can not be deleted e Lt Move object to up moves to up the selected menu object MM Move object to down moves down the selected menu object e Alvisble sets as visible all the menu objects of the Menu Bar e None Visible sets as no visible all the menu objects of the Menu Bar The menu objects related to menu configuration always have to be visible o b Applies the changes and closes the window Cancel Closes the window without applying the changes 3 5 9 1 2 POPUP MENU The popup menu of menu object is as follows Load image icon Add new submenu Add new item Delete object Move item or submenu to up Sie Move item or submenu to up Send to menu Insert in submenu Figure 41 Object menu popup menu Next we further describe each of the options e Load image ico
82. of a number To search for any character that represents a digit or a point we can use the regular expression TI As noted above within the brackets the point represents a literal character not a metacharacter so it is not necessary to precede the backslash The only character that must be preceded by the backslash inside the brackets is the backslash 16 2 4 THE BAR Used to indicate one of several options For example the regular expression ale find all a or e in the text The regular expression East West North South will find any of the names of the cardinal points The bar is commonly used in conjunction with other special characters User s Manual 140 16 2 5 THE DOLLAR SIGN Represents the end of the string or the end of the line when using the multi line mode There is not a special character but a position Using the regular expression the engine will find all the places where a line ends with a dot which is useful for moving between paragraphs 16 2 6 THE CARET This character has a dual function which differs when used alone and when used in conjunction with other special characters Firstly its functionality as an individual character the character represents the beginning of the chain in the same way that the dollar sign represents the end of the string Therefore using the regular expression az the engine will find all paragraphs beginni
83. of characters is optional for example Nov Jemberliembre finds both Nov November and Noviembre Similarly you can use the question mark with another meaning Parentheses define groups anonymous but the question mark in conjunction with triangular brackets lt gt give name to such groups as follows lt Day gt d d lt Month gt d d lt Year gt d d d d Whereupon it specifies to the search engine that the first two digits found will be labeled Day the second will be labeled Month and the last four digits will be labeled Year 16 2 9 THE BRACES Usually the braces are literal characters which are used separately in a regular expression To be used as metacharacters they have to enclose one or more numbers separated by commas and to be placed to the right of another regular expression as follows d 2 This expression will find two adjacent digits Using this formula the example d d d d d d d d that served to validate a date format will become to d 2 d 2 d 4 for clarity in reading the expression 16 2 10 THE ASTERISK The asterisk is used to find something that is repeated 0 or more times For example using the expression a zA Z id will be possible to find both H and H1 H01 H100 and H1000 a letter followed by a indefinite number of digits 16 2 11 THE PLUS SIGN It is used to f
84. onoso 32 FOUE E e Le NE AAA 34 Figure 10 Compilation by extension nnnnnnnennennnnnunnennnnnnnnnrnnrnrenrrnrrnrnnnnnn 35 FOTS VE MEKKE eee 36 Figure 12 Compilation by marked files oocccocccoccconoconccnncocncoconanonos 37 Figure 13 Execution Menu ee 38 Figure 14 Execution Drocess 38 FOS 10 VOW Mens esse ss a 40 Figure 16 Configuration men 42 Figure 17 LEXICON MENU drena ENEE Eerie E irei 42 Figure 18 NeW IOXICOMN EEN 43 Figure 19 Reserved words 44 Figure 20 Delimiters confguraton 45 Figure 21 Remarks configuration ooccocccccncocncoccconoconcnoncncnonncnnnnonnnononanonoss 46 Figure 22 Draut IOXICONS pcece vec cocsdoacneacncacsaacsaadsaagnaatsansaeaceaasanesnoasanneadadcens 48 Figure 23 Grammar men 49 User s Manual 13 Figure 24 Figure 25 Figure 26 Figure 27 Figure 28 Figure 29 Figure 30 Figure 31 Figure 32 Figure 33 Figure 34 Figure 35 Figure 36 Figure 37 Figure 38 Figure 39 Figure 40 Figure 41 Figure 42 Figure 43 Figure 44 Figure 45 Figure 46 Figure 47 Figure 48 Figure 49 Figure 50 User s Manual NE ee oe incsenascrcttscneratescreratteaneratsensnatsrasenatisanesetsecasnabenanenateyens 50 Grammar generation DrorCess 51 Moddiy TANA 52 EE 53 Compiler COMTIGUPAUON ssccccsoccsccrsaecstensanaedcweorueteuenenrtoancadnuadnencnoncomants 53 File editor configuration arrranrnanrnanrnnnnnnrnnnrnanenannnannnnsnnnennnena
85. ons to launch external applications To configure buttons to send commands to the console each configuration of a button should be headed by a comment line starting with and consists of six lines with the following structure e name name displayed e action command to run on the console User s Manual 130 e hintText help text displayed when user puts mouse over the button e icon path of the image for the button e parameterType type of the parameter that the command uses on console It can be o NONE o TEXT o FILE o DIRECTORY e isExecutedinSystemShell if is executed in the system or not Once the list of command buttons is ended user has to enter the following line in the file in order to indicate that the following settings are for buttons that launch external applications End of Console Panel Tool Bar Button Configuration Configurations of buttons that launch applications must be headed by a comment line starting with followed by four lines of properties e name name displayed e path path to run e hintText help text displayed when user puts the mouse over the button e icon path of the image for the button Once the list of command buttons is ended user has to enter the following line in the file in order to indicate that configuration of buttons that launch external applications is ended End of External Applications Tool Bar Button Configuration User s Manual
86. plained before in Chapter 3 The user can send commands to the shell in different ways As explained before user can send the selected text or the content of a file to the sell Also he can configure the toolbar with buttons which send commands to shell A new performance of this version is that user can configure the Menu Bar to build buttons that send commands to shell in the same way that the toolbar buttons The default buttons of ACIDE A Configurable IDE send special commands that will be further explained in Chapter 14 User s Manual 83 8 DATABASE PANEL The database panel shows the metadata of your computer s databases on the lower left corner of the screen 3 5 131 des Tables Views Integrity Constraints Figure 56 Database panel This panel can be connected with the DES or ODBC connections of your computer The user can choose the connection in the configuration menu submenu database panel Nodes can be expanded with double click or with one click on the node and one more on the button 8 1 DATABASES NODE This is the root node of the database panel below it all the databases connected will be showed User s Manual 84 o Sele Figure 57 Databases node The popup menu of this node is the next Ey Open 4 Refresh x Close Figure 58 Databases node popup menu Next we further detail each one of the components of the popup menu 8 1 1 OPEN With this option user can
87. s as main file the selected file UNSET_MAIN_FILE Unsets as main file the selected file e View menu O O O User s Manual SHOW_LOG TAB Shows the log tab SHOW_EXPLORER_PANEL Shows or hides the explorer panel SHOW_CONSOLE PANEL Shows or hides the console panel 122 o SHOW_DATABASE_PANEL Shows or hides the database panel o SHOW_GRAPH_PANEL Shows or hides th graph panel e Configuration menu o Lexicon submenu NEW_LEXICON Opens a window where user type down the name for the new lexicon DOCUMENT_ LEXICON Loads the lexicon configuration file in the active file of the file editor MODIFY_LEXICON Open the lexicon configuration window DEFAULT_LEXICON Shows the default lexicon configuration window o Grammar submenu NEW_GRAMMAR Opens the new grammar configuration window SLOAD GRAMMAR Loads a grammar configuration MODIFY_GRAMMAR Displays the modify grammar configuration window SAVE_GRAMMAR Saves the current grammar configuration into a file SAVE_GRAMMAR_AS Saves the current grammar configuration into a file with a different path SET_PATHS Displays the set paths window o COMPILER Displays the compiler configuration window o File editor submenu PREFERENCES Displays the preferences window FILE EDITOR DISPLAY OPTIONS Displays the file editor display configuration window AUTOMATIC_INDENT Enables or disables the automatic indent in the file editor
88. sent document Next we ilustrate its usage with two examples 3 3 14 1 COMPILATION BASED ON EXTENSION The process has the following steps First in the compiler configuration window the user selects the extension of the files that he wants to compile Tb Reeg TT e Compiler configuration Executable Path path Arguments arguments Compiler Options Compile all the checked files File separator Extension extension Figure 10 Compilation by extension Finally the project is compiled using the Menu Project Compile menu item option User s Manual 35 3 3 14 2 COMPILATION BASED ON MARKED FILES FOR COMPILATION The process has the following steps e First the user marks all the files that he wants to compile in the file editor or in the explorer tree using the option for this purpose File Edit Project View Configuration Help DES L q2 New Project AlteMayUseN process ising dbschema pdg strata abolsh listet des et cd lb pwd log nolog verbose noverbose bultins help ol Acrobat Reader 8 Open Project Alt Mayds O Dee a E E p Open Recent Projects Class Ljava GJ Cass jawa Cass 2 un a Pa Close Project 91 Save Project AlteMayiseS STOTE Java util Arraylist Mg Save Project As public class Classi Add Opened Files 1 New file public static OntologyDocunent onto Add File s Alte Mays A Remove File public static MainWindow mainWindow at mld ublic static nto
89. t e The following items are commands configured by user that run commands on shell explained on chapters 3 5 10 and 15 3 2 e o Sends file content to console e The following items are commands configured by user that run external applications explained on chapters 3 5 10 and 15 3 2 User s Manual 81 7 CONSOLE PANEL At console panel the user can work with the shell he connects to ACIDE A Configurable IDE explained on Chapter 3 5 5 An example of console panel connected with DES SEES eee eee SSeS eS SS SSeS eS SSS SSeS See ee ee eee eee eee eS Se eS Ki DES Datalog Educational System v 3 3 e Type help for help about commands de Fernando Saenz Perez c 2004 2013 GPD UCM Please send comments questions etc to fernan sip ucm es Web site http des sourceforge net de de This program comes with ABSOLUTELY NO WARRANTY is free software and you are welcome to redistribute it under certain conditions Type license for details mrk G DES gt employee smith sales 1000 Figure 54 Console panel The popup menu is as follows User s Manual 82 Console display configuration Line Wrapping m els Save content into file Document Lexicon Des Copy Cut Paste Reset Clear console buffer Find Ctrl May s F S A AM Close shell Figure 55 Console panel popup menu All the options have been ex
90. t are executed in the console panel User s Manual 70 e External applications panel defines the commands related to the external applications tool bar that are executed out of the aplication In each one of the panels the user can do the following operations e Add button adds a new command to the command list in the table e Remove button removes the selected command from the command list e Direct edition on the tables the user can modify the commands by editing directly on the table However the changes will not be applied until the focus changes or the user presses down the ENTER key In the console panel tab the table contains the following parameters e Name text to display in the button If this field is empty the application will assign it a number as name by default e Command command itself lt admits the insertion of ACIDE A Configurable IDE special variables that are further detailed in the Chapter 13 of the present document e Help text hint text of the button e Image image for the button which can be selected by the option available in the popupmenu of the column e Extra parameter shows a combo box with the following options NONE TEXT FILE DIRECTORY Each one of the previous options will ask the user for the selected type with different dialog windows e ls executed in the OS shell indicates if the command is executed in the Operative System shell or in the loaded shell in the console panel I
91. th Datalog Figure 71 Execute query 8 4 5 2 1 4 PRINT It displays the print window to print the grid 8 4 5 2 1 5 CLOSE Close the data view window It also can be closed with the key combination Alt F4 8 4 5 2 2 EDIT MENU It contains the following menu items for the common grid editor management Undo Ctrl Z Redo Ctrl _ Copy Ctrl C F Paste Ctrl V p Cut Ctrl X 29 Find Ctrl F 48 Replace Figure 72 Data view edit menu 8 4 5 2 2 1 UNDO Undoes the updates in the grid It also can be done with the key combination Ctrl Z 8 4 5 2 2 2 REDO Redoes the updates in the grid It also can be done with the key combination Ctrl Y User s Manual 95 8 4 5 2 2 3 COPY Copies the selected text from the grid and put it into the System clipboard It also can be done with the key combination Ctrl C or with the icon of the icon bar 8 4 5 2 2 4 PASTE Pastes the text stored in the System clipboard in the current position of the E cursor It also can be done with the key combination Ctrl V or with the icon of the icon bar 8 4 5 2 2 5 CUT Cuts the selected text active field from the grid and put it into the System clipboard It also can be done with the key combination Cl X or with the icon amp of the icon bar 8 4 5 2 2 6 FIND Displays the search text window for the data view Figure 73 Data view search window It also can be don
92. tive defines true or false value if it is case sensitive o color defines color of the comments lt has four nested tags red blue green alpha that define the RGB components and the degree of opacity of the comments o _fontStyle defines the font style of comments User s Manual 135 15 5 1 TOKENTYPE MANAGER This label has two nested list labels Inside of the most nested there are the AcideLexiconTokenGroup objects that define the token types in the lexicon The AcideLexicon TokenGroup objects have five nested labels e name it is a summary of the properties defined by the remaining labels It has the following form o Color R G B Font Style _ Case Sensitive o For color will take the values defines in the label color In Font Style appears the name that corresponds to the number defined on the label fontStyle In Case Sensitive value yes appears if the label _ sCaseSensitive is true and value not if the label sCaseSensitive has value false e color same structure as explained for color label above e fontStyle it defines with a number the font style e isCaseSensitive it defines by true or false value if it is case sensitive e tokenList contains a label called list where appears the list of String objects which define the tokens with the properties user has described for this token group Adding removing and editing these strings the user will get the list of tokens 15 5 2 VALIDEXTENSION MANAG
93. tribute e Tab Shift selects previous attribute e Esc deselects the selected object 3 5 9 2 LOAD Loads a menu configuration with XML extension User s Manual 68 3 5 9 3 MODIFY Selecting this option displays the following configuration window similar to creating a new configuration window but with corresponding options of the loaded menu and with the name of the configuration in the window title Path Child rows 23 4 3 a oser E Ed Active File process activ None Ei Ed SL e 6 7 8 9 10 11 Figure 42 Modify menu lts performance is equal to the new menu window explained on Chapter 3 5 9 1 3 5 9 4 SAVE Saves the current menu configuration into a menu configuration file with XML extension 3 5 9 5 SAVE AS Saves the current menu configuration into a menu configuration file with XML extension in a different path User s Manual 69 3 5 10 TOOLBAR CONFIGURATION It contains the menu item options for the tool bar configuration management Tool bar Figure 43 Tool Bar configuration menu We also explain how to configure toolbar externally with toolbarContfig files in Chapter 15 3 2 3 5 10 1 NEW It displays the following configuration window Figure 44 New tool bar The window has two different panels e Console panel defines the commands related to the console panel tool bar tha
94. values in t out of the interval 0 10 So an integrity constraint specifies unfeasible values rather than feasible User s Manual 105 8 5 CHILDREN OF TABLE NODES Under the table node the user can see the information of the columns and all the constraints like primary key foreign key and go on 9 Tables E employee department string varchar name string varchar salary number integer E Columns i name string varchar department string varchar vw salary number integer B a PK department name o parking name string varchar lot string varchar Views il Integrity Constraints Figure 88 Children of table nodes In the primary key node and in all the nodes which define a constraint in the figure the node department name the user has these options in the popup menu 8 5 1 DROP It will drop the restriction 8 5 2 MODIFY The user can modify the restriction with this action User s Manual 106 8 6 VIEWS NODE The children of this node are all the views of the selected database Its popup menu is the following o Create BE Paste Hide Details 8 6 1 CREATE With the next window the user can create a view defining it with an SQL command Figure 89 Create view window 8 6 2 PASTE A new view will be created with the same schema than the view that had been copied before User s Manual 107 8 6 3 HIDE DETAILS This option
95. w the name of the table and all the information of the fields However if the panel is connected with ODBC will only show the name of the table z Databases 1 des 2 3 Tables 7 employee name string varchar department string varchar salary number integer parking name string varchar lot string varchar views Integrity Constraints Figure 66 Table node With the contextual menu of this node you can make the following actions User s Manual 90 Add Primary Key Add Foreign Key Add Candidate Key Add Functional Dependency Add Integrity Constraint Figure 67 Table node popup menu 8 4 1 DROP This action will drop the table 8 4 2 RENAME The user can change the name of the table with this menu item 8 4 3 CopPY With this option the user can choose between copying only the schema or copying the schema and the data 3 4 4 DESIGN VIEW It will display the Design view of the selected table where the user can make changes on it add columns change the primary key and go on Figure 68 Design view User s Manual 91 Clicking on OK button changes will be applied If an error occurs the table will be restored to its previous schema 8 4 5 DATA VIEW Displays the following window which shows the data contained in the selected table or view where the simbol indicates the current record EY employee Table File Edit Records View Help AFP D
96. well as for the negative arrows a window is shown in this window the color of each arrow can be selected User s Manual 63 3 5 7 4 ARROW SHAPE Graph Panel Node color Language t Node shape gt Menu V Arrow color P Tool bar Arrow shape gt Y Polygon Line The point of the arrow can be switched through this menu being the possibilities a solid polygon or lines 3 5 8 LANGUAGE CONFIGURATION Shows the available language list of the application Language IS Spanish Alt S Menu ES English Alt Figure 38 Language configuration menu In this case the user can choose only between English or Spanish 3 5 9 MENU CONFIGURATION It contains the menu item options for the menu configuration management Menu New Tool bar i Load Modify Save Save as Figure 39 Menu configuration menu We also explain how to configure menu externally with XML files in Chapter 15 3 1 Next we further describe each one of the previous menu item options User s Manual 64 3 5 9 1 NEW Displays the following configuration window Row Type Name Visible Erasable Image Path 1 Item New File fresourcesficons Fie een FILE ai resources icons Fiej E SOPEN_FILE 2 Item Open File 3 Submenu Open Recent Files aitem 7 Open All Files 7 S Item Close File litem Close All Files ite Save Fle Siten ET re File As 9 Item Save All Files WEE sj Fief E SEL EN aL FILES iesorcca

Download Pdf Manuals

Related Search

Related Contents

Sharp EL-6890 Owner's Manual  4875_Home Duo Bouquet Floral  Guía de instalación rápida Radio reloj digital con  Vorago VOLT APU 4K-8-1 PC  IC-F33/F34/GT/GS SERVICE MANUAL  Kurzanleitung für Bluetooth (Deutsche Version).  

Copyright © All rights reserved.

• https://telegra.ph/Calculat-Wire-Area-From-Voltage-Drop-ea2e5ff0-11-16
• https://telegra.ph/Calculate-Wire-Resistor-from-Voltage-Drop-a55ad7cd-11-16
• https://telegra.ph/Wire-Size-Calculator-From-Voltage-Drop-6fa6111a-11-16
• https://telegra.ph/1-5-10-Concrete-Mix-Calculator-14de0a8c-11-17
• https://telegra.ph/Concrete-Volume-Calculator-for-Steps-27860cfc-11-17
• https://telegra.ph/1-4-8-Concrete-Mix-Calculator-f7ab7e99-11-13
• https://telegra.ph/round-bar-weight-calculator-4b91b1c2-11-07
• https://telegra.ph/DC-Voltage-Drop-Calculator-46405f5e-11-18
• https://telegra.ph/Calculate-Length-from-Voltage-Drop-b133a5df-11-18
• https://telegra.ph/AC-Single-phase-Voltage-Drop-Calculator-5e3bb9ec-11-18