Changes

Jump to navigation Jump to search
3,474 bytes removed ,  10:06, 12 August 2015
no edit summary
First, launch a '''Server''' and '''Client''' instance of BaseX: double click on the '''BaseX Server/Client''' icons, or run the <code>basexserver</code> and <code>basexclient</code> scripts. [[Startup#BaseX Server|Follow this link]] for more information (or check out the additional [[Command-Line Options#BaseX Server|command-line options]]).
=Create a database=Working with the BaseX Console==
* To create a database you need an XML document, e.g. The BaseX command-line client provides similar features to the [[http://filesStandalone Mode]].basexThe major difference is that all commands will be executed by the BaseX server instance.orgAs a consequence, paths/xml/factbook.xml factbook.xml].* Save this document URIs to resources need to be resolvable by the directory you are working in.* In server (file contents will not be transfered to the client terminal, type in:<code>> [[Commands#CREATE DB|CREATE DB]] factbook factbookserver).xml</code>
: '''factbook''' is The username and password can also be specified as options. To evaluate commands without entering the name of console mode, you can use the database <brcode>-c</code>option on the command line: : '''factbook.xml''' is the xml file, which is used to create the database<brpre>basexclient -V -Uadmin -Padmin -c "CREATE DB input <example/> ; XQUERY /"
If everything works you see the following lines:<pre>Database 'factbookinput' created in 95013.83 85 ms.<example/pre> ; Where is the database stored?Query:By default, databases are stored in the <code>BaseXData</code> directory, which is located in your home folder.Depending on your [[Configuration]], the location of your home folder varies. For example, on a Mac it's <code>/Users/John</code>, if your name is John. If you have used the Windows Installer, the directory will be named <code>data</code>, and reside in the application directory.
=Execute a query=Parsing: 0.18 msThe [[Commands#XQUERY|XQUERY]] command lets you run a queryCompiling: 0.04 ms* For example, this query returns all country nodes in the currently opened databaseEvaluating: 0.12 ms<code>Printing: 0.07 ms> [[Commands#XQUERY|XQUERY]] //country</code>Total Time: 0.41 ms
* You can also run queries in files:<code>> [[Commands#RUN|RUN]] /Users/John/query.xq</code> =Create a new database=Now we will create another database from the [http://files.basex.org/xml/xmark.xml xmark.xml] document. * Create the new database, named 'xmark'.<code>> [[Commands#CREATE DB|CREATE DB]] xmark xmark.xml</code> * Set the new database xmark as the context:<code>> [[Commands#OPEN|OPEN]] xmark</code> * Now you can easily execute queries on your new database:<code>> [[Commands#XQUERY|XQUERY]] //people/person/name</code> =Switch the database=* You can explicitly query the factbook database with the <code>docHit(...s)</code> funtion, no matter what the current context is.<code>> [[Commands#XQUERY|XQUERY]] doc("factbook")//country</code> * Otherwise, to set factbook as the current context, execute the following:1 Item<code>> [[Commands#OPEN|OPEN]] factbook</code> * The following command lists all databases than can be opened by the currently logged in usersUpdated:0 Items<code>> [[Commands#LIST|LIST]]</code> =Close or delete a database=* To [[Commands|close]] the current context database, please typePrinted: 10 Bytes<code>> [[Commands#CLOSE|CLOSE]]</code> * Use the [[Commands#DROP DB|DROP DB]] command to delete the xmark databaseRead Locking:<code>> [local [Commands#DROP DB|DROP DB]input] xmark</code> =Create a collection='''What is a collection?'''With BaseX you can group documents into one logical collection. A collection is a database that contains two or more documents. Collections accept any type of XML documents, regardless of their structure. Let's add the xmark.xml document to the factbook database to create a collection. The name of the original factbook database remains. * First make sure factbook is openedWrite Locking:<code>> [[Commands#OPEN|OPEN]] factbook</code> * Now add the xmark.xml document: <code>> [[Commands#ADD|ADD]] xmark.xml</code> =Delete a document=* Deleting a document from a collection is easy:<code>> [[Commands#DELETE|DELETE]] xmark.xml</code> Make sure that the collection, which contains the '''xmark.xml''' document, is opened. =Delete a collection=Deleting a collection is the same as deleting a database. * To delete the collection factbook, type:<code>> [[Commands#DROP DB|DROP DB]] factbook</code> =Get server information=Several commands help to explore the state of a server. For a complete list, please visit the [[Commands]] Section. * To see all databases on the server, type:<code>> [[Commands#LIST|LIST]]</code> * To see the general information of the opened database, type:<code>> [[Commands#INFO|INFO]]</code> * To list all sessions that are managed by the server instance, type:<code>> [[Commands#SHOW USERS|SHOW USERS]]</code> =Backup and restore=* To backup your database, type:<code>> [[Commands#CREATE BACKUP|CREATE BACKUP]] factbook</code> * To restore your database, type:<code>> [[Commands#RESTORE|RESTORE]] factbook</code> '''Where is the backup-file stored?''' The backup-file is stored in the database directory.The file is named <code>factbook-timestamp.zip</code> (<code>db_name-timestamp.zip</code>).To restore the database the file with the newest timestamp is taken.none
Query "user" executed in 0.41 ms.</pre>
[[Category:Beginner]]
[[Category:Server]]
Bureaucrats, editor, reviewer, Administrators
13,550

edits

Navigation menu