SQL Server Data Manipulation
Version used here SQL Server Management Studio 15.0.18206.04 The following illustrates the BikeStores database diagram: 5 Load Sample Database BikeStores Sample Database – create objects.sql – this file is for creating database objects including schemas and tables.BikeStores Sample Database – load data.sql – this file is for inserting data into the tablesBikeStores Sample Database –…
MS SQL Server 2016 Express
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…