python -m pip install -U pip
from PyQt5 import uic
from PyQt5.QtWidgets import QMainWindow
class MainWindow(QMainWindow):
def __init__(self):
super(MainWindow, self).__init__()
uic.loadUi('mainwindow.ui', self)import json
from django import forms
class SomeForm(forms.Form):
name = forms.CharField(label=u'Name', max_length=25)
def some_view(request):
json_string = request.POST.get('json_data')
form_data = json.loads(json_string)[0]
f = SomeForm(form_data)
if f.is_valid():
name = f.cleaned_data['name']
# ... Работа с данными ...
else:
# ... Обработка ошибки ...from django.forms.models import model_to_dict
model = Chat2.objects.get(id=20)
field_values = model_to_dict(model)field_values = Chat2.objects.get(id=20).values()
UPDATE pg_database SET datallowconn = 'false' WHERE datname = 'database_name';SELECT pg_terminate_backend(pg_stat_activity.pid)
FROM pg_stat_activity
WHERE pg_stat_activity.datname = 'database_name' AND pid <> pg_backend_pid();DROP DATABASE database_name;
def form_invalid(self, form):
form.add_error(None, u'Вы кто такие? Я вас не звал!');
return super(LoginFormView, self).form_invalid(form)select
t1.name, array_agg(t2.skills)
from table1 as t1
inner join table2 as t2
using (id)
group by t1.name;tagnews = set(tag_tag | tag_city | tag_country)from django.db.models import Q
tagnews = Entry.objects.filter(Q(tags__slug=slug) | Q(to_city__name_en=slug) | Q(to_city__country_code__name_en=slug))class WorkModelForm(forms.ModelForm):
description = forms.CharField(label='описание', widget=forms.Textarea, required=False)
...class WorkModelForm(forms.ModelForm):
class Meta:
model = Work
fields = "__all__"
widgets = {
'description': forms.Textarea,
}insert into m2m_table select p.id, c.id, 1 from products as p join currencies as c;