Django.db.utils.ProgrammingError: syntax error at or near "User" LINE 1: INSERT INTO User (password, firstname, lastname, username, e
@api_view(["POST"]) @permission_classes((IsAuthenticated,)) def create_user(request):
cursor = connection.cursor()
email = request.data['email']
role = request.data['role']
username = request.data['email']
firstname = request.data['firstname']
lastname = request.data['lastname']
is_staff = request.data['is_staff']
password = request.data['password']
query = """INSERT INTO User (password, firstname, lastname, username, email, is_staff, role_id)
VALUES (?, ?, ?, ?, ?, ?, ?)"""
cursor.execute(query, (password, firstname, lastname, username, email, is_staff, role))