import sqlite3

class MoldManager:

def __init__(self, db_name):

self.conn = sqlite3.connect(db_name)

self.cursor = self.conn.cursor()

self.cursor.execute('''

CREATE TABLE IF NOT EXISTS molds (

id INTEGER PRIMARY KEY,

name TEXT,

type TEXT,

status TEXT

)

''')

def add_mold(self, name, mold_type, status):

self.cursor.execute('INSERT INTO molds (name, type, status) VALUES (?, ?, ?)',

(name, mold_type, status))

self.conn.commit()

def display_molds(self):

self.cursor.execute('SELECT * FROM molds')

rows = self.cursor.fetchall()

for row in rows:

print(f"ID: {row[0]}, Name: {row[1]}, Type: {row[2]}, Status: {row[3]}")

# Example usage

manager = MoldManager('molds.db')

manager.add_mold('Mold A', 'Plastic', 'Active')

manager.add_mold('Mold B', 'Metal', 'Inactive')

manager.display_molds()

]]>

import matplotlib.pyplot as plt

def plot_mold_status(manager):

statuses = {}

manager.cursor.execute('SELECT status, COUNT(*) FROM molds GROUP BY status')

for status, count in manager.cursor.fetchall():

statuses[status] = count

labels = statuses.keys()

sizes = statuses.values()

plt.pie(sizes, labels=labels, autopct='%1.1f%%')

plt.title('Mold Status Distribution')

plt.show()

# Example usage

plot_mold_status(manager)

]]>