Download: https://www.microsoft.com/en-us/download/confirmation.aspx?id=56840 Install also the SSMS tool SQL Server Management Studio (SSMS) is an integrated environment for managing any SQL infrastructure, from SQL Server to Azure SQL Database. SSMS provides tools to configure, monitor, and administer instances of SQL Server and databases. Use SSMS to deploy, monitor, and upgrade the data-tier components used by your…
Azure SDK Pyhon
https://azure.github.io/azure-sdk/python_introduction.html Python Guidelines: Introduction: Design principlesIdiomaticConsistentApproachableDiagnosableDependablePython Design Principles:–PEP 20 — The Zen of Python, import this https://www.python.org/dev/peps/pep-0020/ General Guidelines: https://azure.github.io/azure-sdk/general_introduction.html Gitub: https://github.com/azure/azure-sdk-for-python Supported python versions:Code style: https://www.python.org/dev/peps/pep-0008/ Naming conventions: service_client = ServiceClient() service_client.list_things() def do_something(): class ThisIsCorrect(object): pass MAX_SIZE = 4711 database_module.py Method signatures: DO NOT use, static, do not use get set, use properties…
Docker-compose ubuntu
Install it from here, the two first lines https://get.docker.com/ curl -fsSL https://get.docker.com -o get-docker.sh sh get-docker.sh docker –version Compose is a tool for defining and running multi-container Docker applications. With Compose, you use a YAML file to configure your application’s services. Then, with a single command, you create and start all the services from your…
PEP 8
Programming Recommendations https://www.python.org/dev/peps/pep-0008/#programming-recommendations Use is not operator rather than not … is. While both expressions are functionally identical, the former is more readable and preferred. Always use a def statement instead of an assignment statement that binds a lambda expression directly to an identifier. Derive exceptions from Exception rather than BaseException. Direct inheritance from BaseException…
Python debugging in VS Code
Debugging 101 https://github.com/microsoft/vscode-recipes/tree/master/debugging%20python We need VSC, Python extension and a launch.json with the minimum of integrated and external. The launch.json Debug->Open configurations Ok, let’s run a script and test it. F5 is for run, F10 is for step into. We are going to test Python set functions, union and intersection. The breakpoint will be at…
Python, lxml and Xpath
https://lxml.de/xpathxslt.html https://www.w3schools.com/xml/xpath_syntax.asp Read a file with xml, convert it to a string from bytes: pip install lxml from lxml import etree as et Make dictionary (duplicate keys, get atr) result: Code: def xml_to_dict(xmlfile): msg = {} count = 1 with open(xmlfile) as r: xml = r.read() print(type(xml)) parser = et.XMLParser(recover=True, collect_ids=True) root = et.fromstring(bytes(xml, encoding=”utf-8″), parser) x = root.xpath(“//*”)# get all #x…
Python as systemctl service
https://www.loggly.com/blog/new-style-daemons-python/ https://github.com/torfsen/python-systemd-tutorial This is an easy and not enough tested script, you may also enable it to start at boot. Read about systemctl: https://www.freedesktop.org/software/systemd/man/systemctl.html So create a file in /lib/systemd/system touch python_service.service sudo nano python_service.service run the script with (when it is done and has no erros): This is my test script: It prints service…
Testing Zabbix VirtualBox 6.0
https://www.virtualbox.org/wiki/Downloads If you’re looking for the latest VirtualBox 5.2 packages, see VirtualBox 5.2 builds. Please also use version 5.2 if you still need support for 32-bit hosts, as this has been discontinued in 6.0. Version 5.2 will remain supported until July 2020. Note: After upgrading VirtualBox it is recommended to upgrade the guest additions as…
MariaDb linux Python ORM
https://linuxize.com/post/how-to-install-mariadb-on-ubuntu-18-04/ MariaDB is an open source, multi-threaded relational database management system, backward compatible replacement for MySQL. It is maintained and developed by the MariaDB Foundation including some of the original developers of the MySQL. https://linuxize.com/post/how-to-create-a-sudo-user-on-ubuntu/ sudo apt update sudo apt install mariadb-server sudo mysql -V sudo systemctl status mariadb Run the mysql_secure_installation command to improve…
Python for Cyber Security additional resources to learn
The Cyber Defenders Program: https://medium.com/cyberdefenders/search?q=python So the plan is to do the second and third resource first and then move to the next. The first one is a course so…. Second, skip the most of the basic, repeat some from automating the boring stuff: https://automatetheboringstuff.com/ Chapter 5 – Dictionaries and Structuring Data = checkChapter 10…