Scripts

                            
                import datetime

                def write_log_001(logger):
                    try:
                        with open("log.log", "a") as f:
                            f.write(f"{datetime.datetime.now()} - {logger}\n")
                    except Exception as e:
                        with open("log.log", "a") as f:
                            f.write(f"{datetime.datetime.now()} - Error #001 - {e}\n")
            
        

                            
                                from email.message import EmailMessage
                                import smtplib

                                def send_email_002():
                                    try:
                                        sender = "sender"
                                        recipient = "recipient"
                                        message = "msg"

                                        email = MIMEMultipart()

                                        email = EmailMessage()
                                        email["From"] = sender
                                        email["To"] = recipient
                                        email["Subject"] = "subject"
                                        email.set_content(message)


                                        smtp = s.SMTP("smtp_address", port=port_number)
                                        smtp.starttls()
                                        smtp.login(sender, "password")
                                        smtp.sendmail(sender, recipient, email.as_string())
                                        smtp.quit()

                                    except Exception as e:
                                        write_log(f" Error #002 - {e}\n")
                                
                            

                            
                                import http.server
                                import socketserver

                                port = 8000

                                with socketserver.TCPServer(('', port), http.server.SimpleHTTPRequestHandler) as http_d:
                                    print(f"Opening server at port: {port}")
                                    http_d.serve_forever()
                            
                            

                            
                                import smtplib as s
import requests
from email.message import EmailMessage
import time
import datetime

current_ip = ""

def write_log(argu):
    with open("log.log", "a") as f:
        f.write(f"{datetime.datetime.now()} - {argu}\n")

def get_ip():
    try:
        response = requests.get('https://cybar.co.il')
        a = response.text[response.text.index("You IP Address is")+len("You IP Address is:"):response.text.index("")]
        print(a)
        time.sleep(2)
        compare_ip(a)

    except Exception as e:
        write_log(f" -- def get_ip() -- {e}\n")



def compare_ip(result_ip):
    try:
        global current_ip
        if current_ip == result_ip:
            return True
        else:
            current_ip = result_ip
            send_email_002(result_ip)
            return False
    except Exception as e:
        write_log(f" -- def compare_ip(result_ip) -- {e}\n")

def send_email_002(my_ip_email):
    try:
        sender = "sender"
        recipient = "recipient"
        message = f"Your IP Address is: {my_ip_email}"

        email = EmailMessage()
        email["From"] = sender
        email["To"] = recipient
        email["Subject"] = "Your IP Address"
        email.set_content(message)


        smtp = s.SMTP("smtp_address", port=port_number)
        smtp.starttls()
        smtp.login(sender, "password")
        smtp.sendmail(sender, recipient, email.as_string())
        smtp.quit()

    except Exception as e:
        write_log(f" Error #002 - {e}\n")
                            
                            

                            
                                import sqlite3
import os

db_file = 'example.db'

if not os.path.exists(db_file):
    conn = sqlite3.connect(db_file)
    print(f"Database {db_file} created successfully.")
else:
    print(f"Database {db_file} already exists.")

with sqlite3.connect(db_file) as conn:
    cursor = conn.cursor()

    cursor.execute('''
    CREATE TABLE IF NOT EXISTS users (
        id INTEGER PRIMARY KEY AUTOINCREMENT,
        name TEXT,
        age INTEGER
    )
    ''')
    print("Table 'users' created successfully (if it didn't exist).")

conn.close()

                            
                            

                                
                                import sqlite3

db_file = 'example.db'

def insert_user(name, age):
    try:
        conn = sqlite3.connect(db_file)
        cursor = conn.cursor()

        cursor.execute('''
            INSERT INTO users (name, age) 
            VALUES (?, ?)
        ''', (name, age))

        conn.commit()

        print(f"User {name} inserted successfully.")

    except sqlite3.Error as e:
        print(f"An error occurred: {e}")

    finally:
        conn.close()

insert_user('Alice', 30)
insert_user('Bob', 25)
insert_user('Charlie', 35)
                            
                            

                                
                                import sqlite3

db_file = 'example.db'

def delete_user(name):
    try:
        conn = sqlite3.connect(db_file)
        cursor = conn.cursor()

        cursor.execute('''
            DELETE FROM users 
            WHERE name = ?
        ''', (name,))

        conn.commit()

        if cursor.rowcount > 0:
            print(f"User {name} deleted successfully.")
        else:
            print(f"No user found with the name {name}.")

    except sqlite3.Error as e:
        print(f"An error occurred: {e}")

    finally:
        conn.close()

delete_user('Alice')
delete_user('Eve')


                            
                            

                                
                                import sqlite3

db_file = 'example.db'

def update_user(name, new_age):
    try:
        conn = sqlite3.connect(db_file)
        cursor = conn.cursor()

        cursor.execute('''
            UPDATE users 
            SET age = ? 
            WHERE name = ?
        ''', (new_age, name))

        conn.commit()

        if cursor.rowcount > 0:
            print(f"User {name}'s age updated to {new_age} successfully.")
        else:
            print(f"No user found with the name {name}.")

    except sqlite3.Error as e:
        print(f"An error occurred: {e}")

    finally:
        conn.close()

update_user('Alice', 31)
update_user('Bob', 26)