# groonga - オープンソースのカラムストア機能付き全文検索エンジン

- English

# 7.3.41. `object_list`

## 7.3.41.1. 概要

バージョン 6.0.7 で追加.

`object_list` lists objects in database. Object information is taken from metadata in database. `object_list` doesn't open any objects. So `object_list` is a light command for database that has many tables and/or columns.

Normally, schema is a useful command than `object_list`. Because schema returns more information than `object_list`.

## 7.3.41.2. 構文

このコマンドに引数はありません:

    object_list

## 7.3.41.3. 使い方

以下は出力例を示すためのサンプルスキーマです。

実行例:

    table_create Memos TABLE_HASH_KEY ShortText
    # [[0, 1337566253.89858, 0.000355720520019531], true]
    column_create Memos content COLUMN_SCALAR Text
    # [[0, 1337566253.89858, 0.000355720520019531], true]
    table_create Terms TABLE_PAT_KEY ShortText \
      --default_tokenizer TokenBigram \
      --normalizer NormalizerAuto
    # [[0, 1337566253.89858, 0.000355720520019531], true]
    column_create Terms memos_content_index \
      COLUMN_INDEX|WITH_POSITION \
      Memos content
    # [[0, 1337566253.89858, 0.000355720520019531], true]

Here is an output of `object_list` command against this database:

実行例:

    object_list
    # [
    #   [
    #     0,
    #     1337566253.89858,
    #     0.000355720520019531
    #   ],
    #   {
    #     "TokyoGeoPoint": {
    #       "opened": true,
    #       "flags": {
    #         "names": "KEY_GEO_POINT",
    #         "value": 24
    #       },
    #       "path": null,
    #       "size": 8,
    #       "type": {
    #         "id": 32,
    #         "name": "type"
    #       },
    #       "id": 17,
    #       "name": "TokyoGeoPoint"
    #     },
    #     "Bool": {
    #       "opened": true,
    #       "flags": {
    #         "names": "KEY_UINT",
    #         "value": 0
    #       },
    #       "path": null,
    #       "size": 1,
    #       "type": {
    #         "id": 32,
    #         "name": "type"
    #       },
    #       "id": 3,
    #       "name": "Bool"
    #     },
    #     "WGS84GeoPoint": {
    #       "opened": true,
    #       "flags": {
    #         "names": "KEY_GEO_POINT",
    #         "value": 24
    #       },
    #       "path": null,
    #       "size": 8,
    #       "type": {
    #         "id": 32,
    #         "name": "type"
    #       },
    #       "id": 18,
    #       "name": "WGS84GeoPoint"
    #     },
    #     "Int32": {
    #       "opened": true,
    #       "flags": {
    #         "names": "KEY_INT",
    #         "value": 8
    #       },
    #       "path": null,
    #       "size": 4,
    #       "type": {
    #         "id": 32,
    #         "name": "type"
    #       },
    #       "id": 8,
    #       "name": "Int32"
    #     },
    #     "Int16": {
    #       "opened": true,
    #       "flags": {
    #         "names": "KEY_INT",
    #         "value": 8
    #       },
    #       "path": null,
    #       "size": 2,
    #       "type": {
    #         "id": 32,
    #         "name": "type"
    #       },
    #       "id": 6,
    #       "name": "Int16"
    #     },
    #     "Terms": {
    #       "opened": true,
    #       "token_filters": [],
    #       "range": {
    #         "id": 0,
    #         "name": null
    #       },
    #       "flags": {
    #         "names": "TABLE_PAT_KEY|PERSISTENT",
    #         "value": 49153
    #       },
    #       "path": "/tmp/groonga-databases/commands_object_list.0000102",
    #       "type": {
    #         "id": 49,
    #         "name": "table:pat_key"
    #       },
    #       "id": 258,
    #       "name": "Terms"
    #     },
    #     "LongText": {
    #       "opened": true,
    #       "flags": {
    #         "names": "KEY_VAR_SIZE",
    #         "value": 16384
    #       },
    #       "path": null,
    #       "size": 2147483648,
    #       "type": {
    #         "id": 32,
    #         "name": "type"
    #       },
    #       "id": 16,
    #       "name": "LongText"
    #     },
    #     "ShortText": {
    #       "opened": true,
    #       "flags": {
    #         "names": "KEY_VAR_SIZE",
    #         "value": 16384
    #       },
    #       "path": null,
    #       "size": 4096,
    #       "type": {
    #         "id": 32,
    #         "name": "type"
    #       },
    #       "id": 14,
    #       "name": "ShortText"
    #     },
    #     "Object": {
    #       "opened": true,
    #       "flags": {
    #         "names": "KEY_UINT",
    #         "value": 0
    #       },
    #       "path": null,
    #       "size": 8,
    #       "type": {
    #         "id": 32,
    #         "name": "type"
    #       },
    #       "id": 2,
    #       "name": "Object"
    #     },
    #     "UInt16": {
    #       "opened": true,
    #       "flags": {
    #         "names": "KEY_UINT",
    #         "value": 0
    #       },
    #       "path": null,
    #       "size": 2,
    #       "type": {
    #         "id": 32,
    #         "name": "type"
    #       },
    #       "id": 7,
    #       "name": "UInt16"
    #     },
    #     "UInt32": {
    #       "opened": true,
    #       "flags": {
    #         "names": "KEY_UINT",
    #         "value": 0
    #       },
    #       "path": null,
    #       "size": 4,
    #       "type": {
    #         "id": 32,
    #         "name": "type"
    #       },
    #       "id": 9,
    #       "name": "UInt32"
    #     },
    #     "Terms.memos_content_index": {
    #       "opened": true,
    #       "sources": [
    #         {
    #           "id": 257,
    #           "name": "Memos.content"
    #         }
    #       ],
    #       "range": {
    #         "id": 256,
    #         "name": "Memos"
    #       },
    #       "flags": {
    #         "names": "COLUMN_INDEX|WITH_POSITION|PERSISTENT",
    #         "value": 33282
    #       },
    #       "path": "/tmp/groonga-databases/commands_object_list.0000103",
    #       "type": {
    #         "id": 72,
    #         "name": "column:index"
    #       },
    #       "id": 259,
    #       "name": "Terms.memos_content_index"
    #     },
    #     "UInt8": {
    #       "opened": true,
    #       "flags": {
    #         "names": "KEY_UINT",
    #         "value": 0
    #       },
    #       "path": null,
    #       "size": 1,
    #       "type": {
    #         "id": 32,
    #         "name": "type"
    #       },
    #       "id": 5,
    #       "name": "UInt8"
    #     },
    #     "Int64": {
    #       "opened": true,
    #       "flags": {
    #         "names": "KEY_INT",
    #         "value": 8
    #       },
    #       "path": null,
    #       "size": 8,
    #       "type": {
    #         "id": 32,
    #         "name": "type"
    #       },
    #       "id": 10,
    #       "name": "Int64"
    #     },
    #     "Time": {
    #       "opened": true,
    #       "flags": {
    #         "names": "KEY_INT",
    #         "value": 8
    #       },
    #       "path": null,
    #       "size": 8,
    #       "type": {
    #         "id": 32,
    #         "name": "type"
    #       },
    #       "id": 13,
    #       "name": "Time"
    #     },
    #     "UInt64": {
    #       "opened": true,
    #       "flags": {
    #         "names": "KEY_UINT",
    #         "value": 0
    #       },
    #       "path": null,
    #       "size": 8,
    #       "type": {
    #         "id": 32,
    #         "name": "type"
    #       },
    #       "id": 11,
    #       "name": "UInt64"
    #     },
    #     "Text": {
    #       "opened": true,
    #       "flags": {
    #         "names": "KEY_VAR_SIZE",
    #         "value": 16384
    #       },
    #       "path": null,
    #       "size": 65536,
    #       "type": {
    #         "id": 32,
    #         "name": "type"
    #       },
    #       "id": 15,
    #       "name": "Text"
    #     },
    #     "Float": {
    #       "opened": true,
    #       "flags": {
    #         "names": "KEY_FLOAT",
    #         "value": 16
    #       },
    #       "path": null,
    #       "size": 8,
    #       "type": {
    #         "id": 32,
    #         "name": "type"
    #       },
    #       "id": 12,
    #       "name": "Float"
    #     },
    #     "Int8": {
    #       "opened": true,
    #       "flags": {
    #         "names": "KEY_INT",
    #         "value": 8
    #       },
    #       "path": null,
    #       "size": 1,
    #       "type": {
    #         "id": 32,
    #         "name": "type"
    #       },
    #       "id": 4,
    #       "name": "Int8"
    #     },
    #     "Memos.content": {
    #       "opened": true,
    #       "range": {
    #         "id": 15,
    #         "name": "Text"
    #       },
    #       "flags": {
    #         "names": "COLUMN_SCALAR|PERSISTENT",
    #         "value": 49152
    #       },
    #       "path": "/tmp/groonga-databases/commands_object_list.0000101",
    #       "type": {
    #         "id": 65,
    #         "name": "column:var_size"
    #       },
    #       "id": 257,
    #       "name": "Memos.content"
    #     },
    #     "Memos": {
    #       "opened": true,
    #       "token_filters": [],
    #       "range": {
    #         "id": 0,
    #         "name": null
    #       },
    #       "flags": {
    #         "names": "TABLE_HASH_KEY|PERSISTENT",
    #         "value": 49152
    #       },
    #       "path": "/tmp/groonga-databases/commands_object_list.0000100",
    #       "type": {
    #         "id": 48,
    #         "name": "table:hash_key"
    #       },
    #       "id": 256,
    #       "name": "Memos"
    #     },
    #     "TokenMecab": {
    #       "opened": true,
    #       "flags": {
    #         "names": "CUSTOM_NAME",
    #         "value": 4096
    #       },
    #       "path": "tokenizers/.libs/mecab.so",
    #       "plugin_id": 1,
    #       "type": {
    #         "id": 33,
    #         "name": "proc"
    #       },
    #       "id": 64,
    #       "name": "TokenMecab"
    #     }
    #   }
    # ]

## 7.3.41.4. 引数

このセクションではすべての引数について説明します。

### 7.3.41.4.1. 必須引数

必須の引数はありません。

### 7.3.41.4.2. 省略可能引数

省略可能な引数はありません。

## 7.3.41.5. 戻り値

`object_list` command returns a list of object information in the database:

    [HEADER, OBJECTS]

### 7.3.41.5.1. `HEADER`

`HEADER` については 出力形式 を参照してください。

### 7.3.41.5.2. `OBJECTS`

`OBJECTS` are pairs of object name and object details:

    {
      "OBJECT_1": OBJECT_1,
      "OBJECT_2": OBJECT_2,
      ...,
      "OBJECT_n": OBJECT_n,
    }

Each `OBJECT` consists of common properties and object type specific properties.

### 7.3.41.5.3. `OBJECT` (common properties)

Here are common properties:

    {
      "id":     ID,
      "name":   NAME,
      "opened": OPENED,
      "type":   OBJECT_TYPE,
      "flags":  FLAGS,
      "path":   PATH
    }

名前 | 説明
--- | ---
`id` | The ID of the object.
`name` | The name of the object.
`opened` | Whether the object is opened or not. It's `true` or `false`. If the object is opened, this value is `true`. Otherwise, this value is `false`.
`type` | The type of the object. See OBJECT_TYPE for details.
`flags` | The flags of the object. See FLAGS for details.
`path` | The path that contains data of the object. It's `null` for objects that doesn't have data. For example, command object doesn't have data.

### 7.3.41.5.4. `OBJECT_TYPE`

`OBJECT_TYPE` represents the type of object. For example, patricia trie table, hash table and index column are object types.

`OBJECT_TYPE` has the following properties:

    {
      "id":   ID,
      "name": NAME
    }

名前 | 説明
--- | ---
`id` | The ID of the type.
`name` | The name of the type. For example, TABLE_HASH_KEY is `"table:hash_key"`, ベクターカラム is `"column:var_size"` and インデックスカラム is `"column:index"`.

### 7.3.41.5.5. `FLAGS`

`FLAGS` represents the flags of object. The most flags are the specified flags in table_create or column_create. Some flags are added internally.

`FLAGS` has the following properties:

    {
      "value": VALUE,
      "names": NAMES
    }

名前 | 説明
--- | ---
`value` | The value of the flags. It's an integer.
`names` | The names of each flag. It's a string. Each name is separated by `|` such as `TABLE_HASH_KEY|PERSISTENT`.

### 7.3.41.5.6. `OBJECT` (`"type"` object type specific properties)

Here are `"type"` object type specific properties in `OBJECT`:

    {
      "size": SIZE
    }

名前 | 説明
--- | ---
`size` | The size of the type. If the type is fixed size type, the size is the size of each value. If the type is variable size type, the size is the maximum size of each value.

### 7.3.41.5.7. `OBJECT` (`"proc"` object type specific properties)

Here is a list of object that is `"proc"` object type:

> - コマンド
> - 関数
> - ノーマライザー
> - トークナイザー
> - トークンフィルター

Here are `"proc"` object type specific properties in `OBJECT`:

    {
      "plugin_id": PLUGIN_ID
    }

名前 | 説明
--- | ---
`plugin_id` | The plugin ID of the `"proc"` object. If the `"proc"` object is defined by plugin, the value is `1` or more larger integer. Plugin ID is `0` for builtin `"proc"` object.

### 7.3.41.5.8. `OBJECT` (`"table:\*"` object types specific properties)

Here are `"table:\*"` object types specific properties in `OBJECT`:

    {
      "range":         RANGE,
      "token_filters": TOKEN_FILTERS
    }

名前 | 説明
--- | ---
`range` | The type of the table's value. See RANGE for details.
`token_filters` | The token filters of the table.See TOKEN_FILTERS for details.

### 7.3.41.5.9. `RANGE`

`RANGE` represents the type of the range.

`RANGE` has the following properties:

    {
      "id":   ID,
      "name": NAME
    }

名前 | 説明
--- | ---
`id` | The ID of the type of the range. It's an integer. If the object doesn't have range, ID is `0`.
`name` | The name of the type of the range. It's a string or `null`. If the object doesn't have range, name is `null`.

### 7.3.41.5.10. `TOKEN_FILTERS`

`TOKEN_FILTERS` represents the token filters of the table.

`TOKEN_FILTERS` is an array of `TOKEN_FILTER`:

    [
      TOKEN_FILTER_1,
      TOKEN_FILTER_2,
      ...,
      TOKEN_FILTER_n
    ]

`TOKEN_FILTER` has the following properties:

    {
      "id":   ID,
      "NAME": NAME
    }

名前 | 説明
--- | ---
`id` | The ID of the token filter. It's an integer.
`name` | The name of the token filter. It's a string.

### 7.3.41.5.11. `OBJECT` (`"column:\*"` object types specific properties)

Here are `"column:\*"` object types specific properties in `OBJECT`:

    {
      "range": RANGE
    }

名前 | 説明
--- | ---
`range` | The type of the column's value. See RANGE for details.

### 7.3.41.5.12. `OBJECT` (`"column:index"` object type specific properties)

Here are `"column:index"` object type specific properties in `OBJECT`:

    {
      "sources": SOURCES
    }

名前 | 説明
--- | ---
`sources` | The sources of the index column. See SOURCES for details.

### 7.3.41.5.13. `SOURCES`

`SOURCES` represents the sources of the index column.

`SOURCES` is an array of `SOURCE`:

    [
      SOURCE_1,
      SOURCE_2,
      ...,
      SOURCE_n
    ]

`SOURCE` has the following properties:

    {
      "id":   ID,
      "NAME": NAME
    }

名前 | 説明
--- | ---
`id` | The ID of the source table or column. It's an integer.
`name` | The name of the source table or column. It's a string.

## 7.3.41.6. 参考

> - schema