主页 / user-26437626

mehdi ahmadi's questions

Martin Hope
mehdi ahmadi
Asked: 2024-08-23 01:51:51 +0800 CST
  • 5

我正在尝试使用pandas更新我的 excel 文件，但每次文件都会损坏，我无法再打开它

1234.xlsx->工作表1

伽马 伽玛卫星 E50参考 参考文献 欧洲参考文献 丙 φ EA 文件系统
17.67 18.6 10500 10500 36000 4 24 4800
17.67 18.6 10500 10500 36000 4 三十六 7200

所以我想用 python 代码填充fs列，并在计算后立即写入每行的答案

主程序

import pandas as pd
import os
file_name = "1234.xlsx"
file_path =os.path.join(os.getcwd(),file_name)

df = pd.read_excel(file_path)

for index, row in df.iterrows():
    gammaUnsat = row['gammaUnsat']
    gammaSat = row['gammasat']
    E50ref = row['E50ref']
    EoedRef = row['EoedRef']
    EurRef = row['EurRef']
    c = row['c']
    phi = row['Φ']
    EA = row['EA']

    # some calculation

    #code to write in file
    df.loc[index , "f.s"] = sf_i

    writer = pd.ExcelWriter(path=file_path,engine="xlsxwriter")
    df.to_excel(writer,"Sheet1",index=False)

我没有遇到任何错误，程序运行正常，但当我点击 Excel 文件时，它告诉我文件已损坏

在此处输入图片描述

python
Martin Hope
mehdi ahmadi
Asked: 2024-08-15 16:39:15 +0800 CST
  • 6

我试图访问模板中的相关数据，但却没有得到任何结果。

模型

from django.db import models
from django.contrib.auth.models import User
from django.db.models.signals import post_save
from django.dispatch import receiver

class Product(models.Model):
    title = models.CharField(max_length=50)
    description = models.TextField()
    price = models.PositiveBigIntegerField()
    discount = models.PositiveBigIntegerField(default=0)
    inventory = models.PositiveBigIntegerField(default=1)
    last_update =  models.DateTimeField(auto_now_add=True)
    def __str__(self) -> str:
        return self.title

class Image(models.Model):
    image = models.ImageField()
    product = models.ForeignKey(to=Product,on_delete=models.CASCADE)
    
    
class Cart(models.Model):
    
    STATUS = [
        (0,"pending payment"),
        (1,"paid")
              ]
    
    status = models.SmallIntegerField(choices=STATUS,default=0)
    user = models.ForeignKey(to=User,on_delete=models.CASCADE)
    created = models.DateTimeField(auto_now=True)
    
    def __str__(self) -> str:
        return f"{self.user} - {self.status}"
    
@receiver(post_save,sender=Cart)
def cart_post_save(sender, instance, created, *args, **kwargs):
    if created and instance.status == 1 :
        Cart.objects.create(user=instance.user)

    
        

class Order(models.Model):
    product = models.ForeignKey(to=Product,on_delete=models.CASCADE)
    count = models.PositiveIntegerField(default=0)
    cart = models.ForeignKey(to=Cart,on_delete=models.CASCADE)
    
    def __str__(self) -> str:
        return f"{self.product}"

视图


from django.views import generic 
from . import models
from django.http import JsonResponse,HttpResponseBadRequest,HttpResponse

class ProductsList(generic.ListView):
    """return list of all products and template name is prudoct_list.html"""
    model = models.Product
    paginate_by = 30
    
    def get_context_data(self, **kwargs):
        context = super().get_context_data(**kwargs)
        return context
    
class ProductsDetail(generic.DetailView):
    """return a product and template name is prudoct_detail.html"""
    model = models.Product

    def get_context_data(self, **kwargs):
        context = super().get_context_data(**kwargs)
        return context

基础.html



{% load static %}
<!DOCTYPE html>
<html lang="en">
<head>
    <meta charset="UTF-8">
    <meta name="viewport" content="width=device-width, initial-scale=1.0">
    <title>online-shop</title>
    
</head>
<body>
    <nav>
        {% if request.user.is_anonymous %}

        {% else %}
            {{request.user}}
            <form method="post" action="{% url 'logout' %}">
                {% csrf_token %}
                <button type="submit">logout</button>
            </form>
            <a href="{% url 'cart' %}">cart</a>
            
        {% endif %}

    </nav>
    <script src="{% static 'js/jquery-3.7.1.min.js' %}"></script>
    {% block content %}
    
    {% endblock content %}

    
</body>
</html>

产品详细信息.html

{% extends "base.html" %}

{% block content %}

{% for image in object.image_set.all %}
    <img src="{{image.image.url}}" alt="">
{% endfor %}
<div>title : {{object.title}}</div>
<div>description : {{object.description}}</div>
<div>price : {{object.price}}</div>
<div>discount : {{object.discount}}</div>
<div>last_update : {{object.last_update}}</div>

**{{object.order_set.first}}** # returns None

{% endblock content %}

我希望首先订购，{{object.order_set.first}}并且 RelatedManager 对图像也能正常工作。

{% for image in object.image_set.all %}
    <img src="{{image.image.url}}" alt="">
{% endfor %}

但对于订单我只得到 None 。product_detail 中的输出是：

标题：test123 描述：此处有一些文字 价格：12345 折扣：0 最后更新：2024 年 8 月 9 日，下午 7:03 无

如果我将{{object.order_set.first}}更改为 {{object.order_set}} 输出将是

标题：test123 描述：此处有一些文字 价格：12345 折扣：0 最后更新：2024 年 8 月 9 日，下午 7:03 stor.Order.None

更新

{{object.order_set.all}}

返回 -><QuerySet []> 并且

{% for order in object.order_set.all %}
{{order}}
{% endfor %}

由于为<QuerySet []>空，因此不返回任何内容

python 版本 -> 3.10.11 Django 版本 -> 5.1

python
Martin Hope
mehdi ahmadi
Asked: 2024-08-09 06:25:41 +0800 CST
  • 8

我创建了一个继承自的表单，UserCreationForm并使用了基于类的视图CreateView，当我使用 runserver 并显示表单时，底部有一个基于密码的身份验证部分，我没有注意到

表单.py

from django.contrib.auth import get_user_model
from django.contrib.auth.forms import UserCreationForm


class RegisterForm(UserCreationForm):
    """Form to Create new User"""

    class Meta:
        model = get_user_model()
        fields = ["username", "password1", "password2"]

视图.py

from django.views.generic import CreateView

from .forms import RegisterForm

from django.urls import reverse_lazy

class SignUp(CreateView):
    form_class = RegisterForm
    template_name = "register.html"
    success_url = reverse_lazy("core:Login")
    def form_valid(self, form):
        user = form.save()
        if user:
            login(self.request, user)
        return super().form_valid(form)

注册.html

<h1>signup</h1>

    {{form}}

当我运行代码时，我看到了这个输出

输出图像

所以我没想到基于密码的身份验证。

我的问题是

  1. 这到底是什么？
  2. 它应该显示在这里吗？
  3. 我该如何隐藏它？
python