-- Inserting some test Authors
INSERT INTO Author (idAuthor, firstName, lastName, mailingAddress, email, affiliation) VALUES (1, "Alex", "Chan", "Woodeward Hall", "Chanimal@gmail.com", "Dartmouth");
INSERT INTO Author (idAuthor, firstName, lastName, mailingAddress, email, affiliation) VALUES (2, "Steven", "Jiang", "1 Webster Avenue", "SJ@dartmouth.edu", "Dartmouth");
INSERT INTO Author (idAuthor, firstName, lastName, mailingAddress, email, affiliation) VALUES (3, "Ted", "Bausch", "6 Smith Avenue", "TD@dartmouth.edu", "Dartmouth");
INSERT INTO Author (idAuthor, firstName, lastName, mailingAddress, email, affiliation) VALUES (4, "Dan", "Lein", "1 Webster Avenue", "bigshow@yahoo.com", "toysRus");
INSERT INTO Author (idAuthor, firstName, lastName, mailingAddress, email, affiliation) VALUES (5, "Re", "McLendon", "Triangle Avenue", "Redawg@gmail.edu", "Collis");
INSERT INTO Author (idAuthor, firstName, lastName, mailingAddress, email, affiliation) VALUES (6, "fake first name", "fake last name", "1 Webster Avenue", "2ndTierschool.edu", "Fake affiliation");



--Inserting some test editors
INSERT INTO Editor(idEditor, firstName, lastName) VALUES (1, "Al", "Forbes");
INSERT INTO Editor(idEditor, firstName, lastName) VALUES (2, "ted", "poatsy");
INSERT INTO Editor(idEditor, firstName, lastName) VALUES (3, "johnny", "emm");
INSERT INTO Editor(idEditor, firstName, lastName) VALUES (4, "kuroosh", "sagin");

-- Inserting RICodes
INSERT INTO RICode(idRICODE) VALUES(1);
INSERT INTO RICode(idRICODE) VALUES(2);
INSERT INTO RICode(idRICODE) VALUES(3);
INSERT INTO RICode(idRICODE) VALUES(4);

-- Inserting Test Issues
INSERT INTO Issue(idIssue, pubYear, pubPeriod, printDate) VALUES (1, 2017, 1, NOW());
INSERT INTO Issue(idIssue, pubYear, pubPeriod, printDate) VALUES (2, 2011, 3, NOW());
INSERT INTO Issue(idIssue, pubYear, pubPeriod, printDate) VALUES (3, 2012, 3, NOW());
INSERT INTO Issue(idIssue, pubYear, pubPeriod, printDate) VALUES (4, 1998, 1, NOW());
INSERT INTO Issue(idIssue, pubYear, pubPeriod, printDate) VALUES (5, 3000, 4, NOW());

-- Inserting Test Reviewers
INSERT INTO Reviewer(idReviewer, firstName, lastName, email, affiliation) VALUES(1, "Matt", "Vance", "MVp@gmail.com", 1);
INSERT INTO Reviewer(idReviewer, firstName, lastName, email, affiliation) VALUES(1, "R1", "R1", "wowwow.com", 1);
INSERT INTO Reviewer(idReviewer, firstName, lastName, email, affiliation) VALUES(1, "R2", "wow", "not_real.com", 1);
INSERT INTO Reviewer(idReviewer, firstName, lastName, email, affiliation) VALUES(1, "fakeReviewer3", "Vance", "fake.com", 2);
INSERT INTO Reviewer(idReviewer, firstName, lastName, email, affiliation) VALUES(1, "george", "bush", "MVp@gmail.com", 3);
INSERT INTO Reviewer(idReviewer, firstName, lastName, email, affiliation) VALUES(1, "bayrock", "Ohbahma", "POTUS@gmail.com", 1776);


-- Inserting Test Interest Groups SHOULD BE ERROR IF NO REVIWER
INSERT INTO InterestGroup(RICode_idRICODE, Reviewer_idReviewer) VALUES (1, 1);
INSERT INTO InterestGroup(RICode_idRICODE, Reviewer_idReviewer) VALUES (1, 2);
INSERT INTO InterestGroup(RICode_idRICODE, Reviewer_idReviewer) VALUES (1, 3);
INSERT INTO InterestGroup(RICode_idRICODE, Reviewer_idReviewer) VALUES (3, 1);
INSERT INTO InterestGroup(RICode_idRICODE, Reviewer_idReviewer) VALUES (3, 2);


-- Inserting some test manuscripts
INSERT INTO Manuscript(idManuscript, Issue_idIssue, title, dateReceivedByEditor, status, dateAccepted, numPages, startingPage, Editor_idEditor) VALUES (1, 1, "Man1", NOW(), "accepted", NOW(), 30, 1, 1);
INSERT INTO Manuscript(idManuscript, Issue_idIssue, title, dateReceivedByEditor, status, dateAccepted, numPages, startingPage, Editor_idEditor) VALUES (2, 1, "Man2", NOW(), "accepted", NOW(), 30, 1, 1);
INSERT INTO Manuscript(idManuscript, Issue_idIssue, title, dateReceivedByEditor, status, dateAccepted, numPages, startingPage, Editor_idEditor) VALUES (3, 2, "Man3", NOW(), "rejected", NULL, 30, 1, 1);
INSERT INTO Manuscript(idManuscript, Issue_idIssue, title, dateReceivedByEditor, status, dateAccepted, numPages, startingPage, Editor_idEditor) VALUES (4, 2, "Man4", NOW(), "accepted", NOW(), 30, 1, 1);
INSERT INTO Manuscript(idManuscript, Issue_idIssue, title, dateReceivedByEditor, status, dateAccepted, numPages, startingPage, Editor_idEditor) VALUES (5, 4, "Man5", NOW(), "rejected", NULL, 30, 1, 1);
INSERT INTO Manuscript(idManuscript, Issue_idIssue, title, dateReceivedByEditor, status, dateAccepted, numPages, startingPage, Editor_idEditor) VALUES (6, 2, "Man6", NOW(), "in review",NULL, 30, 1, 1);


-- Insert some test Feedback
INSERT INTO Feedback(idFeedback, Reviewer_idReviewer, Manuscript_idManuscript, feedbackAppropriateRating, feedbackClarityRating, feedbackMethodologyRating, feedbackContributionRating, recommendation, dateRequested, dateReceived) VALUE (1, 1, 1, 8, 8, 8, 8, "Yes", NOW(), NOW());
INSERT INTO Feedback(idFeedback, Reviewer_idReviewer, Manuscript_idManuscript, feedbackAppropriateRating, feedbackClarityRating, feedbackMethodologyRating, feedbackContributionRating, recommendation, dateRequested, dateReceived) VALUE (2, 1, 1, 8, 8, 8, 8, "Yes", NOW(), NOW());
INSERT INTO Feedback(idFeedback, Reviewer_idReviewer, Manuscript_idManuscript, feedbackAppropriateRating, feedbackClarityRating, feedbackMethodologyRating, feedbackContributionRating, recommendation, dateRequested, dateReceived) VALUE (3, 2, 1, 8, 8, 8, 8, "Yes", NOW(), NOW());
INSERT INTO Feedback(idFeedback, Reviewer_idReviewer, Manuscript_idManuscript, feedbackAppropriateRating, feedbackClarityRating, feedbackMethodologyRating, feedbackContributionRating, recommendation, dateRequested, dateReceived) VALUE (4, 2, 1, 8, 8, 8, 8, "Yes", NOW(), NOW());
INSERT INTO Feedback(idFeedback, Reviewer_idReviewer, Manuscript_idManuscript, feedbackAppropriateRating, feedbackClarityRating, feedbackMethodologyRating, feedbackContributionRating, recommendation, dateRequested, dateReceived) VALUE (5, 1, 5, 8, 8, 8, 8, "No", NOW(), NOW());
INSERT INTO Feedback(idFeedback, Reviewer_idReviewer, Manuscript_idManuscript, feedbackAppropriateRating, feedbackClarityRating, feedbackMethodologyRating, feedbackContributionRating, recommendation, dateRequested, dateReceived) VALUE (6, 1, 1, 8, 8, 8, 8, "Yes", NOW(), NOW());
INSERT INTO Feedback(idFeedback, Reviewer_idReviewer, Manuscript_idManuscript, feedbackAppropriateRating, feedbackClarityRating, feedbackMethodologyRating, feedbackContributionRating, recommendation, dateRequested, dateReceived) VALUE (7, 3, 4, 4, 8, 5, 8, "Yes", NOW(), NOW());
INSERT INTO Feedback(idFeedback, Reviewer_idReviewer, Manuscript_idManuscript, feedbackAppropriateRating, feedbackClarityRating, feedbackMethodologyRating, feedbackContributionRating, recommendation, dateRequested, dateReceived) VALUE (8, 3, 1, 8, 8, 8, 8, "No", NOW(), NOW());
INSERT INTO Feedback(idFeedback, Reviewer_idReviewer, Manuscript_idManuscript, feedbackAppropriateRating, feedbackClarityRating, feedbackMethodologyRating, feedbackContributionRating, recommendation, dateRequested, dateReceived) VALUE (9, 1, 4, 111, 10, 10, 0, "Yes", NOW(), NOW());


INSERT INTO AuthorGroup (Author_idAuthor, Manuscript_idManuscript, authorOrder) VALUE (1, 1, 1);
INSERT INTO AuthorGroup (Author_idAuthor, Manuscript_idManuscript, authorOrder) VALUE (2, 2, 1);
INSERT INTO AuthorGroup (Author_idAuthor, Manuscript_idManuscript, authorOrder) VALUE (3, 4, 2);
INSERT INTO AuthorGroup (Author_idAuthor, Manuscript_idManuscript, authorOrder) VALUE (4, 1, 1);
INSERT INTO AuthorGroup (Author_idAuthor, Manuscript_idManuscript, authorOrder) VALUE (5, 2, 4);