Product Documentation

FairCom Replication JSON RPC API

Previous Topic

Next Topic

ctMemphisGetDatabaseFolders

int ctMemphisGetDatabaseFolders( pRCESJson request, ppRCESJson result )

Description:

List all the physical folders and optionally the tables present in each of the folders for a given database.

Constraints:

  • "id" must be an existing Database ID;

Parameters:

  • request [IN] - Get database folders request in JSON format. For example:

{

"id": 0, // required - database identification

"listTables": true // optional - default is false - in case of true

// adds the "tableList" element for each folder element.

}

  • result [OUT] - Result in JSON format. For example:

{

"databaseFolderList": [

{

"id": 2432,

"volume": 1,

"path": "FairCom/data",

"name": "ctreeSQL.dbs",

"createTime": "2014-04-07T13:18:09",

"updateTime": "2014-04-07T14:16:39",

"tableList": [

{

"id": 5236,

"volume": 1,

"path": "FairCom/data/ctreeSQL.dbs",

"name": "test.dat",

"table": "test",

"size": 11736,

"createTime": "2014-04-07T13:18:09",

"updateTime": "2014-04-07T14:16:39",

"isDir": 0,

"isPartitioned": false,

"type": 6,

"database": 1,

"isReplicable": false,

"isCtree": true,

"description": "File is pending on the schema checked -

probably due to permission issue"

},

{

"id": 3452,

"volume": 1,

"path": "FairCom/data/ctreeSQL.dbs",

"name": "test2.dat",

"table": "test2",

"size": 125533,

"createTime": "2014-04-07T13:18:09",

"updateTime": "2014-04-07T14:16:39",

"isDir": 0,

"isPartitioned": false,

"type": 5,

"database": 1,

"isReplicable": false,

"isCtree": true,

"description": "File is c-tree but doesn't have an

index that qualifies for replication"

}

]

},

{

"id": 7456,

"volume": 1,

"path": "ctree/app",

"name": "data",

"createTime": "2014-04-07T13:18:09",

"updateTime": "2014-04-07T14:16:39",

"tableList": [

{

"id": 364,

"volume": 1,

"path": "ctree/app/data",

"name": "test.dat",

"table": "test",

"size": 11736,

"createTime": "2014-04-07T13:18:09",

"updateTime": "2014-04-07T14:16:39",

"isDir": 0,

"isPartitioned": false,

"type": 6,

"database": 1,

"isReplicable": false,

"isCtree": true,

"description": "File is pending on the schema checked -

probably due to permission issue"

},

{

"id": 254,

"volume": 1,

"path": "ctree/app/data",

"name": "test2.dat",

"table": "test2",

"size": 125533,

"createTime": "2014-04-07T13:18:09",

"updateTime": "2014-04-07T14:16:39",

"isDir": 0,

"isPartitioned": false,

"type": 5,

"database": 1,

"isReplicable": false,

"isCtree": true,

"description": "File is c-tree but doesn't have an index

that qualifies for replication"

}

]

}

],

"success": true,

"error":

{

"errorCode": 0,

"message": "Success"

}

}

Return:

Error code

TOCIndex