[Trac-dev] Email address lookup

[Logan Anderson]

Can anyone point me towards a reference on the appropriate most accurate way to lookup a user based on email address?

It looks like I can use the following statement:
select sid,name,value from session_attribute where name = 'email';
But I'm uncertain whether this is the most accurate place to gather this data.


Sorry if this is a newb question. I'm not seeing what I am looking for.

[RjOllos]

Post by Logan Anderson
Can anyone point me towards a reference on the appropriate most accurate
way to lookup a user based on email address?
select sid,name,value from session_attribute where name = 'email';
But I'm uncertain whether this is the most accurate place to gather this data.
Sorry if this is a newb question. I'm not seeing what I am looking for.

No problem, don't hesitate to ask.

Here's an example, in the GitConnector class:
https://trac.edgewall.org/browser/tags/trac-1.2/tracopt/versioncontrol/git/git_fs.py?marks=350,352-353#L335

If the lookup will be done repeatedly, I'd put the email to user map in a
dictionary and cache it. In fact it might be a good idea to do that in the
code for GitConnector.

- Ryan