def lookingfor(self):
results = util.fetch_first_or_none(
self.cursor, "select pref_turnsmeon " + "from am_am_member " + "where id = %d;" % self.member_id
)
if results is None:
raise MemberDNEException()
return self._get_preference_names(results[0], _lookingfor)
def lookingfor(self):
results = util.fetch_first_or_none(self.cursor,
"select pref_turnsmeon " +
"from am_am_member " +
"where id = %d;" % self.member_id)
if results is None:
raise MemberDNEException()
return self._get_preference_names(results[0], _lookingfor)
def search_email(self, email):
"""Find a member based on their email, or None if email does not exist"""
email = util.sql_escape(email)
result = util.fetch_first_or_none(self.conn.cursor(),
"select id, email, first_name, last_name " +
"from am_am_member inner join aminno_member_email " +
"on am_am_member.id = aminno_member_email.pnum " +
"where aminno_member_email.email = '" + email + "';")
return AmMember(self.conn, *result) if result is not None else None
def search_email(self, email):
"""Find a member based on their email, or None if email does not exist"""
email = util.sql_escape(email)
result = util.fetch_first_or_none(
self.conn.cursor(), "select id, email, first_name, last_name " +
"from am_am_member inner join aminno_member_email " +
"on am_am_member.id = aminno_member_email.pnum " +
"where aminno_member_email.email = '" + email + "';")
return AmMember(self.conn, *result) if result is not None else None
def search_first_last(self, fname, lname):
"""Find a member based on their first and last name, or None if not exist"""
fname, lname = tuple(map(lambda s: util.sql_escape(s), [fname, lname]))
result = util.fetch_first_or_none(self.conn.cursor(),
"select id, email, first_name, last_name " +
"from am_am_member inner join aminno_member_email " +
"on am_am_member.id = aminno_member_email.pnum " +
"where am_am_member.first_name = '" + fname + "'" +
"and am_am_member.last_name = '" + lname + "';")
return AmMember(self.conn, *result) if result is not None else None
def search_first_last(self, fname, lname):
"""Find a member based on their first and last name, or None if not exist"""
fname, lname = tuple(map(lambda s: util.sql_escape(s), [fname, lname]))
result = util.fetch_first_or_none(
self.conn.cursor(), "select id, email, first_name, last_name " +
"from am_am_member inner join aminno_member_email " +
"on am_am_member.id = aminno_member_email.pnum " +
"where am_am_member.first_name = '" + fname + "'" +
"and am_am_member.last_name = '" + lname + "';")
return AmMember(self.conn, *result) if result is not None else None
