擅长:python、mysql、java
<p>虽然它通常被用作一个成熟的网站框架,但是<a href="https://docs.djangoproject.com/en/2.2/topics/db/models/" rel="nofollow noreferrer">Django model</a>与您在这里尝试做的关于过滤的工作非常接近:</p>
<pre><code>from django.db import models
class CHRecord(models.Model):
namespace = models.CharField(max_length=32)
filepath = models.FileField()
# Not sure what this represents in your question, but if you use
# PostgreSQL as your backend, might want an Array
sel_sets = models.CharField(max_length=512)
# Saves a row to a database (local SQLite by default)
CHRecord.objects.create(namespace="John:", filepath="C:/temp/", sel_sets="xyz")
# Get matching rows translating to a SQL query
CHRecord.objects.filter(namespace__contains="John")
</code></pre>