![subject](/tpl/images/cats/informatica.png)
Computers and Technology, 22.02.2021 18:50 Amyra2003
Given is a Python program that connects to a sqlite database and has one table called writers with two columnns:
name - the name of a writer
num - the number of works the writer has written
The writers table originally has the following data:
name, num
Jane Austen,6
Charles Dickens,20
Ernest Hemingway,9
Jack Kerouac,22
F. Scott Fitzgerald,8
Mary Shelley,7
Charlotte Bronte,5
Mark Twain,11
Agatha Christie,73
Ian Flemming,14
J. K. Rowling,14
Stephen King,54
Oscar Wilde,1
Update the Python program to ask the user if they want to update entries or add new entries. If the name entered already exists in the writers table then the database record is updated, overwriting the original contents. If the name does not exist in the writers table, then add a new record with the writer's name and number of works. The following TODO sections must be completed.
Check if a writer exists in the writers table
If the writer exists in the table, locate an entry to be updated by writer's name and update the writer's value for num
If the writer does not exist in the table, add a new entry in the writers table and provide the value for name and num
Ex: If the input is:
y
J. K. Rowling
30
y
Elton John
y
62
n
The output is:
(ID, Name, Num)
(1, 'Jane Austen', 6)
(2, 'Charles Dickens', 20)
(3, 'Ernest Hemingway', 9)
(4, 'Jack Kerouac', 22)
(5, 'F. Scott Fitzgerald', 8)
(6, 'Mary Shelley', 7)
(7, 'Charlotte Bronte', 5)
(8, 'Mark Twain', 11)
(9, 'Agatha Christie', 73)
(10, 'Ian Flemming', 14)
(11, 'J. K. Rowling', 30)
(12, 'Stephen King', 54)
(13, 'Oscar Wilde', 1)
(14, 'Elton John', 62)
![ansver](/tpl/images/cats/User.png)
Answers: 3
![](/tpl/images/ask_question.png)
![](/tpl/images/ask_question_mob.png)
Another question on Computers and Technology
![question](/tpl/images/cats/informatica.png)
Computers and Technology, 22.06.2019 05:30
Agood flowchart alludes to both the inputs and outputs you will need to receive and give to the user. true or false?
Answers: 3
![question](/tpl/images/cats/informatica.png)
Computers and Technology, 22.06.2019 07:30
In the film "epic 2015," epic is the name for:
Answers: 3
![question](/tpl/images/cats/informatica.png)
Computers and Technology, 23.06.2019 06:00
Which statistical function in a spreadsheet you to see how far each number varies, on average, from the average value of the list?
Answers: 2
![question](/tpl/images/cats/informatica.png)
Computers and Technology, 23.06.2019 06:00
When is a chart legend used a. all the time b. whenever you are comparing data that is the same c. whenever you are comparing multiple sets of data d. only for hand-drawn charts
Answers: 2
You know the right answer?
Given is a Python program that connects to a sqlite database and has one table called writers with t...
Questions
![question](/tpl/images/cats/User.png)
![question](/tpl/images/cats/User.png)
![question](/tpl/images/cats/User.png)
SAT, 16.03.2022 07:40
![question](/tpl/images/cats/mat.png)
![question](/tpl/images/cats/User.png)
![question](/tpl/images/cats/mat.png)
Mathematics, 16.03.2022 07:50
![question](/tpl/images/cats/fizika.png)
![question](/tpl/images/cats/informatica.png)
Computers and Technology, 16.03.2022 07:50
![question](/tpl/images/cats/mat.png)
![question](/tpl/images/cats/biologiya.png)
![question](/tpl/images/cats/en.png)
English, 16.03.2022 07:50
![question](/tpl/images/cats/mat.png)
Mathematics, 16.03.2022 07:50
![question](/tpl/images/cats/User.png)
![question](/tpl/images/cats/obshestvoznanie.png)
Social Studies, 16.03.2022 07:50
![question](/tpl/images/cats/mat.png)
Mathematics, 16.03.2022 07:50
![question](/tpl/images/cats/obshestvoznanie.png)
![question](/tpl/images/cats/ekonomika.png)
![question](/tpl/images/cats/obshestvoznanie.png)
![question](/tpl/images/cats/fizika.png)
![question](/tpl/images/cats/mat.png)
Mathematics, 16.03.2022 07:50