Commit Graph

225 Commits

Author SHA1 Message Date
Jim Martens 8d8761d893 Improved coding style
Signed-off-by: Jim Martens <github@2martens.de>
2017-07-12 14:28:01 +02:00
Jim Martens c95234c4ca Moved main method to top and removed obsolete parameter
Signed-off-by: Jim Martens <github@2martens.de>
2017-07-12 14:27:20 +02:00
Jim Martens 143aec106c Removed obsolete type specification
Signed-off-by: Jim Martens <github@2martens.de>
2017-07-12 09:37:25 +02:00
Jim Martens 64fd37e53d Improved code style
Signed-off-by: Jim Martens <github@2martens.de>
2017-07-12 09:35:45 +02:00
Hexoka e1c54fd15b Blatt 8 Apriori Alg 2017-07-07 20:39:41 +02:00
Jim Martens bb0fda948c Extended cross table with time and product as grouping elements
Signed-off-by: Jim Martens <github@2martens.de>
2017-07-05 15:03:19 +02:00
Jim Martens 7fb5778e3f Implemented interactivity of cross table
Signed-off-by: Jim Martens <github@2martens.de>
2017-07-05 14:32:57 +02:00
Jim Martens 7eba64459c Extended cross table query to allow different entries for time dimension
Signed-off-by: Jim Martens <github@2martens.de>
2017-07-05 13:51:39 +02:00
Jim Martens e601db107e Extended cross table query to allow different entries for location dimension
Signed-off-by: Jim Martens <github@2martens.de>
2017-07-05 13:34:32 +02:00
Jim Martens 8e4b359762 Extended cross table query to select product dimension
Signed-off-by: Jim Martens <github@2martens.de>
2017-07-04 18:02:07 +02:00
Jim Martens 3945e41a8c Fixed formatting for small column headers
Signed-off-by: Jim Martens <github@2martens.de>
2017-07-04 18:00:53 +02:00
Jim Martens 3e175712c3 Improved table formatting
Signed-off-by: Jim Martens <github@2martens.de>
2017-07-04 17:48:37 +02:00
Jim Martens 69ac94939e Fixed aggregation query
The interesting value for the sales is the nr of sold articles, NOT
the amount of database entries.

Signed-off-by: Jim Martens <github@2martens.de>
2017-07-04 16:56:02 +02:00
Jim Martens a1ce3f4cd4 Removed wrong table header
Signed-off-by: Jim Martens <github@2martens.de>
2017-07-03 18:19:14 +02:00
Jim Martens bd70806586 Implemented first visualization of table
Signed-off-by: Jim Martens <github@2martens.de>
2017-07-03 18:16:50 +02:00
Jim Martens 69f4ac4024 Finished getSalesCrossTable method
Signed-off-by: Jim Martens <github@2martens.de>
2017-07-03 17:46:28 +02:00
Jim Martens 3809749143 Created MainAnalysis class
Signed-off-by: Jim Martens <github@2martens.de>
2017-07-01 10:32:41 +02:00
Jim Martens 6df559a9d5 Created cross table query
Signed-off-by: Jim Martens <github@2martens.de>
2017-07-01 10:32:25 +02:00
Jim Martens e5681a3db6 Added wrapper method for rollback
Signed-off-by: Jim Martens <github@2martens.de>
2017-07-01 09:08:52 +02:00
Jim Martens f4b2efe861 Added console output
Signed-off-by: Jim Martens <github@2martens.de>
2017-06-28 17:03:55 +02:00
Jim Martens 392e671ca5 Implemented load method
Signed-off-by: Jim Martens <github@2martens.de>
2017-06-28 16:55:09 +02:00
Jim Martens b32a382c5c Added wrapper methods for auto commit and commit
Signed-off-by: Jim Martens <github@2martens.de>
2017-06-28 16:54:33 +02:00
Jim Martens 532f54d19a Added method to add sales
Signed-off-by: Jim Martens <github@2martens.de>
2017-06-28 16:52:14 +02:00
Jim Martens a11d922a0e Added methods to add dimension data
Signed-off-by: Jim Martens <github@2martens.de>
2017-06-28 16:49:29 +02:00
Jim Martens f6b181db41 Improved formatting
Signed-off-by: Jim Martens <github@2martens.de>
2017-06-28 16:19:05 +02:00
Jim Martens 0658b39309 Changed earnings to float
Signed-off-by: Jim Martens <github@2martens.de>
2017-06-28 15:52:54 +02:00
Jim Martens 2eaad2996e CSV scanner now skips empty line
Signed-off-by: Jim Martens <github@2martens.de>
2017-06-28 15:52:36 +02:00
Jim Martens 995f01aaa0 Changed earnings to float
Signed-off-by: Jim Martens <github@2martens.de>
2017-06-28 15:51:25 +02:00
Jim Martens b12e921efe Fixed date split regex
Signed-off-by: Jim Martens <github@2martens.de>
2017-06-28 15:51:11 +02:00
Jim Martens b78eebb515 Skipped first line
Signed-off-by: Jim Martens <github@2martens.de>
2017-06-28 15:38:48 +02:00
Jim Martens 0ae6d6ed20 Finished CSV scanner
Signed-off-by: Jim Martens <github@2martens.de>
2017-06-28 15:38:05 +02:00
Jim Martens 58e8e39ee7 Finished extract method
Signed-off-by: Jim Martens <github@2martens.de>
2017-06-28 15:30:11 +02:00
Jim Martens 422669c2ba Finished Date object
Signed-off-by: Jim Martens <github@2martens.de>
2017-06-28 15:30:01 +02:00
Jim Martens 6b441cfb63 Replaced date with dateID
Signed-off-by: Jim Martens <github@2martens.de>
2017-06-28 15:29:45 +02:00
Jim Martens bf5aed1037 Added Main class
Signed-off-by: Jim Martens <github@2martens.de>
2017-06-26 18:11:20 +02:00
Jim Martens 5a18e14ff1 Made scan method static
Signed-off-by: Jim Martens <github@2martens.de>
2017-06-26 18:08:33 +02:00
Jim Martens adf79f425e Added Date class
Signed-off-by: Jim Martens <github@2martens.de>
2017-06-26 18:05:45 +02:00
Jim Martens ff292db655 Added method to get all shops
Signed-off-by: Jim Martens <github@2martens.de>
2017-06-26 18:03:52 +02:00
Jim Martens a3d3c42bf3 Modified Shop to work with transformation
Signed-off-by: Jim Martens <github@2martens.de>
2017-06-26 18:03:39 +02:00
Jim Martens cab0c6a184 Added ORM
Signed-off-by: Jim Martens <github@2martens.de>
2017-06-26 17:58:45 +02:00
Jim Martens f998476513 Modified Article to fit for transformation step
Signed-off-by: Jim Martens <github@2martens.de>
2017-06-26 17:58:30 +02:00
Jim Martens fecc1f0e21 [07] Fixed package path
Signed-off-by: Jim Martens <github@2martens.de>
2017-06-26 17:17:12 +02:00
Jim Martens 2ac2068080 Improved scanner datastructure
Signed-off-by: Jim Martens <github@2martens.de>
2017-06-26 17:05:36 +02:00
Jim Martens 5d599e8334 Added Shop datastructure
Signed-off-by: Jim Martens <github@2martens.de>
2017-06-22 15:29:34 +02:00
Jim Martens 99e8bed4cf Added Article datastructure
Signed-off-by: Jim Martens <github@2martens.de>
2017-06-22 15:20:29 +02:00
Jim Martens 4ad9e7bd95 Added Sale datastructure
Signed-off-by: Jim Martens <github@2martens.de>
2017-06-22 15:16:58 +02:00
Jim Martens b659deabd0 Added CSVScanner
Signed-off-by: Jim Martens <github@2martens.de>
2017-06-22 15:16:36 +02:00
Jim Martens a6a743f7d3 Added connection manager
Signed-off-by: Jim Martens <github@2martens.de>
2017-06-22 14:04:50 +02:00
Jim Martens b007ed2d4f Increased buffer size to 50
Signed-off-by: Jim Martens <github@2martens.de>
2017-05-31 15:48:19 +02:00
Jim Martens 0e87b2918b Fixed typo
Signed-off-by: Jim Martens <github@2martens.de>
2017-05-31 15:39:32 +02:00