FQL v4 will be decommissioned on June 30, 2025. Ensure that you complete your migration from FQL v4 to FQL v10 by that date.

Fauna accounts created after August 21, 2024 must use FQL v10. These accounts will not be able to run FQL v4 queries or access the v4 Dashboard.

For more details, see the v4 EOL announcement and migration guide. Contact support@fauna.com with any questions.

IsDatabase

This reference topic applies to FQL v4. Go to this page for the latest FQL v10 reference topics.

 
IsDatabase( value )
is_database( value )
IsDatabase( value )
IsDatabase( value )
IsDatabase( value )
IsDatabase( value )

Description

The IsDatabase function returns true only if value is a database document, otherwise it returns false.

Parameters

Parameter Type Definition and Requirements

value

Any

Any value, which is to be tested to determine whether it is a database document or not.

Returns

Returns a Boolean, indicating whether value was a database document or not.

Examples

The following query uses Map to iterate over an array of all of the types of values that can be tested by a type-check function, passing each item into a Lambda function that returns an object, which contains the value and the result of calling IsDatabase with that value:

client.query(
  q.Map(
    [
      ['array'],
      true,
      false,
      new Uint8Array([1, 2, 3, 4]),
      [0x1, 0x2, 0x3, 0x4],
      q.Collection('Letters'),
      q.Ref('credentials/self'),
      q.Database('child_db'),
      q.Date('2019-11-12'),
      q.Ref(q.Collection('Letters'), 123),
      10.1,
      q.Function('double'),
      q.Index('letters'),
      10,
      q.Ref(q.Keys(), '1'),
      q.Query(q.Lambda('x', q.Var('x'))),
      null,
      { x: 10 },
      q.Role('employees'),
      q.Match(q.Index('letters')),
      'ten',
      '10',
      q.Time('2020-07-06T12:34:56.789Z'),
      q.Ref(q.Tokens(), '1'),
    ],
    q.Lambda('x', {
      value: q.Var('x'),
      IsDatabase: q.IsDatabase(q.Var('x')),
    })
  )
)
.then((ret) => console.log(ret))
.catch((err) => console.error(
  'Error: [%s] %s: %s',
  err.name,
  err.message,
  err.errors()[0].description,
))
[
  { value: [ 'array' ], IsDatabase: false },
  { value: true, IsDatabase: false },
  { value: false, IsDatabase: false },
  { value: Bytes("AQIDBA=="), IsDatabase: false },
  { value: [ 1, 2, 3, 4 ], IsDatabase: false },
  { value: Collection("Letters"), IsDatabase: false },
  {
    value: Ref(Credentials(), "268432096302728704"),
    IsDatabase: false
  },
  { value: Database("child_db"), IsDatabase: true },
  { value: Date("2019-11-12"), IsDatabase: false },
  { value: Ref(Collection("Letters"), "123"), IsDatabase: false },
  { value: 10.1, IsDatabase: false },
  { value: Function("double"), IsDatabase: false },
  { value: Index("letters"), IsDatabase: false },
  { value: 10, IsDatabase: false },
  { value: Ref(Keys(), "1"), IsDatabase: false },
  { value: Query(Lambda("x", Var("x"))), IsDatabase: false },
  { value: null, IsDatabase: false },
  { value: { x: 10 }, IsDatabase: false },
  { value: Role("employees"), IsDatabase: false },
  { value: Match(Index("letters")), IsDatabase: false },
  { value: 'ten', IsDatabase: false },
  { value: '10', IsDatabase: false },
  { value: Time("2020-06-15T21:14:07.090Z"), IsDatabase: false },
  { value: Ref(Tokens(), "1"), IsDatabase: false }
]
result = client.query(
  q.map_(
    q.lambda_("x", {
      "value": q.var("x"),
      "IsDatabase": q.is_database(q.var("x")),
    }),
    [
      ["array"],
      True,
      False,
      bytearray([1, 2, 3, 4]),
      [0x1, 0x2, 0x3, 0x4],
      q.collection("Letters"),
      q.ref("credentials/self"),
      q.database("child_db"),
      q.date("2019-11-12"),
      q.ref(q.collection("Letters"), 123),
      10.1,
      q.function("double"),
      q.index("letters"),
      10,
      q.ref(q.keys(), "1"),
      q.query(q.lambda_("x", q.var("x"))),
      None,
      {"x": 10},
      q.role("employees"),
      q.match(q.index("letters")),
      "ten",
      "10",
      q.time("2020-07-06T12:34:56.789Z"),
      q.ref(q.tokens(), "1"),
    ],
  )
)
print(result)
[{'value': ['array'], 'IsDatabase': False}, {'value': True, 'IsDatabase': False}, {'value': False, 'IsDatabase': False}, {'value': bytearray(b'\x01\x02\x03\x04'), 'IsDatabase': False}, {'value': [1, 2, 3, 4], 'IsDatabase': False}, {'value': Ref(id=Letters, collection=Ref(id=collections)), 'IsDatabase': False}, {'value': Ref(id=282032258185953792, collection=Ref(id=credentials)), 'IsDatabase': False}, {'value': Ref(id=child_db, collection=Ref(id=databases)), 'IsDatabase': True}, {'value': datetime.date(2019, 11, 12), 'IsDatabase': False}, {'value': Ref(id=123, collection=Ref(id=Letters, collection=Ref(id=collections))), 'IsDatabase': False}, {'value': 10.1, 'IsDatabase': False}, {'value': Ref(id=double, collection=Ref(id=functions)), 'IsDatabase': False}, {'value': Ref(id=letters, collection=Ref(id=indexes)), 'IsDatabase': False}, {'value': 10, 'IsDatabase': False}, {'value': Ref(id=1, collection=Ref(id=keys)), 'IsDatabase': False}, {'value': Query({'api_version': '4', 'lambda': 'x', 'expr': {'var': 'x'}}), 'IsDatabase': False}, {'value': None, 'IsDatabase': False}, {'value': {'x': 10}, 'IsDatabase': False}, {'value': Ref(id=employees, collection=Ref(id=roles)), 'IsDatabase': False}, {'value': SetRef({'match': Ref(id=letters, collection=Ref(id=indexes))}), 'IsDatabase': False}, {'value': 'ten', 'IsDatabase': False}, {'value': '10', 'IsDatabase': False}, {'value': FaunaTime('2020-07-06T12:34:56.789Z'), 'IsDatabase': False}, {'value': Ref(id=1, collection=Ref(id=tokens)), 'IsDatabase': False}]
result, err := client.Query(
	f.Map(
		f.Arr{
			f.Arr{"array"},
			true,
			false,
			f.BytesV{0x01, 0x02, 0x03, 0x04},
			f.Arr{0x1, 0x2, 0x3, 0x4},
			f.Collection("Letters"),
			f.Ref("credentials/self"),
			f.Database("child_db"),
			f.Date("2019-11-12"),
			f.Ref(f.Collection("Letters"), 123),
			10.1,
			f.Function("double"),
			f.Index("letters"),
			10,
			f.Ref(f.Keys(), "1"),
			f.Query(f.Lambda("x", f.Var("x"))),
			nil,
			f.Null(),
			f.Obj{"x": 10},
			f.Role("employees"),
			f.Match(f.Index("letters")),
			"ten",
			"10",
			f.Time("2020-07-06T12:34:56.789Z"),
			f.Ref(f.Tokens(), "1"),
		},
		f.Lambda("x", f.Obj{
			"value": f.Var("x"),
			"IsDatabase": f.IsDatabase(f.Var("x")),
		})))

if err != nil {
	fmt.Fprintln(os.Stderr, err)
} else {
	fmt.Println(result)
}
[map[IsDatabase:false value:[array]] map[IsDatabase:false value:true] map[IsDatabase:false value:false] map[IsDatabase:false value:[1 2 3 4]] map[IsDatabase:false value:[1 2 3 4]] map[IsDatabase:false value:{Letters 0xc000132210 0xc000132210 <nil>}] map[IsDatabase:false value:{280481857410171392 0xc000132330 0xc000132330 <nil>}] map[IsDatabase:true value:{child_db 0xc000132450 0xc000132450 <nil>}] map[IsDatabase:false value:{0 63709113600 <nil>}] map[IsDatabase:false value:{123 0xc000132660 0xc000132660 <nil>}] map[IsDatabase:false value:10.1] map[IsDatabase:false value:{double 0xc0001327b0 0xc0001327b0 <nil>}] map[IsDatabase:false value:{letters 0xc0001328d0 0xc0001328d0 <nil>}] map[IsDatabase:false value:10] map[IsDatabase:false value:{1 0xc000178030 0xc000178030 <nil>}] map[IsDatabase:false value:{[123 34 97 112 105 95 118 101 114 115 105 111 110 34 58 34 51 34 44 34 108 97 109 98 100 97 34 58 34 120 34 44 34 101 120 112 114 34 58 123 34 118 97 114 34 58 34 120 34 125 125]}] map[IsDatabase:false value:{}] map[IsDatabase:false value:{}] map[IsDatabase:false value:map[x:10]] map[IsDatabase:false value:{employees 0xc000178240 0xc000178240 <nil>}] map[IsDatabase:false value:{map[match:{letters 0xc000178390 0xc000178390 <nil>}]}] map[IsDatabase:false value:ten] map[IsDatabase:false value:10] map[IsDatabase:false value:{789000000 63729635696 <nil>}] map[IsDatabase:false value:{1 0xc000178540 0xc000178540 <nil>}]]
try
{
    Value result = await client.Query(
        Map(
            Arr(
                Arr("array"),
                true,
                false,
                BytesV.Of(0x1, 0x2, 0x3, 0x4),
                Arr(0x1, 0x2, 0x3, 0x4),
                Collection("Letters"),
                Ref("credentials/self"),
                Database("child_db"),
                Date("2019-11-12"),
                Ref(Collection("Letters"), 123),
                10.1,
                Function("double"),
                Index("letters"),
                10,
                Ref(Keys(), "1"),
                Query(Lambda("x", Var("x"))),
                null,
                Obj("x", 10),
                Role("employees"),
                Match(Index("letters")),
                "ten",
                "10",
                Time("2020-07-06T12:34:56.789Z"),
                Ref(Tokens(), "1")
            ),
            Lambda(
                "x",
                Obj(
                    "value", Var("x"),
                    "IsDatabase", IsDatabase(Var("x"))
                )
            )
        )
    );

    Console.WriteLine(result);
}
catch (Exception e)
{
    Console.WriteLine($"ERROR: {e.Message}");
}
Arr(ObjectV(value: Arr(StringV(array)),IsDatabase: BooleanV(False)), ObjectV(value: BooleanV(True),IsDatabase: BooleanV(False)), ObjectV(value: BooleanV(False),IsDatabase: BooleanV(False)), ObjectV(value: BytesV(0x01, 0x02, 0x03, 0x04),IsDatabase: BooleanV(False)), ObjectV(value: Arr(LongV(1), LongV(2), LongV(3), LongV(4)),IsDatabase: BooleanV(False)), ObjectV(value: RefV(id = "Letters", collection = RefV(id = "collections")),IsDatabase: BooleanV(False)), ObjectV(value: RefV(id = "295434481250075136", collection = RefV(id = "credentials")),IsDatabase: BooleanV(False)), ObjectV(value: RefV(id = "child_db", collection = RefV(id = "databases")),IsDatabase: BooleanV(True)), ObjectV(value: FaunaDate(2019-11-12 12:00:00 AM),IsDatabase: BooleanV(False)), ObjectV(value: RefV(id = "123", collection = RefV(id = "Letters", collection = RefV(id = "collections"))),IsDatabase: BooleanV(False)), ObjectV(value: DoubleV(10.1),IsDatabase: BooleanV(False)), ObjectV(value: RefV(id = "double", collection = RefV(id = "functions")),IsDatabase: BooleanV(False)), ObjectV(value: RefV(id = "letters", collection = RefV(id = "indexes")),IsDatabase: BooleanV(False)), ObjectV(value: LongV(10),IsDatabase: BooleanV(False)), ObjectV(value: RefV(id = "1", collection = RefV(id = "keys")),IsDatabase: BooleanV(False)), ObjectV(value: QueryV(System.Collections.Generic.Dictionary`2[System.String,FaunaDB.Query.Expr]),IsDatabase: BooleanV(False)), ObjectV(value: NullV,IsDatabase: BooleanV(False)), ObjectV(value: ObjectV(x: LongV(10)),IsDatabase: BooleanV(False)), ObjectV(value: RefV(id = "employees", collection = RefV(id = "roles")),IsDatabase: BooleanV(False)), ObjectV(value: SetRefV(System.Collections.Generic.Dictionary`2[System.String,FaunaDB.Types.Value]),IsDatabase: BooleanV(False)), ObjectV(value: StringV(ten),IsDatabase: BooleanV(False)), ObjectV(value: StringV(10),IsDatabase: BooleanV(False)), ObjectV(value: FaunaTime(2020-07-06T12:34:56.789Z),IsDatabase: BooleanV(False)), ObjectV(value: RefV(id = "1", collection = RefV(id = "tokens")),IsDatabase: BooleanV(False)))
System.out.println(
    client.query(
        Map(
            Arr(
                Arr(Value("array")),
                Value(true),
                Value(false),
                Value(new byte[] {0x1, 0x2, 0x3, 0x4}),
                Arr(Value(0x1), Value(0x2), Value(0x3), Value(0x4)),
                Collection("Letters"),
                Ref("credentials/self"),
                Database("child_db"),
                Date("2019-11-12"),
                Ref(Collection("Letters"), "123"),
                Value(10.1),
                Function("double"),
                Index("letters"),
                Value(10),
                Ref(Keys(), "1"),
                Query(Lambda("x", Var("x"))),
                Null(),
                Obj("x", Value(10)),
                Role("employees"),
                Match(Index("letters")),
                Value("ten"),
                Value("10"),
                Time("2020-07-06T12:34:56.789Z"),
                Ref(Tokens(), "1")
            ),
            Lambda(
                "x",
                Obj("value", Var("x"), "IsDatabase", IsDatabase(Var("x")))
            )
        )
    ).get());
[{value: ["array"], IsDatabase: false}, {value: true, IsDatabase: false}, {value: false, IsDatabase: false}, {value: [0x01 0x02 0x03 0x04], IsDatabase: false}, {value: [1, 2, 3, 4], IsDatabase: false}, {value: ref(id = "Letters", collection = ref(id = "collections")), IsDatabase: false}, {value: ref(id = "286816445084467712", collection = ref(id = "credentials")), IsDatabase: false}, {value: ref(id = "child_db", collection = ref(id = "databases")), IsDatabase: true}, {value: 2019-11-12, IsDatabase: false}, {value: ref(id = "123", collection = ref(id = "Letters", collection = ref(id = "collections"))), IsDatabase: false}, {value: 10.1, IsDatabase: false}, {value: ref(id = "double", collection = ref(id = "functions")), IsDatabase: false}, {value: ref(id = "letters", collection = ref(id = "indexes")), IsDatabase: false}, {value: 10, IsDatabase: false}, {value: ref(id = "1", collection = ref(id = "keys")), IsDatabase: false}, {value: QueryV({api_version=4, lambda=x, expr={var=x}}), IsDatabase: false}, {value: null, IsDatabase: false}, {value: {x: 10}, IsDatabase: false}, {value: ref(id = "employees", collection = ref(id = "roles")), IsDatabase: false}, {value: {@set = {match: ref(id = "letters", collection = ref(id = "indexes"))}}, IsDatabase: false}, {value: "ten", IsDatabase: false}, {value: "10", IsDatabase: false}, {value: 2020-07-06T12:34:56.789Z, IsDatabase: false}, {value: ref(id = "1", collection = ref(id = "tokens")), IsDatabase: false}]
Map(
  [
    ['array'],
    true,
    false,
    new Uint8Array([1, 2, 3, 4]),
    [0x1, 0x2, 0x3, 0x4],
    Collection('Letters'),
    Ref('credentials/self'),
    Database('child_db'),
    Date('2019-11-12'),
    Ref(Collection('Letters'), 123),
    10.1,
    Function('double'),
    Index('letters'),
    10,
    Ref(Keys(), '1'),
    Query(Lambda('x', Var('x'))),
    null,
    { x: 10 },
    Role('employees'),
    Match(Index('letters')),
    'ten',
    '10',
    Time('2020-07-06T12:34:56.789Z'),
    Ref(Tokens(), '1'),
  ],
  Lambda('x', {
    value: Var('x'),
    IsDatabase: IsDatabase(Var('x')),
  })
)
[
  { value: [ 'array' ], IsDatabase: false },
  { value: true, IsDatabase: false },
  { value: false, IsDatabase: false },
  { value: { '0': 1, '1': 2, '2': 3, '3': 4 }, IsDatabase: false },
  { value: [ 1, 2, 3, 4 ], IsDatabase: false },
  { value: Collection("Letters"), IsDatabase: false },
  {
    value: Ref(Credentials(), "302043979982045696"),
    IsDatabase: false
  },
  { value: Database("child_db"), IsDatabase: true },
  { value: Date("2019-11-12"), IsDatabase: false },
  { value: Ref(Collection("Letters"), "123"), IsDatabase: false },
  { value: 10.1, IsDatabase: false },
  { value: Function("double"), IsDatabase: false },
  { value: Index("letters"), IsDatabase: false },
  { value: 10, IsDatabase: false },
  { value: Ref(Keys(), "1"), IsDatabase: false },
  { value: Query(Lambda("x", Var("x"))), IsDatabase: false },
  { value: null, IsDatabase: false },
  { value: { x: 10 }, IsDatabase: false },
  { value: Role("employees"), IsDatabase: false },
  { value: Match(Index("letters")), IsDatabase: false },
  { value: 'ten', IsDatabase: false },
  { value: '10', IsDatabase: false },
  { value: Time("2020-07-06T12:34:56.789Z"), IsDatabase: false },
  { value: Ref(Tokens(), "1"), IsDatabase: false }
]
Query metrics:

  •    bytesIn:   604

  •   bytesOut: 1,631

  • computeOps:     2

  •    readOps:     0

  •   writeOps:     0

  •  readBytes:   373

  • writeBytes:     0

  •  queryTime:  21ms

  •    retries:     0

This query operates on a pre-existing schema, which is not provided here.

Also, the query is executed via a client connection, that uses a secret acquired by calling the Login function (not shown here), so that Ref("credentials/self") returns a valid value.

Is this article helpful? 

Tell Fauna how the article can be improved:
 Visit Fauna's forums or email docs@fauna.com

Thank you for your feedback!