Как вставить данные с помощью хранимой процедуры в django для mssql?

enter image description here Я получаю эту ошибку,

ValueError at /health/ Представление Healthcare.views.Sp_tbl_user_detail_views не вернуло объект HttpResponse. Вместо этого оно вернуло None.

модели

class sp_tbl_user_detail(models.Model):
    userid = models.CharField(db_column='userID', primary_key=True,max_length=36,editable = False)  # Field name made lowercase.
    username = models.CharField(unique=True, max_length=255, db_collation='SQL_Latin1_General_CP1_CI_AS')
    userfirstname = models.CharField(max_length=50, db_collation='SQL_Latin1_General_CP1_CI_AS')      
    userlastname = models.CharField(max_length=50, db_collation='SQL_Latin1_General_CP1_CI_AS')       
    user_contact = models.BigIntegerField(unique=True)
    user_dob = models.DateField()
    gender = models.CharField(max_length=1)
    height = models.FloatField(max_length=6)
    weight = models.FloatField(max_length=6)
    blood_group = models.CharField(max_length=3)
    user_password = models.CharField(max_length=30)  # This field type is a guess.  user_email=models.CharField(unique=True,max_length=100,db_collation='SQL_Latin1_General_CP1_CI_AS)
    addedby = models.CharField(max_length=36)
    addedon = models.DateTimeField(blank=True,null=True,auto_now_add=True)
    updatedby = models.CharField(max_length=36, blank=True, null=True)
    updatedon = models.DateTimeField(blank=True,null=True,auto_now=True)
    active = models.BooleanField()

просмотров

def Sp_tbl_user_detail_views(request):
    if request.method=='POST':
        if request.POST.get('userid') and request.POST.get('username') and request.POST.get('fname') and request.POST.get('lname') and request.POST.get('pnumber') and request.POST.get('dob') and request.POST.get('gender') and request.POST.get('height') and request.POST.get('weight') and request.POST.get('bloodgroup') and request.POST.get('password') and request.POST.get('emailid'):
            empsave=sp_tbl_user_detail()
            empsave.userid=str(uuid.uuid4())
            empsave.username=request.POST.get('username')
            empsave.fname=request.POST.get('fname')
            empsave.lname=request.POST.get('lname')
            empsave.pnumber=request.POST.get('pnumber')
            empsave.dob=request.POST.get('dob')
            empsave.gender=request.POST.get('gender')
            empsave.height=request.POST.get('height')
            empsave.weight=request.POST.get('weight')
            empsave.bloodgroup=request.POST.get('bloodgroup')
            empsave.password=request.POST.get('password')
            empsave.emailid=request.POST.get('emailid')
            empsave.addedby='55CD065E-29ED-442D-90AA-C6A443757CE5'
            cursor=connection.cursor()
            cursor.execute ("sp_tbl_user_detail '"+empsave.userid+"','"+empsave.username+"','"+empsave.fname+"','"+empsave.lname+","+empsave.pnumber+"','"+empsave.dob+"','"+empsave.gender+","+empsave.height+","+empsave.weight+",'"+empsave.bloodgroup+"','"+empsave.password+"','"+empsave.emailid+"','"+empsave.addedby)
            #cursor.execute ("sp_tbl_user_detail (@userID='%s',@username='%s',@userfirstname='%s',@userlastname='%s',@user_contact=%s,@user_dob='%s',@gender'%s',@height=%s,@weight=%s,@blood_group='%s',@user_password='%s',@user_email='%s')",(empsave.userid,empsave.username,empsave.fname,empsave.lname,empsave.pnumber,empsave.dob,empsave.gender,empsave.height,empsave.weight,empsave.bloodgroup,empsave.password,empsave.emailid))
            messages.success(request,"Info saved successfully")
            print('User Created')
            return JsonResponse(empsave,safe=False)
    else:
        return render(request,'Index.html')

Index.html

<body>
        <center>      
            <h2>Sign Up</h2>    
            <form method="POST"> 
                {% csrf_token %}   
                <!--User ID: <input type = "text" name="userid" placeholder="Please enter your User Name" /><br/> -->   
                USERNAME: <input type = "text" name="username" placeholder="Please enter your First Name" /><br/>
                First Name: <input type = "text" name="fname" placeholder="Please enter your First Name" /><br/> 
                Last Name: <input type = "text" name="lname" placeholder="Please enter your Last Name" /><br/> 
                Contact Number: <input type = "text" name="pnumber" placeholder="Please enter your Phone Name" /><br/> 
                DOB: <input type = "text" name="dob" placeholder="Please enter your DOB" /><br/> 
                Gender: <input type = "text" name="gender" placeholder="Please enter your Gender" /><br/> 
                Height: <input type = "text" name="height" placeholder="Please enter your Height" /><br/> 
                Weight: <input type = "text" name="weight" placeholder="Please enter your Weight" /><br/> 
                Blood group: <input type = "text" name="bloodgroup" placeholder="Please enter your Blood group" /><br/> 
                Password: <input type = "text" name="password" placeholder="Please enter your Password" /><br/>
                Email ID: <input type = "text" name="emailid" placeholder="Please enter your email id" /><br/>
                <hr/>
                <input type="submit" value="Insert">
                {% if messages %}
                {% for displaydata in messages %}
                <h3 style="color:green;">{{ displaydata }} </h3>
                {% endfor %}
                {% endif %}
            </form>
        </center>    
    </body>

Может ли кто-нибудь помочь мне исправить это, Я не понимаю, я думаю, что мне не хватает какого-то синтаксиса в представлениях или, возможно, мой синтаксис неправильный.

Вернуться на верх