import sqlite3
import csv

DB_NAME = 'warehouse.db'

def connect():
    return sqlite3.connect(DB_NAME)

def setup_database():
    conn = connect()
    cursor = conn.cursor()
    # Inventory Table: Stores raw materials and finished goods
    cursor.execute('''
        CREATE TABLE IF NOT EXISTS inventory (
            id INTEGER PRIMARY KEY AUTOINCREMENT,
            name TEXT NOT NULL UNIQUE,
            quantity INTEGER NOT NULL,
            price REAL NOT NULL
        )
    ''')
    # Invoices Table: Tracks both sales and purchases
    cursor.execute('''
        CREATE TABLE IF NOT EXISTS invoices (
            id INTEGER PRIMARY KEY AUTOINCREMENT,
            type TEXT NOT NULL, -- 'SALE' or 'PURCHASE'
            party_name TEXT, -- Customer or Supplier Name
            date TIMESTAMP DEFAULT CURRENT_TIMESTAMP
        )
    ''')
    # Invoice Items Table: Links items from inventory to an invoice
    cursor.execute('''
        CREATE TABLE IF NOT EXISTS invoice_items (
            id INTEGER PRIMARY KEY AUTOINCREMENT,
            invoice_id INTEGER,
            item_id INTEGER,
            quantity INTEGER NOT NULL,
            price_per_unit REAL NOT NULL,
            FOREIGN KEY (invoice_id) REFERENCES invoices (id),
            FOREIGN KEY (item_id) REFERENCES inventory (id)
        )
    ''')
    conn.commit()
    conn.close()

def get_inventory():
    conn = connect()
    cursor = conn.cursor()
    cursor.execute("SELECT id, name, quantity, price FROM inventory ORDER BY name")
    items = cursor.fetchall()
    conn.close()
    return items

def add_inventory_item(name, quantity, price):
    conn = connect()
    cursor = conn.cursor()
    try:
        cursor.execute("INSERT INTO inventory (name, quantity, price) VALUES (?, ?, ?)", (name, quantity, price))
        conn.commit()
    except sqlite3.IntegrityError:
        # Item with this name already exists
        return False
    finally:
        conn.close()
    return True

def update_item_quantity(item_id, change_in_quantity):
    conn = connect()
    cursor = conn.cursor()
    cursor.execute("UPDATE inventory SET quantity = quantity + ? WHERE id = ?", (change_in_quantity, item_id))
    conn.commit()
    conn.close()
    
def find_item_by_name(name):
    conn = connect()
    cursor = conn.cursor()
    cursor.execute("SELECT * FROM inventory WHERE name = ?", (name,))
    item = cursor.fetchone()
    conn.close()
    return item

# Add more functions here for invoices, etc. as we build the app.

# Hashtags: #SQLite #DatabaseDesign #DataPersistence #Python

import sys
import csv
from PyQt5.QtWidgets import *
import database as db # Import our database module

class WarehouseApp(QMainWindow):
    def __init__(self):
        super().__init__()
        self.setWindowTitle("Warehouse ERP System")
        self.setGeometry(100, 100, 1000, 700)
        db.setup_database() # Ensure tables are created

        self.tabs = QTabWidget()
        self.setCentralWidget(self.tabs)
        
        # Create tabs
        self.inventory_tab = QWidget()
        self.purchase_tab = QWidget() # Incoming
        self.sales_tab = QWidget()    # Outgoing
        self.production_tab = QWidget()
        self.reports_tab = QWidget()

        self.tabs.addTab(self.inventory_tab, "Inventory")
        # Add other tabs later...

        self.setup_inventory_ui()
        self.load_inventory_data()

    def setup_inventory_ui(self):
        layout = QVBoxLayout()
        # Table view
        self.inventory_table = QTableWidget()
        self.inventory_table.setColumnCount(4)
        self.inventory_table.setHorizontalHeaderLabels(['ID', 'Name', 'Quantity', 'Price'])
        self.inventory_table.setEditTriggers(QAbstractItemView.NoEditTriggers)
        layout.addWidget(self.inventory_table)
        
        # Form for adding new items
        form = QFormLayout()
        self.item_name = QLineEdit()
        self.item_qty = QSpinBox()
        self.item_qty.setRange(0, 99999)
        self.item_price = QLineEdit()
        form.addRow("Name:", self.item_name)
        form.addRow("Quantity:", self.item_qty)
        form.addRow("Price:", self.item_price)
        add_btn = QPushButton("Add New Item")
        add_btn.clicked.connect(self.add_item)
        layout.addLayout(form)
        layout.addWidget(add_btn)
        
        self.inventory_tab.setLayout(layout)

    def load_inventory_data(self):
        items = db.get_inventory()
        self.inventory_table.setRowCount(len(items))
        for row_num, row_data in enumerate(items):
            for col_num, data in enumerate(row_data):
                self.inventory_table.setItem(row_num, col_num, QTableWidgetItem(str(data)))

    def add_item(self):
        name = self.item_name.text()
        qty = self.item_qty.value()
        price = float(self.item_price.text())
        if not name:
            QMessageBox.warning(self, "Input Error", "Item name cannot be empty.")
            return
        if db.add_inventory_item(name, qty, price):
            self.load_inventory_data() # Refresh table
            self.item_name.clear()
            self.item_qty.setValue(0)
            self.item_price.clear()
        else:
            QMessageBox.warning(self, "DB Error", f"Item '{name}' already exists.")

if __name__ == '__main__':
    app = QApplication(sys.argv)
    window = WarehouseApp()
    window.show()
    sys.exit(app.exec_())

# Hashtags: #PyQt5 #GUI #CRUD #InventoryManagement

def create_invoice(invoice_type, party_name, items):
    conn = connect()
    cursor = conn.cursor()
    # Create the invoice record
    cursor.execute("INSERT INTO invoices (type, party_name) VALUES (?, ?)", (invoice_type, party_name))
    invoice_id = cursor.lastrowid
    
    # Add items to the invoice and update inventory
    for item in items:
        item_id, quantity, price = item['id'], item['quantity'], item['price']
        cursor.execute(
            "INSERT INTO invoice_items (invoice_id, item_id, quantity, price_per_unit) VALUES (?, ?, ?, ?)",
            (invoice_id, item_id, quantity, price)
        )
        # Update inventory quantity
        change = quantity if invoice_type == 'PURCHASE' else -quantity
        cursor.execute("UPDATE inventory SET quantity = quantity + ? WHERE id = ?", (change, item_id))
    
    conn.commit()
    conn.close()
    return invoice_id

# In __init__, add the tab and call the setup
self.tabs.addTab(self.purchase_tab, "Purchasing (Incoming)")
self.setup_purchase_ui()

# In __init__, add the sales tab and call setup
self.tabs.addTab(self.sales_tab, "Sales (Outgoing)")
self.setup_sales_ui()

# New methods for the class
def setup_purchase_ui(self):
    # This is a simplified UI for demonstration
    layout = QVBoxLayout()
    form = QFormLayout()
    self.supplier_name = QLineEdit()
    self.purchase_item = QComboBox()
    self.purchase_qty = QSpinBox()
    self.purchase_qty.setRange(1, 1000)
    
    form.addRow("Supplier Name:", self.supplier_name)
    form.addRow("Item:", self.purchase_item)
    form.addRow("Quantity:", self.purchase_qty)
    
    add_purchase_btn = QPushButton("Record Purchase")
    add_purchase_btn.clicked.connect(self.record_purchase)
    
    layout.addLayout(form)
    layout.addWidget(add_purchase_btn)
    self.purchase_tab.setLayout(layout)
    self.update_item_combos()

def setup_sales_ui(self):
    # UI is very similar to purchase
    layout = QVBoxLayout()
    form = QFormLayout()
    self.customer_name = QLineEdit()
    self.sales_item = QComboBox()
    self.sales_qty = QSpinBox()
    self.sales_qty.setRange(1, 1000)
    
    form.addRow("Customer Name:", self.customer_name)
    form.addRow("Item:", self.sales_item)
    form.addRow("Quantity:", self.sales_qty)
    
    add_sale_btn = QPushButton("Record Sale")
    add_sale_btn.clicked.connect(self.record_sale)
    
    layout.addLayout(form)
    layout.addWidget(add_sale_btn)
    self.sales_tab.setLayout(layout)

def update_item_combos(self):
    self.purchase_item.clear()
    self.sales_item.clear()
    items = db.get_inventory()
    for item in items:
        # Store the full item tuple as userData
        self.purchase_item.addItem(item[1], userData=item) 
        self.sales_item.addItem(item[1], userData=item)

def record_purchase(self):
    supplier = self.supplier_name.text()
    item_data = self.purchase_item.currentData()
    qty = self.purchase_qty.value()
    if not supplier or not item_data:
        QMessageBox.warning(self, "Input Error", "Please fill all fields.")
        return
        
    invoice_item = {'id': item_data[0], 'quantity': qty, 'price': item_data[3]}
    db.create_invoice('PURCHASE', supplier, [invoice_item])
    
    QMessageBox.information(self, "Success", "Purchase recorded successfully.")
    self.load_inventory_data() # Refresh all UIs
    self.update_item_combos()

def record_sale(self):
    customer = self.customer_name.text()
    item_data = self.sales_item.currentData()
    qty_to_sell = self.sales_qty.value()
    
    if not customer or not item_data:
        QMessageBox.warning(self, "Input Error", "Please fill all fields.")
        return
    
    # Check for sufficient stock
    if item_data[2] < qty_to_sell:
        QMessageBox.critical(self, "Stock Error", f"Not enough {item_data[1]} in stock. Available: {item_data[2]}")
        return

    invoice_item = {'id': item_data[0], 'quantity': qty_to_sell, 'price': item_data[3]}
    db.create_invoice('SALE', customer, [invoice_item])
    
    QMessageBox.information(self, "Success", "Sale recorded successfully.")
    self.load_inventory_data()
    self.update_item_combos()

# In __init__, add the tabs and call the setups
self.tabs.addTab(self.production_tab, "Production")
self.setup_production_ui()
self.tabs.addTab(self.reports_tab, "Reporting")
self.setup_reports_ui()

# Define Bill of Materials (can be moved to DB in a real app)
self.bill_of_materials = {
    'Wooden Table': {'Wood Plank': 5, 'Varnish': 1},
    'Wooden Chair': {'Wood Plank': 2, 'Nail': 10}
}

def setup_production_ui(self):
    layout = QVBoxLayout()
    form = QFormLayout()
    self.product_to_make = QComboBox()
    self.product_to_make.addItems(self.bill_of_materials.keys())
    self.production_qty = QSpinBox()
    self.production_qty.setRange(1, 100)
    
    form.addRow("Product:", self.product_to_make)
    form.addRow("Quantity:", self.production_qty)
    produce_btn = QPushButton("Produce Items")
    produce_btn.clicked.connect(self.run_production)
    
    layout.addLayout(form)
    layout.addWidget(produce_btn)
    self.production_tab.setLayout(layout)

def run_production(self):
    product_name = self.product_to_make.currentText()
    qty_to_make = self.production_qty.value()
    bom = self.bill_of_materials[product_name]
    
    # 1. Check stock for all required materials
    for material, required_qty in bom.items():
        item_data = db.find_item_by_name(material)
        if not item_data or item_data[2] < required_qty * qty_to_make:
            QMessageBox.critical(self, "Production Halt", f"Not enough {material} in stock.")
            return

    # 2. If stock is sufficient, consume materials
    for material, required_qty in bom.items():
        item_data = db.find_item_by_name(material)
        db.update_item_quantity(item_data[0], - (required_qty * qty_to_make))

    # 3. Add finished product to inventory
    finished_product = db.find_item_by_name(product_name)
    if finished_product:
        db.update_item_quantity(finished_product[0], qty_to_make)
    else:
        # You'd calculate a price here in a real app
        db.add_inventory_item(product_name, qty_to_make, price=50.0)

    QMessageBox.information(self, "Success", f"Produced {qty_to_make} of {product_name}.")
    self.load_inventory_data()
    self.update_item_combos()

def setup_reports_ui(self):
    layout = QVBoxLayout()
    label = QLabel("Select a report to export to CSV:")
    self.report_type = QComboBox()
    self.report_type.addItems(["Current Inventory", "Sales History"]) # Add more as needed
    export_btn = QPushButton("Export Report")
    export_btn.clicked.connect(self.export_report)
    
    layout.addWidget(label)
    layout.addWidget(self.report_type)
    layout.addWidget(export_btn)
    layout.addStretch()
    self.reports_tab.setLayout(layout)

def export_report(self):
    report = self.report_type.currentText()
    path, _ = QFileDialog.getSaveFileName(self, "Save CSV", "", "CSV Files (*.csv)")
    if not path:
        return

    try:
        if report == "Current Inventory":
            data = db.get_inventory()
            headers = ['ID', 'Name', 'Quantity', 'Price']
            with open(path, 'w', newline='') as f:
                writer = csv.writer(f)
                writer.writerow(headers)
                writer.writerows(data)
        # Add other report types here
        # elif report == "Sales History": ...
        
        QMessageBox.information(self, "Success", f"Report exported to {path}")
    except Exception as e:
        QMessageBox.critical(self, "Export Error", f"An error occurred: {e}")

# Hashtags: #Production #Reporting #CSVExport #BusinessLogic

print("Hello, World!")

Hello, World!

my_list = [1, 2, 3, 4]
print(len(my_list))

4

name = "Python"
print(type(name))

<class 'str'>

username = input("Enter your name: ")
print("Hello, " + username)

Enter your name: Alex
Hello, Alex

string_number = "101"
number = int(string_number)
print(number + 9)

110

age = 25
print("My age is " + str(age))

My age is 25

integer_value = 5
print(float(integer_value))

5.0

print(bool(1))
print(bool(0))
print(bool("Hello"))
print(bool(""))

True
False
True
False

my_tuple = (1, 2, 3)
my_list = list(my_tuple)
print(my_list)

[1, 2, 3]

my_list = [4, 5, 6]
my_tuple = tuple(my_list)
print(my_tuple)

(4, 5, 6)

numbers = [10, 20, 30]
print(sum(numbers))

60

numbers = [5, 29, 12, 99]
print(max(numbers))

99

numbers = [5, 29, 12, 99]
print(min(numbers))

5

negative_number = -15
print(abs(negative_number))

15

pi = 3.14159
print(round(pi, 2))

3.14

for i in range(5):
    print(i)

0
1
2
3
4

unsorted_list = [3, 1, 4, 1, 5, 9]
sorted_list = sorted(unsorted_list)
print(sorted_list)

[1, 1, 3, 4, 5, 9]

fruits = ['apple', 'banana', 'cherry']
for index, fruit in enumerate(fruits):
    print(index, fruit)

0 apple
1 banana
2 cherry

names = ['Alice', 'Bob', 'Charlie']
ages = [25, 30, 35]
for name, age in zip(names, ages):
    print(f"{name} is {age} years old.")

Alice is 25 years old.
Bob is 30 years old.
Charlie is 35 years old.

def square(n):
    return n * n

numbers = [1, 2, 3, 4]
squared_numbers = map(square, numbers)
print(list(squared_numbers))

[1, 4, 9, 16]

def is_even(n):
    return n % 2 == 0

numbers = [1, 2, 3, 4, 5, 6]
even_numbers = filter(is_even, numbers)
print(list(even_numbers))

[2, 4, 6]

multiply = lambda a, b: a * b
print(multiply(5, 6))

30

def greet(name):
    return f"Hello, {name}!"

print(greet("World"))

Hello, World!

def add(a, b):
    return a + b

result = add(7, 8)
print(result)

15

number = 10
print(isinstance(number, int))
print(isinstance(number, str))

True
False

score = 85
if score >= 90:
    print("Grade A")
elif score >= 80:
    print("Grade B")
else:
    print("Grade C")

Grade B

colors = ["red", "green", "blue"]
for color in colors:
    print(color)

red
green
blue

count = 0
while count < 3:
    print(f"Count is {count}")
    count += 1

Count is 0
Count is 1
Count is 2

for i in range(10):
    if i == 5:
        break
    print(i)

0
1
2
3
4

for i in range(5):
    if i == 2:
        continue
    print(i)

0
1
3
4

message = "hello python"
print(message.upper())

HELLO PYTHON

message = "HELLO PYTHON"
print(message.lower())

hello python

text = "   some space   "
print(text.strip())

some space

sentence = "Python is fun"
words = sentence.split(' ')
print(words)

['Python', 'is', 'fun']

words = ['Python', 'is', 'awesome']
sentence = " ".join(words)
print(sentence)

Python is awesome

text = "I like cats."
new_text = text.replace("cats", "dogs")
print(new_text)

I like dogs.

filename = "document.pdf"
print(filename.startswith("doc"))

True

filename = "image.jpg"
print(filename.endswith(".jpg"))

True

text = "hello world"
print(text.find("world"))

6

name = "Alice"
age = 30
print(f"{name} is {age} years old.")

Alice is 30 years old.

fruits = ['apple', 'banana']
fruits.append('cherry')
print(fruits)

['apple', 'banana', 'cherry']

fruits = ['apple', 'banana', 'cherry']
fruits.pop(1) # Removes 'banana'
print(fruits)

['apple', 'cherry']

fruits = ['apple', 'banana', 'cherry', 'banana']
fruits.remove('banana')
print(fruits)

['apple', 'cherry', 'banana']

fruits = ['apple', 'cherry']
fruits.insert(1, 'banana')
print(fruits)

['apple', 'banana', 'cherry']

numbers = [3, 1, 5, 2]
numbers.sort()
print(numbers)

[1, 2, 3, 5]

my_dict = dict(name="John", age=36)
print(my_dict)

{'name': 'John', 'age': 36}

person = {'name': 'Alice', 'age': 25}
print(person.keys())

dict_keys(['name', 'age'])

person = {'name': 'Alice', 'age': 25}
print(person.values())

dict_values(['Alice', 25])

person = {'name': 'Alice', 'age': 25}
print(person.items())

dict_items([('name', 'Alice'), ('age', 25)])

person = {'name': 'Alice', 'age': 25}
print(person.get('city', 'Unknown'))

Unknown

try:
    result = 10 / 0
except ZeroDivisionError:
    result = "You can't divide by zero!"
print(result)

You can't divide by zero!

# This code creates a file named "myfile.txt"
# No direct output, but a file is created.
file = open("myfile.txt", "w") 
file.close() 
print("File created and closed.")

File created and closed.

file = open("myfile.txt", "w")
file.write("Hello, File!")
file.close()
# No direct output, but content is written to myfile.txt
print("Content written to file.")

Content written to file.

# Assuming "myfile.txt" contains "Hello, File!"
file = open("myfile.txt", "r")
content = file.read()
print(content)
file.close()

Hello, File!

with open("myfile.txt", "w") as f:
    f.write("This is safer!")
# The file is automatically closed here.
print("File written and closed safely.")

File written and closed safely.

import math
print(math.sqrt(16))

4.0

from datetime import date
today = date.today()
print(today)

2023-10-27 
(Note: Output date will be the current date)

my_list = [1, 2, 3, 4, 5]
print(3 in my_list)
print(10 in my_list)

True
False

my_list = [10, 20, 30]
del my_list[1] # delete item at index 1
print(my_list)

[10, 30]

def my_empty_function():
    pass # To be implemented later

my_empty_function() # This does nothing and produces no error
print("Function executed without error.")

Function executed without error.

ping -c 4 google.com

PING google.com (142.250.72.14) 56(84) bytes of data.
64 bytes from lhr48s23-in-f14.1e100.net (142.250.72.14): icmp_seq=1 ttl=118 time=8.53 ms
...
--- google.com ping statistics ---
4 packets transmitted, 4 received, 0% packet loss, time 3005ms

whois google.com

Domain Name: GOOGLE.COM
Registry Domain ID: 2138514_DOMAIN_COM-VRSN
Registrar WHOIS Server: whois.markmonitor.com
...
Registrant Organization: Google LLC
Registrant State/Province: CA
Registrant Country: US

dig google.com

; <<>> DiG 9.18.1-1-Debian <<>> google.com
;; ANSWER SECTION:
google.com.  156 IN A 142.250.187.238
...
;; Query time: 12 msec
;; SERVER: 8.8.8.8#53(8.8.8.8)

nmap -sV -p 80,443 scanme.nmap.org

Starting Nmap 7.92 ( https://nmap.org ) at ...
Nmap scan report for scanme.nmap.org (45.33.32.156)
Host is up (0.16s latency).

PORT    STATE SERVICE  VERSION
80/tcp  open  http     Apache httpd 2.4.7 ((Ubuntu))
443/tcp open  ssl/http Apache httpd 2.4.7 ((Ubuntu))

nc -zv scanme.nmap.org 80

Connection to scanme.nmap.org (45.33.32.156) 80 port [tcp/http] succeeded!

netstat -tulpn

Active Internet connections (only servers)
Proto Recv-Q Send-Q Local Address      Foreign Address    State       PID/Program name
tcp        0      0 127.0.0.1:5432     0.0.0.0:*          LISTEN      675/postgres
tcp        0      0 0.0.0.0:22         0.0.0.0:*          LISTEN      789/sshd
udp        0      0 0.0.0.0:68         0.0.0.0:*                      654/dhclient

traceroute 8.8.8.8

traceroute to 8.8.8.8 (8.8.8.8), 30 hops max, 60 byte packets
 1  gateway (192.168.1.1)  1.234 ms  1.567 ms  1.890 ms
 2  isp-router.net (10.0.0.1)  5.432 ms  5.678 ms  5.901 ms
 ...
10  142.251.52.221 (142.251.52.221)  10.112 ms  10.345 ms  10.578 ms
11  dns.google (8.8.8.8)  10.801 ms  10.923 ms  11.045 ms

sudo tcpdump -i eth0 -c 5 port 80

tcpdump: verbose output suppressed, use -v or -vv for full protocol decode
listening on eth0, link-type EN10MB (Ethernet), capture size 262144 bytes
14:30:01.123456 IP my-pc.54321 > example.com.80: Flags [S], seq 123456789, win 64240, options [mss 1460,sackOK,TS val 10,ecr 0], length 0
... (4 more packets) ...
5 packets captured

arp -a

? (192.168.1.1) at 00:1a:2b:3c:4d:5e [ether] on eth0
? (192.168.1.105) at 98:76:54:32:10:fe [ether] on eth0

ip addr show

1: lo: <LOOPBACK,UP,LOWER_UP> mtu 65536 ...
    inet 127.0.0.1/8 scope host lo
2: eth0: <BROADCAST,MULTICAST,UP,LOWER_UP> mtu 1500 ...
    inet 192.168.1.100/24 brd 192.168.1.255 scope global dynamic eth0

curl -I http://example.com

HTTP/1.1 200 OK
Content-Encoding: gzip
Accept-Ranges: bytes
Cache-Control: max-age=604800
Content-Type: text/html; charset=UTF-8
Date: Fri, 27 Oct 2023 10:00:00 GMT
Server: ECS (dcb/7F83)
Content-Length: 648

gobuster dir -u http://example.com -w /usr/share/wordlists/dirb/common.txt

===============================================================
Gobuster v3.5
===============================================================
[+] Url:                     http://example.com
[+] Threads:                 10
[+] Wordlist:                /usr/share/wordlists/dirb/common.txt
===============================================================
/index.html           (Status: 200) [Size: 1256]
/images               (Status: 301) [Size: 178] -> http://example.com/images/
/javascript           (Status: 301) [Size: 178] -> http://example.com/javascript/

nikto -h http://scanme.nmap.org

- Nikto v2.1.6
---------------------------------------------------------------------------
+ Target IP:          45.33.32.156
+ Target Hostname:    scanme.nmap.org
+ Target Port:        80
+ Start Time:         ...
---------------------------------------------------------------------------
+ Server: Apache/2.4.7 (Ubuntu)
+ The anti-clickjacking X-Frame-Options header is not present.
+ OSVDB-3233: /icons/README: Apache default file found.

sqlmap -u "http://testphp.vulnweb.com/listproducts.php?cat=1" --dbs

...
available databases [2]:
[*] information_schema
[*] acuart

whatweb scanme.nmap.org

http://scanme.nmap.org [200 OK] Apache[2.4.7], Country[UNITED STATES], HTTPServer[Ubuntu Linux][Apache/2.4.7 ((Ubuntu))], IP[45.33.32.156], Script, Title[Go ahead and ScanMe!], Ubuntu

# Assume 'hashes.txt' contains 'user:$apr1$A.B.C...$...'
john --wordlist=/usr/share/wordlists/rockyou.txt hashes.txt

Using default input encoding: UTF-8
Loaded 1 password hash (md5crypt, 32/64 OpenSSL)
Press 'q' or Ctrl-C to abort, almost any other key for status
password123      (user)
1g 0:00:00:01 DONE (2023-10-27 10:15) 0.9803g/s 1234p/s 1234c/s
Session completed

# -m 0 = MD5 hash type
hashcat -m 0 -a 0 hashes.md5 /usr/share/wordlists/rockyou.txt

...
Session..........: hashcat
Status...........: Cracked
Hash.Name........: MD5
Hash.Target......: 5f4dcc3b5aa765d61d8327deb882cf99
Guess.Base.......: File (/usr/share/wordlists/rockyou.txt)
...
Recovered........: 1/1 (100.00%) Digests

hydra -l user -P /path/to/passwords.txt ftp://192.168.1.101

Hydra v9.1 (c) 2020 by van Hauser/THC - Please do not use in military projects
...
[21][ftp] host: 192.168.1.101 login: user password: password
1 of 1 target successfully completed, 1 valid password found

msfconsole

=[ metasploit v6.3.3-dev                          ]
+ -- --=[ 2289 exploits - 1184 auxiliary - 406 post       ]
+ -- --=[ 953 payloads - 45 encoders - 11 nops            ]
+ -- --=[ 9 evasion                                       ]

msf6 >

searchsploit apache 2.4.7

-------------------------------------------------- ---------------------------------
 Exploit Title                            |  Path
-------------------------------------------------- ---------------------------------
Apache 2.4.7 (Ubuntu) - 'mod_cgi' Bash Env | linux/remote/34900.py
Apache mod_authz_svn < 1.8.10 / < 1.7.18 - | multiple/remote/34101.txt
-------------------------------------------------- ---------------------------------

strings /bin/bash

/lib64/ld-linux-x86-64.so.2
_ITM_deregisterTMCloneTable
__gmon_start__
...
echo
read
printf

grep "Failed password" /var/log/auth.log

Oct 27 10:20:05 server sshd[1234]: Failed password for invalid user admin from 203.0.113.5 port 54321 ssh2
Oct 27 10:20:10 server sshd[1236]: Failed password for root from 203.0.113.5 port 12345 ssh2

# Before
ls -l script.sh
-rwxrwxr-x 1 user user 50 Oct 27 10:25 script.sh

# Command
chmod 700 script.sh

# After
ls -l script.sh

-rwx------ 1 user user 50 Oct 27 10:25 script.sh

echo -n "Hi" | xxd

00000000: 4869                                     Hi

echo -n "security" | base64

c2VjdXJpdHk=

# Generate a self-signed certificate
openssl req -x509 -newkey rsa:2048 -keyout key.pem -out cert.pem -days 365 -nodes

Generating a RSA private key
...........................................................................+++++
......................................................................+++++
writing new private key to 'key.pem'
-----
You are about to be asked to enter information that will be incorporated
into your certificate request.
...
(Files key.pem and cert.pem are created)

echo -n "hello world" > file.txt
sha256sum file.txt

b94d27b9934d3e08a52e52d7da7dabfac484efe37a5380ee9088f7ace2efcde9  file.txt

# Encrypt a file
echo "secret message" > secret.txt
gpg -c secret.txt

(A file named secret.txt.gpg is created after prompting for a passphrase)

# Put interface in monitor mode
airmon-ng start wlan0

PHY Interface Driver  Chipset

phy0 wlan0  ath9k  Atheros Communications Inc. AR9271 802.11n
  (mac80211 monitor mode vif enabled for [phy0]wlan0 on [phy0]wlan0mon)
  (mac80211 station mode vif disabled for [phy0]wlan0)

theharvester -d google.com -l 100 -b google

[*] Target: google.com
[*] Searching Google for 100 results...
[*] Found 2 emails:
 - some-email@google.com
 - another-email@google.com
[*] Found 15 hosts:
 - host1.google.com
 - host2.google.com
 ...

print("Hello, World!")

Hello, World!

message = "I am learning Python."
print(message)

I am learning Python.

age = 30
print("My age is:", age)

My age is: 30

price = 19.99
print("The price is:", price)

The price is: 19.99

is_learning = True
print("Am I learning?", is_learning)

Am I learning? True

name = input("What is your name? ")
print("Hello, " + name)

What is your name? Alice
Hello, Alice

a = 10
b = 5
print(a + b)

15

# This line calculates the area of a rectangle
length = 10
width = 5
area = length * width
print("Area is:", area)

Area is: 50

age_str = input("Enter your age: ")
age_int = int(age_str)
next_year_age = age_int + 1
print("Next year you will be:", next_year_age)

Enter your age: 25
Next year you will be: 26

first_name = "John"
last_name = "Doe"
full_name = first_name + " " + last_name
print(full_name)

John Doe

x, y, z = 10, 20, 30
print(x, y, z)

10 20 30

num = 123
text = "hello"
pi = 3.14
print(type(num))
print(type(text))
print(type(pi))

<class 'int'>
<class 'str'>
<class 'float'>

a = 15
b = 4
print("Addition:", a + b)
print("Subtraction:", a - b)
print("Multiplication:", a * b)
print("Division:", a / b)

Addition: 19
Subtraction: 11
Multiplication: 60
Division: 3.75

a = 15
b = 4
print("Floor Division:", a // b)
print("Modulus (Remainder):", a % b)

Floor Division: 3
Modulus (Remainder): 3

power = 3 ** 4  # 3 to the power of 4
print(power)

81

my_string = "Python is fun"
print(len(my_string))

13