Dictionary ▪️ Dictionary is the inbuilt data type in python which organizes data in a collection of key-value pairs, where each key is unique and maps to a specific value. ▪️ Each element in the dictionary is a key–value pair and one individual key value… Read More
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
|
1 2 3 4 5 6 7 8 9 10 11 12 |
//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 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 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 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 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 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 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. 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:
|
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
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
