Skip to main content

Python useful classes for office work automation

Project description

Coffeece

Python useful classes for office work automation. Currently working on Python 3.

Install

You can install this package using pip: pip install coffeece

Popup

Tkinter popup functions to:

  • show_info(title, message) -> shows a popup with the title and message provided.
  • ask_file(admitted_file_extensions='any') -> Ask user for a file. Optional: pass admitted file extensions as a list of strings argument. Returns path as string.
  • ask_directory() -> popup asks for a directory through file explorer. Returns path as string.
  • ask_yes_no(title, message) -> shows a popup with the title and message provided and ask yes-no. If yes returns 'True'.

SQLiteDB

A class to manage SQLite3 databases. Now it could:

  • create_connection(self) -> Connect with sqlite3 DB (create it if there isn't). Returns conection object.
  • create_cursor(self) -> Create cursor to communicate with DB. Returns cursor.
  • create_table(cursor, table_name, table_columns) -> Create a table with the name (string) columns and column types (dictionary) given by the user.
  • insert_row(cursor, table_name, row_items) -> Inserts row into DB with the cursor (cursor), table name (string), and items (list) given by the user.
  • commit_changes(self) -> Save DB changes.
  • close_connection(self) -> Close connection to DB.
  • export_table_to_excel(self, table_name) -> Exports table to excel using Pandas library.

System

System navigation and recursion functions:

  • list_all_files(src_directory) -> Make a list of all the files in the given directory. Returns list.
  • list_all_files_recursively(src_directory) -> Make a dictionary of all the files in the given directory recursively. Returns dictionary = root: { dirs: {} , files: {} }
  • list_files_by_type(src_directory, file_extension) -> Make a list of all the files with the given file extension in the given directory. Returns list.
  • extractall_zipfile(filepath, password=None) -> Opens zip file and extracts all its content.

Excel

All Excel-related functions:

  • xls_to_xlsx(src_filename,output_filename) -> Converts .xls file to .xlsx file format.

Scripts

Scripts with utilities:

venv_cleaner

Delete all virtual environments inside the active directory tree. Usage:

  • From Python shell:
>>> from coffeece.scripts import venv_cleaner
>>> venv_cleaner.main()
  • As a script file:
python venv_cleaner.py

You can delete venvs with different name than 'venv' using the optional argument -vn or --venvname.

Why Coffeece?

The main reason behind this little classes is that a huge part of the mechanical work at a job office can be automated through this kind of objects. The other reason to use this is to make office scripts cleaner with an — even more — simplified dependency management.

Project details


Download files

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

Source Distribution

coffeece-1.1.0.tar.gz (5.2 kB view details)

Uploaded Source

Built Distribution

coffeece-1.1.0-py3-none-any.whl (6.8 kB view details)

Uploaded Python 3

File details

Details for the file coffeece-1.1.0.tar.gz.

File metadata

  • Download URL: coffeece-1.1.0.tar.gz
  • Upload date:
  • Size: 5.2 kB
  • Tags: Source
  • Uploaded using Trusted Publishing? No
  • Uploaded via: twine/3.3.0 pkginfo/1.7.0 requests/2.25.1 setuptools/52.0.0 requests-toolbelt/0.9.1 tqdm/4.56.0 CPython/3.9.1

File hashes

Hashes for coffeece-1.1.0.tar.gz
Algorithm Hash digest
SHA256 df324a94218503afe9fceb91c5be8cc055b24297a65eee07e520cc5921eebf78
MD5 83be0fcbd6536adcf8028db03fb24a43
BLAKE2b-256 38baee3ab488997a5b2490a55e103c1acc575632071d609b5482b0f0308b6a76

See more details on using hashes here.

Provenance

File details

Details for the file coffeece-1.1.0-py3-none-any.whl.

File metadata

  • Download URL: coffeece-1.1.0-py3-none-any.whl
  • Upload date:
  • Size: 6.8 kB
  • Tags: Python 3
  • Uploaded using Trusted Publishing? No
  • Uploaded via: twine/3.3.0 pkginfo/1.7.0 requests/2.25.1 setuptools/52.0.0 requests-toolbelt/0.9.1 tqdm/4.56.0 CPython/3.9.1

File hashes

Hashes for coffeece-1.1.0-py3-none-any.whl
Algorithm Hash digest
SHA256 d0a558c65cf4750413f57934a8d422e3913c83845cf4c72d31e58b567a4656c8
MD5 6969041bd661a61a36fed386be67c90d
BLAKE2b-256 d470e5ab3750a71f5b46f69026411a82893dd471bfb95237163e7d6203f418e4

See more details on using hashes here.

Provenance

Supported by

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