mrbusche / trap-scoring Goto Github PK

This issue lists Renovate updates and detected dependencies. Read the Dependency Dashboard docs to learn more.

This repository currently has no open or pending branches.

Detected dependencies

• Check this box to trigger a request for Renovate to run again on this repository

top 3 scores, must have 2 locations and only 1 can be a five stand

I have MySQL running locally and have set it up using the below tables (plus many more). The application runs fine locally, but I'm trying to convert this to mariaDB, so it can run on anyone's computer easily. The error I receive is

org.springframework.beans.factory.BeanCreationException: 
Error creating bean with name 'entityManagerFactory' defined in class path resource [org/springframework/boot/autoconfigure/orm/jpa/HibernateJpaConfiguration.class]: 
Initialization of bean failed; nested exception is org.springframework.jdbc.datasource.init.ScriptStatementFailedException: 
Failed to execute SQL script statement #3 of URL 
[file:/C:/scoring/out/production/resources/data.sql]: 
CREATE OR REPLACE VIEW singlesAggregate AS 
SELECT athlete, classification, gender, team, SUM(total) total 
FROM ( 
  SELECT athlete, classification, gender, total, team 
  FROM singlesData 
) AS a 
GROUP BY athlete, classification, gender ORDER BY total DESC;
nested exception is java.sql.SQLException: 'trap.singlesaggregate' is not VIEW

The tables/views I've create up to this point are

CREATE OR REPLACE VIEW singlesAggregate AS
SELECT athlete, classification, gender, team, SUM(total) total
FROM (
  SELECT athlete, classification, gender, total, team
  FROM singlesData
) AS a
GROUP BY athlete, classification, gender
ORDER BY total DESC;

The problem is mariaDB doesn't accept `CREATE OR REPLACE VIEW` it needs to be `CREATE VIEW IF NOT EXISTS`

Looks like we may have a couple errors:
Looks like Sporting Clays Team score is incorrect. Should only total up to 450 for team score right? 3 squad members with a max personal score of 150.
Looks like same for Sporting Clays individual scores. Is shows totals past 150.
Skeet should match btw. Looks like it dies, but didn’t want to assume

I really like the sheet from last year that showed what scores used in the calculations on the clean data sheet. Would it be possible to get that back? I think it was a column called TOP5, if I remember correctly.

• Creating a report for the new 5-Stand league (same business rule as sporting clays, 3 events from at least 2 different facilities)
• Removing the 5-stand calculation component and any references from the existing sporting clays league.
• Updating the excel report headers to "2022 State League Standings"
• The new report for 5-stand is here: https://metabase.sssfonline.com/public/question/3c5aecf2-a9f2-49b2-a11f-36965cb1a964

https://medium.com/faun/continuous-integration-of-java-project-with-github-actions-7a8a0e8246ef

and is less than 24 hours old

There is an error with this repository's Renovate configuration that needs to be fixed. As a precaution, Renovate will stop PRs until it is resolved.

File: renovate.json
Error type: Invalid JSON (parsing failed)
Message: Syntax error: expecting String near ], ignor

Links are in the README