Task 1 [40%]
Create a parser that extracts useful data from Internet Resource. Parser must
collect data struct it and write it as a your_parsed_data.json file.
Hint: you can use selenium + beautifulsoup, urlopen libraries or scrapy
framework for python.
Note: Please don't parse data from the government (.gov) and Banks (et. Kaspi
Shop) websites. This is commiting a crime.
Task 2 [10%]
Realize connection from python to Database. To do this, you need to connect
python to the database you created DB (preferred DBMS is postgresql, but there
are no restrictions). You can verify connection to DB by using
cursor.execute("SELECT VERSION()");
Task 3 [50%]
Related to the previous task, it is necessary to implement several functions for
interacting with the connected database.
- Displaying a list of tables in the connected database; [5%]
- Displaying schema of selected table; [5%]
- Displays the contents of the selected table; [5%]
- Functions insert, change, delete row in selected table; [25%]
- Function loading of content from selected .json file to selected table;
[10%]
