<commit_before>#!/bin/sh
#Please run with user SBR
#************* DATABASE SETTINS *************
#------------- Please change according to your environment before executing the script -------------
echo input parameters in the order specified:
echo "old_context to new_context from_date(format YYYY-MM-DD) end_date (format YYYY-MM-DD) curator_id"
export user=SBR
export pwd=<PASSWORD>
export SQLPLUS_PATH=~/Dropbox/nih/instantclient_10_2
#export SQLPLUS_PATH=
export HOST=@"(description=(address_list=(address=(protocol=TCP)(host=192.168.127.12)(port=1551)))(connect_data=(SID=DSRDEV)))"

#************* APPLICATION SETTINS *************
#------------- Please change according to the request before executing the script -------------
export FROM_CONTEXT=NHLBI
export TO_CONTEXT=NHLBI
export FROM_DATE=2013-05-22
export TO_DATE=2013-05-23
export CREATOR=yyy

#------------- One generally DO NOT need to change anything beyond this line -------------
export DATE_TIME=$(date)
export CHANGE_NOTE="'Changed from $FROM_CONTEXT to $TO_CONTEXT for $CREATOR by script $DATE_TIME'"
#echo $CHANGE_NOTE
#exit
#$SQLPLUS_PATH/sqlplus $user/$pwd$HOST @change_user_ac_context.sql 'NHLBI' 'NHLBI' '2013-05-22' '2013-05-23' xxx
#$SQLPLUS_PATH/sqlplus $user/$pwd$HOST @check_user_ac_context.sql 'NHLBI' 'NHLBI' '2013-05-22' '2013-05-23' xxx

$SQLPLUS_PATH/sqlplus $user/$pwd$HOST @change_user_ac_context.sql $FROM_CONTEXT $TO_CONTEXT $FROM_DATE $TO_DATE $CREATOR $CHANGE_NOTE
#$SQLPLUS_PATH/sqlplus $user/$pwd$HOST @change_user_ac_context.sql $FROM_CONTEXT $TO_CONTEXT $FROM_DATE $TO_DATE $CREATOR 'Test'
$SQLPLUS_PATH/sqlplus $user/$pwd$HOST @check_user_ac_context.sql $FROM_CONTEXT $TO_CONTEXT $FROM_DATE $TO_DATE $CREATOR<commit_msg>Changed based on input from DBA.<commit_after>#!/bin/sh
#Please run with user SBR
#************* DATABASE SETTINS *************
#------------- Please change according to your environment before executing the script -------------
echo input parameters in the order specified:
echo "old_context to new_context from_date(format YYYY-MM-DD) end_date (format YYYY-MM-DD) curator_id"
export user=SBR
export pwd=<PASSWORD>
#export SQLPLUS_PATH=~/Dropbox/nih/instantclient_10_2/
export SQLPLUS_PATH=
export HOST=@"(description=(address_list=(address=(protocol=TCP)(host=192.168.127.12)(port=1551)))(connect_data=(SID=DSRDEV)))"

#************* APPLICATION SETTINS *************
#------------- Please change according to the request before executing the script -------------
export FROM_CONTEXT=NHLBI
export TO_CONTEXT=NHLBI
export FROM_DATE=2013-05-22
export TO_DATE=2013-05-23
export CREATOR=yyy

#------------- One generally DO NOT need to change anything beyond this line -------------
export DATE_TIME=$(date)
export CHANGE_NOTE="'Changed from $FROM_CONTEXT to $TO_CONTEXT for $CREATOR by script $DATE_TIME'"
#echo $CHANGE_NOTE
#exit
$SQLPLUS_PATHsqlplus $user/$pwd$HOST @check_user_ac_context.sql $FROM_CONTEXT $TO_CONTEXT $FROM_DATE $TO_DATE $CREATOR
{'fraction_non_alphanumeric': 0.18240053944706675, 'fraction_numerical': 0.033715441672285906, 'mean_word_length': 5.155601659751038, 'pattern_counts': {'":': 0, '<': 5, '<?xml version=': 0, '>': 5, 'https://': 0, 'lorem ipsum': 0, 'www.': 0, 'xml': 0}, 'pii_count': 2, 'substrings_counts': 0, 'word_list_counts': {'cursed_substrings.json': 0, 'profanity_word_list.json': 0, 'sexual_word_list.json': 0, 'zh_pornsignals.json': 0}}
{'dir': 'git-commits-cleaned', 'id': '7651811', 'n_tokens_mistral': 1049, 'n_tokens_neox': 974, 'n_words': 242}