Robotframework-Database-Library

Robotframework-Database-Library copied to clipboard

The assertion keywords like "Check if (not) exists" or "row count" would currently immediately fail if the intended check fails - which is basically as expected. However, in real life...

amochin

Self managed connections

5

One of the major problems with using libraries like DatabaseLibrary is managing the connection. If we implement #149, it could cause additional problems. Typically QA need to implement following logic:...

bhirsz

There are currently 5 "Row Count" keywords - one just returning the row count and four with assertion (equal, great/less than). This can be replaced with a single "Row Count"...

amochin

I am wondering why do we need a rollback() method after commit() method in execute_sql_string function?

1

In def execute_sql_string(self, sqlString, sansTran=False) # cur = None try: cur = self._dbconnection.cursor() logger.info('Executing : Execute SQL String | %s ' % sqlString) self.__execute_sql(cur, sqlString) if not sansTran: self._dbconnection.commit() finally:...

peerasut

We need a workflow that would publish a new package on PyPi each time there is a new release on GitHub is created. Something like this (beware it might be...

amochin

[Question] How to log query result to robotframework report?

2

Hi Is it possible to enable query log in Robotframework report with the table header? Using `Query` keyword only log the result without header Thanks

4nif

Fixing #184, I slightly improved splitting the SQL script files into statements - now some more statements blocks of a PL/SQL script for Oracle are processed correctly. However, I found...

amochin

Write query result to CSV

2

I would like to export my SQL Query result into a CSV file, would it be possible to implement such keyword? Or is there any elegant way how to do...

lucielavickova

Databricks is popular platform in Big Data. We could create connector for Databricks SQL client: https://github.com/databricks/databricks-sql-python (which also supports DB API 2).

bhirsz

Impala & Hive are popular in Big Data. We could add client for https://github.com/cloudera/impyla which also supports DB API 2.

bhirsz