GADriverMysqlTestFixture
Overview
Please comment me using the following template inspired by Class Responsibility Collaborator (CRC) design:
For the Class part: State the name of the class with one line description: For example, I'm xxx the root of the hierarchy of visitor objects.
For the Responsibility part: Three sentences about my main responsibility, what I'm doing, what services do I offer.
For the Collaborators Part: State my main collaborators and one line about how I interact with them.
Public API and Key Messages
- label item
One simple example is simply gorgeous.
Internal Representation and Key Implementation Points.
Implementation Points
Instance Method Details
createDatabase
createTables
createTablesself connection execute: 'CREATE TABLE IF NOT EXISTS student(
id INTEGER AUTO_INCREMENT,
username VARCHAR(10),
pass VARCHAR(50),
mail VARCHAR(50),
name_surname VARCHAR(30),
regular BOOLEAN,
age SMALLINT,
average_grade DECIMAL(9,3),
sex CHARACTER(3),
description VARCHAR(200),
starting_hour TIME,
sign_up_date DATETIME,
born_date DATE,
nullable_field VARCHAR(64) NULL,
CONSTRAINT pk_students_id PRIMARY KEY (id)
) ENGINE = InnoDB ;
'.
The InnoDB engine is in order to have transaction in this table
self connection execute: 'CREATE TABLE IF NOT EXISTS signature(
code INTEGER,
id_student INTEGER,
name CHAR(100),
observations VARCHAR(255),
course_grade INTEGER,
final_grade INTEGER,
CONSTRAINT pk_signatures_code PRIMARY KEY (id_student, code)
) ENGINE = InnoDB '.
The InnoDB engine is in order to have transaction in this table
self connection execute: 'CREATE TABLE IF NOT EXISTS course(
id_course INTEGER,
id_student INTEGER,
signature_code INTEGER,
starting_date DATE,
CONSTRAINT pk_courses_id_course PRIMARY KEY (id_student, signature_code)
) ENGINE = InnoDB '.
The InnoDB engine is in order to have transaction in this table
self connection execute: 'ALTER TABLE signature
ADD CONSTRAINT se_st_fk FOREIGN KEY (id_student) REFERENCES student(id)'dropDatabase
dropDatabase