Skip to main content

A data matching and canonicalization library with multipl database connector support

Project description

CanonMap

A powerful data matching and canonicalization library with MySQL connector support.

Features

  • Data Matching: Advanced algorithms for fuzzy string matching and record linkage
  • MySQL Integration: Seamless connection and management of MySQL databases
  • Canonicalization: Standardize and normalize data across different formats
  • Rich Logging: Beautiful console output with structured logging
  • FastAPI Support: Optional FastAPI integration for web services

Installation

pip install canonmap

For development dependencies:

pip install canonmap[dev]

For FastAPI support:

pip install canonmap[fastapi]

Quick Start

Command Line Interface

CanonMap provides a CLI tool for quick project setup:

# Create a new API project (default name: app)
cm create-api

# Create a new API project with custom name
cm create-api --name my-api

# Create a new API project with spaces (will be normalized)
cm create-api --name "My API"

The CLI will automatically:

  • Normalize directory names to follow Python conventions
  • Auto-increment names if the directory already exists (app, app-2, app-3, etc.)
  • Copy and customize the example API template
  • Replace all references from "app" to your chosen name
  • Install required dependencies (fastapi, uvicorn, python-dotenv)

Basic Usage

from canonmap import make_console_handler
from canonmap.connectors.mysql_connector import MySQLConnector

# Set up logging
make_console_handler(set_root=True)

# Create a MySQL connector
connector = MySQLConnector(
    host="localhost",
    port=3306,
    user="your_user",
    password="your_password",
    database="your_database"
)

# Use the connector for data operations
# ... your data matching and canonicalization code

Data Matching Example

from canonmap.connectors.mysql_connector.matching import Matcher

# Initialize matcher
matcher = Matcher()

# Perform fuzzy matching
matches = matcher.find_matches(
    source_data=source_records,
    target_data=target_records,
    fields_to_match=["name", "address"],
    threshold=0.8
)

Documentation

For detailed documentation, visit the project homepage.

Development

Setup

  1. Clone the repository:
git clone https://github.com/yourusername/canonmap.git
cd canonmap
  1. Install development dependencies:
pip install -e ".[dev]"
  1. Run tests:
pytest

Code Quality

This project uses several tools to maintain code quality:

  • Black: Code formatting
  • isort: Import sorting
  • flake8: Linting
  • mypy: Type checking
  • pytest: Testing

Run all quality checks:

black src/ tests/
isort src/ tests/
flake8 src/ tests/
mypy src/
pytest

Contributing

  1. Fork the repository
  2. Create a feature branch
  3. Make your changes
  4. Add tests for new functionality
  5. Ensure all tests pass
  6. Submit a pull request

License

This project is licensed under the MIT License - see the LICENSE file for details.

Changelog

See CHANGELOG.md for a list of changes and version history.

Support

Project details


Release history Release notifications | RSS feed

This version

0.4.9

Download files

Download the file for your platform. If you're not sure which to choose, learn more about installing packages.

Source Distribution

canonmap-0.4.9.tar.gz (36.2 kB view details)

Uploaded Source

Built Distribution

If you're not sure about the file name format, learn more about wheel file names.

canonmap-0.4.9-py3-none-any.whl (57.4 kB view details)

Uploaded Python 3

File details

Details for the file canonmap-0.4.9.tar.gz.

File metadata

  • Download URL: canonmap-0.4.9.tar.gz
  • Upload date:
  • Size: 36.2 kB
  • Tags: Source
  • Uploaded using Trusted Publishing? No
  • Uploaded via: twine/6.1.0 CPython/3.13.5

File hashes

Hashes for canonmap-0.4.9.tar.gz
Algorithm Hash digest
SHA256 20d685f816c3c3978ccb55e0d00e04ca63cad945e649b7225da3e95bc3c3d769
MD5 d4a12d154b99cca7b22babda5ad9a50a
BLAKE2b-256 b99c0d067ccd2cd3389215d049e8dedcdd873b49b54263fad794a43ea6ac2c74

See more details on using hashes here.

File details

Details for the file canonmap-0.4.9-py3-none-any.whl.

File metadata

  • Download URL: canonmap-0.4.9-py3-none-any.whl
  • Upload date:
  • Size: 57.4 kB
  • Tags: Python 3
  • Uploaded using Trusted Publishing? No
  • Uploaded via: twine/6.1.0 CPython/3.13.5

File hashes

Hashes for canonmap-0.4.9-py3-none-any.whl
Algorithm Hash digest
SHA256 ffdd5bb2dd599bb0586b6fcc720d389dd7dd94ce9e12dff341cb9c712bd1d1a0
MD5 8aec6433ea7fcfb410173aa4c2a2a4f2
BLAKE2b-256 51dab9d0b66fc1fc841fa413b2afd00674c1f00e12d5791edbbdb8520be3d1a8

See more details on using hashes here.

Supported by

AWS Cloud computing and Security Sponsor Datadog Monitoring Depot Continuous Integration Fastly CDN Google Download Analytics Pingdom Monitoring Sentry Error logging StatusPage Status page