Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Here is some data on chainsaw juggling records, Chainsaw Juggling Record Holders as of July 2018 Country Number of catches Name Janne Mustonen Finland

Here is some data on chainsaw juggling records, Chainsaw Juggling Record Holders as of July 2018 Country Number of catches Name Janne Mustonen Finland 98 Ian Stewart Canada 94 Aaron Gregg Canada 88 Chad Taylor USA 78 EITHER part 1: Simple SQLite application. Build a Python application which stores the following example data in a SQLite database. Use the sqlite3 library, and write SQL statements. Your program should let the user search for a record holder, by name Your program should display all the record holders in the database Your program should let the user add a new row for a record holder. You should be able to update the number of catches for a record holder. And, you should be able to delete a record, by record holder's name (for example, if a person's record was found to be invalid). Use parameterized statements where appropriate. OR Part 2: Peewee. Build the same program but use Peewee. You should still be able to add, edit, insert, and delete records from your database. To think about: how are the two ways to interact with a database different? Which do you prefer? When might you use one, and when might you use the other?

Step by Step Solution

3.39 Rating (161 Votes )

There are 3 Steps involved in it

Step: 1

Answer SOURCE CODE import sqlite3 def createtable conn sqlite3connectchainsawjugglingdb c conncursor ... blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Income Tax Fundamentals 2013

Authors: Gerald E. Whittenburg, Martha Altus Buller, Steven L Gill

31st Edition

1111972516, 978-1285586618, 1285586611, 978-1285613109, 978-1111972516

More Books

Students also viewed these Programming questions