Dust8 的博客

def save_model(self, request, obj, form, change):
    # form.initial 表单里面的初始值保存着原来的数据, cleaned_data 里面就是更改后的数据
    # 新增获取不到,要给个默认值
    user_info = form.initial.get("user_info",None)
    try:
        user_instance = obj.user_classmets
        # 这是保存改动
        super().save_model(request, obj, form, change)
        # 特殊的目的,因为需要保存后才能处理
        xxx(user_instance)
    except Exception as ex:
        # 这里在外键后面直接加_id,来设置数字,不然必须是实例
        # 出错了还原数据
        obj.user_info_id = user_info
        obj.save()
        # 只发送错误信息, 更改的信息不显示, 不然会叠加显示2条信息,导致错误信息被遮罩
        messages.error(request, f"{ex}")
        messages.set_level(request, messages.ERROR)

DATA_UPLOAD_MAX_NUMBER_FIELDS = 1000*10

# 模型
from django.db import models

class Product(models.Model):
    name = models.CharField(max_length=255)
    price = models.DecimalField()
    description = models.TextField()
    release_date = models.DateField()
    manufacturer = models.ForeignKey(Manufacturer)

# 过滤器
import django_filters

class ProductFilter(django_filters.FilterSet):
    class Meta:
        model = Product
        fields = ['price', 'release_date']

class UserFilter(django_filters.FilterSet):
    class Meta:
        model = User
        # 指定字段
        fields = ['username', 'last_login']

class UserFilter(django_filters.FilterSet):
    class Meta:
        model = User
        # 排除字段
        exclude = ['username', 'last_login']

class ProductFilter(django_filters.FilterSet):
    price = django_filters.NumberFilter()
    price__gt = django_filters.NumberFilter(field_name='price', lookup_expr='gt')
    price__lt = django_filters.NumberFilter(field_name='price', lookup_expr='lt')
    price__lte = django_filters.NumberFilter(field_name='price', lookup_expr='lte')

    class Meta:
        model = Product

class ProductFilter(django_filters.FilterSet):
    class Meta:
        model = Product
        fields = {
            'price': ['lt', 'gt'],
            'release_date': ['exact', 'year__gt'],
        }

class Comment(models.Model):
    date = models.DateField()
    time = models.TimeField()

class F(FilterSet):
    date = DateFromToRangeFilter()

    class Meta:
        model = Comment
        fields = ['date']

# Range: Comments added between 2016-01-01 and 2016-02-01
f = F({'date_after': '2016-01-01', 'date_before': '2016-02-01'})

# Min-Only: Comments added after 2016-01-01
f = F({'date_after': '2016-01-01'})

# Max-Only: Comments added before 2016-02-01
f = F({'date_before': '2016-02-01'})

# https://django-filter.readthedocs.io/en/stable/guide/usage.html#customize-filtering-with-filter-method
class F(django_filters.FilterSet):
    username = CharFilter(method='my_custom_filter')

    class Meta:
        model = User
        fields = ['username']

    def my_custom_filter(self, queryset, name, value):
        return queryset.filter(**{
            name: value,
        })

# https://django-filter.readthedocs.io/en/stable/guide/tips.html#filtering-by-relative-times
from django.utils import timezone
from datetime import timedelta
...

class DataModel(models.Model):
    time_stamp = models.DateTimeField()


class DataFilter(django_filters.FilterSet):
    hours = django_filters.NumberFilter(
        field_name='time_stamp', method='get_past_n_hours', label="Past n hours")

    def get_past_n_hours(self, queryset, field_name, value):
        time_threshold = timezone.now() - timedelta(hours=int(value))
        return queryset.filter(time_stamp__gte=time_threshold)

    class Meta:
        model = DataModel
        fields = ('hours',)

# 同时搜索多个字段
class ClassSellInfoFilter(filters_rest.FilterSet):
    fuzzy_search = filters_rest.CharFilter(method='search_title_or_class_tag')

    def search_title_or_class_tag(self, queryset, name, value):
        return queryset.filter(Q(class_sell_title__icontains=value) | Q(class_name__class_tag__icontains=value))

    class Meta:
        model = ClassSellInfo
        fields = ['fuzzy_search']

# settings.py
INSTALLED_APPS = (
    ...
    'import_export',
)

# app/admin.py

from import_export import resources
from core.models import Book

class BookResource(resources.ModelResource):

    class Meta:
        model = Book

from .models import Book
from import_export.admin import ImportExportModelAdmin

class BookAdmin(ImportExportModelAdmin):
    resource_class = BookResource

admin.site.register(Book, BookAdmin)

# 定义导出字段 fields
class BookResource(resources.ModelResource):

    class Meta:
        model = Book
        fields = ('id', 'name', 'price', 'author__name', )

# 排除导出字段 exclude
class BookResource(resources.ModelResource):

    class Meta:
        model = Book
        exclude = ('imported', )

# 排序导出字段 export_order
class BookResource(resources.ModelResource):

    class Meta:
        model = Book
        fields = ('id', 'name', 'author', 'price',)
        export_order = ('id', 'price', 'author', 'name')

from import_export.fields import Field

class BookResource(resources.ModelResource):
    full_title = Field()

    class Meta:
        model = Book

    def dehydrate_full_title(self, book):
        return '%s by %s' % (book.name, book.author.name)

# import_exprt/admin.py
class ExportActionMixin(ExportMixin):
    ...

    actions = admin.ModelAdmin.actions + [export_admin_action]

class ExportActionModelAdmin(ExportActionMixin, admin.ModelAdmin):
    """
    Subclass of ModelAdmin with export functionality implemented as an
    admin action.
    """

class BookAdmin(ImportExportModelAdmin):
    resource_class = BookResource
    actions= ["xxxx", ExportActionMixin.export_admin_action]

admin.site.register(Book, BookAdmin)

# locustfile.py
import time
from locust import HttpUser, task


class QuickstartUser(HttpUser):
    @task
    def hello_world(self):
        self.client.get(
            "/classsellinfo/?page=1&page_size=10&ordering=-created&class_price__gt=0.1"
        )