Server Version (select banner from v$version) CLI Example: .. code-block:: bash salt '*' oracle.version salt '*' oracle.version my_db
(*dbs)
| 169 | |
| 170 | @depends("cx_Oracle", fallback_function=_cx_oracle_req) |
| 171 | def version(*dbs): |
| 172 | """ |
| 173 | Server Version (select banner from v$version) |
| 174 | |
| 175 | CLI Example: |
| 176 | |
| 177 | .. code-block:: bash |
| 178 | |
| 179 | salt '*' oracle.version |
| 180 | salt '*' oracle.version my_db |
| 181 | """ |
| 182 | pillar_dbs = __salt__["pillar.get"]("oracle:dbs") |
| 183 | |
| 184 | def get_version(x): |
| 185 | return [ |
| 186 | r[0] for r in run_query(x, "select banner from v$version order by banner") |
| 187 | ] |
| 188 | |
| 189 | result = {} |
| 190 | if dbs: |
| 191 | log.debug("get db versions for: %s", dbs) |
| 192 | for db in dbs: |
| 193 | if db in pillar_dbs: |
| 194 | result[db] = get_version(db) |
| 195 | else: |
| 196 | log.debug("get all (%s) dbs versions", len(dbs)) |
| 197 | for db in dbs: |
| 198 | result[db] = get_version(db) |
| 199 | return result |
| 200 | |
| 201 | |
| 202 | @depends("cx_Oracle", fallback_function=_cx_oracle_req) |
nothing calls this directly
no test coverage detected