Pastoid

Input andrewID, finger andrewID at unix.andrew.cmu.edu
 
Open Database: locaccino.org database pf2
 
username:  harraton
password:  ilx26_galaxy
 
 
 
Joined the study:
select user.facebookID, user.firstname,
user.lastname from user, condition_membership where user.uid =
condition_membership.user_uid where user.lastname = 'LAST NAME' and
user.firstname = 'FIRSTNAME';
 
 
If empty set then append andrewid on Not Joined list.
 
Send Location:
SELECT
user.lastname from Location, LocationContext, ContextInfo, User,
condition_membership where Location.locID =
LocationContext.location_locID and LocationContext.contextID =
ContextInfo.contextID and ContextInfo.owner_UID = User.UID and user.uid
= condition_membership.user_uid group where user.lastname = 'LAST NAME'
and user.firstname = 'FIRSTNAME';
 
 
If empty set, then append andrewID on SendingLocation list.
 
Rules:
 
Select
user.lastname, count(*) as 'NumRules' from user, rule,
condition_membership where user.uid = rule.owner_uid and user.uid =
condition_membership.user_uid where user.lastname = 'LAST NAME' and
user.firstname = 'FIRSTNAME';
 
 
If empty set, then append andrewID on No Rules list.
 
Print the Not Joined, SendingLocation and No Rules lists to a file.