How to use user input to create databases

Question

How do I get input from user to create databases in python? These data must stored in test.db file.

Code

import sqlite3

conn = sqlite3.connect('test.db');
print "Opened database successfully";


name=raw_input ("enter your name: ");
salary=raw_input("enter your salary: ");

conn.execute("INSERT INTO employee (NAME,SALARY) \
      VALUES ( r"+name+",r "+salary+")");

conn.commit()

Can you add the error you get here? also, raw_input() is input() in python3 — fpietka
– fpietka, Commented Jan 31, 2017 at 14:24
Traceback (most recent call last): File "m1.py", line 13, in <module> VALUES ( r"+name+",r "+salary+")"); sqlite3.OperationalError: near "3432": syntax error — Kaliya Mitesh
– Kaliya Mitesh, Commented Jan 31, 2017 at 14:32

fpietka · Accepted Answer · 2017-01-31 14:50:28Z

1

Your concatenation is broken here, if salary is an integer you should do something like that:

conn.execute("INSERT INTO employee (NAME,SALARY) \
    VALUES ( \"" + name + "\", " + str(salary) + ")");

Basically you need to escape some quotes around strings in your query.

Then to read your table you can do something like that:

for row in conn.execute('SELECT * FROM employee'):
    print row

edited Jan 31, 2017 at 14:50

answered Jan 31, 2017 at 14:37

fpietka

1,0411 gold badge10 silver badges24 bronze badges

Sign up to request clarification or add additional context in comments.

7 Comments

fpietka Over a year ago

you should have a grey tick you can click near its score (zero at the time)

fpietka Over a year ago

You can do DELETE FROM employee WHERE name = "myname" for example.

Kaliya Mitesh Over a year ago

name=raw_input ("enter your name: "); conn.execute("DELETE FROM employee WHERE name =\""+ name+"\"); conn.commit()

Kaliya Mitesh Over a year ago

mitesh@mitesh-Inspiron-N5010:~/Desktop$ python m3.py File "m3.py", line 12 conn.execute("DELETE FROM employee WHERE name =\""+ name+"\"); ^ SyntaxError: EOL while scanning string literal mitesh@mitesh-Inspiron-N5010:~/Desktop$

fpietka Over a year ago

Seems your line isn't complete, should be: conn.execute("DELETE FROM employee WHERE name =\""+ name+"\");")

|

Collectives™ on Stack Overflow

How to use user input to create databases

1 Answer 1

7 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

7 Comments

Your Answer

Sign up or log in

Post as a guest

Related