mrbusche / trap-scoring Goto Github PK
View Code? Open in Web Editor NEWAggregates totals from the Shot system into an excel spreadsheet
License: MIT License
Aggregates totals from the Shot system into an excel spreadsheet
License: MIT License
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.
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.
.github/workflows/daily-standings.yml
actions/checkout v4@692973e3d937129bcbf40652eb9f2f61becf3332
actions/setup-java v4
gradle/actions v4
actions/upload-artifact v4
.github/workflows/gradle.yml
actions/checkout v4@692973e3d937129bcbf40652eb9f2f61becf3332
actions/setup-java v4
gradle/actions v4
settings.gradle.kts
build.gradle.kts
org.springframework.boot 3.4.0-M2
io.spring.dependency-management 1.1.6
org.apache.poi:poi-ooxml 5.3.0
com.opencsv:opencsv 5.9
gradle/wrapper/gradle-wrapper.properties
gradle 8.10
Links are in the README
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
top 3 scores, must have 2 locations and only 1 can be a five stand
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
and is less than 24 hours old
A declarative, efficient, and flexible JavaScript library for building user interfaces.
🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.
TypeScript is a superset of JavaScript that compiles to clean JavaScript output.
An Open Source Machine Learning Framework for Everyone
The Web framework for perfectionists with deadlines.
A PHP framework for web artisans
Bring data to life with SVG, Canvas and HTML. 📊📈🎉
JavaScript (JS) is a lightweight interpreted programming language with first-class functions.
Some thing interesting about web. New door for the world.
A server is a program made to process requests and deliver data to clients.
Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.
Some thing interesting about visualization, use data art
Some thing interesting about game, make everyone happy.
We are working to build community through open source technology. NB: members must have two-factor auth.
Open source projects and samples from Microsoft.
Google ❤️ Open Source for everyone.
Alibaba Open Source for everyone
Data-Driven Documents codes.
China tencent open source team.