Database Methods

View

db._view(view-name)

Returns the view with the given name or null if no such view exists.

  1. arangosh> view = db._view("example");
  2. ........> // or, alternatively
  3. arangosh> view = db["example"]

Show execution results

Hide execution results

  1. [ArangoView 88709, "example" (type arangosearch)]
  2. [ArangoView 88709, "example" (type arangosearch)]

db._view(view-identifier)

Returns the view with the given identifier or null if no such view exists.Accessing views by identifier is discouraged for end users. End users shouldaccess views using the view name.

Examples

Get a View by name:

  1. arangosh> db._view("demoView");

Show execution results

Hide execution results

  1. [ArangoView 99, "demoView" (type arangosearch)]

Unknown View:

  1. arangosh> db._view("unknown");

Show execution results

Hide execution results

  1. null

Create

db._createView(name, type, properties)

Creates a new View.

name is a string and the name of the View. No View or collection with thesame name may already exist in the current database. For more information onvalid View names please refer to the naming conventions.

type must be the string "arangosearch", as it is currently the onlysupported View type.

properties is an optional object containing View configuration specificto each View-type. Currently, only ArangoSearch Views are supported. SeeArangoSearch View definition fordetails.

Examples

  1. arangosh> v = db._createView("example", "arangosearch");
  2. arangosh> v.properties()
  3. arangosh> db._dropView("example")

Show execution results

Hide execution results

  1. [ArangoView 88701, "example" (type arangosearch)]
  2. {
  3. "writebufferIdle" : 64,
  4. "writebufferSizeMax" : 33554432,
  5. "consolidationPolicy" : {
  6. "type" : "tier",
  7. "segmentsBytesFloor" : 2097152,
  8. "segmentsBytesMax" : 5368709120,
  9. "segmentsMax" : 10,
  10. "segmentsMin" : 1,
  11. "minScore" : 0
  12. },
  13. "primarySort" : [ ],
  14. "writebufferActive" : 0,
  15. "consolidationIntervalMsec" : 10000,
  16. "cleanupIntervalStep" : 2,
  17. "commitIntervalMsec" : 1000,
  18. "links" : {
  19. }
  20. }

All Views

db._views()

Returns all views of the given database.

Examples

List all views:

  1. arangosh> db._views();

Show execution results

Hide execution results

  1. [
  2. [ArangoView 99, "demoView" (type arangosearch)],
  3. [ArangoView 88712, "exampleView" (type arangosearch)]
  4. ]

Drop

db._dropView(name)

Drops a view named name and all its data. No error is thrown if there isno such view.

db._dropView(view-identifier)

Drops a view identified by view-identifier with all its data. No error isthrown if there is no such view.

Examples

Drop a view:

  1. arangosh> db._createView("exampleView", "arangosearch");
  2. arangosh> db._dropView("exampleView");
  3. arangosh> db._view("exampleView");

Show execution results

Hide execution results

  1. [ArangoView 88706, "exampleView" (type arangosearch)]
  2. null