this post was submitted on 14 Jul 2023
40 points (100.0% liked)

Python

6339 readers
11 users here now

Welcome to the Python community on the programming.dev Lemmy instance!

๐Ÿ“… Events

PastNovember 2023

October 2023

July 2023

August 2023

September 2023

๐Ÿ Python project:
๐Ÿ’“ Python Community:
โœจ Python Ecosystem:
๐ŸŒŒ Fediverse
Communities
Projects
Feeds

founded 1 year ago
MODERATORS
erlingur@programming.dev
jnovinger@programming.dev
norambna@programming.dev
40
What's the best approach to avoid defining sqlite3 conn and cursor in many different functions? (lemm.ee)
submitted 1 year ago* (last edited 1 year ago) by GodOfThunder@lemm.ee to c/python@programming.dev
6 comments fedilink hide all child comments
 

I've seen two approaches which I'm going to post in the comments to see which one is considered best. Feel free to suggest others.

you are viewing a single comment's thread
view the rest of the comments
[โ€“] const_void@lemmy.world 3 points 1 year ago

Depends on the use case; the question is, do you need to construct and destroy the connection inside each method, or can you do it once, at the start of the program, and exit at the end?

db = Db(DB_FILE)

post_id = insert_post(db,"hello")
comment_id = insert_comment(db,post_id)

db.close()