dtookey
|
0fadeef609
|
added new lines to try and avoid a weird import bug
|
4 years ago |
|
dtookey
|
f647382b90
|
Forgot a drop if exists in 0-functions.sql
|
4 years ago |
|
dtookey
|
0fec39392a
|
apparently calling functions is SUPER slow
|
4 years ago |
|
dtookey
|
d3fb3c3038
|
Renamed 1-sanitize.sql in order to remove user tokens and whatnot before the slow queries.
|
4 years ago |
|
dtookey
|
6d65d76fb2
|
first round of billing.sql is finished. It runs a bit slow and it de-normalizes the data, but I think it's relatively 'safe'
|
4 years ago |
|
dtookey
|
e3ee6e286d
|
Updated the event_counts table in lifecycle.sql to collapse warranty projects down into Soils/Str instead of Soils/Str/Warranty
|
4 years ago |
|
dtookey
|
94206477cb
|
changed formatting in sanitize.sql to use uppercase sql keywords.
|
4 years ago |
|
dtookey
|
fea7142f45
|
updated sanitize.sql to run on stale data
|
4 years ago |
|
dtookey
|
4fa8a33b1a
|
Tweaked all_projects.sql to run on stale data.
|
4 years ago |
|
dtookey
|
9f300305c5
|
added division column to the event_counts table in lifecycle.sql.
|
4 years ago |
|
dtookey
|
a551f9321c
|
added first round of lifecycle processing.
added minor lifecycle cleanup to sanitize.sql.
|
4 years ago |
|
dtookey
|
14497754f5
|
first round of all_projects table generation. this is entirely hardcoded, so it ain't future proof. We need a way to do this programmatically.
|
4 years ago |
|
dtookey
|
1106b38346
|
cleaned up import.sh to have a bit better flow (also trying to troubleshoot ```./update-datastudio: line 5: /home/clarity: Is a directory```)
|
4 years ago |
|
dtookey
|
37a9a0ec52
|
cleaned up import.sh to have a bit better flow (also trying to troubleshoot ```./update-datastudio: line 5: /home/clarity: Is a directory```)
|
4 years ago |
|
dtookey
|
b0030323a7
|
better way of handling gluing *.sql scripts together in import.sh
|
4 years ago |
|
dtookey
|
1ed99c5ef9
|
tweaked import.sh to make the linter a bit more happy
|
4 years ago |
|
dtookey
|
3f8cd57183
|
basic proof of concept. just need it to run tonight
|
4 years ago |
|
dtookey
|
78a441ff9e
|
changed proof to import.sh. this is just going to make it clearer which direction to proceed tomorrow
|
4 years ago |
|
dtookey
|
a8409692e2
|
adding a proof script to make sure the automation works correctly
|
4 years ago |
|
dtookey
|
c0a0e29df1
|
initial commit
|
4 years ago |