Skip to content

Moved CONTRIBUTING.md to project root and updated content #467

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.

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
merged 15 commits into from
Aug 26, 2017

Conversation

jgebal
Copy link
Member

@jgebal jgebal commented Aug 23, 2017

No description provided.

Copy link
Member

@pesse pesse left a comment

Choose a reason for hiding this comment

The reason will be displayed to describe this comment to others. Learn more.

Great, especially the scripts!

CONTRIBUTING.md Outdated
git fetch --all

# remove sub-direcotry containing master branch shallow copy
rm -rf utPLSQL/*
Copy link
Member

Choose a reason for hiding this comment

The reason will be displayed to describe this comment to others. Learn more.

rm -rf utPLSQL

Otherwise it will lead to an error with following clone command

CONTRIBUTING.md Outdated
export UT3_TABLESPACE=users
export UT3_USER="UT3\$USER#"
export UT3_USER_PASSWORD=ut3
export SQLCLI=sql
Copy link
Member

Choose a reason for hiding this comment

The reason will be displayed to describe this comment to others. Learn more.

shouldn't that be

SQLCI=sqlplus

?

CONTRIBUTING.md Outdated
export ORACLE_PWD=oracle

.travis/install.sh
.travis/install_utplsql_release.sh
Copy link
Member

Choose a reason for hiding this comment

The reason will be displayed to describe this comment to others. Learn more.

$ .travis/install_utplsql_release.sh

cd $UTPLSQL_DIR/source
.travis/install_utplsql_release.sh: line 5: cd: /source: No such file or directory

I guess exporting UTPLSQL_DIR is missing

CONTRIBUTING.md Outdated
execute immediate i.drop_orphaned_synonym;
end loop;
end;
/
Copy link
Member

Choose a reason for hiding this comment

The reason will be displayed to describe this comment to others. Learn more.

Doesn't work inside 12c PDBs, raises ORA-65040: operation not allowed from within a pluggable database

Copy link
Member Author

Choose a reason for hiding this comment

The reason will be displayed to describe this comment to others. Learn more.

any alternative or any idea how to get this to work?

Copy link
Member

Choose a reason for hiding this comment

The reason will be displayed to describe this comment to others. Learn more.

Sorry I didn't come with a suggestion in the first place.
Problem is that it tries to drop SYS-Synonyms, which is not allowed for PDBS.
The following should do it:

begin
  for i in (
    select decode(owner,'PUBLIC','drop public synonym "','drop synonym "'||owner||'"."')|| synonym_name ||'"' drop_orphaned_synonym from dba_synonyms a
     where a.table_owner <> 'SYS' and not exists (select null from dba_objects b where a.table_name=b.object_name and a.table_owner=b.owner )
  ) loop
    execute immediate i.drop_orphaned_synonym;
  end loop;
end;

@jgebal jgebal force-pushed the feature/contributing branch from 0b3445d to fc8cd08 Compare August 25, 2017 08:30
CONTRIBUTING.md Outdated
/
Cleanup of utPLSQL installation (call from your base repo directory).
```bash
development/cleanup.sh
Copy link
Member Author

Choose a reason for hiding this comment

The reason will be displayed to describe this comment to others. Learn more.

nice!

pesse and others added 3 commits August 25, 2017 11:21
… - so developers don't change it by accident. Changed directory name to `utPLSQL_latest_release` in travis to match the `template.env.sh` and updated `.gitignore` to prevent `env.sh` and `utPLSQL_latest_release` from getting committed.
@jgebal jgebal force-pushed the feature/contributing branch from 5a85874 to 3fddfbd Compare August 26, 2017 08:35
@jgebal jgebal force-pushed the feature/contributing branch from 88127d8 to 681c1fa Compare August 26, 2017 17:14
@jgebal jgebal added this to the v3.0.3 milestone Aug 26, 2017
@jgebal jgebal merged commit bd0c89f into develop Aug 26, 2017
@jgebal jgebal deleted the feature/contributing branch August 30, 2017 08:14
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Projects
None yet
Development

Successfully merging this pull request may close these issues.

3 participants