Categories
Archives
-
Recent Posts
Top Posts
Advertisements
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
[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
[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
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
[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.
