memberjojo

memberjojo is a Python library for using Membermojo data from CSV imports.
It provides member database, and completed payments querying.
This is done in a local SQLite database which is optionally encrypted if sqlcipher3 is installed, and does not alter anything on Membermojo.
It provides tools to load, and query membership and transaction data efficiently without having to use SQLite directly.
When importing CSV files existing entries are dropped before import, so you can just import the latest download and the local database is updated with a summary diff printed out.

Using the download_csv function the csv can be downloaded directly into the db, which can also be in memory if :memory: is used as the db path.

Installation

Installing via pip on macos with optional sqlcipher installed via homebrew:
(The sqlcipher bindings are compiled by pip so the C_INCLUDE_PATH and LIBRARY_PATH are needed for the libsqlcipher files to be found)

brew install sqlcipher
export C_INCLUDE_PATH="/opt/homebrew/opt/sqlcipher/include"
export LIBRARY_PATH="/opt/homebrew/opt/sqlcipher/lib"
pip install memberjojo[sqlciper]

Installing via pip on ubuntu:

sudo apt-get --no-install-recommends --no-install-suggests install libsqlcipher-dev
pip install memberjojo[sqlcipher]

Installing via pip without sqlcipher:

pip install memberjojo

Or clone the repo and install locally with flit:

git clone https://github.com/a16bitsysop/memberjojo.git
cd memberjojo
flit install --symlink

Usage

Example loading members and using Member objects:

from pathlib import Path
from membermojo import Member

# database is created if it does not exist
member_database_path = Path(Path(__file__).parent, "database", "my-members.db")
member_csv_path = Path("download", "members.csv")

members = Member(member_database_path, "My DB Password")
members.import_csv(member_csv_path)

for member in members:
    print(member.first_name, member.last_name, member.member_number)

# Get full name for a given member number
found_name = members.get_name(1)
if found_name:
    print(f"Member with id of 1 is {found_name}")
else:
    print("Member 1 does not exist")

Documentation

Full documentation is available at
👉 https://a16bitsysop.github.io/memberjojo/

Running Tests

Run tests:

pytest

Contributing

Contributions are welcome! Please:

1. Fork the repo
2. Create your feature branch git checkout -b my-feature
3. Edit the source code to add and test your changes
4. Commit your changes git commit -m 'Add some feature'
5. Push to your branch git push origin my-feature
6. Open a Pull Request

Please follow the existing code style and write tests for new features.

License

This project is licensed under the MIT MIT License.

Contact

Created and maintained by Duncan Bellamy. Feel free to open issues or reach out on GitHub.