2

If have multiple databases defined on a particular ArangoDB server, how do I specify the database I'd like an AQL query to run against?

Running the query through the REST endpoint that includes the db name (substituted into [DBNAME] below) ie:

/_db/[DBNAME]/_api/cursor

doesn't seem to work. The error message says 'unknown path /_db/[DBNAME]/_api/cursor'

Is this something I have to specify in the query itself?

Also: The query I'm trying to run is:

FOR col in COLLECTIONS() RETURN col.name

Fwiw, I haven't found a way to set the "current" database through the REST API. Also, I'm accessing the REST API from C++ using fuerte.

Tom Regner
  • 6,856
  • 4
  • 32
  • 47
Dave
  • 2,653
  • 4
  • 20
  • 22
  • The database seems to be part of the RequestHeader (see include/fuerte/message.h line 96 (https://github.com/arangodb/fuerte/blob/0a8f40a9c5c617975f8fc85738901efb8bade294/include/fuerte/message.h#L96)); I'd say have a look at the headers, revise your code and post the relevanrt parts of it if your problems remain – Tom Regner Feb 24 '20 at 11:07
  • 1
    The answer to your question is: You don't specify the database as part of the AQL-query. – Tom Regner Feb 24 '20 at 11:09
  • Thanks for the suggestion Tom. I tried setting the request->header.database value, but it didn't help. I seem completely unable to change arangodb's notion of the "Current" database (as returned by the endpoint /_api/database/current), nor can I seem to get the /_db/[DBNAME]/ prefix to work. The current database seems to be stuck at '_system', at least via the REST api as accessed through fuerte. Still looking for advice in how to get past this. I will look into rephrasing the question, providing some simple code and asking again. – Dave Feb 29 '20 at 17:34
  • Glad you found a way; it's a low-level lib in it's infancy, it seems, that's just the way it is then. kind regards – Tom Regner Mar 01 '20 at 12:58

2 Answers2

3

Tom Regner deserves primary credit here for prompting the enquiry that produced this answer. I am posting my findings here as an answer to help others who might run into this.

I don't know if this is a fuerte bug, shortcoming or just an api caveat that wasn't clear to me... BUT...

In order for the '/_db/[DBNAME/' prefix in an endpoint (eg full endpoint '/_db/[DBNAME/_api/cursor') to be registered and used in the header of a ::arangodb::fuerte::Request, it is NOT sufficient (as of arangodb 3.5.3 and the fuerte version available at the time of this answer) to simply call:

std::unique_ptr<fuerte::Request> request;
const char *endpoint = "/_db/[DBNAME/_api/cursor";
request = fuerte::createRequest(fuerte::RestVerb::Post,endpoint);
// and adding any arguments to the request using a VPackBuilder...
// in this case the query (omitted)

To have the database name included as part of such a request, you must additionally call the following:

request->header.parseArangoPath(endpoint);

Failure to do so seems to result in an error about an 'unknown path'.

Note 1: Simply setting the database member variable, ie

request->header.database = "[DBNAME]";

does not work.

Note 2: that operations without the leading '/_db/[DBNAME]/' prefix, seem to work fine using the 'current' database. (which at least for me, seems to be stuck at '_system' since as far as I can tell, there doesn't seem to be an endpoint to change this via the HTTP REST Api.)

Wai Ha Lee
  • 8,598
  • 83
  • 57
  • 92
Dave
  • 2,653
  • 4
  • 20
  • 22
0

The docs aren't very helpful right now, so just incase someone is looking for a more complete example, then please consider the following code.

EventLoopService eventLoopService;
// adjust the connection for your environment!
std::shared_ptr<Connection> conn = ConnectionBuilder().endpoint("http://localhost:8529")
        .authenticationType(AuthenticationType::Basic)
        .user(?)      // enter a user with access
        .password(?)  // enter the password
        .connect(eventLoopService);

// create the request
std::unique_ptr<Request> request = createRequest(RestVerb::Post, ContentType::VPack);

// enter the database name (ensure the user has access)
request->header.database = ?;

// API endpoint to submit AQL queries
request->header.path = "/_api/cursor";

// Create a payload to be submitted to the API endpoint
VPackBuilder builder;
builder.openObject();
// here is your query
builder.add("query", VPackValue("for col in collections() return col.name"));
builder.close();

// add the payload to the request
request->addVPack(builder.slice());

// send the request (blocking)
std::unique_ptr<Response> response = conn->sendRequest(std::move(request));

// check the response code - it should be 201
unsigned int statusCode = response->statusCode();

// slice has the response data
VPackSlice slice = response->slices().front();

std::cout << slice.get("result").toJson() << std::endl;
gamedev8
  • 61
  • 1
  • 4