Reply to thread

Message

<blockquote data-quote="Moogly" data-source="post: 385943" data-attributes="member: 16998">Aside from using tkinter to make it more approachable, anytime you repeat the same code like a SQL query, you could parametize it and use format as necessary:[code]query_str = 'INSERT INTO Class{0}(FirstName, SecondName, Score) VALUES(?,?,?)'.format(classnum)[/code]Then instead of:[code]with con:if classnum == '1':&nbsp;&nbsp; cur = con.cursor()&nbsp;&nbsp; cur.execute('''INSERT INTO Class1(FirstName, SecondName, Score) VALUES(?,?,?)''', (firstname,secondname,correct))&nbsp;&nbsp; con.commit()elif classnum == '2':&nbsp;&nbsp; cur = con.cursor()&nbsp;&nbsp; cur.execute('''INSERT INTO Class2(FirstName, SecondName, Score) VALUES(?,?,?)''', (firstname,secondname,correct))&nbsp;&nbsp; con.commit()elif classnum == '3':&nbsp;&nbsp; cur = con.cursor()&nbsp;&nbsp; cur.execute('''INSERT INTO Class3(FirstName, SecondName, Score) VALUES(?,?,?)''', (firstname,secondname,correct))&nbsp;&nbsp; con.commit()[/code]You could do:[code]# with con line goes before this block:cur = con.cursor()query_str = 'INSERT INTO Class{0}(FirstName, SecondName, Score) VALUES(?,?,?)'.format(classnum)cur.execute(query_str, (firstname,secondname,correct))con.commit()[/code]You would get rid of 9 lines of code and accomplish the same. If you ever find yourself repeating yourself in code, chances are you can find a quicker way in less lines of code to accomplish the same. It may take a while to grasp sometimes, but the more willing you are to fix up your code the better you will be and closer you will become to being a Pythonista. Anyway: great job, maybe for your next challenge try adding Tkinter as an interface, it's not as hard as it sounds. I was able to use tkinter with little to no Python experience before.</blockquote>

[QUOTE="Moogly, post: 385943, member: 16998"] Aside from using tkinter to make it more approachable, anytime you repeat the same code like a SQL query, you could parametize it and use format as necessary: [code] query_str = 'INSERT INTO Class{0}(FirstName, SecondName, Score) VALUES(?,?,?)'.format(classnum) [/code] Then instead of: [code] with con: if classnum == '1': cur = con.cursor() cur.execute('''INSERT INTO Class1(FirstName, SecondName, Score) VALUES(?,?,?)''', (firstname,secondname,correct)) con.commit() elif classnum == '2': cur = con.cursor() cur.execute('''INSERT INTO Class2(FirstName, SecondName, Score) VALUES(?,?,?)''', (firstname,secondname,correct)) con.commit() elif classnum == '3': cur = con.cursor() cur.execute('''INSERT INTO Class3(FirstName, SecondName, Score) VALUES(?,?,?)''', (firstname,secondname,correct)) con.commit() [/code] You could do: [code] # with con line goes before this block: cur = con.cursor() query_str = 'INSERT INTO Class{0}(FirstName, SecondName, Score) VALUES(?,?,?)'.format(classnum) cur.execute(query_str, (firstname,secondname,correct)) con.commit() [/code] You would get rid of 9 lines of code and accomplish the same. If you ever find yourself repeating yourself in code, chances are you can find a quicker way in less lines of code to accomplish the same. It may take a while to grasp sometimes, but the more willing you are to fix up your code the better you will be and closer you will become to being a Pythonista. Anyway: great job, maybe for your next challenge try adding Tkinter as an interface, it's not as hard as it sounds. I was able to use tkinter with little to no Python experience before. [/QUOTE]

Verification

Reply to thread

Connect with us

Newest members