python3 global name is not defined

[oliverjrose99]

I have a main.py file and in that is

import sqlite3from functions import *db = sqlite3.connect('accounts.db')c = db.cursor()

and a functions.py file and in that is

def check_db():    c.execute("""CREATE TABLE IF NOT EXISTS accounts (id NOT NULL AUTOINCREMENT PRIMARY KEY, username VCHAR(255) NOT NULL, password VCHAR(255) NOT NULL ) """)    db.commit()

my problem is when I run check_db() I get "global name 'c' is not defined", how can i fix this?

 

thanks

[WorldDominator]

Did you import the module that .cursor() is in? It seems like the c in the first bit of code may be what's throwing you. I'm not 100% sure though. I've never used this before.

[alpenwasser]

I'm still very much a beginner when it comes to Python, but don't you need to

import main.py into functions.py for this to work?

[MikeD]

The import is going to import the function before the definition of c (c = ...) so it won't know what c is because it is not yet defined.

 

What you want to do is pass c as an argument to check_db

[WorldDominator]

Listen to what @MikeD says

[oliverjrose99]

The import is going to import the function before the definition of c (c = ...) so it won't know what c is because it is not yet defined.

 

What you want to do is pass c as an argument to check_db

how can I do that?

[MikeD]

import sqlite3from functions import *db = sqlite3.connect('accounts.db')c = db.cursor()check_db(c, db)

def check_db(c, db):    c.execute("""CREATE TABLE IF NOT EXISTS accounts (id NOT NULL PRIMARY KEY, username VCHAR(255) NOT NULL, password VCHAR(255) NOT NULL ) """)    db.commit()

You actually need both c and db.

Passing arguments to functions is just a matter of declaring that the function receives something and calling the function with the actual object you have.

[oliverjrose99]

thanks alot

[MikeD]

thanks alot

 

 You're welcome!

 

 

Listen to what @MikeD says

 

But make sure to double check because it might be all wrong!

[spoiler "Funny story actually..."]Today I had a Natural Language test with a few multiple choice questions and at the very last second I decided to change my mind about the answer to a couple of them and I ended up changing from right to wrong... yeahhh....  

[WorldDominator]

But make sure to double check because it might be all wrong!

[spoiler "Funny story actually..."]Today I had a Natural Language test with a few multiple choice questions and at the very last second I decided to change my mind about the answer to a couple of them and I ended up changing from right to wrong... yeahhh....  

Don't let it get to ya bud, what happens in the real world is what really mattrers.

[Ryan Leech]

It sounds like the root file system is undefined