PythonQuickies: Difference between revisions

From Traxel Wiki
Jump to navigation Jump to search
No edit summary
 
(20 intermediate revisions by the same user not shown)
Line 1: Line 1:
[[Category:Python]]
[[Category:Python]]
= Abstract Base Class =
<syntaxhighlight lang="python" line>
from abc import ABC, abstractmethod
from .event import Event
class ThreadEvent(ABC, Event):
    """
    A class used to represent a post, comment, or reply in a community.
    """
   
    @abstractmethod
    def to_tag(self):
        """
        Returns
        -------
        list
            contains one element which is this event's own tag
        """
        pass
</syntaxhighlight>
= buffering =
= buffering =
Fix CLI buffering in Python with:
Fix CLI buffering in Python with:
Line 8: Line 31:
"-u" means unbuffered, or something
"-u" means unbuffered, or something


= Delayed Type Definitions =
= Caching =
<pre>
== Disable __pycache__ Caching ==
from __future__ import annotations # allows types to be used before definition
 
class Foo:
  def add_child(self, a_foo: Foo)
    self.children.append(a_foo)
</pre>
 
= Random =
<pre>
base64.b32encode(os.urandom(64)).decode('utf-8')
</pre>
= Sorting =
<pre>
<pre>
sorted_stories = sorted(stories, key=lambda x: x['job']['ups'], reverse=True)
$ python -B foo.py
</pre>
</pre>
= Decorators =
<syntaxhighlight lang="python" line>
def my_decorator(func):
    def wrapper(*args, **kwargs):
        print("Something is happening before the function is called.")
        func(*args, **kwargs)
        print("Something is happening after the function is called.")
    return wrapper
@my_decorator
def say_hello():
    print("Hello!")
say_hello()
</syntaxhighlight>
= Virtual Environments =
<syntaxhighlight lang="bash">
# Check Python version
python3 --version
# Check pip version
pip3 --version
# Install virtualenv
pip3 install virtualenv
# Install venv
sudo apt install python3-venv
# Navigate to your project directory
cd ~/my_project/
# Create virtual environment
python3 -m venv myenv
# Activate virtual environment
source myenv/bin/activate
# Now you can install packages
pip install <your-package>
# Deactivate when you're done
deactivate
</syntaxhighlight>


= What Libs Have I? =
<pre>
<pre>
$ pip freeze --local
export PYTHONDONTWRITEBYTECODE=1
blinker==1.6.2
python script.py
click==8.1.7
flask==2.3.3
importlib-metadata==6.8.0
itsdangerous==2.1.2
Jinja2==3.1.2
MarkupSafe==2.1.3
werkzeug==2.3.7
zipp==3.16.2
</pre>
</pre>


= Package Info =
* https://pypi.org/project/package-name/
** eg: https://pypi.org/project/itsdangerous/
= Datetime and Timestamp =
= Datetime and Timestamp =
<syntaxhighlight lang="python" line>
<syntaxhighlight lang="python" line>
Line 125: Line 77:
</syntaxhighlight>
</syntaxhighlight>


= Decorators =
<syntaxhighlight lang="python" line>
def my_decorator(func):
    def wrapper(*args, **kwargs):
        print("Something is happening before the function is called.")
        func(*args, **kwargs)
        print("Something is happening after the function is called.")
    return wrapper
@my_decorator
def say_hello():
    print("Hello!")
say_hello()
</syntaxhighlight>
= Delayed Type Definitions =
<pre>
from __future__ import annotations # allows types to be used before definition
class Foo:
  def add_child(self, a_foo: Foo)
    self.children.append(a_foo)
</pre>
= GUI =
* Python GUI
** Tkinter is the built-in: https://raspberrypi.stackexchange.com/questions/1353/recommended-gui-toolkit-for-python-development-on-the-raspberry-pi
** PyQT is fancy: https://raspberrytips.com/python-gui-libraries-for-raspberry-pi/
== Tkinter ==
* Tkinter Tutorial: https://www.pythontutorial.net/tkinter/
** Frames: https://www.pythontutorial.net/tkinter/tkinter-frame/
* Full Screen: root.attributes("-fullscreen", True)
* Tkinter with Matplotlib: https://www.geeksforgeeks.org/how-to-embed-matplotlib-charts-in-tkinter-gui/
= Jupyter =
<pre>
2048  mkdir kiln-jupyter
2049  cd kiln-jupyter/
2050  python -m venv venv
2051  source venv/bin/activate
2052  pip install jupyter
2053  jupyter-lab
2054  deactivate
</pre>
= MariaDB =
<pre>
pip install mysql-connector-python
</pre>
<syntaxhighlight lang="python" line>
import mysql.connector
from mysql.connector import Error
# Establish the connection to the MariaDB database
def create_connection():
    try:
        connection = mysql.connector.connect(
            host="localhost",  # or your host
            user="your_user",
            password="your_password",
            database="your_database"
        )
        if connection.is_connected():
            print("Connected to MariaDB")
        return connection
    except Error as e:
        print(f"Error connecting to MariaDB: {e}")
        return None
# Function to insert data using a prepared statement
def insert_data(connection, name, age):
    try:
        cursor = connection.cursor(prepared=True)
        sql_insert_query = """INSERT INTO users (name, age) VALUES (%s, %s)"""
        data_tuple = (name, age)
        cursor.execute(sql_insert_query, data_tuple)
        connection.commit()
        print("Data inserted successfully")
    except Error as e:
        print(f"Error: {e}")
    finally:
        cursor.close()
# Function to fetch data
def fetch_data(connection):
    try:
        cursor = connection.cursor()
        cursor.execute("SELECT id, name, age FROM users")
        result = cursor.fetchall()
        for row in result:
            print(f"ID: {row[0]}, Name: {row[1]}, Age: {row[2]}")
    except Error as e:
        print(f"Error fetching data: {e}")
    finally:
        cursor.close()
# Main flow
if __name__ == "__main__":
    conn = create_connection()
    if conn:
        # Insert example data
        insert_data(conn, "John Doe", 30)
       
        # Fetch and display data
        fetch_data(conn)
        # Close the connection
        conn.close()
</syntaxhighlight>
== Batch Insert ==
<syntaxhighlight lang="python" line>
import mysql.connector
from mysql.connector import Error
# Create a connection to MariaDB
def create_connection():
    try:
        connection = mysql.connector.connect(
            host="localhost",
            user="your_user",
            password="your_password",
            database="your_database"
        )
        if connection.is_connected():
            print("Connected to MariaDB")
        return connection
    except Error as e:
        print(f"Error: {e}")
        return None
# Insert multiple rows using a batch insert with prepared statements
def batch_insert(connection, data):
    try:
        cursor = connection.cursor(prepared=True)
        sql_insert_query = """INSERT INTO event_log (event_description, event_time)
                              VALUES (%s, %s)"""
       
        # Perform batch insert
        cursor.executemany(sql_insert_query, data)
       
        # Commit the transaction
        connection.commit()
       
        print(f"{cursor.rowcount} rows inserted successfully.")
    except Error as e:
        print(f"Error: {e}")
    finally:
        cursor.close()
# Main program
if __name__ == "__main__":
    conn = create_connection()
    if conn:
        # Prepare data for batch insert
        event_data = [
            ("Event 1 description", "2024-10-10 10:00:00"),
            ("Event 2 description", "2024-10-11 11:30:00"),
            ("Event 3 description", "2024-10-12 14:00:00")
        ]
       
        # Execute batch insert
        batch_insert(conn, event_data)
       
        # Close the connection
        conn.close()
</syntaxhighlight>
= Matplotlib =
* Matplotlib with TkInter: https://www.geeksforgeeks.org/how-to-embed-matplotlib-charts-in-tkinter-gui/
* Matplotlib Docs: https://matplotlib.org/stable/users/explain/axes/legend_guide.html
= Package Info =
* https://pypi.org/project/package-name/
** eg: https://pypi.org/project/itsdangerous/
= Random =
<pre>
base64.b32encode(os.urandom(64)).decode('utf-8')
</pre>
= Sorting =
<pre>
sorted_stories = sorted(stories, key=lambda x: x['job']['ups'], reverse=True)
</pre>
= Subclass =
= Subclass =
<syntaxhighlight lang="python" line>
<syntaxhighlight lang="python" line>
Line 154: Line 290:
car.display()
car.display()
</syntaxhighlight>
</syntaxhighlight>
= Abstract Base Class =
<syntaxhighlight lang="python" line>
from abc import ABC, abstractmethod


from .event import Event
= Type Safety =
== ==
<pre>
class Car:
    def __init__(self, make: str, year: int) -> None:
        self.make = make
        self.year = year
 
    def drive(self, speed: float) -> None:
        print(f"Driving at {speed} km/h")
 
    def new_model(self, year: int) -> Car:
        return Car(self.make, self.year + 1)
 
# Example usage
car = Car("Toyota", 2022)
car.drive(100.0)  # Valid
 
car.drive("fast")  # Invalid, but no runtime error (type checker will warn)
</pre>
 
= Virtual Environments =
 
<syntaxhighlight lang="bash">
# Check Python version
python3 --version
 
# Check pip version
pip3 --version
 
# Install virtualenv
pip3 install virtualenv
 
# Install venv
sudo apt install python3-venv
 
# Navigate to your project directory
cd ~/my_project/
 
# Create virtual environment
python3 -m venv myenv
 
# Activate virtual environment
source myenv/bin/activate
 
# Now you can install packages
pip install <your-package>


class ThreadEvent(ABC, Event):
# Deactivate when you're done
    """
deactivate
    A class used to represent a post, comment, or reply in a community.
    """
   
    @abstractmethod
    def to_tag(self):
        """
        Returns
        -------
        list
            contains one element which is this event's own tag
        """
        pass


</syntaxhighlight>
</syntaxhighlight>
= What Libs Have I? =
<pre>
$ pip freeze --local
blinker==1.6.2
click==8.1.7
flask==2.3.3
importlib-metadata==6.8.0
itsdangerous==2.1.2
Jinja2==3.1.2
MarkupSafe==2.1.3
werkzeug==2.3.7
zipp==3.16.2
</pre>

Latest revision as of 20:15, 25 October 2024

Abstract Base Class

from abc import ABC, abstractmethod

from .event import Event

class ThreadEvent(ABC, Event):
    """
    A class used to represent a post, comment, or reply in a community.
    """
    
    @abstractmethod
    def to_tag(self):
        """
        Returns
        -------
        list
            contains one element which is this event's own tag
        """
        pass

buffering

Fix CLI buffering in Python with:

$ python -u foo.py | tee mylog.log

"-u" means unbuffered, or something

Caching

Disable __pycache__ Caching

$ python -B foo.py
export PYTHONDONTWRITEBYTECODE=1
python script.py

Datetime and Timestamp

from datetime import datetime, timezone
import pytz

print("When including time, use one of the following:")

ts = 0
good_dt = pytz.utc.localize(datetime.utcfromtimestamp(ts))
print(f'pytz.utc.localize(datetime.utcfromtimestamp(ts)) = {good_dt}')

ts = 0
good_dt = datetime.fromtimestamp(ts, timezone.utc)
print(f'datetime.fromtimestamp(ts, timezone.utc) = {good_dt}')

dt_with_tz = good_dt
good_ts = int(dt_with_tz.timestamp())
print(f'int(dt_with_tz.timestamp()) = {good_ts}')

now_dt = pytz.utc.localize(datetime.utcnow())
now_ts = int(now_dt.timestamp())
renow_dt = datetime.fromtimestamp(now_ts, timezone.utc)

print()
print(f'now_dt = pytz.utc.localize(datetime.utcnow()) = {now_dt}')
print(f'now_ts = int(now_dt.timestamp()) = {now_ts}')
print(f'now_dt = datetime.fromtimestamp(now_ts, timezone.utc) = {renow_dt}')

now_ts = int(pytz.utc.localize(datetime.utcnow()).timestamp())
print(f'now_ts = int(pytz.utc.localize(datetime.utcnow()).timestamp()) = {now_ts}')

import time
print(f'now_ts = int(time.time()) = {int(time.time())}')

Decorators

def my_decorator(func):
    def wrapper(*args, **kwargs):
        print("Something is happening before the function is called.")
        func(*args, **kwargs)
        print("Something is happening after the function is called.")
    return wrapper

@my_decorator
def say_hello():
    print("Hello!")

say_hello()


Delayed Type Definitions

from __future__ import annotations # allows types to be used before definition

class Foo:
  def add_child(self, a_foo: Foo)
    self.children.append(a_foo)

GUI

Tkinter

Jupyter

 2048  mkdir kiln-jupyter
 2049  cd kiln-jupyter/
 2050  python -m venv venv
 2051  source venv/bin/activate
 2052  pip install jupyter
 2053  jupyter-lab
 2054  deactivate

MariaDB

pip install mysql-connector-python
import mysql.connector
from mysql.connector import Error

# Establish the connection to the MariaDB database
def create_connection():
    try:
        connection = mysql.connector.connect(
            host="localhost",  # or your host
            user="your_user",
            password="your_password",
            database="your_database"
        )
        if connection.is_connected():
            print("Connected to MariaDB")
        return connection
    except Error as e:
        print(f"Error connecting to MariaDB: {e}")
        return None

# Function to insert data using a prepared statement
def insert_data(connection, name, age):
    try:
        cursor = connection.cursor(prepared=True)
        sql_insert_query = """INSERT INTO users (name, age) VALUES (%s, %s)"""
        data_tuple = (name, age)
        cursor.execute(sql_insert_query, data_tuple)
        connection.commit()
        print("Data inserted successfully")
    except Error as e:
        print(f"Error: {e}")
    finally:
        cursor.close()

# Function to fetch data
def fetch_data(connection):
    try:
        cursor = connection.cursor()
        cursor.execute("SELECT id, name, age FROM users")
        result = cursor.fetchall()
        for row in result:
            print(f"ID: {row[0]}, Name: {row[1]}, Age: {row[2]}")
    except Error as e:
        print(f"Error fetching data: {e}")
    finally:
        cursor.close()

# Main flow
if __name__ == "__main__":
    conn = create_connection()
    if conn:
        # Insert example data
        insert_data(conn, "John Doe", 30)
        
        # Fetch and display data
        fetch_data(conn)

        # Close the connection
        conn.close()

Batch Insert

import mysql.connector
from mysql.connector import Error

# Create a connection to MariaDB
def create_connection():
    try:
        connection = mysql.connector.connect(
            host="localhost",
            user="your_user",
            password="your_password",
            database="your_database"
        )
        if connection.is_connected():
            print("Connected to MariaDB")
        return connection
    except Error as e:
        print(f"Error: {e}")
        return None

# Insert multiple rows using a batch insert with prepared statements
def batch_insert(connection, data):
    try:
        cursor = connection.cursor(prepared=True)
        sql_insert_query = """INSERT INTO event_log (event_description, event_time) 
                              VALUES (%s, %s)"""
        
        # Perform batch insert
        cursor.executemany(sql_insert_query, data)
        
        # Commit the transaction
        connection.commit()
        
        print(f"{cursor.rowcount} rows inserted successfully.")
    except Error as e:
        print(f"Error: {e}")
    finally:
        cursor.close()

# Main program
if __name__ == "__main__":
    conn = create_connection()
    if conn:
        # Prepare data for batch insert
        event_data = [
            ("Event 1 description", "2024-10-10 10:00:00"),
            ("Event 2 description", "2024-10-11 11:30:00"),
            ("Event 3 description", "2024-10-12 14:00:00")
        ]
        
        # Execute batch insert
        batch_insert(conn, event_data)
        
        # Close the connection
        conn.close()

Matplotlib

Package Info

Random

base64.b32encode(os.urandom(64)).decode('utf-8')

Sorting

sorted_stories = sorted(stories, key=lambda x: x['job']['ups'], reverse=True)

Subclass

# Parent class
class Vehicle:
    def __init__(self, brand, model):
        self.brand = brand
        self.model = model

    def display(self):
        print(f"This is a {self.brand} {self.model}.")

# Child class
class Car(Vehicle):
    def __init__(self, brand, model, doors):
        super().__init__(brand, model)  # Call the __init__ of the parent class
        self.doors = doors

    # Overriding the display method of the parent class
    def display(self):
        super().display()  # Call the display method of the parent class
        print(f"It has {self.doors} doors.")

# Testing the classes
vehicle = Vehicle("Toyota", "Camry")
vehicle.display()

car = Car("Honda", "Civic", 4)
car.display()

Type Safety

class Car:
    def __init__(self, make: str, year: int) -> None:
        self.make = make
        self.year = year

    def drive(self, speed: float) -> None:
        print(f"Driving at {speed} km/h")

    def new_model(self, year: int) -> Car:
        return Car(self.make, self.year + 1)

# Example usage
car = Car("Toyota", 2022)
car.drive(100.0)  # Valid

car.drive("fast")  # Invalid, but no runtime error (type checker will warn)

Virtual Environments

# Check Python version
python3 --version

# Check pip version
pip3 --version

# Install virtualenv
pip3 install virtualenv

# Install venv
sudo apt install python3-venv

# Navigate to your project directory
cd ~/my_project/

# Create virtual environment
python3 -m venv myenv

# Activate virtual environment
source myenv/bin/activate

# Now you can install packages
pip install <your-package>

# Deactivate when you're done
deactivate

What Libs Have I?

$ pip freeze --local
blinker==1.6.2
click==8.1.7
flask==2.3.3
importlib-metadata==6.8.0
itsdangerous==2.1.2
Jinja2==3.1.2
MarkupSafe==2.1.3
werkzeug==2.3.7
zipp==3.16.2