akhawer875/cricket-data-dashboard
so this data is in SQLite database, I want to connect that data and create an advance dashboard which can be used by the users
cr.execute("CREATE TABLE IF NOT EXISTS deliveries (_uid INTEGER PRIMARY KEY, Matchid INTEGER, inningNumber INTEGER, ballsActual REAL, ballsUnique REAL, oversUnique REAL, oversActual REAL, overNumber INTEGER, ballNumber INTEGER, totalRuns INTEGER, batsmanRuns INTEGER, isFour BOOLEAN, isSix BOOLEAN, isWicket BOOLEAN, dismissalType TEXT, byes INTEGER, legbyes INTEGER, wides INTEGER, noballs INTEGER, penalties INTEGER, wagonX INTEGER, wagonY INTEGER, wagonZone INTEGER, pitchLine TEXT, pitchLength TEXT, shotType TEXT, shotControl REAL, timestamp INT, batsmanPlayer TEXT, nonStrikerPlayer TEXT, bowlerPlayer TEXT, outPlayer TEXT, totalInningRuns INTEGER, totalInningWickets INTEGER, predictedScore INTEGER, predictedWinProbability REAL, BattingTeam TEXT, BowlingTeam TEXT, winner TEXT, BatFirst TEXT, Venue TEXT, matchTimeStamp INT, series TEXT, BatterbattingStyleLong TEXT, bowlingPaceSpin TEXT,bowlingStyleLong TEXT, isBatterCap INT, isBowlerCap INT, BatterAgeYears INT, BatterAgeDays INT,BowlerAgeYears INT, BowlerAgeDays INT);")
initial commit
