blocks|key|4003166|text|您需要一个能够创建或更新Model的funx。你可以参考django文档：https://docs.djangoproject.com/en/2.1/ref/models/instances/|type|unstyled|depth|inlineStyleRanges|entityRanges|offset|length|data|4003167|entityMap|0|LINK|mutability|MUTABLE|url|https://docs.djangoproject.com/en/2.1/ref/models/instances/^0|11|1N|0|0^^$0|@$1|2|3|4|5|6|7|L|8|@]|9|@$A|M|B|N|1|O]]|C|$]]|$1|D|3|-4|5|6|7|P|8|@]|9|@]|C|$]]]|E|$F|$5|G|H|I|C|$J|K]]]]

You need to have a funx that makes it possible to create or update Model. You can follow the django doc:
<a href="https://docs.djangoproject.com/en/2.1/ref/models/instances/" rel="nofollow noreferrer">https://docs.djangoproject.com/en/2.1/ref/models/instances/</a>

blocks|key|4000275|text|使用模型表单：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|4000276|from+your_app+import+Client

class+ClientUpdateForm(forms.ModelForm):
++++class+Meta:
++++++++model+=+Client
++++++++fields+=+('company_name',+'launchpad_id',+'client_email',+'content_id')

++++def+__init__(self,+*args,+**kwargs):
++++++++super(ClientUpdateForm,+self).__init__(*args,+**kwargs)
++++++++self.fields['company_name'].required++=+True
++++++++self.fields['launchpad_id'].required++=+True
++++++++self.fields['client_email'].required++=+True
++++++++self.fields['content_id'].required++=+True

++++def+clean(self):
++++++++cleaned_data+=+super(ClientUpdateForm,+self).clean()
++++++++company_name+=+cleaned_data.get('company_name')
++++++++launchpad_id+=+cleaned_data.get('launchpad_id')
++++++++client_email+=+cleaned_data.get('client_email')
++++++++content_id+=+cleaned_data.get('content_id')|code-block|syntax|javascript|4000277|然后从UpdateView继承：|4000278|from+django.views.generic+import+UpdateView
from+your_app+import+Client

class+ClientUpdateForm(UpdateView):
++++model+=+Client
++++form_class+=+ClientUpdateForm
++++template_name_suffix+=+'_update_form'

++++def+form_valid(self,+form):
++++++++if+form.is_valid():
++++++++++++client+=+form.save(commit=False)
++++++++++++client.save()
++++++++++++return+HttpResponseRedirect('/redirect/')|4000279|template_name_suffix意味着您应该在呈现表单client_update_form.html的地方调用模板。|4000280|entityMap^0|0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|O|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|P|8|@]|9|@]|A|$E|F]]|$1|G|3|H|5|6|7|Q|8|@]|9|@]|A|$]]|$1|I|3|J|5|D|7|R|8|@]|9|@]|A|$E|F]]|$1|K|3|L|5|6|7|S|8|@]|9|@]|A|$]]|$1|M|3|-4|5|6|7|T|8|@]|9|@]|A|$]]]|N|$]]

Use a model form:

<pre><code>from your_app import Client

class ClientUpdateForm(forms.ModelForm):
 class Meta:
 model = Client
 fields = ('company_name', 'launchpad_id', 'client_email', 'content_id')

 def __init__(self, *args, **kwargs):
 super(ClientUpdateForm, self).__init__(*args, **kwargs)
 self.fields['company_name'].required = True
 self.fields['launchpad_id'].required = True
 self.fields['client_email'].required = True
 self.fields['content_id'].required = True

 def clean(self):
 cleaned_data = super(ClientUpdateForm, self).clean()
 company_name = cleaned_data.get('company_name')
 launchpad_id = cleaned_data.get('launchpad_id')
 client_email = cleaned_data.get('client_email')
 content_id = cleaned_data.get('content_id')
</code></pre>

Then inherit from UpdateView:

<pre><code>from django.views.generic import UpdateView
from your_app import Client

class ClientUpdateForm(UpdateView):
 model = Client
 form_class = ClientUpdateForm
 template_name_suffix = '_update_form'

 def form_valid(self, form):
 if form.is_valid():
 client = form.save(commit=False)
 client.save()
 return HttpResponseRedirect('/redirect/')
</code></pre>

The template_name_suffix means you should call your template where you render the form client_update_form.html.

blocks|key|4000329|text|我认为你需要一个database_router来做这件事。按住https://docs.djangoproject.com/en/2.1/topics/db/multi-db/。基本上，您需要设置一个DatabaseRouter，您可以在其中设置将从哪个数据库读取模型表ecc。然后在django设置中设置自定义数据库路由。你可能需要像这样运行这个模型的迁移。/manage.py+migrate+myapp+0005_migration_to_run+--+database+=your_target_database_name，我可能会建议你在每个数据库的项目中有不同的应用程序，这样更容易。|type|unstyled|depth|inlineStyleRanges|entityRanges|offset|length|data|4000330|entityMap|0|LINK|mutability|MUTABLE|url|https://docs.djangoproject.com/en/2.1/topics/db/multi-db/^0|V|1L|0|0^^$0|@$1|2|3|4|5|6|7|L|8|@]|9|@$A|M|B|N|1|O]]|C|$]]|$1|D|3|-4|5|6|7|P|8|@]|9|@]|C|$]]]|E|$F|$5|G|H|I|C|$J|K]]]]

I think you need a database_router for this. Hold <a href="https://docs.djangoproject.com/en/2.1/topics/db/multi-db/" rel="nofollow noreferrer">https://docs.djangoproject.com/en/2.1/topics/db/multi-db/</a>. Basically you need to set up a DatabaseRouter where you set up from which database you will read the model table ecc. then set your Custom database route in django settings. And you will probably need to run migration for this model with something like this ./manage.py migrate myapp 0005_migration_to_run --databse=your_target_databse_name, I would probably recommend you having different apps inside project per database for take it easier.

blocks|key|4000379|text|通过将以下代码添加到我的模型中，我能够获得我想要的结果：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|4000380|def+update_mysql(self):
++++cursor+=+db.cursor()
++++sql+=+"UPDATE+tb_reporting_info+SET+client_email+=+'%25s'+WHERE+content_id+=+'%25s'+AND+launchpad_id+=+'%25s';"
++++cursor.execute(+sql+%25+(self.client_email,+self.content_id,+self.launchpad_id))
++++db.commit()|code-block|syntax|javascript|4000381|我将表单操作设置为action="{%25+url+'contact:addClient'+%25}"，视图设置为：|offset|length|style|CODE|4000382|def+addClient(request):
++++if+request.method+==+'POST':
++++++++#+Set+POST+data+to+variables
++++++++company_name+=+request.POST['company_name']
++++++++launchpad_id+=+request.POST['launchpad_id']
++++++++content_id+=+request.POST['content_id']
++++++++client_email+=+request.POST['client_email']
++++++++client_added+=+True++#+Tells+the+template+to+render+a+success+message

++++++++#+Pass+POST+data+to+Client+object
++++++++c+=+Client(company_name+=+company_name,
++++++++++++++++launchpad_id+=+launchpad_id,
++++++++++++++++content_id+=+content_id,
++++++++++++++++client_email+=+client_email
++++++++++++++++)
++++++++c.update_mysql()|4000383|它是最基本的，但它完美地满足了我的需求。|4000384|entityMap^0|0|0|9|12|0|0|0^^$0|@$1|2|3|4|5|6|7|S|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|T|8|@]|9|@]|A|$E|F]]|$1|G|3|H|5|6|7|U|8|@$I|V|J|W|K|L]]|9|@]|A|$]]|$1|M|3|N|5|D|7|X|8|@]|9|@]|A|$E|F]]|$1|O|3|P|5|6|7|Y|8|@]|9|@]|A|$]]|$1|Q|3|-4|5|6|7|Z|8|@]|9|@]|A|$]]]|R|$]]

I was able to achieve my desired results by adding the following code to my model:

<pre><code>def update_mysql(self):
 cursor = db.cursor()
 sql = "UPDATE tb_reporting_info SET client_email = '%s' WHERE content_id = '%s' AND launchpad_id = '%s';"
 cursor.execute( sql % (self.client_email, self.content_id, self.launchpad_id))
 db.commit()
</code></pre>

I set my form action to <code>action="{% url 'contact:addClient' %}"</code> and my view to:

<pre><code>def addClient(request):
 if request.method == 'POST':
 # Set POST data to variables
 company_name = request.POST['company_name']
 launchpad_id = request.POST['launchpad_id']
 content_id = request.POST['content_id']
 client_email = request.POST['client_email']
 client_added = True # Tells the template to render a success message

 # Pass POST data to Client object
 c = Client(company_name = company_name,
 launchpad_id = launchpad_id,
 content_id = content_id,
 client_email = client_email
 )
 c.update_mysql()
</code></pre>

It's bare bones but it works perfectly for what I need.

I'm trying to create an app with a form that when submitted, updates a table in my database based on the info submitted, but I'm not sure how to go about it. Currently, I have a simple mode:

<pre><code>class Client(models.Model):
 company_name = models.CharField(max_length=200)
 launchpad_id = models.PositiveIntegerField()
 client_email = models.EmailField()
 content_id = models.CharField(max_length=200)

 def __str__(self):
 return self.company_name + ' | ' + self.content_id
</code></pre>

and my databases configured like so:

<pre><code>DATABASES = {
 'default': {
 'ENGINE': 'django.db.backends.mysql',
 'NAME': 'django_project',
 'USER': 'xxx',
 'PASSWORD': 'xxx',
 'HOST': 'xxxx',
 'PORT': 'xxx',
 },
 'info': {
 'ENGINE': 'django.db.backends.mysql',
 'NAME': 'reporting_database',
 'USER': 'xxx',
 'PASSWORD': 'xxx',
 'HOST': 'xxx',
 'PORT': 'xxx',
 }
}
</code></pre>

What I want to happen is when I submit my fields through the Client model either in admin or a template, it updates my client_info table in the reporting_database. I cant seem to figure out how to make that connection work though. I would appreciate any direction you can give me. Thanks.

How do I update a table column with Django?

数据库

路由

我正在尝试创建一个带有表单的应用程序，该应用程序在提交时会根据提交的信息更新数据库中的表，但我不确定如何进行。目前，我有一个简单的模式：class Client(models.Model):    company_name = models.CharField(max_length=200)    launchpad_...

问如何使用Django更新表列？
EN

社区

活动

资源

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问如何使用Django更新表列？EN

社区

活动

资源

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问如何使用Django更新表列？
EN