Handling SQL Error and Vulnerability BUG in JENKINS_job by SQLplus script runner plugin How to make Jenkins job as failure for SQL errors (SQL syntax or any SQL Error): Add the additional code in Jenkins SQL file or SQL user defined code. 👉To check the SQL failure.… Read More
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
DATATYPES IN CQL (2.0) CUSTOM DATA TYPE: A Custom datatype is defined by every Java class that extends the server-side Abstract Type class and can be loaded by Cassandra is called a custom type; as a result, it should be included in the CLASSPATH of every… 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
COLLECTION DATATYPES IN CQL Collections are designed to store and denormalize modest amounts of data. They are useful for things like “labels applied to an email,” “the phone numbers of a given user,” and so on. However, collections are inappropriate in situations when items are… 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
DATA TYPES IN CQL The Cassandra Query Language, or CQL, is supported by Apache Cassandra. Cassandra Apache The categories of data known as data types specify the kinds of data that can be kept in a variable or object. Programmers instruct the compiler on how… 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
