IT Journey

Nose Test using Python

2021-03-19T23:35:00.006-07:00

Nose test is one of the unit testing tool in python to run the unit tests.

Below code show who to run the test for circle with various test case.

# Import the Circle class from the circle module using the expression from proj.circle import Circle
# Import assert_raises from nose.tools using the expression from nose.tools import assert_raises, eq_.
# Use eq_ method for assert, and to check. Don't use assert statement.
from proj.circle import Circle
from nose.tools import assert_raises, eq_

# Define a nose test class 'TestingCircleCreation'
class TestingCircleCreation:
# Define a nose test method 'test_creating_circle_with_numeric_radius', which creates a circle with radius 2.5, and check if its radius value is 2.5 using eq_ method.
def test_creating_circle_with_numeric_radius(self):
c1 = Circle(2.5)
r = c1.radius
eq_(r,2.5)

# Define a nose test method 'test_creating_circle_with_negative_radius', which checks if the ValueError exception is raised with the error message "radius must be between 0 and 1000 inclusive" using eq_ method, while creating a circle of radius -2.5.
# Hint: Use assert_raises and with.
def test_creating_circle_with_negative_radius(self):
#eq_()
with assert_raises(ValueError) as e:
c = Circle(-2.5)
eq_(str(e.exception), "radius must be between 0 and 1000 inclusive")

# Define a nose test method 'test_creating_circle_with_greaterthan_radius', which checks if the ValueError exception is raised with the error message "radius must be between 0 and 1000 inclusive" using eq_ method, while creating circle of radius 1000.1 .
# Hint: Use assert_raises and with
def test_creating_circle_with_greaterthan_radius(self):
#eq_()
with assert_raises(ValueError) as e:
c = Circle(1000.1)
eq_(str(e.exception), "radius must be between 0 and 1000 inclusive")

# Define a nose test method 'test_creating_circle_with_nonnumeric_radius', which checks if the TypeError exception is raised with the error message "radius must be a number" using eq_ method, while creating circle of radius 'hello' .
# Hint: Use assert_raises and with.
def test_creating_circle_with_nonnumeric_radius(self):
with assert_raises(TypeError) as e:
c=Circle("hello")
eq_(str(e.exception), "radius must be a number")

#Define a nose test class 'TestCircleArea'
class TestCircleArea:
# Define a nose test method 'test_circlearea_with_random_numeric_radius', which creates a circle 'c1' with radius 2.5, and check if its computed area is 19.63 using eq_ method.
def test_circlearea_with_random_numeric_radius(self):
c1=Circle(2.5)
eq_(c1.area(), 19.63)

# Define a nose test method 'test_circlearea_with_min_radius', which creates a circle 'c2' with radius 0, and check if its computed area is 0 using eq_ method.
def test_circlearea_with_min_radius(self):
c2=Circle(0)
eq_(int(c2.area()), 0)

# Define a nose test method 'test_circlearea_with_max_radius', which creates a circle 'c3' with radius 1000, and check if its computed area is 3141592.65 using eq_ method.
def test_circlearea_with_max_radius(self):
c3=Circle(1000)
eq_(c3.area(), 3141592.65)

# Define a nose test class 'TestCircleCircumference'
class TestCircleCircumference:
# Define a nose test method 'test_circlecircum_with_random_numeric_radius', which creates a circle 'c1' with radius 2.5, and check if its computed circumference is 15.71 using eq_ method.
def test_circlecircum_with_random_numeric_radius(self):
c1=Circle(2.5)
eq_(c1.circumference(), 15.71)

# Define a nose test method 'test_circlecircum_with_min_radius', which creates a circle 'c2' with radius 0, and check if its computed circumference is 0 using eq_ method.
def test_circlecircum_with_min_radius(self):
c2=Circle(0)
eq_(int(c2.circumference()), 0)

# Define a nose test method 'test_circlecircum_with_max_radius', which creates a circle 'c3' with radius 1000, and check if its computed circumference is 6283.19 using eq_ method.
def test_circlecircum_with_max_radius(self):
c3=Circle(1000)
eq_(c3.circumference(), 6283.19)

Sql server General T-SQL Interview questions

2021-03-16T00:12:00.000-07:00

How to Delete duplicate Records:

here am showing the examples how to delete duplicate records in sqlserver.

First create the table with sample data

create table #test (id int identity,name varchar(100))

insert #test

select 'mals'

union all

select 'mals'

first method.using cte with row_number

;with cte as

(

select ID,name,ROW_NUMBER() over(PARTITION BY NAME ORDER BY ID) as row from #test

)

delete from CTE

where row>1

select * from #test

drop table #test

second method.using group by clause

create table #test (id int identity,name varchar(100))

insert #test

select 'mals'

union all

select 'mals'
go

delete from #test

where id in (select MAX(ID) from #test

group by name

having COUNT(*)>1)

select * from #test

drop table #test

Suppose there is no unique key in table. using the below sample query you can delete the duplicate data.

create table test (name varchar(10))

insert Test

select 'malli'

union all

select 'malli'

union all

select 'ram'

union all

select 'ram'

;with cte as

(

select row_number() over (partition by name order by name) as row,name from test

)

delete from cte where row>1

select * from Test

drop table Test

How to get top n records from a give table

using ranking function.

;with cte

(

select id,dense_rank() over ( order by id desc) as row

from systables

)

select id from cte where row between 6 and 10 ---top 6-10 records

go

using top

declare @date datetime;

set @date=getdate()

select top 5 id

from sysobjects

where id in (select top 10 id

from sysobjects order by id desc

)

order by id asc ---top 6-10 records

Suppose i have 3 tables with same data.First table have clustered index ,second table have non clustered
index and third table have no index. suppose i issue a command

select * from tablename

which will execute faster.

declare @time datetime2;

set @time=GETDATE()

select * from NOIXRELATIONSHIP

select DATEDIFF(ms,@time,getdate())

set @time=GETDATE()

select * from CLIXRELATIONSHIP

select DATEDIFF(ms,@time,getdate())

set @time=GETDATE()

select * from NONCLIXRELATIONSHIP

select DATEDIFF(ms,@time,getdate())

Create test script in python3 using unittest

2021-01-05T04:06:00.001-08:00

Below sample shows how to create unit test script using unittest in python for testing a Circle,area and circumference

Create test script using doctest test in python3

2021-01-04T16:59:00.001-08:00

Sample script for creating a doc test for Circle, radius,area and circumference of a Circle.

This one check the polindrome of a given number using doctest

This one check the Circle method

Couroutines in python3 programming

2021-01-03T04:07:00.001-08:00

Below is the sample how to write the couroutines in python.

Python programming to find the given string is Polindrome

2021-01-03T04:04:00.001-08:00

Below is the basic code to write Polindrome program in python. I have used online python compiler to write the program.

Context Managers in python3

2021-01-02T23:47:00.001-08:00

Context manager sample in python

Abstract class sample in python3

2021-01-02T23:44:00.001-08:00

Class and Static method in python3

2021-01-02T03:38:00.001-08:00

Descriptors in python3

2021-01-01T14:28:00.001-08:00

Decorators functions in python3

2021-01-01T14:24:00.000-08:00

reg expression 3

2020-12-30T05:25:00.001-08:00

Get middle value of a string using python3 with regex

2020-12-30T04:42:00.001-08:00

Working with regular expression in python3

2020-12-29T13:21:00.001-08:00

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

2020-12-29T01:17:00.001-08:00

Below is the sample script for high order functions.

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

2020-12-29T01:12:00.001-08:00

Python programming to write Fizzbuzz program

2020-12-25T04:30:00.001-08:00

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

2020-12-25T02:54:00.001-08:00

Python Sample test to find odd number and return list

2020-12-25T02:52:00.002-08:00

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

2020-12-24T14:51:00.001-08:00

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

2020-12-20T04:53:00.001-08:00

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

Artillery inline variable using yml

2020-12-20T04:02:00.001-08:00

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

2020-12-20T03:55:00.001-08:00

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

artillery timeout sample

2020-12-20T01:12:00.001-08:00

save the file into test.yml and run the script

Artillery run test.yml -o output

Loop and logging

2020-12-19T21:46:00.001-08:00

Create a test.yml

the above will be logged the created user.