Vinod Siram – Page 2

Run SQL as JENKINS_PIPELINE_job by SQLplus script runner plugin

Run SQL as JENKINS_PIPELINE_job by SQL plus script runner plugin. Running the SQL script – As Scripted pipeline job from Jenkins file in GIT repo Note: the SQL script placed in the same location as Jenkins file

//Pipeline code (scripted pipe) in   Jenkins file in GIT repo //
node ('master') {
   stage('Code_checkout') {
   git url: 'https://github.com/mshan0181/java-sample-code.git'
   }
   stage('SQL_script_runner') {
   echo 'SQLPlusRunner running user define script for shandba@client_access'
   step([$class: 'SQLPlusRunnerBuilder',credentialsId:'shandb-priv-id', instance:'client_access',scriptType:'userDefined', script: '',scriptContent: 'select * from v$version'])
   step([$class: 'SQLPlusRunnerBuilder',credentialsId:'shandb-priv-id', instance:'client_access',scriptType:'userDefined', script: '',scriptContent: 'select name from v$database'])
   step([$class: 'SQLPlusRunnerBuilder',credentialsId:'shandb-priv-id', instance:'client_access',scriptType:'file', script: 'switchover_status.sql',scriptContent: ''])
   }  
}

//Pipeline code (scripted pipe) in Jenkins file in GIT repo //

node ('master') {

stage('Code_checkout') {

git url: 'https://github.com/mshan0181/java-sample-code.git'

}

stage('SQL_script_runner') {

echo 'SQLPlusRunner running user define script for shandba@client_access'

step([$class: 'SQLPlusRunnerBuilder',credentialsId:'shandb-priv-id', instance:'client_access',scriptType:'userDefined', script: '',scriptContent: 'select * from v$version'])

step([$class: 'SQLPlusRunnerBuilder',credentialsId:'shandb-priv-id', instance:'client_access',scriptType:'userDefined', script: '',scriptContent: 'select name from v$database'])

step([$class: 'SQLPlusRunnerBuilder',credentialsId:'shandb-priv-id', instance:'client_access',scriptType:'file', script: 'switchover_status.sql',scriptContent: ''])

}

👉 Create the (above code) scripted pipeline in Jenkins… Read More

LOOPING IN PYTHON

3 months ago by Vinod SiramPython

LOOPING IN PYTHON Loop: A loop is a control flow structure that allows a set of statements that will be executed repeatedly until a certain condition is met. Loops are used to automate repetitive tasks, to iterate over a data structure. Python language support two… Read More

Run SQL as JENKINS_UI_job by SQLplus script runner plugin

3 months ago by Vinod SiramDevOps

Run SQL as JENKINS_UI_job by SQLplus script runner plugin To perform SQL operations connecting to Remote Oracle DB without SSH connection. This article uses the Jenkins master node to run/execute the SQL. ▪️ SQL plus Script Runner plugin is required to run the SQL code… Read More

Tuples – PYTHON

3 months ago by Vinod SiramPython

Tuples Tuple: ➔ A tuple is an inbuilt data type which is an ordered, immutable and lightweight collection of elements in python. ➔ The term immutable means once the tuple is created you can’t modify the size or the elements which are present in the… Read More

Parameterization in Jenkins job

3 months ago by Vinod SiramDevOps

Parameterization in Jenkins job Parameters in Jenkins: Parameters can be used in 2 ways in Jenkins job. ▪️ Define parameter value directly inside a build job (or in shell/batch commands) as fixed value. ▪️ Define using Build Parameters – Setting build parameter and passing values… Read More

Basic Program Fundamentals in Python

3 months ago by Vinod SiramPython

Basic Program Fundamentals in Python How To Take Input from User in Python? By using the “input () “Function to take the input from the user. In python for this we don’t need to import any libraries in python. Syntax: Some point on input ()… Read More

Variables in Python

3 months ago by Vinod SiramPython

Variables in Python Identifiers: An identifier is a name given to the entities in a program such as variables, classes, functions and all the other objects in python. ▪️ Identifiers are case sensitive. ▪️ There is no length restriction for the identifiers, but you have… Read More

Python Script to make connection for Oracle databases.

4 months ago by Vinod SiramPython

Python Script to make connection for Oracle databases. Hello Folks, This article will explain you about installation cx_Oracle module and basic python script to make connection to Oracle databases. Check the Python Version:

[root@ociktexperts3 ~]# python3 --version
Python 3.6.8

1 2	[root@ociktexperts3 ~]# python3 --version Python 3.6.8

Install oracle package cx-Oracle: cx_Oracle is a Python extension module that… Read More

Declarative and Scripted pipeline job in Jenkins -PART 2

4 months ago by Vinod SiramDevOps

Please check the PART -1, before going through the Part -2 Declarative and Scripted pipeline job in Jenkins -PART 1 🔗https://www.ktexperts.com/declarative-and-scripted-pipeline-job-in-jenkins-part-1/ Declarative and Scripted pipeline job in Jenkins -PART 2 Creating a Scripted Pipeline job (code in Jenkins web UI): 👉 Configure the Jenkins… Read More

Declarative and Scripted pipeline job in Jenkins -PART 1

4 months ago by Vinod SiramDevOps

Declarative and Scripted pipeline job in Jenkins -PART 1 What is Pipeline in DevOps? ▪️ A pipeline is a collection of jobs that brings the software from version control into the hands of the end users by using automation tools. ▪️ It is a feature used to… Read More