dtookey
/
mercury
1
0
Fork 0
Code Issues Pull Requests Projects Releases Wiki Activity

Commit Graph

  • 2c92a99f58 cheap hack for preserving some lifecycle information for the moriarty project master dtookey 2023-08-23 13:44:10 -0400
  • 1cb6ee49e4 Added a review_contributions table for the different reviewed statuses dtookey 2023-08-07 12:53:37 -0400
  • e37c1e3a34 Added a review_contributions table for the different reviewed statuses dtookey 2023-08-07 12:51:46 -0400
  • 08e3aaafe3 Added a review_contributions table for the different reviewed statuses dtookey 2023-08-07 12:29:08 -0400
  • 3b0cb09fbb scoured out all_projects dtookey 2023-07-19 08:59:02 -0400
  • bdd97bcae9 updated data structures to hopefully match clarity dtookey 2023-07-19 08:55:52 -0400
  • b5de485fa3 tweaks to all projects view construction. - happy new year dtookey 2023-07-10 15:05:10 -0400
  • 7cf9b6cca8 fixed weird issue with timesheet reports dtookey 2023-03-01 15:19:07 -0500
  • 9a1adf6bd3 tweaks to all projects view construction. - happy new year dtookey 2023-01-06 16:25:24 -0500
  • 72e50e3e49 tweaks to all projects view construction. change to paycor hours to eliminate need for joining inside of looker dtookey 2023-01-03 09:37:53 -0500
  • cab8898dd0 tweaks to all projects view construction. dtookey 2022-12-07 09:17:48 -0500
  • 331867ee4e added wilmington to clarity vitals dtookey 2022-12-06 10:17:35 -0500
  • 2958b3124e literally one line of function documentation... dtookey 2022-12-02 14:49:51 -0500
  • f3446b5c08 cleaned up some procedure logic in paycor.go and added documentation to csvWorker.go dtookey 2022-11-08 13:22:39 -0500
  • a87213d98f basic pipeline from the driver project through to the database at data-connect is working. dtookey 2022-11-02 17:45:45 -0400
  • 5c63b01fb6 migration from legacy report to new report hours are complete. dtookey 2022-11-02 16:10:38 -0400
  • 11d3ca3e6d new interface/worker to accelerate csv parsing. define the struct, write a mapping function, and baby -- you got a stew goin'. dtookey 2022-11-01 16:54:13 -0400
  • b6d9f3e9fd data structures for the new timesheet reports are created and the parsing logic should be okay. still need to test for typos/bugs dtookey 2022-09-21 14:39:55 -0400
  • 8e6a2f376d first draft of timesheet reports. still need to modify all existing reports to match up to the schema of what's actually coming out from HR lately. dtookey 2022-09-19 14:43:22 -0400
  • bc0c38745d added failed review checking to table reset logic. dtookey 2022-06-22 14:44:24 -0400
  • e6798bb339 tweaked script formatting dtookey 2022-06-22 13:53:14 -0400
  • 8a64255a89 added view for project kickbacks dtookey 2022-06-22 13:51:27 -0400
  • 3a48e7e033 fixed Account receivables report. dtookey 2022-06-15 13:52:39 -0400
  • 5e28da9c17 Added Blocker (for turning objects into 'blocks' of query text) interface in database-primitives.go along with an ExecuteString method for *ConnectorGenerics that will take a file name and run a concatenated query. This VASTLY improves insert times. dtookey 2022-06-09 09:27:17 -0400
  • 6fd8e8bd39 Added some status Printlns. Added parametric header skipping in processTrialBalance in csv.go. Began earnest work on a sustainable verizon pipeline. dtookey 2022-06-07 17:05:08 -0400
  • 791ca84414 Removed debugging lines from GetTimeAllTimeEntriesForUserThroughDate, but kept the non-200 response code debugging line. Modified insight-connect.go to only capture time entry data from engineering users. Added line for updating some finance info into the main mercury.go routine, but it's commented out until the delivery pipeline gets sorted out. dtookey 2022-05-19 09:56:43 -0400
  • c7e92d9fa0 added some debug printing to the logs. Swapped the order of some things in 1-sanitize_init.sql in hopes to speed up the import/processing times. dtookey 2022-05-18 09:44:57 -0400
  • 909509d2c5 fixed a bone-headed mistake naming the files. hopefully the symptom was corrected. I'll get to work on the cause. dtookey 2022-05-12 10:00:02 -0400
  • 05e21fda8e migrated the sql scripts from the clarity-vitals project dtookey 2022-05-12 09:56:08 -0400
  • d36464aa8a AR aging reports can be scanned from a file and updated on the datastudio server. However, this is a highly-manual process. we need to work on automation next. dtookey 2022-05-10 12:37:43 -0400
  • f7b56120ea refactoring lead to a successful run. However, when running from my home computer, the insight update took approx. 25 minutes. We should add some benchmarking features tomorrow and get a better sense of how long runs actually take. dtookey 2022-05-05 17:09:21 -0400
  • e5924caefc changed "DBConnectorGeneric" to "ConnectorGeneric" to avoid clashing with the package name. dtookey 2022-05-05 16:27:58 -0400
  • 71552ec88e renamed "util" package to "db" to better reflect the fact that's all that the package does. It also makes site calls to things such as db.BulkUpdate() much more clear. dtookey 2022-05-05 16:26:38 -0400
  • 96f4eae410 SQL scripts that mostly handle the administration of databases and tables has been moved into database-primitives.go, and executed via the "runner" pattern that we came up with. dtookey 2022-05-05 16:24:30 -0400
  • 1a16e1ba38 tweaked one function call to be uppercase. dtookey 2022-05-05 11:28:16 -0400
  • 26c4ba93d3 beginning work on picture timestamp correlation dtookey 2022-05-04 16:51:02 -0400
  • dc6ba5a8ce debugging finished. we are back to pre-refactor parity dtookey 2022-05-04 12:01:11 -0400
  • f48bde1e61 Debugging new schema dtookey 2022-05-04 11:53:15 -0400
  • e40a72f38e refactoring of the database is complete and a lot more clean. It is currently untested, so we'll kick off the inaugural scan here in a minute. dtookey 2022-05-04 11:51:20 -0400
  • f1a149ee52 updated gitignore dtookey 2022-05-03 15:52:41 -0400
  • 019c9f16d7 removed a hard coded date string in the UpdateTimeEntries method on the Interconnect struct dtookey 2022-05-03 09:30:45 -0400
  • 9246c1a5bb replaced all error-fed fatal logs with errors instead of fatalln dtookey 2022-05-02 14:22:03 -0400
  • fb4c7f7bbb The mercury binary is now deployable and *should* run every morning at 2am dtookey 2022-04-29 16:21:53 -0400
  • 400d65b58f changed the insight scraper to get all data for every person, and then create the engineering_contributions table by filtering against clarity user info dtookey 2022-04-29 15:09:45 -0400
  • 7be29424a9 engineering contributions are in a much better, simpler place. dtookey 2022-04-29 13:43:18 -0400
  • accade8dff we have the first round of engineering time from insight in the reports dtookey 2022-04-29 10:41:27 -0400
  • 49e6b7bb73 created abstractions for automatically pulling users and time entries for users. We haven't completed a full successful (the description field in TimeEntry failed at varchar(512), so we've upped it to 4k) run. However, it's currently running and has gotten past the initial hiccup. dtookey 2022-04-28 16:49:04 -0400
  • 7a3f678aa9 initial processing for Trial Balances. dtookey 2022-04-28 15:20:22 -0400
  • 8e105637e3 started work on transferring information to the data-connect database dtookey 2022-04-26 12:39:54 -0400
  • c776278913 started work on a library for pulling project insight data dtookey 2022-04-22 09:04:43 -0400
  • 695eab1276 added a few notes, fixed a few erroneous logging calls to something other than log.X dtookey 2022-04-19 14:02:24 -0400
  • 418fc5f7f2 Initial commit. dtookey 2022-04-18 13:12:57 -0400