HotRecruiter.Com

Sign up or Sign in | Share
 
ClearMyBench
Welcome, Guest
Please Login or Register.    Lost Password?
ClearMyBench Technology Web Technologies Ruby
Re:Ruby concepts part 2 (1 viewing) (1) Guest
Go to bottom Post Reply Favoured: 0
TOPIC: Re:Ruby concepts part 2
#4648
ShriNi (User)
Software Techie (PEGA) currently on a Career Break
Platinum Boarder
Posts: 4000
graph
User Offline Click here to see the profile of this user
Gender: Female Location: Secundrabad India Birthdate: 1983-09-29
Re:Ruby concepts part 2 3 Years, 10 Months ago Karma: 0  
Update operation can be done using the following steps

1.Prearing SQL query based on required conditions. This will be done using prepare method.

2.Executing SQL query to select all the results from the database. This will be done using execute method.

3.Releasing Stattement handle. This will be done using finish method.

4.finally we can perform the commit operation otherwise we can rollback complete transaction.
 
Report to moderator   Logged Logged  
  The administrator has disabled public write access.
#4649
ShriNi (User)
Software Techie (PEGA) currently on a Career Break
Platinum Boarder
Posts: 4000
graph
User Offline Click here to see the profile of this user
Gender: Female Location: Secundrabad India Birthdate: 1983-09-29
Re:Ruby concepts part 2 3 Years, 10 Months ago Karma: 0  
DELETE Operation

DELETE operation is required when we want to delete some records from your database
 
Report to moderator   Logged Logged  
  The administrator has disabled public write access.
#4650
ShriNi (User)
Software Techie (PEGA) currently on a Career Break
Platinum Boarder
Posts: 4000
graph
User Offline Click here to see the profile of this user
Gender: Female Location: Secundrabad India Birthdate: 1983-09-29
Re:Ruby concepts part 2 3 Years, 10 Months ago Karma: 0  
The Delete operation can be performed using the following steps

1.Prearing SQL query based on required conditions. This will be done using prepare method.

2. Executing SQL query to delete required records from the database. This will be done using execute method.

3.Releasing Stattement handle. This will be done using finish method.

4. Finally perform the commit operation .
 
Report to moderator   Logged Logged  
  The administrator has disabled public write access.
#4651
ShriNi (User)
Software Techie (PEGA) currently on a Career Break
Platinum Boarder
Posts: 4000
graph
User Offline Click here to see the profile of this user
Gender: Female Location: Secundrabad India Birthdate: 1983-09-29
Re:Ruby concepts part 2 3 Years, 10 Months ago Karma: 0  
Transactions are a mechanism that ensures data consistency. Transactions should have the following four properties:

1. Atomicity

2.Consistency

3.Isolation

4.Durability
 
Report to moderator   Logged Logged  
  The administrator has disabled public write access.
#4652
ShriNi (User)
Software Techie (PEGA) currently on a Career Break
Platinum Boarder
Posts: 4000
graph
User Offline Click here to see the profile of this user
Gender: Female Location: Secundrabad India Birthdate: 1983-09-29
Re:Ruby concepts part 2 3 Years, 10 Months ago Karma: 0  
Atomicity: Either a transaction completes or nothing happens at all.

Consistency: A transaction must start in a consistent state and leave the system is a consistent state.
 
Report to moderator   Logged Logged  
  The administrator has disabled public write access.
#4653
ShriNi (User)
Software Techie (PEGA) currently on a Career Break
Platinum Boarder
Posts: 4000
graph
User Offline Click here to see the profile of this user
Gender: Female Location: Secundrabad India Birthdate: 1983-09-29
Re:Ruby concepts part 2 3 Years, 10 Months ago Karma: 0  
Isolation: Intermediate results of a transaction are not visible outside the current transaction.

Durability: Once a transaction was committed, the effects are persistent, even after a system failure
 
Report to moderator   Logged Logged  
  The administrator has disabled public write access.
Go to top Post Reply
get the latest posts directly to your desktop
 
logo footer   Copyright 2009 - 2013 HotRecruiter.Com - All Rights Reserved