Python Programming 85 - Updating and Deleting Books through Console App

preview_player
Показать описание


~~~~~~~~~~~~~~~ CONNECT ~~~~~~~~~~~~~~~

~~~~~~~~~~~~~~ SUPPORT ME ~~~~~~~~~~~~~~

🅑 Bitcoin - 3HnF1SWTzo1dCU7RwFLhgk7SYiVfV37Pbq
🅔 Eth - 0x350139af84b60d075a3a0379716040b63f6D3853
  1. Caleb Curry
  2. python
  3. tutorial series
  4. tutorial
  5. programming
  6. code
Рекомендации по теме
Python Programming 85 0:08:36

Python Programming 85 - Updating and Deleting Books through Console App

Creating command line 0:18:32

Creating command line utility in python | Python Tutorial - Day #85

Day 85 : 0:00:53

Day 85 : Desktop Notification with Python

Python Update, Delete 0:06:28

Python Update, Delete and Select

Python - Access 0:05:43

Python - Access Update & Delete List

Python Pandas Tutorial 0:40:03

Python Pandas Tutorial (Part 5): Updating Rows and Columns - Modifying Data Within DataFrames

Python in VS 0:03:12

Python in VS Code - Release News v1.85

Delete data from 0:04:28

Delete data from list : Python tutorial 85

Easy Google Sign-in 0:15:57

Easy Google Sign-in Integration (One-Tap) using JavaScript and Python | Shariq Shaukat

Adding Updating List 0:07:34

Adding Updating List In Python (Delete Item From A List In Python 8)

How to use 0:00:22

How to use Update list in Python . Unique and effective way .

Python - If 0:00:35

Python - If and else condition | intro | #shorts #amplifyabhi | py 85

ChatGPT outperforms 85% 0:10:21

ChatGPT outperforms 85% of the 4m programmers assessed on Python on LinkedIn

Python 3.7: Update 0:03:45

Python 3.7: Update Objects In A List In Python

List Data Type 0:19:26

List Data Type in Python Programming | Inserting, Updating and Deleting List Item in List in Python

How to run 0:09:12

How to run Python in Visual Studio Code on Windows 10/11 [ 2024 Update ] Python Developers

How to Install 0:04:02

How to Install Python 3.11.1 on Windows 10/11 [ 2023 Update ] Complete Guide

How to Install 0:05:19

How to Install Python 3.12.4 on Windows 10/11 [2024 Update] Complete Guide | Hello World Python Code

How to update 0:01:00

How to update or change Tuple #python #TechnoDexterous #tuple #list #shorts #programming #tricks

How to Install 0:04:15

How to Install Python 3.12.5 on Windows 10/11 [2024 Update] Complete Guide | Hello World Python Code

Day 85 🔥 0:05:09

Day 85 🔥 | 100DaysofCode | Tamil | Tech Siddhar | Python Programming #TS

85b - An 0:21:16

85b - An introduction to autoencoders - in Python

How to Install 0:04:17

How to Install Python 3.11.4 on Windows 11 [ 2023 Update ] Complete Guide

SQL Joins: Part 0:22:56

SQL Joins: Part #85 Python API Course

Комментарии
Автор

About this funky code at 3:20 : you can do it in a different yet more compact way:
title = input("What is the current title? ")
pages = input("What is the current no of pages? ")

uchicha
Автор

I’m first today but I swear I no nothing about programming but I wanna learn

bfoster
Автор

for updating i found this to be a lot better

def update_book(title:str, updated_title:str, updated_pages:int):
c = get_cursor()
with c.connection:
c.execute("SELECT rowid FROM books WHERE title=? LIMIT 1 ", (title, ))
row = c.fetchone()
c.execute("UPDATE books SET title =?, pages =? WHERE rowid =?", (updated_title, updated_pages, row[0], ))
c.connection.close()

this way you don't need to know the current page. it uses the current title to find the rowid which is then used to do the update

JoshStasio
Автор

Great series! You still need to close the connection even if you are using "with c.connection"?

etienneb
Автор

Can you please make Robinhood stock trading app or GeForce now cloud gaming from nivida in java Android studio if you can

joshuaadinku
join shbcf.ru