bockor

"""

A complete, dependency-free Python script (using only the standard library) 
that compares two SQLite databases. 

It compares:
-----------
    Tables: Tables added or removed.
    Schemas: Columns added, removed, or if their data types changed.
    Data: Rows inserted, deleted, or updated.

bockor

Database Browser for SQLITE : https://sqlitebrowser.org/

Using REGEXP in the Data Filter Bar
------------------------------------
 
/^(?!mc\.)/    not beginning with mc.

/(?<!.int)$/   not ending with .int

/(10.5.135.49|10.5.135.50)/ OR function

bockor

"""
Ref: https://zetcode.com/python/sqlite3-connection-row-factory/
See also: https://zetcode.com/python/sqlite3-row-keys/
"""


import sqlite3
from collections import namedtuple

bockor

Relevant unicode characters reference:  https://www.unicode.org/charts/PDF/U2000.pdf

how to type an unicode character in Linux:
    CTRL + Shift + U2014 Enter
how to type an unico character in Windoze:  (not sure here !)
    NumLock ON  Alt Down 0151 

file_with_illegal_characters.csv
--------------------------------

bockor

FIND NETWORK HIERARCHIES in SQLITE 
using
Simple Recursion with Common Table Expressions ( CTE )
======================================================

Ref: https://www.youtube.com/watch?v=7GpyHedM4pw
Ref: https://douglaskline.blogspot.com/2016/06/simple-recursion-in-sql-with-common.html

Recursive CTE Principle:

bockor

# https://stackoverflow.com/questions/74400075/how-to-select-based-on-a-substring-in-jq
# https://jqlang.org/manual/#conditionals-and-comparisons
# https://play.jqlang.org/s/ovqQqRTfNE_Zxw0
# https://www.youtube.com/watch?v=YrVR09v78Dc

curl -s 'https://api.github.com/repos/jqlang/jq/commits?per_page=80' | jq -r '.[].commit.author | select (.email | contains(".us"))'

curl -s 'https://api.github.com/repos/jqlang/jq/commits?per_page=80' | jq '.[].commit.author | select (.email | contains("github") | not) '

curl -s 'https://api.github.com/repos/jqlang/jq/commits?per_page=80' | jq --arg n "github" '.[].commit.author | select (.email | contains($n)) '

bockor

"""

PyTricia : Matching IPs to Subnets in Python in an Efficient Way
https://jmanteau.fr/posts/matching-ips-to-subnets-in-python-in-an-efficient-way/
https://github.com/jsommers/pytricia

https://www.youtube.com/watch?v=i5zP7iiw91Y ; 
    What is Python Pickle? A Beginner’s Guide to Data Serialization

bockor

# Inspiration ... where did I start ?:
# https://www.blopig.com/blog/2021/05/hosting-multiple-flask-apps-using-apache-mod_wsgi/
# https://www.rosehosting.com/blog/how-to-install-flask-on-ubuntu-22-04-with-apache-and-wsgi/?srsltid=AfmBOoqkm3GW5tXYBQywDTb_Y6SuLD0URVm9OC3uBqO4QhtSHpndMbz-
# https://stackoverflow.com/questions/29882579/run-multiple-independent-flask-apps-in-ubuntu
# https://serverfault.com/questions/357108/what-permissions-should-my-website-files-folders-have-on-a-linux-webserver

sudo apt install apache2 -y
sudo systemctl status apache2
sudo apt install libapache2-mod-wsgi-py3
apachectl -M | grep wsgi

bockor

SQLITE DATE - TIME - DATETIME YOUTUBE TUT
    https://www.youtube.com/watch?v=nJRvz5Rhrx0

# Insert DEFAULT timestamp "now" as INTEGER
# and unixepoch prior SQLITE 3.38 (2022-02-22).
####################################################

create table t1 (c1 TEXT, c2 INTEGER DEFAULT (strftime('%s', 'now')));
insert into t1(c1) values ('drink'),('eat');

bockor

"""
The walrus operator “:=” is an operator used to evaluate, assign, and return value from a single statement in Python.
It was introduced in Python 3.8
"""

sss = {'color': 'red', 'size': 'l', 'clips': {'number': 6, 'material': 'metal'}}

if value := sss.get("clips", {}).get("number"):
     print(f"Number of clips: {value}")
"""