Sorting Hat

Description

A tool to manage identities.

Sorting Hat maintains an SQL database of unique identities of communities members across (potentially) many different sources. Identities corresponding to the same real person can be merged in the same unique identity with a unique uuid. For each unique identity, a profile can be defined, with the name and other data shown for the corresponding person by default.

In addition, each unique identity can be related to one or more affiliations, for different time periods. This will usually correspond to different organizations in which the person was employed during those time periods.

Sorting Hat is a part of the GrimoireLab toolset, which provides Python modules and scripts to analyze data sources with information about software development, and allows the production of interactive dashboards to visualize that information.

In the context of GrimoireLab, Sorting Hat is usually run after data is retrieved with Perceval, to store the identities obtained into its database, and later merge them into unique identities (and maybe affiliate them).

Source code and contributions

All the source code is available in the Sorting Hat GitHub repository. Please, submit pull requests if you have proposals to change the source code, and open an issue if you want to report a bug, ask for a new feature, or just provide feedback.

Usage

usage: sortinghat [--help] [-c <file>] [-u <user>] [-p <password>]
                  [--host <host>] [--port <port>] [-d <name>]
                  command [<cmd_args>]

The most commonly used sortinghat commands are:

    add          Add identities
    affiliate    Affiliate identities
    autogender   Auto complete gender data
    autoprofile  Auto complete profiles
    blacklist    List, add or delete entries from the blacklist
    config       Get and set configuration parameters
    countries    List information about countries
    enroll       Enroll identities into organizations
    export       Export data (i.e identities) from the registry
    init         Create an empty registry
    load         Import data (i.e identities, organizations) on the registry
    merge        Merge unique identities
    mv           Move an identity into a unique identity
    log          List enrollment information available in the registry
    orgs         List, add or delete organizations and domains
    profile      Edit profile
    rm           Remove identities from the registry
    show         Show information about a unique identity
    unify        Merge identities using a matching algorithm
    withdraw     Remove identities from organizations

General options:
  -h, --help            show this help message and exit
  -c FILE, --config FILE
                        set configuration file
  -u USER, --user USER  database user name
  -p PASSWORD, --password PASSWORD
                        database user password
  -d DATABASE, --database DATABASE
                        name of the database where the registry will be stored
  --host HOST           name of the host where the database server is running
  --port PORT           port of the host where the database server is running

Run 'sortinghat <command> --help' to get information about a specific command.

Installation

From pypi

You can install sortinghat as a package from the pypi repository:

$ pip install sortinghat

Native

You can install sortinghat just by running setup.py script:

$ python setup.py install

This will install it in the python default directories in your system.

If you don't install sortinghat with root privileges, or don't want to install it in the default directories, you can also use the source code directory, as cloned from the main git repo. It is enough to configure your $PATH and $PYTHONPATH so that sortinghat, and the Python modules it needs, are found.

Add to your $PATH the directory which contains the sortinghat executables:

$ export PATH=$PATH:sortinghatdir/bin

In $PYTHONPATH, you need to include sortinghat as well. If sortinghatdir is the path where sortinghat is installed:

$ export PYTHONPATH=$PYTHONPATH:sortinghatdir

You are ready to use sortinghat!

Docker

You can use our image from DockerHub (grimoirelab/sortinghat) and skip the docker build step. If you prefer to build the image yourself execute:

$ docker build -t grimoirelab/sortinghat .

Next step would be to start a MySQL docker container for data storage:

$ docker run --name mysql \
             -e MYSQL_ROOT_PASSWORD=sortinghat \
             -d mysql

Run the sortinghat docker container in interactive mode:

$ docker run -i -t --rm \
             --link mysql:mysql \
             -e SORTINGHAT_DB_HOST=mysql \
             -e SORTINGHAT_DB_PASSWORD=sortinghat \
             -e SORTINGHAT_DB_DATABASE=sortinghat \
             grimoirelab/sortinghat \
             /bin/bash

Now you can initialize sortinghat with the database name sortinghat:

$ sortinghat init sortinghat

You are ready to use sortinghat and explore the commands documented below. Have fun!

Configuration

Set the database parameters via the config command:

  $ sortinghat config set db.host <mysql-host>
  $ sortinghat config set db.user <user>
  $ sortinghat config set db.password <password>
  $ sortinghat config set db.database <name>
  $ sortinghat config set db.port <port>

Alternatively you can set environment variables:

  $ export SORTINGHAT_DB_HOST=<mysql-host>
  $ export SORTINGHAT_DB_USER=<user>
  $ export SORTINGHAT_DB_PASSWORD=<password>
  $ export SORTINGHAT_DB_DATABASE=<name>
  $ export SORTINGHAT_DB_PORT=<port>

After this initialize a new database:

  $ sortinghat init <name>

Compatibility between versions

Python 2.7 is no longer supported. Any code using this version will not work. Please update your code to 3.4 or newer versions.

SortingHat databases previous to 0.7.0 are compatible but UTF-8 encoded 4-bytes characters will not be inserted in the database and will cause errors. For this reason, it is recommended to update its schema. The fastest way is to dump the data into a file, regenerate the database with init command and restore the data from the dump.

SortingHat databases previous to 0.6.0 are no longer compatible. The database schema changed in profiles table to add the fields gender and gender_acc.

The next MySQL statements should be run to update the schema

mysql> ALTER TABLE profiles ADD COLUMN gender VARCHAR(32) DEFAULT NULL
mysql> ALTER TABLE profiles ADD COLUMN gender_acc INT(11) DEFAULT NULL

SortingHat databases previous to 0.5.0 are no longer compatible. The database schema changed in uidentites and identities tables to add the field last_modified to log when a record was updated.

The next MySQL statements should be run to update the schema

mysql> ALTER TABLE uidentities ADD COLUMN last_modified DATETIME(6) DEFAULT NULL
mysql> ALTER TABLE identities ADD COLUMN last_modified DATETIME(6) DEFAULT NULL

SortingHat databases previous to 0.3.0 are no longer compatible. The seed used to generate identities UUIDs changed and for that reason, these ids should be re-generated.

The next steps will restore the database generating new UUIDs for each identity but keeping the data and relationships between them.

Export data

$ sortinghat export --orgs orgs.json
$ sortinghat export --identities identities.json

Remove the database and/or create a new one with sortinghat init
Load data, this will regenerate the UUIDs

$ sortinghat load orgs.json
$ sortinghat load identities.json

Basic commands

Add some unique identities

  $ sortinghat add --name "John Smith" --email "[email protected]" --username "jsmith" --source scm
  New identity a9b403e150dd4af8953a52a4bb841051e4b705d9 to a9b403e150dd4af8953a52a4bb841051e4b705d9

  $ sortinghat add --name "John Doe" --email "[email protected]" --source scm
  New identity 3de180633322e853861f9ee5f50a87e007b51058 added to 3de180633322e853861f9ee5f50a87e007b51058

Set a profile

  $ sortinghat profile --name "John Smith" --email "[email protected]" --country US a9b403e150dd4af8953a52a4bb841051e4b705d9
  unique identity a9b403e150dd4af8953a52a4bb841051e4b705d9

  Profile:
      * Name: John Smith
      * E-Mail: [email protected]
      * Bot: No
      * Country: US - United States of America

Add an identity to an existing unique identity

  $ sortinghat add --username "jsmith" --source mls --uuid a9b403e150dd4af8953a52a4bb841051e4b705d9
  New identity 2612aad107cae121b45c1f46041650abc8e39421 added to a9b403e150dd4af8953a52a4bb841051e4b705d9

Merge two identities

  $ sortinghat merge a7637bb1737bc2a83f3a3e25b9b441cba62d97c2 a9b403e150dd4af8953a52a4bb841051e4b705d9
  Unique identity 3de180633322e853861f9ee5f50a87e007b51058 merged on a9b403e150dd4af8953a52a4bb841051e4b705d9

Move an identity into a unique identity

  $ sortinghat mv 3de180633322e853861f9ee5f50a87e007b51058 3de180633322e853861f9ee5f50a87e007b51058
  New unique identity 3de180633322e853861f9ee5f50a87e007b51058 created. Identity moved

Remove a unique identity

  $ sortinghat rm 3de180633322e853861f9ee5f50a87e007b51058
  Unique identity 3de180633322e853861f9ee5f50a87e007b51058 removed

Show identities information

  $ sortinghat show
  unique identity a9b403e150dd4af8953a52a4bb841051e4b705d9

  Profile:
      * Name: John Smith
      * E-Mail: [email protected]
      * Bot: No
      * Country: US - United States of America

  Identities:
    2612aad107cae121b45c1f46041650abc8e39421	-	-	jsmith	mls
    a9b403e150dd4af8953a52a4bb841051e4b705d9	John Smith	[email protected]	jsmith	scm

  No enrollments

Add some organizations

  $ sortinghat orgs -a Example
  $ sortinghat orgs -a Bitergia
  $ sortinghat orgs -a Individual

Add some domains to the organizations

  $ sortinghat orgs -a Example example.com --top-domain
  $ sortinghat orgs -a Example web.example.com
  $ sortinghat orgs -a Bitergia bitergia.com --top-domain

List organizations

  $ sortinghat orgs
  Bitergia	bitergia.com *
  Example	example.com *
  Example	web.example.com
  Individual

Remove domains

  $ sortinghat orgs -d Example web.example.com

Remove organizations

 $ sortinghat orgs -d Bitergia

Enroll

  $ sortinghat enroll --from 2014-06-01 --to 2015-09-01 a9b403e150dd4af8953a52a4bb841051e4b705d9 Example
  $ sortinghat enroll --from 2015-09-01 a9b403e150dd4af8953a52a4bb841051e4b705d9 Individual

Show enrollments information

  $ sortinghat show a9b403e150dd4af8953a52a4bb841051e4b705d9
  unique identity a9b403e150dd4af8953a52a4bb841051e4b705d9

  Profile:
      * Name: John Smith
      * E-Mail: [email protected]
      * Bot: No
      * Country: US - United States of America

  Identities:
    2612aad107cae121b45c1f46041650abc8e39421	-	-	jsmith	mls
    a9b403e150dd4af8953a52a4bb841051e4b705d9	John Smith	[email protected]	jsmith	scm

  Enrollments:
    Example	2014-06-01 00:00:00	2015-09-01 00:00:00
    Individual	2015-09-01 00:00:00	2100-01-01 00:00:00

Withdraw

  $ sortinghat withdraw --from 2014-06-01 --to 2015-09-01 a9b403e150dd4af8953a52a4bb841051e4b705d9 Example

Basic API calls

Sortinghat can be integrated on your Python scripts by leveraging on its API. Each API call requires as a parameter the database in which the operations will be performed. A database object should thus be created by specifying the user, password, database and optional host and port.

from sortinghat import api
from sortinghat.db.database import Database

db = Database('root', '*****', 'test_db')

Key terms

identity_id: Identifier assigned to the identity.
entity: Entity can be any term, word or value to blacklist.
from_date: Starting date which is a datetime objects. The method str_to_datetime can be used to convert the string date and time parameter to datetime object.
matcher: Criteria used to match identities.
source: Source of the identities.
term: Term to match with an attribute(e.g organization, country name).
to_date: Ending date which is a datetime objects. The method str_to_datetime can be used to convert the string date and time parameter to datetime object.
uuid: Unique identifier for the identity.

Usage

Add a unique identity to the registry

api.add_unique_identity(db=db, uuid='a9b403e150dd4af8953a52a4bb841051e4b705d9')

Add an identity to the registry

source = 'git'
email = '[email protected]'
name = 'John Smith'
username = 'jsmith'
uuid = 'a9b403e150dd4af8953a52a4bb841051e4b705d9'
   
api.add_identity(db=db, source=source, email=email, name=name, username=username, uuid=uuid)

Add an organization to the registry

api.add_organization(db=db, organization='ExampleOrg')

Add a new domain to the given organization

To set the domain as the top domain pass is_top_domain = True. The domain for an organization can be updated by passing overwrite=True.

api.add_domain(db=db, organization='ExampleOrg', domain='example.com', is_top_domain=True, overwrite=False)

Enroll a unique identity to an organization

from sortinghat.utils import str_to_datetime
    
uuid = 'a9b403e150dd4af8953a52a4bb841051e4b705d9'
organization = 'ExampleOrg'
from_date = str_to_datetime('2020-04-01')
to_date = str_to_datetime('2020-04-05')
    
api.add_enrollment(db=db, uuid=uuid, organization=organization, from_date=from_date, to_date=to_date)

Add entity to the matching blacklist

api.add_to_matching_blacklist(db=db, entity='example')

List the blacklisted entities available in the registry

The API returns a list of blacklisted entities sorted by their name.

api.blacklist(db=db, term='example')

List the countries available in the registry

The API returns a list of countries sorted by their country id.

api.countries(db=db, code='US', term='United States of America')

Remove a unique identity from the registry

api.delete_unique_identity(db=db, uuid='a9b403e150dd4af8953a52a4bb841051e4b705d9')

Remove an identity from the registry

api.delete_identity(db=db, identity_id='a9b403e150dd4af8953a52a4bb841051e4b705d9')

Remove an organization from the registry

api.delete_organization(db=db, organization='ExampleOrg')

Remove the given organization domain from the registry

api.delete_domain(db=db, organization='ExampleOrg', domain='example.com')

Withdraw a unique identity from an organization

from sortinghat.utils import str_to_datetime
    
uuid = 'a9b403e150dd4af8953a52a4bb841051e4b705d9'
organization = 'ExampleOrg'
from_date = str_to_datetime('2020-04-01')
to_date = str_to_datetime('2020-04-05')
    
api.delete_enrollment(db=db, uuid=uuid, organization=organization, from_date=from_date, to_date=to_date)

Remove a blacklisted entity from the registry

api.delete_from_matching_blacklist(db=db, entity='example')

List the domains available in the registry

The API returns a list of domains.

api.domains(db=db, domain='example.com')

Edit unique identity profile

The allowed keywords are, name, email,gender, gender_acc, is_bot and country_code. Any other keyword will be ignored.

kwargs = {
    'name': 'John Doe',
    'email': '[email protected]',
    'gender': 'Female',
    'gender_acc': 50,
    'is_bot': False,
    'country_code': 'IN'
}
api.edit_profile(db=db, uuid='a9b403e150dd4af8953a52a4bb841051e4b705d9', **kwargs)

List the enrollment information available in the registry

The API returns a list of enrollments sorted by uuid or by organization.

from sortinghat.utils import str_to_datetime
    
uuid = 'a9b403e150dd4af8953a52a4bb841051e4b705d9'
organization = 'ExampleOrg'
from_date = str_to_datetime('2020-04-01')
to_date = str_to_datetime('2020-04-05')
    
api.enrollments(db=db, uuid=uuid, organization=organization, from_date=from_date, to_date=to_date)

Search for similar unique identities

The API requires a Matcher object to be passed a parameter. The object can be created using the create_identity_matcher method.

from sortinghat.matcher import create_identity_matcher

matcher = create_identity_matcher()

api.match_identities(db=db, uuid='a9b403e150dd4af8953a52a4bb841051e4b705d9', matcher=matcher)

Merge one unique identity into another

from_uuid = 'a9b403e150dd4af8953a52a4bb841051e4b705d9'
to_uuid = '3de180633322e853861f9ee5f50a87e007b51058'
    
api.merge_unique_identities(db=db, from_uuid=from_uuid, to_uuid=to_uuid)

Merge overlapping enrollments

api.merge_enrollments(db=db, uuid='a9b403e150dd4af8953a52a4bb841051e4b705d9', organization='ExampleOrg')

Move an identity to a unique identity

from_id = 'a9b403e150dd4af8953a52a4bb841051e4b705d9'
to_uuid = 'a9b403e150dd4af8953a52a4bb841051e4b705d9'
        
api.move_identity(db=db, from_id=from_id, to_uuid=to_uuid )

List the organizations available in the registry

The API returns a list of organizations sorted by their name.

api.registry(db=db, term='example')

Search for the uuids of identities modified on or after a given date

The API returns a list of uuids of identities modified.

api.search_last_modified_identities(db=db, after='2020-04-01')

Search for the uuids of unique identities modified on or after a given date

The API returns a list of uuids of unique identities modified.

api.search_last_modified_unique_identities(db=db, after='2020-04-01')

List unique identities profiles

The API returns a list of profile entities. To return only the entities having no gender set no_gender=True.

api.search_profiles(db, no_gender=False)

Search for unique identities

The API returns a list of unique identities. The term will be compared with name, email, username and source values of each identity. When source is given, this search will be only performed on identities linked to this source.

api.search_unique_identities(db=db, term='example', source='scm')

Search for unique identities using slicing

The API returns a list of unique identities starting from offset and limiting a maximum number of identities specified by limit. The term will be compared with name, email, username and source values of each identity.

api.search_unique_identities_slice(db=db, term='example', offset=4, limit=20)

List the unique identities available in the registry

The function returns a list of unique identities.

api.unique_identities(db=db, uuid='a9b403e150dd4af8953a52a4bb841051e4b705d9', source='scm')

Import / Export

Import data from a Sorting Hat JSON file

  $ sortinghat load sh.json
  Loading blacklist...
  Entry  added to the blacklist
  1/1 blacklist entries loaded
  Loading unique identities...
  + 00000ba7f563234e5f239e912f2df1021695122e (old 00000ba7f563234e5f239e912f2df1021695122e) loaded
  + 00003e37e7586be36c64ce4f9eafa89f11be2448 (old 00003e37e7586be36c64ce4f9eafa89f11be2448) loaded
  ...
  + fa84729382093928570aef849483948489238498 (old fa84729382093928570aef849483948489238498) loaded
  100/100 unique identities loaded

Export identities

  $ sortinghat export --identities sh_ids.json

Export organizations

  $ sortinghat export --orgs sh_orgs.json

Requirements

Python >= 3.4
MySQL >= 5.6 or MariaDB 10.0
SQLAlchemy >= 1.2
Jinja2 >= 2.7
python-dateutil >= 2.6
python-yaml >= 3.12
requests >= 2.9
urllib3 >= 1.22

You will also need a MySQL Python driver to connect with the database server. We recommend using one these packages:

PyMySQL

Optionally, you can install Pandas library to speed up the matching process:

python-pandas >= 0.15

Running tests

SortingHat comes with a comprehensive list of unit tests. To run them, copy the file 'tests/tests.conf.sample' to 'tests/tests.conf' and edit it to suit your configuration:

name: Name of the database to use for testing
host, port: How to access the database server (MySQL, MariaDB)
user, password: Credentials for the database server
create: Whether the database for testing will be created (True) or not (False, by default). If True, tests will fail if database already exists. If False, tests will fail if database does not exist.

You can run the tests through setup.py (no need to install dependencies or something else, setup.py will take care of that):

$ python3 setup.py test

Troubleshooting

Once SortingHat has been installed, some errors may pop up when running the test suite due to the underlying MySQL database configuration.

MySQL command should be executed without superuser privilege (sudo):

mysql> GRANT ALL PRIVILEGES ON *.* TO 'root'@'localhost' WITH GRANT OPTION;
mysql> FLUSH PRIVILEGES;

MySQL strict mode should be disabled:

mysql> SET @@global.sql_mode= '';

License

Licensed under GNU General Public License (GPL), version 3 or later.

Name		Name	Last commit message	Last commit date
Latest commit History 652 Commits
bin		bin
misc		misc
sortinghat		sortinghat
tests		tests
.gitignore		.gitignore
.travis.yml		.travis.yml
AUTHORS		AUTHORS
Dockerfile		Dockerfile
LICENSE		LICENSE
MANIFEST.in		MANIFEST.in
NEWS		NEWS
README.md		README.md
requirements.txt		requirements.txt
requirements_setup.txt		requirements_setup.txt
requirements_tests.txt		requirements_tests.txt
setup.py		setup.py

Provide feedback

Saved searches

Use saved searches to filter your results more quickly

Repository files navigation

Sorting Hat

Description

Source code and contributions

Usage

Installation

From pypi

Native

Docker

Configuration

Compatibility between versions

Basic commands

Basic API calls

Key terms

Usage

Import / Export

Requirements

Running tests

Troubleshooting

License

About

Releases

Packages

Languages

License

mafesan/grimoirelab-sortinghat

Folders and files

Latest commit

History

Repository files navigation

Sorting Hat

Description

Source code and contributions

Usage

Installation

From pypi

Native

Docker

Configuration

Compatibility between versions

Basic commands

Basic API calls

Key terms

Usage

Import / Export

Requirements

Running tests

Troubleshooting

License

About

Resources

License

Stars

Watchers

Forks

Releases

Packages 0

Languages

Packages