• Home
• org.jspringbot
• jspringbot-db
• 1.0
• source code

×

Project download

Many resources are needed to download a project. Please understand that we have to compensate our server costs. Thank you in advance.
Project price only 1 $

You can buy this project and download/modify it how often you want.

t.jspringbot-db.1.0.source-code.libdoc.intro Maven / Gradle / Ivy

JSpringBot Database Library for Robot Framework. Contains keyword for accessing the database.


= Configuration =

Configure the following to use jspringbot-db.

1. Add this artifact in maven dependency

|  
|    
|      org.jspringbot
|      jspringbot-db
|    
|  

You must also add the java connector for the database that you want to use.

 *Sample MySql Configuration*
|    
|      5.1.13
|    
|
|    
|      mysql
|      mysql-connector-java
|      ${mysql.version}
|    

2. Import spring-http in {{jspringbot-global.xml}}

| 

3. A {{jspringbot.properties}} file should exist in resources. See the possible properties below.

| *Key* | *Description* | Required |
| {{db.connection.set}} | Defines the various database connection name that can be used. | N |
| {{db.jdbc.driverClassName}} | Defines the JDBC database driver. | Y |
| {{db.jdbc.url}} | Defines the JDBC database url. | Y |
| {{db.jdbc.username}} | Defines the JDBC database username. | Y |
| {{db.jdbc.password}} | Defines the JDBC database password. | Y |
| {{db.hibernate.dialect}} | Defines the Hibernate dialect. | Y |

*Sample MySql Configuration*
| {{db.jdbc.driverClassName}}=com.mysql.jdbc.Driver
| {{db.jdbc.url}}=${jdbc.url}?createDatabaseIfNotExist=true&useUnicode=true&autoReconnect=true&characterEncoding=utf-8
| {{db.jdbc.username}}=${jdbc.username}
| {{db.jdbc.password}}=${jdbc.password}
| {{db.hibernate.dialect}}=org.hibernate.dialect.MySQL5InnoDBDialect

*Sample Multiple Database Configuration*
| {{db.hibernate.dialect}}=org.hibernate.dialect.MySQL5InnoDBDialect
| {{db.connection.set}}=db1,db2
|
| {{db.jdbc.driverClassName}}=${default.jdbc.driver}
| {{db.jdbc.url}}=${default.jdbc.url}
| {{db.jdbc.username}}=${default.jdbc.username}
| {{db.jdbc.password}}=${default.jdbc.password}
|
| {{db1.db.jdbc.driverClassName}}=${db1.jdbc.driver}
| {{db1.db.jdbc.url}}=${db1.jdbc.url}
| {{db1.db.jdbc.username}}=${db1.jdbc.username}
| {{db1.db.jdbc.password}}=${db1.jdbc.password}
|
| {{db2.db.jdbc.driverClassName}}=${db2.jdbc.driver}
| {{db2.db.jdbc.url}}=${db2.jdbc.url}
| {{db2.db.jdbc.username}}=${db2.jdbc.username}
| {{db2.db.jdbc.password}}=${db2.jdbc.password}

4. Add {{JSpringBotGlobal}} library in the in the test suite settings.

| *** Settings *** |
| Library | JSpringBotGlobal |

5. Create queries under src/test/resources/*db-queries*/*.xml. This is only required if `Create DB Query By Name` keyword is used.

*Sample employee.xml.*
This file contains queries for employee table.
| 
| 
|
| 
|
|     
|         
|     
|
|     
|         
|     
|
|     
|         
|     
|
| 

= Sample Usage =

The examples below the uses `Create DB Query By Name` refers to the src/test/resources/db-queries/employees.xml file specified in configuration step #4.

*Sample Usage of `Create DB Query` (using default database)*
| `DB Begin`                            |
| `Use DB Schema`                       |  |
| `Create DB Query`                     | select id from employee order by rand() limit 1 | # Gets a random employee id from employee table |
| `Execute DB Query`                    |
| ${id}=                                | `Get DB Unique Result` |
| `DB Rollback`                         |

*Sample Usage of `Create DB Query By Name` (using default database)*
| `DB Begin`                            |
| `Use DB Schema`                       |  |
| `Create DB Query By Name`             | count.employee | # will execute query defined in employee.xml given key 'count.employee' |
| `Execute DB Query`                    |
| `DB Projected Count Should Be Equal`  | 100 |
| `DB Rollback`                         |


*Sample for passing parameter values to query (using default database)*
| `DB Begin`                            | |
| `Use DB Schema`                       |  |
| `Create DB Query By Name`             | verify.employee | | # will execute query defined in employee.xml given key 'verify.employee' |
| `Set DB Integer Parameter`            | employeeID  | 1 |
| `Set DB String Parameter`             | employeeFirstName | Shiela |
| `Set DB String Parameter`             | employeeLastName | Buitizon |
| `Execute DB Query`                    |
| `DB Projected Count Should Be Equal`  | 1 | |
| `DB Rollback`                         | | |


*Sample for retrieving query result values (using default database)*
| `DB Begin`                            |
| `Use DB Schema`                       |  |
| `Create DB Query By Name`             | get.employee.department.info | | # will execute query defined in employee.xml given key 'get.employee.department.info' |
| `Set DB Integer Parameter`            | employeeID  | 1 |
| `Set DB String Parameter`             | employeeFirstName | Shiela |
| `Set DB String Parameter`             | employeeLastName | Buitizon |
| `Add DB Result Column`                | deptID | INTEGER | # where INTEGER is a hibernate data type |
| `Add DB Result Column`                | deptCode | STRING | # where STRING is a hibernate data type |
| `Add DB Result Column`                | deptName | STRING | # where STRING is a hibernate data type |
| ${deptID}=                            | `Get DB Record At Column`             | 0 |
| ${deptCode}=                          | `Get DB Record At Column`             | 1 |
| ${deptName}=                          | `Get DB Record At Column`             | 2 |
| `Execute DB Query`                    |
| `DB Rollback`                         |

*Sample for switching to different database connection*
| `DB Begin`                            |
| `Use DB Schema`                       |  |
| `Create DB Query By Name`             |  |
| `Execute DB Query`                    |
| `DB Rollback`                         |
| Switch DB Connection                  |  | This can be found in {{db.connection.set}} configured in jspringbot.properties. |
| `DB Begin`                            |
| `Use DB Schema`                       |  |
| `Create DB Query By Name`             |  |
| `Execute DB Query`                    |
| `DB Rollback`                         |