build(gomod): bump github.com/schollz/progressbar/v3 (#38) #23
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
name: Test Oracle DB | |
on: | |
push: | |
paths: | |
- '**.go' | |
- '**.mod' | |
branches: | |
- main | |
pull_request: | |
paths: | |
- '**.go' | |
- '**.mod' | |
branches: | |
- main | |
jobs: | |
test: | |
runs-on: ubuntu-latest | |
services: | |
oracle: | |
image: container-registry.oracle.com/database/free:latest | |
env: | |
ORACLE_PWD: Test123 | |
options: --name oracle | |
ports: | |
- 1521:1521 | |
steps: | |
- name: Checkout code | |
uses: actions/checkout@v4 | |
- name: Set up Go | |
uses: actions/setup-go@v5 | |
with: | |
go-version: 1.21 | |
- name: Connect to Oracle DB and set up | |
run: | | |
docker exec oracle bash -c " | |
sqlplus sys/Test123@localhost:1521/FREE as sysdba <<EOF | |
alter session set \"_ORACLE_SCRIPT\"=true; | |
CREATE USER test IDENTIFIED BY Test123; | |
GRANT CONNECT, RESOURCE TO test; | |
ALTER USER test QUOTA UNLIMITED ON USERS; | |
CREATE TABLE test.test_table (id NUMBER, name VARCHAR2(50)); | |
INSERT INTO test.test_table VALUES (1, 'John Doe'); | |
INSERT INTO test.test_table VALUES (2, 'Jane Doe'); | |
GRANT SELECT ON test.test_table TO test; | |
exit; | |
EOF | |
" | |
- name: Test the connection | |
run: go run main.go -server "oracle://test:Test123@localhost:1521/FREE" "select * from test_table" |