msgid "" msgstr "" "Project-Id-Version: PACKAGE VERSION\n" "POT-Creation-Date: 2023-02-02 19:52+0000\n" "PO-Revision-Date: YEAR-MO-DA HO:MI+ZONE\n" "Last-Translator: FULL NAME \n" "Language-Team: LANGUAGE \n" "MIME-Version: 1.0\n" "Content-Type: text/plain; charset=UTF-8\n" "Content-Transfer-Encoding: 8bit\n" #. Put one translator per line, in the form NAME , YEAR1, YEAR2 msgctxt "_" msgid "translator-credits" msgstr "" #. (itstool) path: info/title #: C/actions.page:5 #: C/data-manager-perspective.page:5 #: C/data-manager-xml-syntax.page:5 #: C/data-manager-source-editor.page:5 #: C/declaredfk.page:5 #: C/diagram.page:5 #: C/features.page:5 #: C/general-ui.page:5 #: C/query-execution-perspective.page:5 #: C/schema-browser-perspective.page:5 #: C/transactions.page:5 #: C/table-insert-data.page:5 #: C/variables.page:5 #: C/virtual-connections.page:5 #: C/ldap-browser-perspective.page:5 #: C/ldap-connections.page:5 msgctxt "sort" msgid "1" msgstr "" #. (itstool) path: page/title #: C/actions.page:9 msgid "Actions" msgstr "" #. (itstool) path: page/p #: C/actions.page:10 msgid "Actions are bits of SQL code which depends on variables and can be executed from the contextual menu of any data set presented in a grid." msgstr "" #. (itstool) path: page/p #: C/actions.page:14 msgid "For example if there is a table \"products\" which lists some kind of products and a table \"comments\" which lists all the comments left by users on a product (presumably the \"comments\" table will have a foreign key on the \"products\" table to reference it)." msgstr "" #. (itstool) path: page/p #: C/actions.page:19 msgid "An action can be defined to show all the entries in the \"comments\" table provided the key is defining a product. Then anytime a product is listed in a result set, the contextual menu will allow the user to execute this action and thus display all the comments on the selected product. This situation is illustrated in the following figures." msgstr "" #. (itstool) path: page/p #: C/actions.page:25 msgid "The first step is to define an action, which is just a favorite in the query execution perspective which is defined as an action: bring up the properties for the favorite, and make sure the \"Is action\" toggle is checked:" msgstr "" #. (itstool) path: figure/title #: C/actions.page:31 msgid "Action - define an action" msgstr "" #. (itstool) path: figure/desc #: C/actions.page:32 msgid "Define the action to list the comments for a product, from the query execution perspective" msgstr "" #. (itstool) path: figure/media #. This is a reference to an external file such as an image or video. When #. the file changes, the md5 hash will change to let you know you need to #. update your localized copy. The msgstr is not used at all. Set it to #. whatever you like once you have updated your copy of the file. #: C/actions.page:33 msgctxt "_" msgid "external ref='figures/action-4.png' md5='100071a6077a81f6282c19fe5160629a'" msgstr "" #. (itstool) path: figure/title #: C/actions.page:36 msgid "Action - display a list of products" msgstr "" #. (itstool) path: figure/desc #: C/actions.page:37 msgid "In the query execution perspective, let's select all the products. Notice that there are here two defined actions: \"Add comment on product\" and \"List comments for product\"" msgstr "" #. (itstool) path: figure/media #. This is a reference to an external file such as an image or video. When #. the file changes, the md5 hash will change to let you know you need to #. update your localized copy. The msgstr is not used at all. Set it to #. whatever you like once you have updated your copy of the file. #: C/actions.page:40 msgctxt "_" msgid "external ref='figures/action-1.png' md5='bb889796dfd0467d6d0b0b338f3674f8'" msgstr "" #. (itstool) path: page/p #: C/actions.page:42 msgid "Now let's pop up the contextual menu:" msgstr "" #. (itstool) path: figure/title #: C/actions.page:46 msgid "Action - contextual menu" msgstr "" #. (itstool) path: figure/desc #: C/actions.page:47 msgid "Pop up the contextual menu and select Execute actionList comments for product" msgstr "" #. (itstool) path: figure/media #. This is a reference to an external file such as an image or video. When #. the file changes, the md5 hash will change to let you know you need to #. update your localized copy. The msgstr is not used at all. Set it to #. whatever you like once you have updated your copy of the file. #: C/actions.page:48 msgctxt "_" msgid "external ref='figures/action-2.png' md5='8ea0610cb4be792c57a62882050aad6e'" msgstr "" #. (itstool) path: page/p #: C/actions.page:50 msgid "After a confirmation of the parameters to execute the action, the result is there:" msgstr "" #. (itstool) path: figure/title #: C/actions.page:54 msgid "Action - executed" msgstr "" #. (itstool) path: figure/desc #: C/actions.page:55 msgid "The action is now executed" msgstr "" #. (itstool) path: figure/media #. This is a reference to an external file such as an image or video. When #. the file changes, the md5 hash will change to let you know you need to #. update your localized copy. The msgstr is not used at all. Set it to #. whatever you like once you have updated your copy of the file. #: C/actions.page:56 msgctxt "_" msgid "external ref='figures/action-3.png' md5='321f1284164e0f1bb1d1f0fc49050a77'" msgstr "" #. (itstool) path: page/title #: C/data-manager-perspective.page:8 msgid "The data manager perspective" msgstr "" #. (itstool) path: page/p #: C/data-manager-perspective.page:9 msgid "Use the data manager perspective to navigate through the database's data. To switch to this perspective, use the PerspectiveData Manager menu, or the CtrlD shortcut." msgstr "" #. (itstool) path: page/p #: C/data-manager-perspective.page:14 msgid "The workflow in this perspective is organized around the definition of one or more data sources (which selects data in the database) which, when executed, result in a data set displayed in a tabular view." msgstr "" #. (itstool) path: page/p #: C/data-manager-perspective.page:19 msgid "The perspective is divided in two horizontal panes: the left pane to keep favorite data sources set's definitions, and the right pane being the action area, where each data source is executed and the results presented in a tabular view." msgstr "" #. (itstool) path: figure/title #: C/data-manager-perspective.page:25 msgid "Data manager perspective" msgstr "" #. (itstool) path: figure/desc #: C/data-manager-perspective.page:26 msgid "The data manager perspective, with two data sources" msgstr "" #. (itstool) path: figure/media #. This is a reference to an external file such as an image or video. When #. the file changes, the md5 hash will change to let you know you need to #. update your localized copy. The msgstr is not used at all. Set it to #. whatever you like once you have updated your copy of the file. #: C/data-manager-perspective.page:27 msgctxt "_" msgid "external ref='figures/data-man-persp.png' md5='b4e0678527c03093031dcb3805bb2841'" msgstr "" #. (itstool) path: page/p #: C/data-manager-perspective.page:29 msgid "In the figure above, there are two data sources: one for the 'customers' table and one for the 'orders' table (which here lists the orders from a customer), the later data source depending on the former one as there is a foreign key from the 'orders' table which references the 'customers' table. The two data sources have been executed and the result is composed of two tabular views side by side." msgstr "" #. (itstool) path: page/p #: C/data-manager-perspective.page:36 msgid "Because the 'orders' data source depends on the 'customers' data source, its corresponding view is on the right of the one corresponding to the 'customers' data source. Also when the row selection of the 'customers' view changes, the whole contents of the 'orders' view is refreshed." msgstr "" #. (itstool) path: section/title #: C/data-manager-perspective.page:44 msgid "Defining data sources" msgstr "" #. (itstool) path: section/p #: C/data-manager-perspective.page:45 msgid "The simplest data source is a data source which represents all the data from a table, displayed when executed as a single tabular view, as if one executed the SELECT * FROM mytable statement in the ." msgstr "" #. (itstool) path: p/media #. This is a reference to an external file such as an image or video. When #. the file changes, the md5 hash will change to let you know you need to #. update your localized copy. The msgstr is not used at all. Set it to #. whatever you like once you have updated your copy of the file. #: C/data-manager-perspective.page:53 #: C/data-manager-perspective.page:93 msgctxt "_" msgid "external ref='figures/data-man-mode.png' md5='fa36a6e1e640c7a082fc7c3d16e095d6'" msgstr "" #. (itstool) path: section/p #: C/data-manager-perspective.page:51 msgid "The following figure shows the data sources editing mode (switch to editing mode using the toolbar button)." msgstr "" #. (itstool) path: section/p #: C/data-manager-perspective.page:55 msgid "Data sources can be defined using an XML syntax, or using the default interface." msgstr "" #. (itstool) path: figure/title #: C/data-manager-perspective.page:60 #: C/data-manager-perspective.page:65 msgid "Data sources edition" msgstr "" #. (itstool) path: figure/desc #: C/data-manager-perspective.page:61 msgid "Editing data sources in the data manager perspective, from the XML syntax" msgstr "" #. (itstool) path: figure/media #. This is a reference to an external file such as an image or video. When #. the file changes, the md5 hash will change to let you know you need to #. update your localized copy. The msgstr is not used at all. Set it to #. whatever you like once you have updated your copy of the file. #: C/data-manager-perspective.page:62 msgctxt "_" msgid "external ref='figures/data-man-xmlcompose.png' md5='fd3ae97c42d58ddbd87404c92b95ee9c'" msgstr "" #. (itstool) path: figure/desc #: C/data-manager-perspective.page:66 msgid "Editing data sources in the data manager perspective, using the default interface: two data sources are defined, which list the contents of the \"customers\" and \"orders\" tables. The setup is the same as the figure above showing the XML syntax" msgstr "" #. (itstool) path: figure/media #. This is a reference to an external file such as an image or video. When #. the file changes, the md5 hash will change to let you know you need to #. update your localized copy. The msgstr is not used at all. Set it to #. whatever you like once you have updated your copy of the file. #: C/data-manager-perspective.page:69 msgctxt "_" msgid "external ref='figures/data-man-uicompose.png' md5='33b1cf9354761dac4ee3f14a9534357a'" msgstr "" #. (itstool) path: section/p #: C/data-manager-perspective.page:72 #: C/query-execution-perspective.page:71 msgid "The commands available through the command buttons are:" msgstr "" #. (itstool) path: item/p #: C/data-manager-perspective.page:76 msgid "Reset: resets the XML editor to a default XML template, only available when the XML view is currently displayed" msgstr "" #. (itstool) path: item/p #: C/data-manager-perspective.page:78 msgid "Add: displays a popup menu with shortcuts to quickly define new data sources as whole table contents (also analyses the database schema to propose relevant choices), only available when the XML edition mode is not selected" msgstr "" #. (itstool) path: item/p #: C/data-manager-perspective.page:81 msgid "Variables: shows/hide the variables panel where you can give values to the variables present in the SQL code of any data source's definition. The panel is automatically shown when a variable is detected in the SQL code." msgstr "" #. (itstool) path: item/p #: C/data-manager-perspective.page:84 msgid "Execute: executes the defined data sources" msgstr "" #. (itstool) path: item/p #: C/data-manager-perspective.page:85 msgid "View XML: toggles between the XML editor and the UI editor" msgstr "" #. (itstool) path: item/p #: C/data-manager-perspective.page:86 msgid "Help: shows some help" msgstr "" #. (itstool) path: section/title #: C/data-manager-perspective.page:90 msgid "Executing defined data sources" msgstr "" #. (itstool) path: section/p #: C/data-manager-perspective.page:91 msgid "To execute a defined set of data sources, simply switch to execute mode using the toolbar button or the Execute button." msgstr "" #. (itstool) path: section/p #: C/data-manager-perspective.page:96 msgid "The layout of tabular views for each data source is automatically generated in columns using the following rule: if a data source B depends on a data source A, then its tabular view is displayed on the right of the one for A." msgstr "" #. (itstool) path: section/p #: C/data-manager-perspective.page:101 msgid "Also if you change the selected row of tabular view of a data source A, then the tabular views of all the data sources depending on A will also have their tabular view refreshed." msgstr "" #. (itstool) path: page/title #: C/data-manager-xml-syntax.page:7 msgid "The data manager's XML syntax" msgstr "" #. (itstool) path: page/p #: C/data-manager-xml-syntax.page:8 msgid "The XML tree's root node must be a <data>, which is allowed to contain one or more data source definitions. Each data source is defined by <query> or <table> nodes, both accepting the following optional attributes:" msgstr "" #. (itstool) path: item/p #: C/data-manager-xml-syntax.page:15 msgid "\"id\" to specify a data source string ID, used when linking data sources one to another;" msgstr "" #. (itstool) path: item/p #: C/data-manager-xml-syntax.page:16 msgid "\"title\" to specify a title." msgstr "" #. (itstool) path: page/p #: C/data-manager-xml-syntax.page:18 msgid "It is of course possible to use both the <query> or <table> tags in the same data sources specifications." msgstr "" #. (itstool) path: section/title #: C/data-manager-xml-syntax.page:24 #: C/data-manager-xml-syntax.page:73 #: C/data-manager-xml-syntax.page:154 msgid "Exported variables" msgstr "" #. (itstool) path: section/p #: C/data-manager-xml-syntax.page:25 msgid "Each data source exports some variables which can be reused by other data sources to introduce a dependency. When the data sources are executed, the contents of these exported variables are reset depending on the row actually selected in the resulting tabular view. If no row is selected then the variable is unset." msgstr "" #. (itstool) path: section/p #: C/data-manager-xml-syntax.page:31 msgid "Any data source depending on a variable is executed again when the variable changes, and in case the variable is unset, the data source's execution result is an empty data set." msgstr "" #. (itstool) path: section/title #: C/data-manager-xml-syntax.page:37 msgid "The <query> tag" msgstr "" #. (itstool) path: section/p #: C/data-manager-xml-syntax.page:38 msgid "Use the <query> tag to specify an SQL SELECT statement, as the contents of the tag. Linkage to other data sources can be achieved using variables in the SELECT's SQL." msgstr "" #. (itstool) path: section/code #: C/data-manager-xml-syntax.page:44 #, no-wrap msgid "" "\n" "<data>\n" " <query title=\"Customers\" id=\"customers\">\n" " SELECT id, name FROM customers where name like ##name::string\n" " </query>\n" " <query title=\"Customer's details\" id=\"cust_details\">\n" " SELECT * FROM customers WHERE id=##customers@id::int\n" " </query>\n" "</data>\n" " " msgstr "" #. (itstool) path: section/p #: C/data-manager-xml-syntax.page:54 #: C/data-manager-xml-syntax.page:130 msgid "For example the previous XML specification defines two data sources:" msgstr "" #. (itstool) path: item/p #: C/data-manager-xml-syntax.page:58 msgid "the customers data source which selects some fields from the customers table, and which depends on a string variable named name. This variable has to be set when the data sources are executed because it won't be exported by any data source in this specification." msgstr "" #. (itstool) path: item/p #: C/data-manager-xml-syntax.page:62 msgid "the cust_details data source which selects all the details of a customer specified using its ID. This second data source depends on the previous one because the customers@id variable is exported from the customers data source." msgstr "" #. (itstool) path: section/p #: C/data-manager-xml-syntax.page:67 msgid "Executing this data sources specification will create two tabular views: one where you can select a customer, and one which displays all the attributes for the selected customer." msgstr "" #. (itstool) path: section/p #: C/data-manager-xml-syntax.page:74 msgid "Each data source defined by a <query> tag exports the following variable for each column of the resulting data set (the variable's type is the same as the column's type):" msgstr "" #. (itstool) path: item/p #: C/data-manager-xml-syntax.page:79 #: C/data-manager-xml-syntax.page:161 msgid "<data source ID>@<column position> where the column's position starts at 1" msgstr "" #. (itstool) path: item/p #: C/data-manager-xml-syntax.page:81 msgid "<data source ID>@<column name> if the data set's column is a table column" msgstr "" #. (itstool) path: section/title #: C/data-manager-xml-syntax.page:88 msgid "The <table> tag" msgstr "" #. (itstool) path: section/p #: C/data-manager-xml-syntax.page:89 msgid "Use the <table> tag to define a data source which will display the contents of a table. This tag:" msgstr "" #. (itstool) path: item/p #: C/data-manager-xml-syntax.page:94 msgid "requires the \"name\" attribute which represents the table name." msgstr "" #. (itstool) path: item/p #: C/data-manager-xml-syntax.page:95 msgid "can have a \"id\" attribute corresponding to the data source's ID. If not present, and ID will be assigned automatically." msgstr "" #. (itstool) path: item/p #: C/data-manager-xml-syntax.page:97 msgid "can contain a <depend> tag which defines a dependency on another data source with the \"foreign_key_table\" attribute defining the name of the table to which there are foreign keys used to determine the dependency, and the \"id\" attribute can specify a data source ID if different than the aforementioned table" msgstr "" #. (itstool) path: section/p #: C/data-manager-xml-syntax.page:103 msgid "The <depend> tag, which, for a data source from a table, defines a dependency to another data source from a table:" msgstr "" #. (itstool) path: item/p #: C/data-manager-xml-syntax.page:108 msgid "requires the \"foreign_key_table\" attribute defining the name of the table to which there are foreign keys used to determine the dependency" msgstr "" #. (itstool) path: item/p #: C/data-manager-xml-syntax.page:110 msgid "can have a \"id\" attribute corresponding to the ID of the referenced data source. If not provided, then the dependency may fail if there is no data source which ID is the\"foreign_key_table\" attribute." msgstr "" #. (itstool) path: item/p #: C/data-manager-xml-syntax.page:113 msgid "can contain one or more <column> tag which contents define the columns to identify the foreign key to use; this is necessary if there are multiple foreign keys, and can be omitted if there is only one possible foreign key. The listed columns are the one from the table where the foreign key exists." msgstr "" #. (itstool) path: section/code #: C/data-manager-xml-syntax.page:120 #, no-wrap msgid "" "\n" "<data>\n" " <table id=\"the_cust\" name=\"customers\"/>\n" " <table name=\"orders\">\n" " <depend id=\"the_cust\" foreign_key_table=\"customers\">\n" " <column>customer_id</column>\n" " </depend>\n" " </table>\n" "</data>\n" " " msgstr "" #. (itstool) path: item/p #: C/data-manager-xml-syntax.page:134 msgid "the customers data source which selects all the contents of the customers table." msgstr "" #. (itstool) path: item/p #: C/data-manager-xml-syntax.page:136 msgid "the orders data source which selects among contents of the orders table, the rows which correspond to a row in the customers table using the foreign key on table orders which involves the \"orders.customer_id\" column and the primary key of the customers table. The \"id\" attribute of the <depend> tag is necessary here to identify referenced the data source." msgstr "" #. (itstool) path: section/p #: C/data-manager-xml-syntax.page:143 msgid "Note in this example that:" msgstr "" #. (itstool) path: item/p #: C/data-manager-xml-syntax.page:147 msgid "you don't have to specify the fields involved in the foreign key linking the orders and customers tables" msgstr "" #. (itstool) path: item/p #: C/data-manager-xml-syntax.page:149 msgid "the data sources IDs have been assigned the names of the selected tables as no \"id\" attribute has been specified for the <table> tags." msgstr "" #. (itstool) path: section/p #: C/data-manager-xml-syntax.page:155 msgid "Each data source defined by a <query> tag exports the following variable for each table's column (the variable's type is the same as the column's type):" msgstr "" #. (itstool) path: item/p #: C/data-manager-xml-syntax.page:160 msgid "<data source ID>@<column name>" msgstr "" #. (itstool) path: page/title #: C/data-manager-source-editor.page:7 msgid "The data manager's data sources editor" msgstr "" #. (itstool) path: page/p #: C/data-manager-source-editor.page:8 msgid "To be done." msgstr "" #. (itstool) path: page/title #: C/declaredfk.page:8 msgid "Declared foreign keys" msgstr "" #. (itstool) path: page/p #: C/declaredfk.page:9 msgid "All the foreign key constraints (where the contents of one or more columns in a table is constrained to be among the values of one or more columns of another table) are analysed and reported in the Schema Browser perspective. Foreign key constraints help understand the database schema and is automatically used where appropriate by the application." msgstr "" #. (itstool) path: page/p #: C/declaredfk.page:16 msgid "However sometimes the designer of a database has forgotten or did not whish to use foreign key constraints, and so it is possible to \"declare foreign keys\" which are only declaration to the tool and not actually defined in the database." msgstr "" #. (itstool) path: figure/title #: C/declaredfk.page:22 msgid "Declared foreign keys in diagrams" msgstr "" #. (itstool) path: figure/desc #: C/declaredfk.page:23 msgid "When displayed in diagrams, declared foreign keys are represented using a dashed line instead of a solid line for actual foreign keys" msgstr "" #. (itstool) path: figure/media #. This is a reference to an external file such as an image or video. When #. the file changes, the md5 hash will change to let you know you need to #. update your localized copy. The msgstr is not used at all. Set it to #. whatever you like once you have updated your copy of the file. #: C/declaredfk.page:25 msgctxt "_" msgid "external ref='figures/declaredfk.png' md5='b5d15e99a2724bdda33147dc007770bc'" msgstr "" #. (itstool) path: page/p #: C/declaredfk.page:27 #: C/variables.page:21 msgid "Notes:" msgstr "" #. (itstool) path: item/p #: C/declaredfk.page:31 msgid "the (foreign key name, table, referenced table) triplet uniquely identifies a declared foreign key and thus declaring a new foreign key with the same triplet will remove any previously declared one." msgstr "" #. (itstool) path: item/p #: C/declaredfk.page:34 msgid "If the same constraint is actually represented by a real foreign key and also by a declared foreign key, then the real foreign key definition will mask the declared one" msgstr "" #. (itstool) path: item/p #: C/declaredfk.page:37 msgid "Declared foreign key don't have any policy to determine what action to perform on UPDATE or DELETE situations, so the reported policy will always be \"not enforced\"" msgstr "" #. (itstool) path: section/title #: C/declaredfk.page:42 msgid "Declaring a new foreign key" msgstr "" #. (itstool) path: section/p #: C/declaredfk.page:43 msgid "A new foreign key can be declared from the Schema Browser perspective using the TableDeclare foreign key menu which is present when a table's properties are shown in the current tab." msgstr "" #. (itstool) path: section/p #: C/declaredfk.page:49 msgid "Another way of declaring a foreign key is using the contextual menu on a table in a diagram, and selecting the Declare foreign key for this table option." msgstr "" #. (itstool) path: section/p #: C/declaredfk.page:53 msgid "In any way, to declare a new foreign key, the following information must be provided:" msgstr "" #. (itstool) path: item/p #: C/declaredfk.page:57 msgid "A foreign key name" msgstr "" #. (itstool) path: item/p #: C/declaredfk.page:58 msgid "The referenced table" msgstr "" #. (itstool) path: item/p #: C/declaredfk.page:59 msgid "Columns and referenced columns for each column involved in the foreign key" msgstr "" #. (itstool) path: figure/title #: C/declaredfk.page:62 msgid "Information to declare a new foreign key" msgstr "" #. (itstool) path: figure/desc #: C/declaredfk.page:63 msgid "UI dialog poping up to declare a new foreign key. Here the referenced table is 'warehouses', and the involved columns are 'country' and 'city'." msgstr "" #. (itstool) path: figure/media #. This is a reference to an external file such as an image or video. When #. the file changes, the md5 hash will change to let you know you need to #. update your localized copy. The msgstr is not used at all. Set it to #. whatever you like once you have updated your copy of the file. #: C/declaredfk.page:65 msgctxt "_" msgid "external ref='figures/declaredfk-dialog.png' md5='56aba297f8b88248fabc23c54b361a8f'" msgstr "" #. (itstool) path: section/title #: C/declaredfk.page:70 msgid "Remove a declared foreign key" msgstr "" #. (itstool) path: section/p #: C/declaredfk.page:71 msgid "A declared foreign key can be removed by clicking on the (Remove) link displayed below each declared foreign key properties in the table's properties (in the Schema Browser perspective)." msgstr "" #. (itstool) path: section/p #: C/declaredfk.page:76 msgid "Another way to remove a declared foreign key is in a diagram page through the contextual menu associated with the dashed line representing the declared foreign key, selecting the Remove this declared foreign key option." msgstr "" #. (itstool) path: page/title #: C/diagram.page:7 msgid "Diagrams" msgstr "" #. (itstool) path: page/p #: C/diagram.page:8 msgid "Diagrams are present throughout the gda-browser, and are made of a canvas on which graphical items are displayed (like tables for example)." msgstr "" #. (itstool) path: figure/title #: C/diagram.page:13 msgid "Diagram" msgstr "" #. (itstool) path: figure/desc #: C/diagram.page:14 msgid "Diagram showing some tables and their relations represented by foreign key constraints (also see the declared foreign keys)" msgstr "" #. (itstool) path: figure/media #. This is a reference to an external file such as an image or video. When #. the file changes, the md5 hash will change to let you know you need to #. update your localized copy. The msgstr is not used at all. Set it to #. whatever you like once you have updated your copy of the file. #: C/diagram.page:16 msgctxt "_" msgid "external ref='figures/diagram.png' md5='0ad77cfbbead0832d8ce7fa22d3ce01d'" msgstr "" #. (itstool) path: page/p #: C/diagram.page:18 msgid "The items can be moved around on the canvas (note that as long as the whole diagram fits in the canvas, it remains centered on it). Other manipulations are possible:" msgstr "" #. (itstool) path: item/p #: C/diagram.page:23 msgid "zooming in and out using the mouse's wheel, or through the contextual menu (right click on the canvas); a zoom to fit the canvas is also available in the contextual menu" msgstr "" #. (itstool) path: item/p #: C/diagram.page:25 msgid "bring closer or moving away items from one another using the mouse's wheel while holding the Shift key" msgstr "" #. (itstool) path: item/p #: C/diagram.page:27 msgid "arranging items linearly or radially, through the contextual menu" msgstr "" #. (itstool) path: item/p #: C/diagram.page:28 msgid "printing, through the contextual menu" msgstr "" #. (itstool) path: item/p #: C/diagram.page:29 msgid "exporting as PNG or SVG images, through the contextual menu" msgstr "" #. (itstool) path: item/p #: C/diagram.page:30 msgid "adding items, through the contextual menu" msgstr "" #. (itstool) path: item/p #: C/diagram.page:31 msgid "removing items, through the items's contextual menu" msgstr "" #. (itstool) path: page/title #: C/features.page:8 msgid "Features" msgstr "" #. (itstool) path: page/p #: C/features.page:9 msgid "gda-browser's current features are:" msgstr "" #. (itstool) path: section/title #: C/features.page:13 msgid "General user interface" msgstr "" #. (itstool) path: item/p #: C/features.page:15 #: C/features.page:26 msgid "multi threaded: each connection is handled in it own thread, meaning that no single connection can lock the application" msgstr "" #. (itstool) path: item/p #: C/features.page:17 msgid "several windows can be opened for a single connection" msgstr "" #. (itstool) path: item/p #: C/features.page:18 msgid "full screen mode accessible to maximize the screen space usage" msgstr "" #. (itstool) path: section/title #: C/features.page:22 msgid "Connection management" msgstr "" #. (itstool) path: item/p #: C/features.page:24 msgid "multiple simultaneous connections can be opened at once" msgstr "" #. (itstool) path: item/p #: C/features.page:25 msgid "connections binding: it is possible to \"bind\" several connections into one to execute SQL commands on several connections at once" msgstr "" #. (itstool) path: section/title #: C/features.page:31 msgid "Activities" msgstr "" #. (itstool) path: section/p #: C/features.page:32 msgid "The activities are grouped by theme around the notion of perspectives, the following are currently implemented:" msgstr "" #. (itstool) path: item/p #: C/features.page:36 msgid "analyse the database schema (tables, relations, ...), see the Schema browser perspective" msgstr "" #. (itstool) path: item/p #: C/features.page:38 msgid "execute SQL commands, see the Query execution perspective" msgstr "" #. (itstool) path: item/p #: C/features.page:40 msgid "analyse the table's contents, see the Data manager perspective" msgstr "" #. (itstool) path: item/p #: C/features.page:42 msgid "for LDAP connections, manage the hierarchical data in the LDAP tree, see the LDAP browser perspective" msgstr "" #. (itstool) path: section/p #: C/features.page:45 msgid "See also the section about actions" msgstr "" #. (itstool) path: section/title #: C/features.page:50 msgid "Openness" msgstr "" #. (itstool) path: item/p #: C/features.page:52 msgid "CSV and other text files can be imported and used in conjunction with connection binding" msgstr "" #. (itstool) path: item/p #: C/features.page:53 msgid "the general framework is opened enough to add new integrated features; specifically anyone can develop new perspectives" msgstr "" #. (itstool) path: page/title #: C/general-ui.page:8 msgid "General interface organization" msgstr "" #. (itstool) path: page/p #: C/general-ui.page:9 msgid "The gda-browser is composed of one or more top level windows, each window relating to a single connection (which name is in its title). For any given connection, several windows can be opened (use the WindowNew window menu or the CtrlN shortcut)." msgstr "" #. (itstool) path: figure/title #: C/general-ui.page:16 msgid "A connection window" msgstr "" #. (itstool) path: figure/desc #: C/general-ui.page:17 msgid "Window opened for the 'c1' connection (and the Schema browser perspective)" msgstr "" #. (itstool) path: figure/media #. This is a reference to an external file such as an image or video. When #. the file changes, the md5 hash will change to let you know you need to #. update your localized copy. The msgstr is not used at all. Set it to #. whatever you like once you have updated your copy of the file. #: C/general-ui.page:18 #: C/schema-browser-perspective.page:21 msgctxt "_" msgid "external ref='figures/mainwin.png' md5='8e0eab3f4b2b5573529a98daf3c5aa48'" msgstr "" #. (itstool) path: page/p #: C/general-ui.page:21 msgid "Within each window, several perspectives are available which are adapted to different activities:" msgstr "" #. (itstool) path: item/p #: C/general-ui.page:26 msgid "the Schema browser perspective to help understand the database's layout" msgstr "" #. (itstool) path: item/p #: C/general-ui.page:27 msgid "the Query execution perspective to execute any SQL command" msgstr "" #. (itstool) path: item/p #: C/general-ui.page:28 msgid "the Data manager perspective to navigate through the database's contents" msgstr "" #. (itstool) path: page/p #: C/general-ui.page:30 msgid "The currently displayed perspective can be changed individually for each window, and, as all perspectives have an action area composed of tabs, tabs can be moved from one window to the other if the source and destination window are for the same connection, and display the same perspective (simply drag and drop a tab from one window to the other using the tab's label as a handle)." msgstr "" #. (itstool) path: credit/name #: C/index.page:6 msgid "Vivien Malerba" msgstr "" #. (itstool) path: page/title #: C/index.page:11 msgid "Gda Browser Help" msgstr "" #. (itstool) path: page/p #: C/index.page:12 msgid "gda-browser is a tool for database administrators: they can analyse database's schemas to understand how data is organized, run SQL commands interactively, and in a broader way manage the data contained in the databases." msgstr "" #. (itstool) path: page/p #: C/index.page:16 msgid "Several connections to databases can be opened at once, allowing the user to work on multiple databases at once (it is also possible to execute commands on several connections at the same time)." msgstr "" #. (itstool) path: page/p #: C/index.page:19 msgid "As gda-browser uses the libgda library, it can open connections to databases for which a database driver (provider) exists in libgda (Oracle, MySQL, PostgreSQL, SQLite, MS Access (through the MDBTools library), LDAP and JDBC are supported at the moment)." msgstr "" #. (itstool) path: section/title #: C/index.page:29 msgid "Presentation" msgstr "" #. (itstool) path: section/title #: C/index.page:32 msgid "Perspectives" msgstr "" #. (itstool) path: section/title #: C/index.page:36 msgid "Connections management" msgstr "" #. (itstool) path: p/link #: C/legal.xml:4 msgid "Creative Commons Attribution-Share Alike 3.0 Unported License" msgstr "" #. (itstool) path: license/p #: C/legal.xml:3 msgid "This work is licensed under a <_:link-1/>." msgstr "" #. (itstool) path: license/p #: C/legal.xml:6 msgid "As a special exception, the copyright holders give you permission to copy, modify, and distribute the example code contained in this document under the terms of your choosing, without restriction." msgstr "" #. (itstool) path: page/title #: C/query-execution-perspective.page:8 msgid "The query execution perspective" msgstr "" #. (itstool) path: page/p #: C/query-execution-perspective.page:9 msgid "Use the query perspective to execute SQL statements. To switch to this perspective, use the PerspectiveQuery execution (SQL) menu, or the CtrlS shortcut." msgstr "" #. (itstool) path: figure/title #: C/query-execution-perspective.page:15 msgid "Query exec perspective" msgstr "" #. (itstool) path: figure/desc #: C/query-execution-perspective.page:16 msgid "The query exec perspective with one SELECT statement executed" msgstr "" #. (itstool) path: figure/media #. This is a reference to an external file such as an image or video. When #. the file changes, the md5 hash will change to let you know you need to #. update your localized copy. The msgstr is not used at all. Set it to #. whatever you like once you have updated your copy of the file. #: C/query-execution-perspective.page:17 msgctxt "_" msgid "external ref='figures/query-exec-persp.png' md5='c52ce85c0f89d26775c8b9dad282910a'" msgstr "" #. (itstool) path: page/p #: C/query-execution-perspective.page:20 msgid "The perspective is divided in two horizontal panes: the left pane for the user defined favorite statements, and the right pane being the action area." msgstr "" #. (itstool) path: page/p #: C/query-execution-perspective.page:24 msgid "In the figure above, there are two favorites: a SELECT statement (named \"List customers\") and an INSERT statement (named \"New customer ...\"). The INSERT statement needs one \"name\" parameter, whereas the SELECT statement does not require any parameter to be executed." msgstr "" #. (itstool) path: page/p #: C/query-execution-perspective.page:30 msgid "The icon difference between the two illustrates the fact that the INSERT favorite is also marked to be an action: it will be proposed as an action to be executed when the contextual menu is brought up in any grid representation of a resultset." msgstr "" #. (itstool) path: page/p #: C/query-execution-perspective.page:35 msgid "The left part of the perspective lists the favorite statements which have been user defined. Activating a favorite (double clicking) resets the SQL text area's contents to the selected statement's SQL." msgstr "" #. (itstool) path: page/p #: C/query-execution-perspective.page:40 msgid "The right pane is composed of zero or more tabs where the SQL is entered and executed. In each tab there is:" msgstr "" #. (itstool) path: item/p #: C/query-execution-perspective.page:45 msgid "an SQL area in the top left part" msgstr "" #. (itstool) path: item/p #: C/query-execution-perspective.page:46 msgid "command buttons in the top right part" msgstr "" #. (itstool) path: item/p #: C/query-execution-perspective.page:47 msgid "execution history in the lower left part" msgstr "" #. (itstool) path: item/p #: C/query-execution-perspective.page:48 msgid "execution results in the lower right part" msgstr "" #. (itstool) path: section/title #: C/query-execution-perspective.page:52 msgid "SQL area" msgstr "" #. (itstool) path: section/p #: C/query-execution-perspective.page:53 msgid "The SQL area is an SQL editor. The SQL can be any SQL understood by the database, with the exception of variables (which must have a specific syntax)." msgstr "" #. (itstool) path: section/p #: C/query-execution-perspective.page:57 msgid "The keyboard shortcuts in the SQL editor are:" msgstr "" #. (itstool) path: item/p #: C/query-execution-perspective.page:61 msgid "CtrlSPACE to obtain a completion list" msgstr "" #. (itstool) path: item/p #: C/query-execution-perspective.page:62 msgid "CtrlENTER to execute the SQL code" msgstr "" #. (itstool) path: item/p #: C/query-execution-perspective.page:63 msgid "Ctrll to clear the editor" msgstr "" #. (itstool) path: item/p #: C/query-execution-perspective.page:64 msgid "CtrlUp and CtrlDown to navigate through the editor's history" msgstr "" #. (itstool) path: section/title #: C/query-execution-perspective.page:70 msgid "Command buttons" msgstr "" #. (itstool) path: item/p #: C/query-execution-perspective.page:75 msgid "Clear: clears the editor (similar to the Ctrll shortcut)" msgstr "" #. (itstool) path: item/p #: C/query-execution-perspective.page:76 msgid "Variables: shows or hides the variables panel where you can give values to the variables present in the SQL code. The panel is automatically shown when a variable is detected in the SQL code" msgstr "" #. (itstool) path: item/p #: C/query-execution-perspective.page:79 msgid "Execute: executes the SQL code. If the SQL code contains some variables which have not been set, then a popup first appears requesting the variables to be given values. This is similar to the CtrlENTER shortcut" msgstr "" #. (itstool) path: item/p #: C/query-execution-perspective.page:82 msgid "Indent: re-indents the SQL code (warning: this removes any comments)" msgstr "" #. (itstool) path: item/p #: C/query-execution-perspective.page:83 msgid "Favorites: adds the current SQL code to the favorites" msgstr "" #. (itstool) path: section/title #: C/query-execution-perspective.page:88 msgid "Execution history" msgstr "" #. (itstool) path: section/p #: C/query-execution-perspective.page:89 msgid "The execution history part contains a list of the past executed statements, ordered by execution date along with an indication when the statement was executed (11 minutes in the figure above). Selecting an history item displays the corresponding result in the execution results part." msgstr "" #. (itstool) path: section/p #: C/query-execution-perspective.page:94 msgid "The Copy button copies the currently selected history item's SQL code to the SQL editor, and the Clear button removes all the history items." msgstr "" #. (itstool) path: section/p #: C/query-execution-perspective.page:98 msgid "Note that any given history item can also be removed individually using the Suppr key." msgstr "" #. (itstool) path: section/title #: C/query-execution-perspective.page:104 msgid "Execution results" msgstr "" #. (itstool) path: section/p #: C/query-execution-perspective.page:105 msgid "The Execution results part displays the execution result of the currently selected execution history item, as a table for SELECT statement, giving information for other types of statement, or giving the execution error notice if the execution failed." msgstr "" #. (itstool) path: page/title #: C/schema-browser-perspective.page:8 msgid "The schema browser perspective" msgstr "" #. (itstool) path: page/p #: C/schema-browser-perspective.page:9 msgid "Use the schema browser perspective to understand the database's organisation (schema). To switch to this perspective, use the PerspectiveSchema browser menu, or the CtrlB shortcut." msgstr "" #. (itstool) path: page/p #: C/schema-browser-perspective.page:14 msgid "The perspective is divided in two horizontal panes: the left pane for the user defined favorites, and the right pane being the action area." msgstr "" #. (itstool) path: figure/title #: C/schema-browser-perspective.page:19 msgid "Schema browser perspective's default view" msgstr "" #. (itstool) path: figure/desc #: C/schema-browser-perspective.page:20 msgid "The default Schema browser perspective" msgstr "" #. (itstool) path: page/p #: C/schema-browser-perspective.page:24 msgid "The left part of the perspective lists the favorite database objects or diagrams. Double clicking on a favorite opens its properties in the right pane." msgstr "" #. (itstool) path: page/p #: C/schema-browser-perspective.page:29 #: C/ldap-browser-perspective.page:31 msgid "The right pane is composed of several types of tabs:" msgstr "" #. (itstool) path: item/p #: C/schema-browser-perspective.page:33 msgid "a tab listing all the database's tables and views, in a cloud view where the tables with the more relations to other tables being displayed in a larger font; this tab is always present" msgstr "" #. (itstool) path: item/p #: C/schema-browser-perspective.page:36 msgid "zero or more tabs representing a table or views' properties: the list of columns, the list of constraints (primary or foreign keys, and unique constraints), a diagram showing the related tables, and an area to define display preferences for each column's data" msgstr "" #. (itstool) path: item/p #: C/schema-browser-perspective.page:39 msgid "zero or more diagrams in which any number of tables can be represented, where they are linked using their relations (as foreign key constraints)" msgstr "" #. (itstool) path: figure/title #: C/schema-browser-perspective.page:44 msgid "Tab showing information about a table" msgstr "" #. (itstool) path: figure/desc #: C/schema-browser-perspective.page:45 msgid "Example of information displayed for each table, note the difference between foreign keys implemented in the database and declared foreign keys" msgstr "" #. (itstool) path: figure/media #. This is a reference to an external file such as an image or video. When #. the file changes, the md5 hash will change to let you know you need to #. update your localized copy. The msgstr is not used at all. Set it to #. whatever you like once you have updated your copy of the file. #: C/schema-browser-perspective.page:47 msgctxt "_" msgid "external ref='figures/schema-browser-persp.png' md5='991ae01b9fb6b17c0b93ee4873b9b985'" msgstr "" #. (itstool) path: page/title #: C/transactions.page:9 msgid "Transactions" msgstr "" #. (itstool) path: page/p #: C/transactions.page:10 msgid "Transactions can be started, committed or rolled back on a per connection basis:" msgstr "" #. (itstool) path: p/media #. This is a reference to an external file such as an image or video. When #. the file changes, the md5 hash will change to let you know you need to #. update your localized copy. The msgstr is not used at all. Set it to #. whatever you like once you have updated your copy of the file. #: C/transactions.page:14 msgctxt "_" msgid "external ref='figures/trans-begin.png' md5='0382a22aeb54be0d7fe0ffa29dddf423'" msgstr "" #. (itstool) path: item/p #: C/transactions.page:14 msgid "use the toolbar button to start a transaction" msgstr "" #. (itstool) path: p/media #. This is a reference to an external file such as an image or video. When #. the file changes, the md5 hash will change to let you know you need to #. update your localized copy. The msgstr is not used at all. Set it to #. whatever you like once you have updated your copy of the file. #: C/transactions.page:16 msgctxt "_" msgid "external ref='figures/trans-commit.png' md5='27f45d32501cc05bd6f6b16263283e9a'" msgstr "" #. (itstool) path: item/p #: C/transactions.page:16 msgid "use the toolbar button to commit the current transaction (apply all the changes)" msgstr "" #. (itstool) path: p/media #. This is a reference to an external file such as an image or video. When #. the file changes, the md5 hash will change to let you know you need to #. update your localized copy. The msgstr is not used at all. Set it to #. whatever you like once you have updated your copy of the file. #: C/transactions.page:18 msgctxt "_" msgid "external ref='figures/trans-rollback.png' md5='470522738b1d6bf91b9787baac1c0191'" msgstr "" #. (itstool) path: item/p #: C/transactions.page:18 msgid "use the toolbar button to abort the current transaction (forget all the changes)" msgstr "" #. (itstool) path: note/p #: C/transactions.page:22 msgid "A transaction may be started automatically when executing a SELECT statement which involves binary objects (BLOBs), and the transaction may be locked while the resulting data set is kept in memory (to get rid of a data set in a query execution perspective, clear the history item relating to the data set)." msgstr "" #. (itstool) path: page/title #: C/table-insert-data.page:8 msgid "Inserting data in a table" msgstr "" #. (itstool) path: page/p #: C/table-insert-data.page:9 msgid "From the schema browser perspective, when a table's properties is displayed in a tab, use the TableInsert data menu to have a popup appear containing a data entry for each column of the table to insert data into." msgstr "" #. (itstool) path: page/p #: C/table-insert-data.page:14 msgid "A popup similar to the following will appear:" msgstr "" #. (itstool) path: figure/title #: C/table-insert-data.page:18 msgid "Popup to insert data into table" msgstr "" #. (itstool) path: figure/desc #: C/table-insert-data.page:19 msgid "A popup to insert data in a table" msgstr "" #. (itstool) path: figure/media #. This is a reference to an external file such as an image or video. When #. the file changes, the md5 hash will change to let you know you need to #. update your localized copy. The msgstr is not used at all. Set it to #. whatever you like once you have updated your copy of the file. #: C/table-insert-data.page:20 msgctxt "_" msgid "external ref='figures/table-insert-data.png' md5='308807b8443d5ab26c8704a6e01aa1ab'" msgstr "" #. (itstool) path: page/p #: C/table-insert-data.page:22 msgid "The noticeable points here are:" msgstr "" #. (itstool) path: item/p #: C/table-insert-data.page:26 msgid "There is one data entry per column in the table, with the exception (not shown in this figure) of multiple foreign key fields for which a single drop down choice widget is shown;" msgstr "" #. (itstool) path: item/p #: C/table-insert-data.page:28 msgid "Each data entry has a small button on the right giving information about the corresponding data entry, and allowing you to reset the data entry's value to the value it had before any modification done, to set it to NULL or to set it to a default value. The button's color has the following signification:" msgstr "" #. (itstool) path: item/p #: C/table-insert-data.page:33 msgid "Red: means the current value in the data entry is invalid" msgstr "" #. (itstool) path: item/p #: C/table-insert-data.page:34 msgid "Blue: means the current value in the data entry is unused and the column's default value will be used instead (useful for example for auto incremented columns)" msgstr "" #. (itstool) path: item/p #: C/table-insert-data.page:36 msgid "Green: means the current value in the data entry is NULL" msgstr "" #. (itstool) path: item/p #: C/table-insert-data.page:37 msgid "Same color as the rest of the UI: means none of the above situations apply" msgstr "" #. (itstool) path: item/p #: C/table-insert-data.page:40 msgid "Columns which are foreign keys to other tables are presented as a drop down combo box where you can only choose among the values in the referenced table (hint: to have that values list refreshed you should close the popup dialog and reopen it);" msgstr "" #. (itstool) path: page/title #: C/variables.page:9 msgid "Variables in SQL code" msgstr "" #. (itstool) path: page/p #: C/variables.page:10 msgid "Variables (sometimes refered to as placeholders) are places in SQL code which are replaced by actual values when the SQL code is executed. The benefits are faster execution times (as the SQL code is parsed only once) and a protection against SQL injection vulnerabilities." msgstr "" #. (itstool) path: page/p #: C/variables.page:16 msgid "Variables can be used in any SQL code, and are defined using the following syntax:" msgstr "" #. (itstool) path: page/code #: C/variables.page:19 #, no-wrap msgid "" "\n" "##<variable name>[::<variable type>[::NULL]]" msgstr "" #. (itstool) path: item/p #: C/variables.page:25 msgid "the variable name can contain any SQL identifier character or among the +-.|@?characters (no space allowed)" msgstr "" #. (itstool) path: item/p #: C/variables.page:27 msgid "the variable type can be among: string, boolean, int, date, time, timestamp, guint, blob and binary" msgstr "" #. (itstool) path: item/p #: C/variables.page:30 msgid "the ::NULL can be appended to specify that the variable may take the special NULL value." msgstr "" #. (itstool) path: page/p #: C/variables.page:33 msgid "Examples:" msgstr "" #. (itstool) path: page/code #: C/variables.page:36 #, no-wrap msgid "" "\n" "##name::string\n" "##id::int::NULL\n" "##sales@3::date::NULL\n" "##customers@id::int" msgstr "" #. (itstool) path: page/title #: C/virtual-connections.page:9 msgid "Connections binding (i.e. virtual connections)" msgstr "" #. (itstool) path: page/p #: C/virtual-connections.page:10 msgid "Connection binding is a feature which allows to \"bind\" several connections and/or imported data sets into a single connection, which can be used almost like a regular connection." msgstr "" #. (itstool) path: page/p #: C/virtual-connections.page:14 msgid "This feature is useful when one needs to execute an SQL command (for example to extract data) taking into account data actually stored in different databases. Without this feature, the way to achieve the same result is by exporting the necessary data from each database and work on the data outside of the databases." msgstr "" #. (itstool) path: page/p #: C/virtual-connections.page:20 msgid "To create a new \"bound\" connection (or \"virtual\" connection), use the ConnectionBind connection menu, or the Ctrli shortcut. This pops up a new dialog window from which elements to be included in the \"bound\" connection can be defined as shown below." msgstr "" #. (itstool) path: figure/title #: C/virtual-connections.page:27 msgid "Dialog to create a new virtual connection" msgstr "" #. (itstool) path: figure/desc #: C/virtual-connections.page:28 msgid "Here the current connection (c1) will be bound in the \"c1\" schema" msgstr "" #. (itstool) path: figure/media #. This is a reference to an external file such as an image or video. When #. the file changes, the md5 hash will change to let you know you need to #. update your localized copy. The msgstr is not used at all. Set it to #. whatever you like once you have updated your copy of the file. #: C/virtual-connections.page:29 msgctxt "_" msgid "external ref='figures/virtual-cnc.png' md5='0a3b008f3696c6239331bf697e2b4847'" msgstr "" #. (itstool) path: page/p #: C/virtual-connections.page:31 msgid "Use the Add binding button to either:" msgstr "" #. (itstool) path: item/p #: C/virtual-connections.page:35 msgid "bind a connection to include all the tables of that connection: use the Bind a connection option. This option simply adds a new element in the dialog, to specify a schema name and select an existing connection" msgstr "" #. (itstool) path: item/p #: C/virtual-connections.page:36 msgid "bind a data set to import data from a text file as a single table: use the Bind a data set option. See section below for more information." msgstr "" #. (itstool) path: section/title #: C/virtual-connections.page:40 msgid "Use case for virtual connections" msgstr "" #. (itstool) path: section/p #: C/virtual-connections.page:41 msgid "To illustrate virtual connection usage, let's define a simple use case and see how it's useful. Suppose you have a database which contains the list of servers which you are responsible for. For simplicity, let's assume that the database contains a table named \"server\" with the following definition:" msgstr "" #. (itstool) path: section/code #: C/virtual-connections.page:46 #, no-wrap msgid "" "CREATE TABLE servers (name string, location string);" msgstr "" #. (itstool) path: section/p #: C/virtual-connections.page:47 msgid "Let's suppose this table contains the following information:" msgstr "" #. (itstool) path: section/code #: C/virtual-connections.page:50 #, no-wrap msgid "" "\n" "> select * from servers ;\n" "name | location\n" "---------+---------\n" "moon | room1 \n" "darkstar | room2 \n" "flag | room3 \n" "alf | room2 \n" "vador | room3 \n" "(5 rows)\n" ">\n" " " msgstr "" #. (itstool) path: section/p #: C/virtual-connections.page:62 msgid "Now let's assume you have a third party program which gives you a list of servers for which there might be a problem, the output of this program is a CSV file with a column for the server name, a column for the error code, and a column describing the problem. Let's assume the CSV file has the following contents:" msgstr "" #. (itstool) path: section/code #: C/virtual-connections.page:67 #, no-wrap msgid "" "\n" "$ cat problems.csv \n" "Server name,Error code,Error description\n" "darkstar,0,file system full\n" "vador,1,outdated AV signature\n" "darkstar,2,overloaded\n" "flag,0,file system full\n" "$\n" " " msgstr "" #. (itstool) path: section/p #: C/virtual-connections.page:76 msgid "Let's suppose now you want to know all the servers, where they are located where there is a problem with error code 0. The solution is to bind the connection to the database (for example in the \"c1\" schema), import the problems CSV file (for example in the \"tab\" table), and execute the following SQL command:" msgstr "" #. (itstool) path: section/code #: C/virtual-connections.page:81 #, no-wrap msgid "" "\n" "SELECT \n" " \"server name\", \n" " location\n" "FROM tab\n" " INNER JOIN c1.servers AS s ON (tab.\"server name\" = s.name)\n" "WHERE \"Error code\"=0\n" " " msgstr "" #. (itstool) path: section/p #: C/virtual-connections.page:89 msgid "Which returns the expected results as shown in the following figure:" msgstr "" #. (itstool) path: figure/title #: C/virtual-connections.page:93 msgid "Expected results from virtual connection" msgstr "" #. (itstool) path: figure/media #. This is a reference to an external file such as an image or video. When #. the file changes, the md5 hash will change to let you know you need to #. update your localized copy. The msgstr is not used at all. Set it to #. whatever you like once you have updated your copy of the file. #: C/virtual-connections.page:94 msgctxt "_" msgid "external ref='figures/virtual-cnc-4.png' md5='9c19e575c63411872a3742efd02473c1'" msgstr "" #. (itstool) path: section/title #: C/virtual-connections.page:100 msgid "Importing a data set into a virtual connection" msgstr "" #. (itstool) path: section/p #: C/virtual-connections.page:101 msgid "To import a data set into a table in the virtual connection (for example to import the \"problems.csv\" file from the use case), use the Bind a data set option from the virtual connection creation dialog:" msgstr "" #. (itstool) path: figure/title #: C/virtual-connections.page:107 msgid "Import a data set into a virtual connection - 1" msgstr "" #. (itstool) path: figure/media #. This is a reference to an external file such as an image or video. When #. the file changes, the md5 hash will change to let you know you need to #. update your localized copy. The msgstr is not used at all. Set it to #. whatever you like once you have updated your copy of the file. #: C/virtual-connections.page:108 msgctxt "_" msgid "external ref='figures/virtual-cnc-5.png' md5='aec9ae2fc4bfac2ac3460720f5f31bb9'" msgstr "" #. (itstool) path: section/p #: C/virtual-connections.page:110 msgid "From there use the Import button which allows you to select a file to import and also define some import options (file encoding, file type, ...) After this step, the virtual connection is ready to be used:" msgstr "" #. (itstool) path: figure/title #: C/virtual-connections.page:116 msgid "Import a data set into a virtual connection - 2" msgstr "" #. (itstool) path: figure/media #. This is a reference to an external file such as an image or video. When #. the file changes, the md5 hash will change to let you know you need to #. update your localized copy. The msgstr is not used at all. Set it to #. whatever you like once you have updated your copy of the file. #: C/virtual-connections.page:117 msgctxt "_" msgid "external ref='figures/virtual-cnc-2.png' md5='275c8e47da75738596b0b4c47b06a70a'" msgstr "" #. (itstool) path: section/p #: C/virtual-connections.page:119 msgid "The resulting virtual connection, identified as \"c2\" here is opened in its own new window:" msgstr "" #. (itstool) path: figure/title #: C/virtual-connections.page:123 msgid "New opened virtual connection" msgstr "" #. (itstool) path: figure/media #. This is a reference to an external file such as an image or video. When #. the file changes, the md5 hash will change to let you know you need to #. update your localized copy. The msgstr is not used at all. Set it to #. whatever you like once you have updated your copy of the file. #: C/virtual-connections.page:124 msgctxt "_" msgid "external ref='figures/virtual-cnc-3.png' md5='a47d581b293767deb95f77e555f07e8c'" msgstr "" #. (itstool) path: section/title #: C/virtual-connections.page:129 msgid "SQL usable with virtual connections" msgstr "" #. (itstool) path: section/p #: C/virtual-connections.page:130 msgid "You can use the SQL understood by SQLite in any virtual connection. Be aware however that if you define database objects (outside of the extended SQL presented next section), they will be lost the next time the virtual connection is opened." msgstr "" #. (itstool) path: section/p #: C/virtual-connections.page:135 #: C/ldap-connections.page:98 msgid "See the SQL understood by LDAP connections and virtual connections section for more information." msgstr "" #. (itstool) path: page/title #: C/ldap-browser-perspective.page:8 msgid "The LDAP browser perspective" msgstr "" #. (itstool) path: page/p #: C/ldap-browser-perspective.page:9 msgid "Use the LDAP browser perspective to view and manipulate data stored in an LDAP directory. To switch to this perspective, use the PerspectiveLDAP browser menu, or the CtrlP shortcut. This perspective is of course only available when the opened connection is an LDAP connection." msgstr "" #. (itstool) path: page/p #: C/ldap-browser-perspective.page:14 msgid "The perspective is divided in two horizontal panes: the left pane for the user defined favorites (to hold references to specific LDAP entries or specific LDAP classes), and the right pane being the action area." msgstr "" #. (itstool) path: figure/title #: C/ldap-browser-perspective.page:20 msgid "LDAP browser's entry tab" msgstr "" #. (itstool) path: figure/desc #: C/ldap-browser-perspective.page:21 msgid "LDAP entries tab" msgstr "" #. (itstool) path: figure/media #. This is a reference to an external file such as an image or video. When #. the file changes, the md5 hash will change to let you know you need to #. update your localized copy. The msgstr is not used at all. Set it to #. whatever you like once you have updated your copy of the file. #: C/ldap-browser-perspective.page:22 msgctxt "_" msgid "external ref='figures/ldap-browser-persp.png' md5='e2c1bbcb2f65ffe16b632141908f7027'" msgstr "" #. (itstool) path: page/p #: C/ldap-browser-perspective.page:25 msgid "The left part of the perspective lists the favorite LDAP entries or classes. Double clicking on a favorite opens its properties in the right pane. Note that the LDAP entries favorites will always appear before the classes favorites." msgstr "" #. (itstool) path: item/p #: C/ldap-browser-perspective.page:35 msgid "tabs to explore the LDAP DIT (Directory Information Tree): when an entry is selected from the tree, its attributes are displayed (only the valued attributes are displayed, the ones with no value are hidden), and the entry's DN (Distinguished Name) is always displayed first. Also note that the children of each entry are only fetched when necessary to avoid unnecessary requests to the LDAP server." msgstr "" #. (itstool) path: item/p #: C/ldap-browser-perspective.page:39 msgid "tabs to explore the LDAP's classes, see figure below. For a selected class, all the information regarding the class is displayed (description, OID, type, ...)" msgstr "" #. (itstool) path: item/p #: C/ldap-browser-perspective.page:41 msgid "tabs to perform LDAP searches, see figure below. An LDAP search definition can be saved as a virtual table, see the LDAP table's mapping." msgstr "" #. (itstool) path: figure/title #: C/ldap-browser-perspective.page:45 msgid "LDAP browser's classes tab" msgstr "" #. (itstool) path: figure/desc #: C/ldap-browser-perspective.page:46 msgid "LDAP classes tab" msgstr "" #. (itstool) path: figure/media #. This is a reference to an external file such as an image or video. When #. the file changes, the md5 hash will change to let you know you need to #. update your localized copy. The msgstr is not used at all. Set it to #. whatever you like once you have updated your copy of the file. #: C/ldap-browser-perspective.page:47 msgctxt "_" msgid "external ref='figures/ldap-classes.png' md5='1ef8ffca04b9ba762a3cf2e884c98d03'" msgstr "" #. (itstool) path: figure/title #: C/ldap-browser-perspective.page:50 msgid "LDAP browser's search tab" msgstr "" #. (itstool) path: figure/desc #: C/ldap-browser-perspective.page:51 msgid "LDAP search tab" msgstr "" #. (itstool) path: figure/media #. This is a reference to an external file such as an image or video. When #. the file changes, the md5 hash will change to let you know you need to #. update your localized copy. The msgstr is not used at all. Set it to #. whatever you like once you have updated your copy of the file. #: C/ldap-browser-perspective.page:52 msgctxt "_" msgid "external ref='figures/ldap-search.png' md5='81aa2f8a2770590d96fd9c980c578d62'" msgstr "" #. (itstool) path: page/p #: C/ldap-browser-perspective.page:54 msgid "Links in these tabs (identified by blue and underlined text) open a new tab, or use the first tab next to the current tab to display information about the selected link. For example in the figure above illustrating an LDAP entries tab, clicking on the \"inetOrgPerson\" will open a new \"LDAP classes\" tab and display the information about that class." msgstr "" #. (itstool) path: page/title #: C/ldap-connections.page:9 msgid "LDAP connections" msgstr "" #. (itstool) path: page/p #: C/ldap-connections.page:10 msgid "LDAP connections are different than other connections in a way that an LDAP database stores data in a hierarchical way, in the DIT (Directory Information Tree), whereas other databases accessible using the gda-browser application are relational databases." msgstr "" #. (itstool) path: page/p #: C/ldap-connections.page:15 msgid "As a consequence, LDAP connections are treaded specially: as normal connections with tables (see the table mapping explained next), and through the presence of the LDAP browser perspective" msgstr "" #. (itstool) path: page/p #: C/ldap-connections.page:20 msgid "Note that LDAP connections may not be available is either the LDAP database provider is not installed or if the LDAP support was disabled during the compilation." msgstr "" #. (itstool) path: section/title #: C/ldap-connections.page:26 msgid "LDAP table's mapping" msgstr "" #. (itstool) path: section/p #: C/ldap-connections.page:27 msgid "Within an LDAP connection, it is possible to declare virtual tables which are mapped to an LDAP search. These virtual tables can then later be used like any other table. The first column of each LDAP virtual table will always be the DN (Distinguished Name) of the entry represented in the row; the other columns depend on the table definition." msgstr "" #. (itstool) path: section/p #: C/ldap-connections.page:33 msgid "An LDAP virtual table is defined by the following attributes:" msgstr "" #. (itstool) path: item/p #: C/ldap-connections.page:37 msgid "a table name" msgstr "" #. (itstool) path: item/p #: C/ldap-connections.page:38 msgid "the base DN for the search: the LDAP entry at which the search begins (if not specified then the top level entry of the LDAP connection is used)" msgstr "" #. (itstool) path: item/p #: C/ldap-connections.page:40 msgid "the search filter: a valid LDAP search filter (if none is provided then the default search filter is \"(objectClass=*)\", requesting any LDAP entry)." msgstr "" #. (itstool) path: item/p #: C/ldap-connections.page:42 msgid "the attributes: the attributes to retrieve, each attribute will be mapped to a column of the table. The attributes must be a comma separated list of attributes, where each attribute can optionally be assigned a type and a multi value option (see below)." msgstr "" #. (itstool) path: item/p #: C/ldap-connections.page:45 msgid "the scope: the search scope, \"subtree\" (to search the base DN and the entire sub tree below), \"onelevel\" (to search the immediate children of the base DN entry only), or \"base\" (to search the base DN only)" msgstr "" #. (itstool) path: figure/title #. (itstool) path: figure/desc #: C/ldap-connections.page:50 #: C/ldap-connections.page:51 msgid "LDAP table's properties" msgstr "" #. (itstool) path: figure/media #. This is a reference to an external file such as an image or video. When #. the file changes, the md5 hash will change to let you know you need to #. update your localized copy. The msgstr is not used at all. Set it to #. whatever you like once you have updated your copy of the file. #: C/ldap-connections.page:52 msgctxt "_" msgid "external ref='figures/ldap-table-mapping.png' md5='39f204f664cf1202deb716bb19b8993b'" msgstr "" #. (itstool) path: section/p #: C/ldap-connections.page:54 msgid "For example in the figure above, the \"users\" table will \"contain\" all the LDAP entries from the top level LDAP entry of the connection, and have 3 columns: the DN, the \"cn\" and the \"jpegPhoto\"." msgstr "" #. (itstool) path: section/title #: C/ldap-connections.page:61 msgid "Attributes to columns mapping" msgstr "" #. (itstool) path: section/p #: C/ldap-connections.page:62 msgid "As mentioned in the previous section, each attribute will be mapped to a column. The column type is normally automatically determined (string, number, ...) but can be forced by appending to the attribute name the \"::<type>\" for the requested type." msgstr "" #. (itstool) path: section/p #: C/ldap-connections.page:67 msgid "Also, because some attributes can have multiple values, the table construction handles multi-valued attributes in different ways, depending on each attribute's options. An option can be specified by appending the \"::<option>\" to the attribute name. Valid options are:" msgstr "" #. (itstool) path: item/p #: C/ldap-connections.page:74 msgid "\"NULL\" or \"0\": a NULL value will be returned for the attribute" msgstr "" #. (itstool) path: item/p #: C/ldap-connections.page:75 msgid "\"CSV\": a comma separated value with all the values of the attribute will be returned. This only works for string attribute types." msgstr "" #. (itstool) path: item/p #: C/ldap-connections.page:77 msgid "\"MULT\" or \"*\": a row will be returned for each value of the attribute, effectively multiplying the number of returned rows" msgstr "" #. (itstool) path: item/p #: C/ldap-connections.page:79 msgid "\"1\": only the first value of the attribute will be used, the other values ignored" msgstr "" #. (itstool) path: item/p #: C/ldap-connections.page:80 msgid "\"CONCAT\": the attributes' values are concatenated (with a newline char between each value)" msgstr "" #. (itstool) path: item/p #: C/ldap-connections.page:82 msgid "\"ERROR\": an error value will be returned (this is the default behaviour)" msgstr "" #. (itstool) path: section/title #: C/ldap-connections.page:87 msgid "SQL usable with LDAP connections" msgstr "" #. (itstool) path: section/p #: C/ldap-connections.page:88 msgid "You can use the SQL understood by SQLite in any LDAP connection. Be aware however that if you define database objects (outside of the extended SQL presented next section), they will be lost the next time the LDAP connection is opened." msgstr "" #. (itstool) path: section/p #: C/ldap-connections.page:93 msgid "So it is perfectly safe for example to create a table to store some LDAP data which may require a long operation to obtain, but after closing the LDAP connection, the table and its data will be lost." msgstr "" #. (itstool) path: section/title #: C/ldap-connections.page:105 msgid "SQL extension to handle LDAP tables" msgstr "" #. (itstool) path: section/p #: C/ldap-connections.page:106 msgid "LDAP tables can be created using an extended set of SQL commands:" msgstr "" #. (itstool) path: item/p #: C/ldap-connections.page:110 msgid "CREATE LDAP TABLE <table_name> [BASE='<base_dn>'] [FILTER='<filter>'] [ATTRIBUTES='<filter>'] [SCOPE='<filter>'] to declare a new LDAP virtual table" msgstr "" #. (itstool) path: item/p #: C/ldap-connections.page:111 msgid "DESCRIBE LDAP TABLE <table_name> to show LDAP virtual table's definition" msgstr "" #. (itstool) path: item/p #: C/ldap-connections.page:112 msgid "ALTER LDAP TABLE <table_name> [BASE='<base_dn>'] [FILTER='<filter>'] [ATTRIBUTES='<filter>'] [SCOPE='<filter>'] to modify an LDAP virtual table's definition (only the specified part is actually modified)" msgstr "" #. (itstool) path: item/p #: C/ldap-connections.page:113 msgid "DROP LDAP TABLE <table_name> to remove an LDAP virtual table. Note that the usual DROP TABLE <table_name> can also be used instead." msgstr "" #. (itstool) path: section/p #: C/ldap-connections.page:116 msgid "For example the following SQL code:" msgstr "" #. (itstool) path: section/code #: C/ldap-connections.page:119 #, no-wrap msgid "" "\n" " CREATE LDAP TABLE users FILTER='(objectClass=inetOrgPerson)'\n" " ATTRIBUTES='cn,sn,givenName,seeAlso::*' SCOPE='subtree';\n" " SELECT * FROM users WHERE cn like '%john%';\n" " ALTER LDAP TABLE users FILTER='(&(objectClass=inetOrgPerson)(cn=*john*))';\n" " SELECT * FROM users;\n" " DROP LDAP TABLE users;\n" " " msgstr "" #. (itstool) path: section/p #: C/ldap-connections.page:127 msgid "should display twice the same results, which list all the LDAP entries of the \"inetOrgPerson\" class with a CommonName (cn) containing the \"john\" string." msgstr ""