Compare Proposal

Nothing to compare.

Create a phyton function that writes in an sqlite table.

  • Posted at : 28 days ago
  • Post Similar Project
60

Budget
8
Proposals
267
Views
Awarded
Status
Skills Required

Posted By -

MT

5.0
Projects Posted : 4
Projects Paid : 2
Services Purchased : 0
Total Spent :
65
Feedbacks : 100 %

Project Details show (+) hide (-)

Hello,

I need your help to write a python function that will read txt with firewall configuration
rules and extract information into an sqlite  table, filling table 
Rules reading a text file with firewall rules will be required to
extract the information.


The sqlite table named Rules has the below columns.


device_id |
name | source_zone | destination_zone | rule_id | protocol | source_IP | destination_IP
|  source_port | destination_port | action



The funtion will take arguments as per below:

def extract_L4_rule(device,config,type,routedomain):

The different fields will be selected from lines containing firewall rules with different syntax rules, sor there will be different possible conditions depending on the syntax to extract the information.
I will provide the table as well as examples of input and desired output in order to test the funtion.
File named: configs and sqlite files.zip contains the config1.txt , config2.txt and configdb.sqlite files compressed.
Kind regards

M