Add table jira_confluence_space. closes #27

[sayan133]

Integration test logs

Logs

``` N/A ```

Example query results

Results

### Basic info ```sql select id, key, name, status, type, title from jira_confluence_space; ``` ``` +-----------+------------+-----------------------+----------+----------+------------+ | id | key | name | status | type | title | +-----------+------------+-----------------------+----------+----------+------------+ | 26673156 | DEMO | Demo service project | current | global | DEMO | | 11010050 | T | Tutorial | current | global | T | | 6455298 | ~289421716 | Subhajit | current | personal | ~289421716 | | 100335628 | SAYAN1 | sayan | archived | global | SAYAN1 | | 73170946 | ~783492484 | Rajesh Mohanty | current | personal | ~783492484 | | 26705922 | HSM | HR service management | current | global | HSM | +-----------+------------+-----------------------+----------+----------+------------+ ``` ### List all archived spaces ```sql select id, key, name, status, type from jira_confluence_space where status = 'archived'; ``` ``` +-----------+--------+-------+----------+--------+ | id | key | name | status | type | +-----------+--------+-------+----------+--------+ | 100335628 | SAYAN1 | sayan | archived | global | +-----------+--------+-------+----------+--------+ ``` ### List spaces without any description ```sql select id, key, name, description, status, type from jira_confluence_space where description = ''; ``` ``` +----------+------------+-----------------------+-------------+---------+----------+ | id | key | name | description | status | type | +----------+------------+-----------------------+-------------+---------+----------+ | 73170946 | ~783492484 | Rajesh Mohanty | | current | personal | | 6455298 | ~289421716 | Subhajit | | current | personal | | 26705922 | HSM | HR service management | | current | global | | 26673156 | DEMO | Demo service project | | current | global | +----------+------------+-----------------------+-------------+---------+----------+ ``` ### List spaces belong to global type ```sql select id, key, name, status, type from jira_confluence_space where type = 'global'; ``` ``` +-----------+--------+-----------------------+----------+--------+ | id | key | name | status | type | +-----------+--------+-----------------------+----------+--------+ | 100335628 | SAYAN1 | sayan | archived | global | | 11010050 | T | Tutorial | current | global | | 26705922 | HSM | HR service management | current | global | | 26673156 | DEMO | Demo service project | current | global | +-----------+--------+-----------------------+----------+--------+ ``` ### List spaces belong to knowledge-bases category ```sql select id, key, name, status, type, category from jira_confluence_space where category @> '"knowledge-bases"'; ``` ``` +-----------+--------+-----------------------+----------+--------+----------------------------------------+ | id | key | name | status | type | category | +-----------+--------+-----------------------+----------+--------+----------------------------------------+ | 100335628 | SAYAN1 | sayan | archived | global | ["foo","knowledge-bases","my","space"] | | 26673156 | DEMO | Demo service project | current | global | ["knowledge-bases"] | | 26705922 | HSM | HR service management | current | global | ["knowledge-bases"] | +-----------+--------+-----------------------+----------+--------+----------------------------------------+ ```

[LalitLab]

A separate plugin exists for confluence https://github.com/ellisvalentiner/steampipe-plugin-confluence