Giter VIP home page Giter VIP logo

work_log_database's Introduction

Work log using a database

This terminal application is part of the Treehouse Python Techdegree. This application can be applied to Start-ups or SMEs by allowing employees to enter their name, time worked, task worked on, and general notes about the task into a database. The script registers the work tasks of a given day and allows to get access to previously registered entries.

Project details

  • In the main menu, the user is able to choose whether to add a new entry or lookup previous entries.
  • If the user chose to add a new work log, the user can register the following information in a database file:
  * User name
  * Task name
  * Number of minutes spent working on a task
  * Any additional notes
  • If the user choose to find a previous entry, ths script propose four options:
  1. Find by employee
The user can enter the employee name and a list of employees with entries is displayed 
allowing the user to select one entry to see details.
  1. Find by date
A list of entries with a given date is displayed and the user is able to choose one to see details.
  1. Find by time spent
The user can enter the amount of time spent (minutes) on a task and a list of entries
containing that amount of time spent is displayed. 
The user can choose one to see details.
  1. Find by keyword
The user can enter a keyword and a list of entries containing that keyword in task name 
or notes is displayed. The user can choose one to see details.
  • The search logic can be found in tools.py

  • A 51% of the code logic is covered by tests using coverage.py. The results can be found here

To run the application type:

python3 work_log_sql.py

Enjoy! :shipit:

work_log_database's People

Contributors

aaronmilloro avatar

Watchers

 avatar

Recommend Projects

  • React photo React

    A declarative, efficient, and flexible JavaScript library for building user interfaces.

  • Vue.js photo Vue.js

    ๐Ÿ–– Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.

  • Typescript photo Typescript

    TypeScript is a superset of JavaScript that compiles to clean JavaScript output.

  • TensorFlow photo TensorFlow

    An Open Source Machine Learning Framework for Everyone

  • Django photo Django

    The Web framework for perfectionists with deadlines.

  • D3 photo D3

    Bring data to life with SVG, Canvas and HTML. ๐Ÿ“Š๐Ÿ“ˆ๐ŸŽ‰

Recommend Topics

  • javascript

    JavaScript (JS) is a lightweight interpreted programming language with first-class functions.

  • web

    Some thing interesting about web. New door for the world.

  • server

    A server is a program made to process requests and deliver data to clients.

  • Machine learning

    Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.

  • Game

    Some thing interesting about game, make everyone happy.

Recommend Org

  • Facebook photo Facebook

    We are working to build community through open source technology. NB: members must have two-factor auth.

  • Microsoft photo Microsoft

    Open source projects and samples from Microsoft.

  • Google photo Google

    Google โค๏ธ Open Source for everyone.

  • D3 photo D3

    Data-Driven Documents codes.