Installing Python and dependencies in Linux

Downloading python and dependencies.

Installing Python

Step0:open the Terminal on ubuntu 10.04. and enter the following steps. get dependencies.
Step1:
sudo apt-get install build-essential
Step2:
sudo apt-get install libreadline-gplv2-dev libncursesw5-dev libssl-dev libsqlite3-dev tk-dev libgdbm-dev libc6-dev libbz2-dev
Step3:get software fom website of python
(or you can also download directly from browser to download folder)

cd Downloads/
wget http://python.org/ftp/python/2.7.3/Python-2.7.3.tgz

Step4:Extract and go to the dirctory
tar -xvf Python-2.7.3.tgz && cd Python-2.7.3/

Step5:Now install using the command:(logged in as administrator or root)
./configure
make
sudo make altinstall


Step6: Installing : IDLE Editor for using Python on ubuntu 2.10
cd /home/administrator/Downloads/python2.7.3/Python-2.7.3/Tools
sudo apt-get install idle

Step7: starting editor IDLE in python

idle

Step8: open a new file in idel and name it as Rahultest.py

and write a small program and get it printed. as shown in images below:

JDBC driver & connections for different RDBMS

JDBC driver name and database URL take different forms for different databases, 

EMS not retrieving records with decimal on windows 7

If you have installed EMS SQL manager lite 2011 on windows 7 and when you execute a select command in it and it gives this following BCD error then this article will help you to fix this.

Go to the windows control panel and in there open the Regional settings and further click Additional settings.

in there select Decimal symbol= . instead of ,

restart the EMS and the Query will work fine.

Ranorex on vmware player

Ranorex on VMware player 4.0.5-893925 windows 2008 server R2

1-     Installed dot net framework 3.5 SP1

2-     From Server manager installed it again.

JIRA in Agile-scrum test environment

Jira installed on windows 32 bits

Handling of Issues  / Bugs within the team. 

create issue, Resolve issue, Reopen issue, close issue, etc..,

Database Procedure (For Bank application) to create Records for test environment.

CREATE PROCEDURE [dbo].[SP_InsertTestData]
AS
BEGIN
    SET NOCOUNT ON
    SET XACT_ABORT ON
INSERT INTO [User] ([UserName], [Password], [Email], [Role], [DisplayName], [Verified]) VALUES ('RAHUL','RAHUL','dummy@domain.ext','SystemIntegrator','RAHUL', 1) 
INSERT INTO   dbo.[CARDCONTROL](  [Name], [EmailForAlerts], SystemIntegratorId) VALUES (  'My First CARDCONTROL', 'RAHUL_test@serverTT2.com', (Select Id from [dbo].[User] where UserName = 'RAHUL' ));
INSERT INTO   dbo.GOLDCARDCONTROL(  Name, Serial,  [Type],  CARDControlnumber,  ChipId,  MaximumCARDControlLimit, BranchID) VALUES (  'TestUser 1', '1178189980',  'STANDARDCHARTEDGBP',  '321082.50.107',  9600,  2.0, (Select Id from dbo.Logins where NAME='Securelogins'));


INSERT INTO   dbo.GOLDCARDCONTROL(  Name, Serial,  [Type],  CARDControlnumber,  ChipId,  MaximumCARDControlLimit, BranchID) VALUES (  'TestUser 2', '1178189981',  'STANDARDCHARTEDGBP',  '321082.50.107',  9600,  2.0, (Select Id from dbo.Logins where NAME='Securelogins2'));
INSERT INTO   dbo.GOLDCARDCONTROL(  Name, Serial,  [Type],  CARDControlnumber,  ChipId,  MaximumCARDControlLimit, BranchID) VALUES (  'TestUser 3', '1178189982',  'STANDARDCHARTEDGBP',  '321082.50.107',  9600,  2.0, (Select Id from dbo.Logins where NAME='Securelogins3'));
INSERT INTO   dbo.GOLDCARDCONTROL(  Name, Serial,  [Type],  CARDControlnumber,  ChipId,  MaximumCARDControlLimit, BranchID) VALUES (  'TestUser 4', '1178189983',  'STANDARDCHARTEDGBP',  '321082.50.107',  9600,  2.0, (Select Id from dbo.Logins where NAME='Securelogins4'));
INSERT INTO   dbo.GOLDCARDCONTROL(  Name, Serial,  [Type],  CARDControlnumber,  ChipId,  MaximumCARDControlLimit, BranchID) VALUES (  'TestUser 5', '1178189984',  'STANDARDCHARTEDGBP',  '321082.50.107',  9600,  2.0, (Select Id from dbo.Logins where NAME='Securelogins5'));
INSERT INTO   dbo.GOLDCARDCONTROL(  Name, Serial,  [Type],  CARDControlnumber,  ChipId,  MaximumCARDControlLimit, BranchID) VALUES (  'TestUser 6', '1234560',  'STANDARDCHARTEDGBP',  '321082.50.107',  9600,  2.0, (Select Id from dbo.Logins where NAME='Securelogins6'));


INSERT INTO   dbo.SAVINGSACCOUNT([Sequence],  GOLDCARDCONTROLId) VALUES (1,  (Select Id from dbo.GOLDCARDCONTROL where Serial='1178189980'));
INSERT INTO   dbo.SAVINGSACCOUNT([Sequence],  GOLDCARDCONTROLId) VALUES (2,  (Select Id from dbo.GOLDCARDCONTROL where Serial='1178189980'));
INSERT INTO   dbo.SAVINGSACCOUNT([Sequence],  GOLDCARDCONTROLId) VALUES (3,  (Select Id from dbo.GOLDCARDCONTROL where Serial='1178189980'));
INSERT INTO   dbo.SAVINGSACCOUNT([Sequence],  GOLDCARDCONTROLId) VALUES (4,  (Select Id from dbo.GOLDCARDCONTROL where Serial='1178189980'));
INSERT INTO   dbo.SAVINGSACCOUNT([Sequence],  GOLDCARDCONTROLId) VALUES (1,  (Select Id from dbo.GOLDCARDCONTROL where Serial='1178189981'));
INSERT INTO   dbo.SAVINGSACCOUNT([Sequence],  GOLDCARDCONTROLId) VALUES (2,  (Select Id from dbo.GOLDCARDCONTROL where Serial='1178189981'));
INSERT INTO   dbo.SAVINGSACCOUNT([Sequence],  GOLDCARDCONTROLId) VALUES (3,  (Select Id from dbo.GOLDCARDCONTROL where Serial='1178189981'));
INSERT INTO   dbo.SAVINGSACCOUNT([Sequence],  GOLDCARDCONTROLId) VALUES (4,  (Select Id from dbo.GOLDCARDCONTROL where Serial='1178189981'));
INSERT INTO   dbo.SAVINGSACCOUNT([Sequence],  GOLDCARDCONTROLId) VALUES (1,  (Select Id from dbo.GOLDCARDCONTROL where Serial='1178189982'));
INSERT INTO   dbo.SAVINGSACCOUNT([Sequence],  GOLDCARDCONTROLId) VALUES (2,  (Select Id from dbo.GOLDCARDCONTROL where Serial='1178189982'));
INSERT INTO   dbo.SAVINGSACCOUNT([Sequence],  GOLDCARDCONTROLId) VALUES (3,  (Select Id from dbo.GOLDCARDCONTROL where Serial='1178189982'));
INSERT INTO   dbo.SAVINGSACCOUNT([Sequence],  GOLDCARDCONTROLId) VALUES (4,  (Select Id from dbo.GOLDCARDCONTROL where Serial='1178189982'));
INSERT INTO   dbo.SAVINGSACCOUNT([Sequence],  GOLDCARDCONTROLId) VALUES (1,  (Select Id from dbo.GOLDCARDCONTROL where Serial='1178189983'));
INSERT INTO   dbo.SAVINGSACCOUNT([Sequence],  GOLDCARDCONTROLId) VALUES (2,  (Select Id from dbo.GOLDCARDCONTROL where Serial='1178189983'));
INSERT INTO   dbo.SAVINGSACCOUNT([Sequence],  GOLDCARDCONTROLId) VALUES (3,  (Select Id from dbo.GOLDCARDCONTROL where Serial='1178189983'));
INSERT INTO   dbo.SAVINGSACCOUNT([Sequence],  GOLDCARDCONTROLId) VALUES (4,  (Select Id from dbo.GOLDCARDCONTROL where Serial='1178189983'));
INSERT INTO   dbo.SAVINGSACCOUNT([Sequence],  GOLDCARDCONTROLId) VALUES (1,  (Select Id from dbo.GOLDCARDCONTROL where Serial='1178189984'));
INSERT INTO   dbo.SAVINGSACCOUNT([Sequence],  GOLDCARDCONTROLId) VALUES (2,  (Select Id from dbo.GOLDCARDCONTROL where Serial='1178189984'));
INSERT INTO   dbo.SAVINGSACCOUNT([Sequence],  GOLDCARDCONTROLId) VALUES (3,  (Select Id from dbo.GOLDCARDCONTROL where Serial='1178189984'));
INSERT INTO   dbo.SAVINGSACCOUNT([Sequence],  GOLDCARDCONTROLId) VALUES (4,  (Select Id from dbo.GOLDCARDCONTROL where Serial='1178189984'));
INSERT INTO   dbo.SAVINGSACCOUNT([Sequence],  GOLDCARDCONTROLId) VALUES (1,  (Select Id from dbo.GOLDCARDCONTROL where Serial='1234560'));
INSERT INTO   dbo.SAVINGSACCOUNT([Sequence],  GOLDCARDCONTROLId) VALUES (2,  (Select Id from dbo.GOLDCARDCONTROL where Serial='1234560'));
INSERT INTO   dbo.SAVINGSACCOUNT([Sequence],  GOLDCARDCONTROLId) VALUES (3,  (Select Id from dbo.GOLDCARDCONTROL where Serial='1234560'));
INSERT INTO   dbo.SAVINGSACCOUNT([Sequence],  GOLDCARDCONTROLId) VALUES (4,  (Select Id from dbo.GOLDCARDCONTROL where Serial='1234560'));
END

Data entry when IDENTITY_INSERT is set to OFF.

If you get an error message while inserting records in a table.
Error message looks like : Cannot insert explicit value for identity column in table ‘dbo.InverterData’ when IDENTITY_INSERT is set to OFF.
to fix this ; SET IDENTITY_INSERT dbo.InverterData ON;  before insert command and after insert enter this: SET IDENTITY_INSERT dbo.InverterData OFF;

SET IDENTITY_INSERT dbo.InverterData ON;

INSERT INTO   dbo.InverterData
(  Id, CurrentL1,  CurrentL2,  CurrentL3,  GridFrequency,  Power,  SampleTime,  Temperature,  TotalEnergy,  TotalEnergyToday,  TotalHours,  InverterId )
VALUES (   5, 33, 43, 53,8,68,21/11/2011 13:00:00,210,2 );

SET IDENTITY_INSERT dbo.InverterData OFF;
GO