Class database.

A class database is a collection of data organized in a structured format that is used to store information related to classes, courses, students, teachers, and other educational entities. This database can be used by educational institutions such as schools, colleges, and universities to manage and track information about classes, enrollments, grades, schedules, and other relevant data.

A class database typically includes tables for storing information such as class names, course codes, teacher names, student IDs, enrollment records, grades, attendance, and other related data. It may also include relationships between different tables to establish connections and dependencies between the various entities in the database.

The database can be accessed and managed through a database management system (DBMS) such as MySQL, Oracle, SQL Server, or PostgreSQL. Users can query the database to retrieve specific information, update records, generate reports, and perform other tasks related to managing class-related data.

Overall, a class database serves as a central repository for storing and organizing information related to classes and courses, providing a valuable resource for educational institutions to effectively manage their academic programs and student records.

class Database:
def __init__(self, connection):
self.connection = connection

def get_connection(self):
return self.connection

def create_database(self, name):
try:
self.connection.create_database(name)
print(f"Database {name} created successfully.")
except Exception as e:
print(f"Error creating database: {e}.")

def drop_database(self, name):
try:
self.connection.drop_database(name)
print(f"Database {name} dropped successfully.")
except Exception as e:
print(f"Error dropping database: {e}.")

def create_table(self, name, columns):
try:
self.connection.create_table(name, columns)
print(f"Table {name} created successfully.")
except Exception as e:
print(f"Error creating table: {e}.")

def drop_table(self, name):
try:
self.connection.drop_table(name)
print(f"Table {name} dropped successfully.")
except Exception as e:
print(f"Error dropping table: {e}.")

def insert_record(self, table, values):
try:
self.connection.insert_record(table, values)
print(f"Record inserted successfully into table {table}.")
except Exception as e:
print(f"Error inserting record: {e}.")

def update_record(self, table, values, where_clause):
try:
self.connection.update_record(table, values, where_clause)
print(f"Record updated successfully in table {table}.")
except Exception as e:
print(f"Error updating record: {e}.")

def delete_record(self, table, where_clause):
try:
self.connection.delete_record(table, where_clause)
print(f"Record deleted successfully from table {table}.")
except Exception as e:
print(f"Error deleting record: {e}.")

def select_record(self, table, columns, where_clause=None):
try:
result = self.connection.select_record(table, columns, where_clause)
print("Records selected successfully from table {table}.")
return result
except Exception as e:
print(f"Error selecting record: {e}.")

def execute_query(self, query):
try:
result = self.connection.execute_query(query)
print("Query executed successfully.")
return result
except Exception as e:
print(f"Error executing query: {e}.")