# Basque translation for libgda. # Copyright (C) 2025 libgda's COPYRIGHT HOLDER # This file is distributed under the same license as the libgda package. # FIRST AUTHOR , YEAR. # msgid "" msgstr "" "Project-Id-Version: libgda master\n" "POT-Creation-Date: 2025-06-07 22:11+0000\n" "PO-Revision-Date: 2025-06-07 22:11+0000\n" "Last-Translator: FULL NAME \n" "Language-Team: Basque \n" "MIME-Version: 1.0\n" "Content-Type: text/plain; charset=UTF-8\n" "Content-Transfer-Encoding: 8bit\n" "Language: eu\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 ""