List of Keywords - System Keywords 2

To learn how to use System keywords in Opkey, you can read Using System Keywords - New UI and Using System Keywords 1 - Opkey Classic.
 

Now, let's go through the second list of various system keywords to understand their utility.

1. FetchRecordSetFromDatabase 

The primary purpose of the FetchRecordSetFromDatabase keyword is to fetch a record set from a database. This keyword is used to fetch a #:#:#:# separated recordset database. 

Let's understand the keyword by an example:-

Suppose there is a "users" table with columns such as "id," "name," "email," and "department," and you want to fetch all records where the department is 'IT'. 

Now to fetch the record set from the database you will need to execute the following query in your test case:-

FetchRecordSetFromDatabase Query : SELECT * FROM users WHERE department = 'IT' ;

Here ,the FetchRecordSetFromDatabase is the Opkey keyword that is used to retrieve a record set.

The Query parameter specifies the SQL query to be executed. You will enter this query in the input data field.

As a result, it will fetch all the columns (*) from the "users" table where the department is 'IT'.

The result of the query will be a set of records matching the criteria.

In the FetchRecordSetFromDatabase Keyword, there was no requirement to add a Test Object argument. Hence, we have mentioned it is not required.

2. FetchAllRecordsFromDatabase 

The FetchAllRecordsFromDatabase query is used in Opkey to retrieve all records from a specified database table. This keyword is used to fetch a  @:@:@:@ separated recordset database. 

Let's understand the keyword with an example.

 Assume that you have an "employees" table with various columns like "employee_id," "first_name," "last_name," "email," and so on.

Now you want to fetch all the records of the employee table from the database.

You will use the following query:-

FetchAllRecordsFromDatabase Query: Select*from employees;

Here the FetchAllRecordsFromDatabase keyword is used to fetch all records from the "employees" table.

The Query parameter specifies a simple SQL query to select all columns (*) from the "employees" table. You will enter this query in the input data field.

The result of this query will be, all the records from the "employees" table.

In the FetchAllRecordsFromDatabase Keyword, there was no requirement to add a Test Object argument. Hence, we have mentioned it is not required.

Test Object

3. FetchValueFromDatabase 

This keyword fetches a single value from the database. 

Let's assume you have a table named users in your database with columns username and email.

If you want to fetch the email address of a user based on their username, you can do so by using the FetchValueFromDataBase keyword.

In this scenario, the FetchValueFromDatabase keyword can be used to execute a SELECT query - ."SELECT email FROM users WHERE username = ?;"   taking username as a parameter to fetch the corresponding email address, and returns the result.

Input Data

4. FetchValueFromProcedure 

This keyword fetches a single value from a procedure. 

Let's assume you have a stored procedure named get_email_by_username that takes a username as a parameter and returns the corresponding email address.

The result will be the corresponding email address.

In this Keyword, adding a Test Object argument was not required. Hence, we have mentioned it is not required.

Test Object

Input Data

5. GetColumnCountOfRecordSet 

This keyword fetches the number of columns of a record set. 

Assume that you have an "employee" table and you want to know the column count of that table. You can use the keyword with input query - get_column_count_of_record_set(employee) to retrieve information about the number of columns in the employee table. 

e): 

In this Keyword, adding a Test Object argument was not required. Hence, we have mentioned it is not required.

Test Object

Input Data

6. GetRowCountOfRecordSet 

This keyword fetches the number of rows of a record set. 

Assume that you have an "employee" table and you want to know the row count of that table. You can use the keyword with input query - get_row_count_of_record_set(employee) to retrieve information about the number of rows in the employee table. 

7. UpdateDatabase 

This keyword executes the update database query which is run to modify the existing records in a table. It allows you to change the values of one or more columns in one or more rows based on a specified condition. 

Let's say you have a table named users with columns user_id, username, and email. You want to update the email address for a user with a specific username: 

You can use the query - UPDATE users SET email = 'joe@gmail.com' WHERE username = 'joe'; 

This query will update the email column in the users table, setting it to 'joe@gmail.com' only for the row where the username is 'joe'. 

8. Date Time Keywords

(I). ConvertTimeToTimeZone 

This keyword converts the time from source to destination time zone concerning the time of our local system.  

It is employed when there's a need to convert time from a source time zone to a destination time zone, especially when the working system is configured in a different time zone. 

For Example: If you want to change the time from “India Standard Time”, to “US Eastern Standard Time”, you can use this keyword. 

In this Keyword, adding a Test Object argument was not required. Hence, we have mentioned it is not required.

Test Object

Error Conditions

(II). GetTimeAtTimeZone 

This keyword offers the time of a specified time zone in relation to the local system time. It proves useful when obtaining the time of different time zones while your working system is configured in a different time zone. 

For Example: your working system is configured in “India Standard Time”, but you want to see time in “US Eastern Standard Time”. 

Input Data

Output Data

Error Conditions

(III). AddDateTime 

This keyword adds a specific number of days, months, years, hours, minutes, and seconds to each date value. 

Suppose you want to add a specific number of days, months, years, hours, minutes, and seconds to your date (12/20/2023)

Input Data

Output Data

Error Conditions

(IV). ConvertDateTimeFormat 

This keyword converts a Date Time value according to some specified format. 

Output Data

Error Conditions

(V). DateTimeDifference 

This keyword returns the date difference in total days. 

You can use this keyword if you want to calculate the day difference between two dates.

1. Provide Valid String and Invalid Format 

2. Provide FirstDate, SecondDate but don’t Provide Format 

3. Don’t Provide Input Argument 

(VI). GetCurrentDateTime 

This keyword gets the Current Date and Time of the system. It is used in such a condition when the user wants to get the current day's Date and Time. 

Suppose you want to get the current data time, you can use this keyword in the following manner with no use of input data to get the desired result.

Output  Data

(VII). GetDayOfWeek 

This Keyword gets the current weekday number. It uses dates to provide the weekly number. 

Output Data

(VIII). IsDate 

This Keyword verifies the given date format. It is used in such a condition where the user wants to verify provided date is in date format or not. 

The user can use this keyword in the following manner to check whether the date provided is in the date format or not.

Output Data

1. Provide Valid String and Invalid Format 

2. Not Providing Input Argument 

(IX). SubtractDateTime 

This keyword Subtracts Date Time a specific number of days, months, years, hours, minutes, and seconds in a given date value. 

1. Don’t Provide Input Argument 

9. File Handling Keywords 

(I). AppendTextToFile 

This keyword appends specified text to the given File. It is used in such a condition where the user wants to add Specific Text to a file.

 You can use this keyword in the following manner to add specific text to a file. 

1. Don’t Provide FilePath or TextToAppend 

2. Provide File path which does not exist. 

(II). CheckFileExists 

This keyword checks whether the file exists or not. 

 You can use this keyword in the following manner to check whether a file exists or not.