Incorrect email or password.
testLogin: PASSED empty password
Incorrect email or password.
testLogin: PASSED empty email
testLogin: PASSED good credentials
Logging out user 30
Logged out user 30
Incorrect email or password.
testLogin: PASSED bad credentials
[ error ] A User is already logged in!
testLogin: PASSED double log in
Logging out user 30
Logged out user 30
[ error ] Your search string may not be empty.
testSearchForUser: PASSED empty search
[ error ] One or more of your search strings is too long.  Each space-separated search word should be <= 50 characters!
testSearchForUser: PASSED long search query
Modified query: %ABC%
Modified query: %XYZ%
No matches for the given search string!
testSearchForUser: PASSED known bad search
Modified query: %FRED%
Modified query: %ANTO%
Modified query: %therapy%
Match: User ID: 88 Name: FREDRIC SPEARS Email: pollmarco@gmail.com
Match: User ID: 7 Name: FREDDY MATHIS Email: wifiinvolving@mail.com
Match: User ID: 30 Name: ANGEL HAYES Email: hourtherapy@mail.com
testSearchForUser: PASSED known good search
[ error ] You must be logged in to do that!
testThreeDegrees: PASSED login required
[ error ] The given userID does not match a known user, cannot find paths!
testThreeDegrees: PASSED bad target
Searching for paths to user 1 (1)
FREDDY MATHIS->WOODROW LOTT->TAMMY HUBER
testThreeDegrees: PASSED nonexistent path
Searching for paths to user 20 (20)
FREDDY MATHIS->DENIS PAUL
testThreeDegrees: PASSED known path length 1
Searching for paths to user 18 (18)
FREDDY MATHIS->CECELIA COOK->TRACEY MATHEWS
testThreeDegrees: PASSED known path length 2
Searching for paths to user 14 (14)
FREDDY MATHIS->LATISHA ZIMMERMAN->MYRA PAUL->AMOS KELLEY
testThreeDegrees: PASSED known path length 3
Logging out user 7
Logged out user 7
Logged in:
false
[ error ] You mustbe logged in to do that!
testCreateGroup: PASSED login required
[ error ] This user does not exist!
testCreateGroup: PASSED bad userID
[ error ] A group by this name already exists!
testCreateGroup: PASSED group already exists
[ error ] Group limits must be positive!
testCreateGroup: PASSED bad limit
[ error ] The new group name can't be empty!
testCreateGroup: PASSED empty name
[ error ] The new group name can't be longer than 50 characters!
testCreateGroup: PASSED name too long
[ error ] The new group description can't be longer than 200 characters!
testCreateGroup: PASSED desc too long
Creating new group as (13, deleteme1, , 1, 30)
Changed 1 rows in groupInfo...
Changed 1 rows in groupMember...
testCreateGroup: PASSED empty description
Logging out user 30
Logged out user 30
[ error ] You must be logged in to do that!
testInitiateGroup: PASSED login required
[ error ] You must provide a message to accompany a group membership request!
testInitiateGroup: PASSED empty message
[ error ] The message cannot be longer than 200 characters!
testInitiateGroup: PASSED message too long
[ error ] No group exists with this group ID!
testInitiateGroup: PASSED bad group ID
initiateAddingGroup changed 1 rows...
testInitiateGroup: PASSED known good request
[ error ] Database error:
ERROR: duplicate key value violates unique constraint "pendinggroupmember_pk"
  Detail: Key (gid, userid)=(1, 7) already exists.
23505
0
testInitiateGroup: PASSED already in group
Logging out user 0
Logged out user 0
[ error ] You must be logged in to do that!
testSendMessageToGroup: PASSED login required
[ error ] You must already be a member of a group to send messages!
testSendMessageToGroup: PASSED bad groupID
[ error ] Your message cannot be empty!
testSendMessageToGroup: PASSED empty message
[ error ] Your message cannot be longer than 200 characters!
testSendMessageToGroup: PASSED message too long
testSendMessageToGroup: PASSED known good call
[ error ] You must already be a member of a group to send messages!
testSendMessageToGroup: PASSED must be group member
Logging out user 1
Logged out user 1
test_createUser : PASSED simple ps.createUser
test_createUser : PASSED second simple createUser
Please use correct dob format [YYYY-MM-DD])
testCreateUser: PASSED bad dob
Illegal name length
testCreateUser: PASSED empty name
Illegal email length
testCreateUser: PASSED empty email
testCreateUser: FAILED empty password
User already Created. Please choose a new email or login using the existing account.
test_CreateUser: PASSED user already exists
Illegal name length
test_CreateUser: PASSED name too long
Illegal email length
test_CreateUser: PASSED email too long
[ error ] Database error:
ERROR: value too long for type character varying(50)
22001
0
test_CreateUser: PASSED password too long
[ error ] You must be logged in to do that!
test_sendMessageToUser : PASSED login required
You are not friends with that person.
test_sendMessageToUser : FAILED simple message
UserID is not found in database.
test_SendMessageToUser: PASSED bad userID
test_SendMessageToUser: PASSED empty message
You are not friends with that person.
testSendMessageToUser: PASSED message too long
You are not friends with that person.
testSendMessageToUser: FAILED known good call
Logging out user 104
Logged out user 104
[ error ] You must be loggedIn to do that.
test_topMessages : PASSED login required
Incorrect email or password.
[ error ] You must be loggedIn to do that.
test_topMessages : FAILED simple sort
[ error ] You must be loggedIn to do that.
test_topMessages : PASSED bad month number
[ error ] You must be loggedIn to do that.
test_topMessages : PASSED bad row number
[ error ] You must be loggedIn to do that.
test_topMessages : FAILED long month range
[ error ] Database error:
ERROR: Those users are already friends
  Where: PL/pgSQL function add_pendingfriends() line 12 at RAISE
P0001
0
testInitiateFriendship: PASSED already friends
[ error ] Database error:
ERROR: insert or update on table "pendingfriend" violates foreign key constraint "fk_toid"
  Detail: Key (toid)=(-5) is not present in table "profile".
23503
0
testInitiateFriendship: PASSED friend doesn't exist
testInitiateFriendship: PASSED valid insert
testDisplayMessages: PASSED invalid userID
Messages from friends:
messageID: 103	fromID: 5	toUserID: 17	toGroupID: 0	Time Sent: 2018-05-08 00:00:00.0
Message Contents: Check out the arch! #childclarity

messageID: 228	fromID: 5	toUserID: 17	toGroupID: 0	Time Sent: 2018-08-11 00:00:00.0
Message Contents: Today in cs1555 we talked about hitting.  In Oracle, we use briefly, but in PostgreSQL we use particles.

messageID: 260	fromID: 5	toUserID: 17	toGroupID: 0	Time Sent: 2018-02-10 00:00:00.0
Message Contents: What are you doing tonight?  I found this strike snake I want to try!

messageID: 280	fromID: 5	toUserID: 17	toGroupID: 0	Time Sent: 2018-10-27 00:00:00.0
Message Contents: What do you want for your birthday?  What about virgin sheep?


Messages sent to groups where you are a member:
testDisplayMessages: PASSED valid userID
testDisplayNewMessages: PASSED invalid userID
New Messages from friends:

New Messages sent to groups where you are a member:
testDisplayNewMessages: PASSED valid userID
Starting testDisplayFriends
Here's a list of your current friends:

User ID: 43	Name: ROBBIE CONWAY
User ID: 49	Name: PARKER SIMS
User ID: 60	Name: NOLA OWENS
User ID: 71	Name: ANGELIA LANCASTER
User ID: 91	Name: FRANCES BALL
testDisplayFriends: PASSED valid userID

Pending friend requests:
You have no pending friend requests.
Pending group requests for groups where you are an administrator:
You have no group requests.
testConfirmRequests: PASSED valid userID

Pending friend requests:
You have no pending friend requests.
Pending group requests for groups where you are an administrator:
You have no group requests.
testConfirmRequests: PASSED valid group admin.

[ error ] Invalid userID
testConfirmRequests: PASSED invalid userID
Logging out user 1
Logged out user 1
[ error ] No user is logged in!
testLogout: PASSED logout without login
[ error ] No user is logged in!
testLogout: PASSED bad userID
Logging out user 30
Logged out user 30
testLogout: PASSED good userID
Logging out user 106
Logged out user 106
test_dropUser: PASSED drop activeUser
Logging out user 1
Logged out user 1
test_dropUser: PASSED drop user in group
Logging out user 33
Logged out user 33
test_dropUser: PASSED drop user in messageInfo
Logging out user 3
Logged out user 3
test_dropUser: PASSED drop user in friend
Logging out user 5
Logged out user 5
test_dropUser: PASSED drop user in pending friend
Unit test results:
70/75 (93.33333333333333%)