reg expression 3

Get middle value of a string using python3 with regex

Working with regular expression in python3

Below is the sample how to replace the string using the regular expression

last line missed in the screen shot

new_address = new_address.append(subst(pattern, replace_str,sub))

return new_address

High order functionsin python

Below is the sample script for high order functions.

Python programming to connect ,create,insert,select and delete record using sqlite db

Python programming to write Fizzbuzz program

Question is like below

Answer for the above program

Python Sample program for returning the yes or no from the list to search a given number

Python Sample test to find odd number and return list

Create 10 virtual users every second on an average for 1 minutes, perform post request to create user details and print the new ID created for each user name using Debug option

We need to below script for the above scenario.

After savings that into test.yml you can run using the following command

Artillery search and update

Above script will help to update the user name and job then search the new created I'd.

Artillery inline variable using yml

Below script show how to use inline variables in artillery using yml. 

Updates name and job using I'd with starting with 10 to 20 users in 2 mins.

User creation test using artillery

Below script create user duration 2 mins and starting from 10 to 20 virtuals users

artillery timeout sample

save the file into test.yml and run the script

Artillery run test.yml -o output

Loop and logging

Create a test.yml

the above will be logged the created user.

Search in yml

Below program show the sample script to search using the yml

Save the above XML using test.yml and run the script

artillery run test.yml -o output

The output will be saved in Jason format

Looping using the yaml or yml

Above script is used for looping 100 times for using user id 3 for 20 virtual users for one minute. Save the above code with test.yml

For running the above script

artillery run test.yml -o output

Create put request in artillery using the yaml.

Create a test.yml file and run the above code

The above code will run using

 artillary run test.yml -o output

transactions

set transaction isolation level repeatable read

begin tran

select * from Relationship where link_id=64099

commit tran

set transaction isolation level repeatable read

begin tran

update Relationship set start_date='2012-12-06' from Relationship where link_id=64099

commit tran

set transaction isolation level read committed

begin tran

select * from Relationship where link_id=64099

commit tran

set transaction isolation level read committed

begin tran

update Relationship set start_date='2012-12-06' from Relationship where link_id=64099

commit tran

NOLOCK VS ReadPast

select * from Relationship(nolock) where link_id=64099

select * from Relationship(readpast) where link_id=64099

Use schema-binding in functions for improve query performance

Execution context in SQL Server

When executing the modules we can specify the EXECUTE AS  clause for executing the module with the execution context.

There are different types of executing context 

EXECUTE AS CALLER|OWNER|USER