//Insert methods for all tables
//Type 1 = tables that need a specialised query
public void insertPatientInformation(String name, String dateOfBirth, String nationality, int nhsNo, String address, String weight)
{
dbOpen();
Insertion ins = new Insertion(con);
ins.patientInformation(name, dateOfBirth, nationality, nhsNo, address, weight);
dbClose();
}
public void insertPointRecognitionScans(int patientID, int scanLocID)
{
dbOpen();
Insertion ins = new Insertion(con);
ins.type3("PointRecognitionScans", "patientID", "scanLocID", patientID, scanLocID);
dbClose();
}
public void insertPatientScans(int patientID, int scanID)
{
dbOpen();
Insertion ins = new Insertion(con);
ins.type3("PatientScans", "patientID", "scanID", patientID, scanID);
dbClose();
}
//Type 3 = tables containing 3 identifiers
public void insertPatientCondition(int patientID, int conditionID)
{
dbOpen();
Insertion ins = new Insertion(con);
ins.type3("PatientCondition", "patientID", "conditionID", patientID, conditionID);
dbClose();
}
public void insertScanLocations(String boneName, String jointName1, String jointName2, double distJoint1, double distJoint2, String jointsDist, DateTime timestamp)
{
dbOpen();
Insertion ins = new Insertion(con);
ins.scanLocations(boneName, jointName1, jointName2, distJoint1, distJoint2, jointsDist, timestamp);
dbClose();
}
public void insertLimbCoordinates(int scanID, double[] joint1, double[] joint2, String[] joint3, String[] joint4)
{
dbOpen();
Insertion ins = new Insertion(con);
ins.LimbCoordinates(scanID, joint1, joint2, joint3, joint4);
dbClose();
}
//Type 2 = tables containing 1 identifier and 2 text fields
//contains the different types of conditions
public void insertConditions(String condition, String description)
{
dbOpen();
Insertion ins = new Insertion(con);
ins.type2("Conditions", "condition", "description", condition, description);
dbClose();
}
//contains the different types of scans
public void insertScanTypes(String scanType, String description)
{
dbOpen();
Insertion ins = new Insertion(con);
ins.type2("ScanTypes", "scanType", "description", scanType, description);
dbClose();
}
public void insertRecords(int scanID, int scanTypeID, double value)
{
dbOpen();
Insertion ins = new Insertion(con);
ins.records(scanID, scanTypeID, value);
dbClose();
}
public void insertScans(int scanTypeID, int patientID, String pointCloudFileReference, String description, DateTime timestamp)
{
dbOpen();
Insertion ins = new Insertion(con);
ins.scans(scanTypeID, pointCloudFileReference, description, timestamp);
ins.patientscans(patientID);
dbClose();
}
public void insertScanLocations(String boneName, String jointName1, String jointName2, double distJoint1, double distJoint2, String jointsDist, DateTime timestamp)
{
dbOpen();
Insertion ins = new Insertion(con);
ins.scanLocations(boneName, jointName1, jointName2, distJoint1, distJoint2, jointsDist, timestamp);
dbClose();
}
public void insertRecords(int scanID, int scanTypeID, double value)
{
dbOpen();
Insertion ins = new Insertion(con);
ins.records(scanID, scanTypeID, value);
dbClose();
}
public void insertPointRecognitionScans(int patientID, int scanLocID)
{
dbOpen();
Insertion ins = new Insertion(con);
ins.type3("PointRecognitionScans", "patientID", "scanLocID", patientID, scanLocID);
dbClose();
}
public void insertPatientScans(int patientID, int scanID)
{
dbOpen();
Insertion ins = new Insertion(con);
ins.type3("PatientScans", "patientID", "scanID", patientID, scanID);
dbClose();
}
//Insert methods for all tables
//Type 1 = tables that need a specialised query
public void insertPatientInformation(String name, String dateOfBirth, String nationality, int nhsNo, String address, String weight)
{
dbOpen();
Insertion ins = new Insertion(con);
ins.patientInformation(name, dateOfBirth, nationality, nhsNo, address, weight);
dbClose();
}
//Type 3 = tables containing 3 identifiers
public void insertPatientCondition(int patientID, int conditionID)
{
dbOpen();
Insertion ins = new Insertion(con);
ins.type3("PatientCondition", "patientID", "conditionID", patientID, conditionID);
dbClose();
}
public DatabaseEngine()
{
insertQueries = new Insertion(this.con);
selectQueries = new Selection(this.con);
}
public void insertScans(int scanTypeID, int patientID, String pointCloudFileReference, String description, DateTime timestamp)
{
dbOpen();
Insertion ins = new Insertion(con);
ins.scans(scanTypeID, pointCloudFileReference, description, timestamp);
ins.patientscans(patientID);
dbClose();
}
//contains the different types of scans
public void insertScanTypes(String scanType, String description)
{
dbOpen();
Insertion ins = new Insertion(con);
ins.type2("ScanTypes", "scanType", "description", scanType, description);
dbClose();
}
//Type 2 = tables containing 1 identifier and 2 text fields
//contains the different types of conditions
public void insertConditions(String condition, String description)
{
dbOpen();
Insertion ins = new Insertion(con);
ins.type2("Conditions", "condition", "description", condition, description);
dbClose();
}
public DatabaseEngine()
{
insertQueries = new Insertion(this.con);
selectQueries = new Selection(this.con);
}
public void insertLimbCoordinates(int scanID, double[] joint1, double[] joint2, String[] joint3, String[] joint4)
{
dbOpen();
Insertion ins = new Insertion(con);
ins.LimbCoordinates(scanID, joint1, joint2, joint3, joint4);
dbClose();
}
