Timeline for Execute select on sqlite db using pythonic data
Current License: CC BY-SA 3.0
5 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| Feb 24, 2016 at 15:04 | vote | accept | v18o | ||
| Feb 24, 2016 at 14:59 | comment | added | alecxe | @Tbizzness great point. Completely agree, we need a parameterized query, updated - thanks! | |
| Feb 24, 2016 at 14:59 | history | edited | alecxe | CC BY-SA 3.0 |
deleted 5 characters in body
|
| Feb 24, 2016 at 14:57 | comment | added | Tbaker | I believe that % is the wild card in SQLite, and looking at the query it would make more sense to write it as: (‘SELECT teams_stats_in_game.rebounds FROM teams_stats_in_game INNER JOIN games ON games.id = teams_stats_in_game.game_id AND games.home_team_id = teams_stats_in_game.team_id WHERE games.home_team_id = ? AND games.season_type = ? AND games.season = ? AND games.date_est < ? ORDER BY games.date_est DESC""" ?’, [team_id, season_type, season, game_date]) | |
| Feb 24, 2016 at 14:55 | history | answered | alecxe | CC BY-SA 3.0 |