Author Archives: cyruslab

[DATABASE]Difference between inner join, right and left outer join

Creating the tables Data from T1 Data from T2 Left outer join In the below example left table is T1 and right table is T2. Left outer join will cause tuples of the left table (T1) to be preserved, the … Continue reading

Posted in Database | Tagged , , | Leave a comment

[python]Email alert when Tufin has a failed automated step

This is the enhanced code for sending customized mail when automation step fails in Tufin. When the Tufin triggers, it sends the ticket_info to the input stream. the code has to read from the input stream and parse the xml.

Posted in General stuffs | Leave a comment

[python]Using cx_Oracle module

This is a try out for using cx_Oracle module maintained by Oracle. The version I am trying is version 12.2 Here’s the same code: The above is a test out code, to test on how to connect to the oracle … Continue reading

Posted in Database, Python | Tagged | Leave a comment

[python]Trying out AWS SDK

I got myself a free basic account to do some hands on try outs. It is not necessary to use the AWS SDK to invoke the API. This try out is to write a simple static script to create a … Continue reading

Posted in Python, Scripting | Tagged , , | Leave a comment

Database – Normalisation

All the examples will use this simple table for explanation. Attribute is column, and tuple is row. In this table the attributes are from A to F. Functional dependency A is determinant, B is dependant. B is functional dependent on … Continue reading

Posted in Database | Tagged , | Leave a comment

[python]Email script

The above code snippet is an email script that is triggered when Tufin fails an automated step. The challenge now is to include a ticket number to the email.

Posted in General stuffs | Leave a comment

Database: count number of rows in a table

This is to count the number of rows in a table. Cyrus is the owner and customer is the table.

Posted in Database | Tagged | Leave a comment