Advertisement database system
Explore the docs »

Report Bug · Request Feature

This program creates a database of advertisements that accepts the name of the advertisement, the name of the client, the start and the end dates and the investment per day in BRL. You can create reports on each entry filtered by client and period of time.

• Peewee
• SQLite
• Schema
• python-tabulate
• pytest

You will need pip to install the packages. It's strongly recommended that you use a virtual environment. Developed in Python 3.7.3.

1. Clone the repo

   git clone https://github.com/Aledosim/adreg.git

2. Enter the directory

   cd adreg

3. Install the packages after activate the virtual environment

   pip install -r requirements.txt

Run the adreg shell script that lives in the root directory. You can't run it out of this location (it's in beta version yet). It will create the database file in root folder as well.

At the root directory:

./adreg add -n NAME -c CLIENT -s START -e END -i INVESTMENT

Being that:

• NAME: the name of the advertisement
• CLIENT: the client name
• START: the starting date in the format dd-mm-yyyy
• END: the ending date in the format dd-mm-yyy
• INVESTMENT: the investment per day

The START parameter defaults to the current day, you can omit it.

You can visualize the reports with

./adreg report

To filter the results, use the optional parameters

./adreg report -c CLIENT -s START -e END

Being that:

• CLIENT: the client name
• START: starting date in the format dd-mm-yyyy
• END: ending date in the format dd-mm-yyy On this command, END defaults to the current day and his value can be omitted.

You can add the -h flag on the commands to see the informations.

To run the tests execute on the root directory:

pytest

Distributed under the GPL3 License. See LICENSE for more information.

Alexandre do Sim - LinkedIn - [email protected]

Checkout my git projects: https://github.com/Aledosim

This application is part of Capgemini Brasil's trainee selection program.

• Implement config module (not fully done)
• Make list and delete functionalities
• Prettier output