DFS_Portfolio_Manager / database_queries.py

Commit History

Forgot to add for Showdown.
cf7e2fd

James McCool commited on

Trying to import locked teams for NBA based on live scoring instead of using a multi-select for re-optimization.
7387bd7

James McCool commited on

Had the wrong designation for the minutes; probably should call them.
15b8e12

James McCool commited on

Added Minutes maps from NBA as well as Minutes exclusions, similar to the Grid exclusions for NASCAR.
e99f0bf

James McCool commited on

Had to change the variable from median to ceiling to match Optimals.
c01b860

James McCool commited on

Updating the database_queries for NASCAR to be for slate-specific.
c601cc3

James McCool commited on

ping
62ea802

James McCool commited on

Change the way that database querying works for NASCAR.
0f71e89

James McCool commited on

Fixing secondary and late slate for NBA for FanDuel.
b7166c4

James McCool commited on

Aiming to add grid exclusion option for NASCAR.
b49ec26

James McCool commited on

Add opponent mapping and conflict checks in exposure spread and lineup optimization functions; refactor data loading for MMA projections
4314382

James McCool commited on

Updating PGA for DK/DF availbaility
fac0021

James McCool commited on

Adding some NASCAR support including database_queries and positional stuff.
99e3301

James McCool commited on

fixing some PGA showdown stuff
848c292

James McCool commited on

Add initial load info and filters in app.py; refine slate filtering in database queries for NBA and NHL baselines to enhance data accuracy.
a477dfc

James McCool commited on

Refactor app logic by removing redundant comments and enhancing data filtering in database queries for NBA and NHL baselines. Updated slate filtering to ensure accurate data retrieval based on the selected slate variable.
38c37f0

James McCool commited on

Refactor database queries to remove unnecessary 'Team_count' filtering, ensuring valid lineup retrieval across multiple sports
b60f2be

James McCool commited on

Update database queries to correct 'Team_count' filtering syntax for valid showdown lineups
c844a90

James McCool commited on

Refine database queries to restrict 'Team_count' to a maximum of 2 for valid showdown lineups
a31482b

James McCool commited on

Fixing database queries to return only valid showdown lineups
9d65b2e

James McCool commited on

Adding exclusions from exposure management, fixing some database query stuff
67eb3a1

James McCool commited on

Refactor salary column references in database queries to use consistent capitalization for 'Salary' across all sports functionalities.
8816f53

James McCool commited on

Refactor salary column references in database queries to use lowercase 'salary' for consistency across NFL, NBA, and PGA functionalities.
25c1968

James McCool commited on

implementing salary restraints on db calls
526342c

James McCool commited on

Adding PGA functionality
68a1d9b

James McCool commited on

wrong collection
6c2adfb

James McCool commited on

Update MMA baseline query to include 'CPT_Own' in the data frame
76b23f3

James McCool commited on

Adding MMA support
548fe2e

James McCool commited on

Add timezone handling for current date in salary retrieval functions across NFL, NBA, MLB, and NHL
9d012a3

James McCool commited on

no need to adjust salary scaling for NBA
3d7387a

James McCool commited on

Addressing salary scaling issues
5d189ce

James McCool commited on

Adding showdown support
91652d3

James McCool commited on

correcting database pull
f71b29d

James McCool commited on

database query oopsies
6a00be6

James McCool commited on

introducing NBA functions
08ef694

James McCool commited on

ping
f59a7f1

James McCool commited on

Update init_nfl_baselines function to handle slate variable mapping
c08b1bb

James McCool commited on

Add user-configurable options for lineup generation in Data Load tab
525cd79

James McCool commited on

ah yeah
649f608

James McCool commited on

Enhance projections file upload functionality by adding a selection option for sourcing projections from either 'User Upload' or 'Paydirt DB'. Update init_nfl_baselines function to accept additional parameters for site and slate, and filter projections based on these parameters, improving data handling and user experience.
b44c733

James McCool commited on

reg to calssic
bef746a

James McCool commited on

Adding some database support
d323d4b

James McCool commited on