Python Intermediate Tutorial #8 - Database Programming

[@hovardlee]

I think the best option to use database is using within context manager. It solves a lot of issues like closing connection:
def count_table():
with sqlite3.connect(DB_NAME) as db:
num_of_rows = db.execute(SQL_COUNT).fetchall()
return num_of_rows[0]

[@dsinghr]

in real world, you would be using something like Pandas or spark dataframes

[@emonymph6911]

The tutorial was so good I will forgive you for using notepad as an IDE.

[@bonsai0076]

That isn’t notepad

[@malikkhan4823]

​@@bonsai0076yes you are right its python idle

[@blocksnmusket]

a

[@Radical9535]

Great use of combining sql with python however if i was a beginner to coding i may be confused by the different syntaxes maybe explain that a bit better we all ought to learn otherwise awesome video!

[@rmediting3349]

yeah i`m currently a beginner to coding and i confused by different syntaxes

[@Machtyn]

Thank you for leaving the mistakes in there.

[@fatemehkhalatbari536]

Hi .l have question. I go to the third step, but it gives me an error(error=databbase is locked).pleas help me🙏🏻

[@jrgomez]

Definitively I love these tutorial series!

[@therealchicken7151]

Bro I love you I am learning java in school and python myself private cause I prefer it by far and here I learn something for both nice ( I focus on python )

[@VíctorAlonsoGarcía-x4h]

The sqlite3 script is very very nice. Could you tell me where to find it in the description. Your video scripts are cool

[@alexw3003]

you should make a discordpy DB tutorial for like warnings and or levels and etc

[@TechMarketer]

Hi Bro, could you tell us more about DB and OOP relations?

[@TobiasLange-n5c]

Thank you for these tutorials

[@rohitdeosthale3604]

why does cursor needs to be defined in class?

[@juniorizcortes6370]

Do we have the same process in creating database tables in oracle and sql?

[@adhilnovandri]

hi bro.
if you open connection database in __init__ function, how to close the connection?

[@hovardlee]

The best option is to use context manager like you can use with file:
def create_table():
with sqlite3.connect(DB_NAME) as db:
db.execute(SQL_CREATE_TABLE)
You do not have to remember to close connection.

[@sebastianquesada3134]

thanks so much my teacher failed to let me know that sql and pyhton have two different syntaxs i was very confused...

[@kvelez]

import sqlite3
class Person:
def __init__(self, usr_id, name, lastname, age) -> None:
self.usr_id = usr_id
self.name = name
self.lastname = lastname
self.age = age
self.connection = sqlite3.connect('python_sql.db') # generates db file in dir.
self.cursor = self.connection.cursor() # rm db and execute again if many vals appear.
def load_person(self, usr_id):
self.cursor.execute(f"""
SELECT * FROM persons
WHERE id = {usr_id}
""")
results = self.cursor.fetchone()
self.usr_id = usr_id
self.name = results[1]
self.lastname = results[2]
self.age = results[3]
connection = sqlite3.connect('mydata.db') # generates db file in dir.
cursor = connection.cursor() # rm db and execute again if many vals appear.
#SQL commands / code
cursor.execute("""
CREATE TABLE IF NOT EXISTS persons (
id INTEGER PRIMARY_KEY,
first_name TEXT,
last_name TEXT,
age INTEGER
)
""")
#SQL input values
cursor.execute("""
INSERT INTO persons VALUES
(1, 'Paul', 'Smith', 24),
(2, 'Mark', 'Murdocc', 42),
(3, 'Ana', 'Smith', 34)
""")
#SQL data fetching
cursor.execute("""
SELECT * FROM persons
WHERE last_name = 'Smith'
""")
#SQL data display
rows = cursor.fetchall()
print(rows)
connection.commit() # apply changes.
connection.close() # close the connection.

[@therealchicken7151]

19:50 couldnt we just pass one tuple instead of 4 placeholders? also cant we instead of person make an class above which takes a name and puts it in the corresponding "person" ?

[@nathanhammond523]

were you able to do that? im working through this right now

[@therealchicken7151]

@@nathanhammond523 I didn't check that tbh I was outside rn and had to pause mid, mind adding me on discord? I am trying it rn

[@therealchicken7151]

TheRealChicken#5230

[@vaishnavikhandare]

look at text cursor on 1:56
did you notice something?

[@gusic4529]

no

[@vaishnavikhandare]

@@gusic4529 it looks bo in shinchan🤧🤧🤧

[@annog6673]

You too think in a functional way in an objective world; my friend.

[@davidfalk99]

I get this error. Can you help? line 15, in load_person
self.cursor.execute("SELECT * FROM persons WHERE id = {}".format(id_number))
AttributeError: 'Person' object has no attribute 'cursor'

[@davidfalk99]

I needed up adding. self.connection = sqlite3.connect('mydata.db')

[@jhonreylabanon5843]

i kept getting this type of error, can anybody help me with this?
line 25, in
p1.load_person(1)
AttributeError: 'Person' object has no attribute 'load_person'

[@jhonreylabanon5843]

I already have the save "mydatebase.db" that supposed to get the attribute of person 1 who is paul, yet i still getting that type of error

[@aadimanchekar1032]

Awesome bro💕

[@NeuralNine]

Thank you brother! Appreciate it! :)

[@jinayjain7664]

Its a good video but
bro sometimes your video becomes blurr

[@karanjoshi8202]

Nice Video

[@NeuralNine]

Thank you brother! :)

[@karanjoshi8202]

@@NeuralNineI appreciate Your Work

[@NeuralNine]

@@karanjoshi8202 that means a lot to me! :)

[@hardani.ismunabil]

your outro music is damn loud