arangodb-arrayindex-test.js

console.log(db._version());

db._create('test');
db.test.save({ _key: "1", value: "foo" });
db.test.save({ _key: "2", value: [ "foo", "bar" ] });

function test(r) {
	const query = r[0];
	const expect = r[1];
	const actual = db._query(query).toArray().sort().join(',');
	const result = actual == expect ? 'PASSED' : 'FAILED';
	console.log(query);
	console.log(result, '--', 'expect:', expect, 'actual:', actual);
}

// double array with query and expected result
const runs = [
	[ 'FOR t IN test RETURN t._key', '1,2' ],
	[ 'FOR t in test FILTER t.value IN [ "foo" ] RETURN t._key', '1,2' ],
	[ 'FOR t in test FILTER "foo" IN t.value RETURN t._key', '1,2' ],
	[ 'FOR t in test FILTER t.value[*] IN [ "foo" ] RETURN t._key', '1,2' ],
	[ 'FOR t in test FILTER "foo" IN t.value[*] RETURN t._key', '1,2' ],
]

console.log('Testing without indices;');
runs.forEach(test);

console.log('Testing with index;', 'value');
db.test.ensureHashIndex('value');
runs.forEach(test);

console.log('Testing with index;', 'value', 'value[*]');
db.test.ensureHashIndex('value[*]');
runs.forEach(test);

db._drop('test');