Skip to content

Restructuring utPSLQL install guide. #1063

New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

Sign up for GitHub

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Merged
jgebal merged 2 commits into from
Mar 27, 2020
Merged

Restructuring utPSLQL install guide. #1063

Changes from 1 commit
Commits
Show all changes
2 commits
Select commit Hold shift + click to select a range
fa4c6b7
Restructuring utPSLQL install guide.
jgebal Mar 25, 2020
62ef235
Fixed some typos
jgebal Mar 26, 2020
File filter

Filter by extension

Filter by extension
Conversations
Failed to load comments.
Loading
Jump to
Jump to file
Failed to load files.
Loading
Diff view
Diff view
Next Next commit
Restructuring utPSLQL install guide. 
Resolves #1062
  • Loading branch information
@jgebal
jgebal committed Mar 25, 2020
commit fa4c6b7ccaf4b55671ac7d3ea2e7f73b342d39a5
70 changes: 43 additions & 27 deletions docs/userguide/install.md
View file
Open in desktop
Original file line number Diff line number Diff line change
@@ -1,10 +1,35 @@
![version](https://img.shields.io/badge/version-v3.1.11.3367--develop-blue.svg)

# Downloading latest version of utPLSQL
# Supported database versions

utPLSQL is continuously tested against following versions of Oracle databases
* 11g R2
* 12c
* 12c R2
* 18c
* 19c

We do our best to assure fill compatibility with supported versions of Oracle databases [See](http://www.oracle.com/us/support/library/lifetime-support-technology-069183.pdf#page=6)

# Downloading utPLSQL

## Manual download

- Go to GitHub releases page for utPLSQL `https://github.com/utPLSQL/utPLSQL/releases`
- Download and one of files
- utPLSQL.tar.gz
- utPLSQL.zip

The files have identical content but different compression (tar / zip ) so choose whichever you preref depending on your platform (Win/Mac/Unix/Linux)


To download latest version of utPLSQL from github on both Unix/Linux as well as Windows machines use the below snippets.
## Scripted download of latest utPLSQL version

## Unix/Linux
The below snippets can be used to download latest version of utPLSQL from github releases.

Installation instructions are outlined in next sections of this document.

### Unix/Linux

```bash
#!/bin/bash
Expand All @@ -22,7 +47,7 @@ You may download with a one-liner if that is more convenient.
curl -LOk $(curl --silent https://api.github.com/repos/utPLSQL/utPLSQL/releases/latest | awk '/browser_download_url/ { print $2 }' | grep ".zip\"" | sed 's/"//g')
```

## Windows
### Windows

To run the script on windows you will need [PowerShell 3.0](https://blogs.technet.microsoft.com/heyscriptingguy/2013/06/02/weekend-scripter-install-powershell-3-0-on-windows-7/) or above.
You will also need .NET 4.0 Framework or above.
Expand Down Expand Up @@ -51,29 +76,6 @@ foreach ($i in $urlList) {
}
```

# Checking environment and utPLSQL version

To check the framework version execute the following query:
```sql
select substr(ut.version(),1,60) as ut_version from dual;
```

Additionally you may retrieve more information about your environment by executing the following query:
```sql
select
xmlserialize( content xmltype(ut_run_info()) as clob indent size = 2 )
from dual;
```

# Supported database versions

The utPLSQL may be installed on any supported version of Oracle Database [see](http://www.oracle.com/us/support/library/lifetime-support-technology-069183.pdf#page=6)
* 11g R2
* 12c
* 12c R2
* 18c
* 19c

# Headless installation

utPLSQL can be installed with DDL trigger, to enable tracking of DDL changes to your unit test packages.
Expand Down Expand Up @@ -235,6 +237,20 @@ The following tools that support the SQL*Plus commands can be used to run the in
- [SQLcl](http://www.oracle.com/technetwork/developer-tools/sqlcl/overview/index.html)
- [Oracle SQL Developer](http://www.oracle.com/technetwork/developer-tools/sql-developer/overview/index.html)

# Checking environment and utPLSQL version

To check the framework version execute the following query:
```sql
select substr(ut.version(),1,60) as ut_version from dual;
```

Additionally you may retrieve more information about your environment by executing the following query:
```sql
select
xmlserialize( content xmltype(ut_run_info()) as clob indent size = 2 )
from dual;
```

# Additional requirements

In order to use the Code Coverage functionality of utPLSQL, users executing the tests must have the CREATE privilege on the PLSQL code that the coverage is gathered on.
Expand Down