Wiki source code of ListTablesOfXWiki
Last modified by hbpadmin on 2022/08/25 01:29
Show last authors
| author | version | line-number | content |
|---|---|---|---|
| 1 | {{velocity}} | ||
| 2 | #if($hasProgramming) | ||
| 3 | #set($sqlTools = $xwiki.parseGroovyFromPage('SQLTools.SQLToolsGroovy')) | ||
| 4 | #set($system = $sqlTools.getXWikiDatabaseSystem($xwiki, $xcontext)) | ||
| 5 | Your database is: **$system** | ||
| 6 | #if($system == "HSQL Database Engine") | ||
| 7 | {{warning}}$system is not supported for this action{{/warning}} | ||
| 8 | #end | ||
| 9 | #set($connection = $sqlTools.getXWikiConnection($xwiki, $xcontext)) | ||
| 10 | #set($results = $sqlTools.getTables($connection)) | ||
| 11 | = Table of content = | ||
| 12 | {{toc /}} | ||
| 13 | |||
| 14 | = Tables = | ||
| 15 | $results | ||
| 16 | #else | ||
| 17 | {{error}}Sorry, you need the programming rights to use this tool{{/error}} | ||
| 18 | #end | ||
| 19 | {{/velocity}} |