Having got monumentally pissed off at an excel spreadsheet we've used historically, I've decided to write my family a program that will manage what revel/humbrol etc. paints we need to buy in order to complete the vast collection of model kits we've bought over the years. The main body of it is a (mostly kinda) normalised database, but there are a couple of features I want that seemed to complicated to implement in MS Access, and as most computers my family use don't have Access anyway, it would have been silly. Therefore, as I know it best and it'll run on anything, I'm using Java.
It stores the following:
Paint - Each paint has a manufacturer, a number/code to identify it, an official name (e.g. black), and a finish.
Tin - Each tin is of a particular kind of paint, so has a manufacturer and code to link back. It can be acrylic or enamel, so there's a boolean to store if it's acrylic, and it's also got an approximate amount left, as it'd be silly to try and paint a huge kit if we've only got a drop of paint, and it's a pain when you get back from the shop to find the one colour you didn't buy has practically run out.
Need - A need is for a particular paint, so again has the manufacturer and code to link back, and has a boolean to say whether acrylic will do, and another to say whether enamel will do. Unfortunately, enamel paints are smelly and will ruin the airbrush my dad bought on a whim, and make up most of the paints we already have. This means that sometimes we can only use one of the types.
Equivalence - There are some colours multiple kit manufacturers both use, so they both make. That means I need to store a list of equivalents from other manufacturers for each paint.
I've also got two other classes so far, one for handling file IO, which has generic read and write methods that I've used before and know work, and another which wraps a HashMap holding the equivalences.
Anyway, this is the first thing I've ever written that I've ever put on GitHub, so if anyone's interested in finishing it all for me, it's at https://github.com/AnyOldName3/Paint-Manager
It stores the following:
Paint - Each paint has a manufacturer, a number/code to identify it, an official name (e.g. black), and a finish.
Tin - Each tin is of a particular kind of paint, so has a manufacturer and code to link back. It can be acrylic or enamel, so there's a boolean to store if it's acrylic, and it's also got an approximate amount left, as it'd be silly to try and paint a huge kit if we've only got a drop of paint, and it's a pain when you get back from the shop to find the one colour you didn't buy has practically run out.
Need - A need is for a particular paint, so again has the manufacturer and code to link back, and has a boolean to say whether acrylic will do, and another to say whether enamel will do. Unfortunately, enamel paints are smelly and will ruin the airbrush my dad bought on a whim, and make up most of the paints we already have. This means that sometimes we can only use one of the types.
Equivalence - There are some colours multiple kit manufacturers both use, so they both make. That means I need to store a list of equivalents from other manufacturers for each paint.
I've also got two other classes so far, one for handling file IO, which has generic read and write methods that I've used before and know work, and another which wraps a HashMap holding the equivalences.
Anyway, this is the first thing I've ever written that I've ever put on GitHub, so if anyone's interested in finishing it all for me, it's at https://github.com/AnyOldName3/Paint-Manager
OS: Windows 10 64 bit Professional
CPU: AMD Ryzen 5900X
RAM: 16GB
GPU: Radeon Vega 56
CPU: AMD Ryzen 5900X
RAM: 16GB
GPU: Radeon Vega 56