我已经将我的SQLite数据库转换为PostgreSQL DB。我已经完成了所有的迁移和集合,在我的windows上的python脚本中,我可以访问DB并执行命令。我的问题是,我没有在我的网站上看到所有的数据.就像服务器和Python互相交谈,而不是对网站。
这里有几个代码片段-
def get_query(group_name , heb_sale_rent ,heb_street, heb_city , heb_rooms , heb_size , heb_floor , heb_porch , heb_storage , heb_mamad , heb_parking , heb_elevator , heb_phone , heb_price):
conn = psycopg2.connect(database='test', host='192.168.72.130', port='5432', user='user_sql', password='user_sql')
cur = conn.cursor()
cur.execute("SELECT * FROM to_excel")
query = cur.fetchall()如果我运行这个命令,我可以看到添加到DB中的结果-

上面的所有行都添加了一个插入命令,如下所示-
elif query == []:
cur.execute("INSERT INTO to_excel (id,group_name,sale_rent ,street, city , rooms , size , floor , porch , storage , mamad , parking , elevator , phone , price , date) VALUES (%s,%s ,%s ,%s ,%s ,%s ,%s ,%s ,%s ,%s ,%s ,%s ,%s ,%s ,%s, %s)", ('1', group_name , heb_sale_rent , heb_street, heb_city , heb_rooms , heb_size , heb_floor , heb_porch , heb_storage , heb_mamad , heb_parking , heb_elevator , heb_phone , heb_price , USER_DATE))
user_date_str = USER_DATE
user_date = datetime.strptime(user_date_str, '%Y-%m-%d').date()
conn.commit()
conn.close()(到目前为止还不错)
#in settings.py
DATABASES = {
'default': {
'ENGINE': 'django.db.backends.postgresql_psycopg2',
'NAME': 'test',
'USER': 'user_sql',
'PASSWORD': 'user_sql',
'HOST': 'localhost',
'PORT': '5432',
}
},这是我的views.py-
from django.http import HttpResponse, HttpResponseRedirect
from django.template import loader
from django.urls import reverse
from .models import Groups
from datetime import datetime
def index(request):
group_names = Groups.objects.all().values()
group_count = Groups.objects.count()
index_list = [i+1 for i in range(group_count)]
combined_list = zip(group_names, index_list)
template = loader.get_template('index.html')
context = {
'group_data': combined_list,
}
return HttpResponse(template.render(context, request))
def add(request):
template = loader.get_template('add.html')
return HttpResponse(template.render({}, request))
def addrecord(request):
group = request.POST['group']
heb_street = 'רחוב, ברובע'
heb_sale_rent = 'מכירה, השכרה'
heb_city = 'שכונת, בסמטאות'
heb_rooms = 'חדרים'
heb_size = 'מ״ר, מ"ר'
heb_floor = 'קומה'
heb_porch = 'מרפסת'
heb_storage = 'מחסן'
heb_mamad = 'ממד, ממ״ד'
heb_parking = 'חניה, חנייה, חניית, חנית'
heb_elevator = 'מעלית'
heb_price = 'מחיר, מבקשים'
heb_phone = '054, 052, 053'
date = datetime.now().strftime('%d %b %Y')
group = Groups(group_name=group, sale_rent=heb_sale_rent, street=heb_street, city=heb_city, rooms=heb_rooms, size=heb_size, floor=heb_floor, elevator=heb_elevator, porch=heb_porch, storage=heb_storage, mamad=heb_mamad, parking=heb_parking, price=heb_price, phone=heb_phone, user_date=date)
group.save()
return HttpResponseRedirect(reverse('index'))
def delete(request, id):
group = Groups.objects.get(id=id)
group.delete()
return HttpResponseRedirect(reverse('index'))
def update(request, id):
group = Groups.objects.get(id=id)
template = loader.get_template('update.html')
context = {
'group': group,
}
return HttpResponse(template.render(context, request))
def updaterecord(request, id):
group_name = request.POST['group']
sale_rent = request.POST['sale_rent']
street = request.POST['street']
city = request.POST['city']
rooms = request.POST['rooms']
size = request.POST['size']
floor = request.POST['floor']
porch = request.POST['porch']
storage = request.POST['storage']
mamad = request.POST['mamad']
elevator = request.POST['elevator']
parking = request.POST['parking']
price= request.POST['price']
phone= request.POST['phone']
date = request.POST['user_date']
group = Groups.objects.get(id=id)
group.group_name = group_name
group.sale_rent = sale_rent
group.street = street
group.city = city
group.rooms = rooms
group.size = size
group.floor = floor
group.porch = porch
group.storage = storage
group.mamad = mamad
group.elevator = elevator
group.parking = parking
group.price = price
group.phone = phone
group.user_date = date
group.save()
return HttpResponseRedirect(reverse('index')),这是我的模型,my
from django.db import models
class Groups(models.Model):
group_name = models.TextField()
sale_rent = models.TextField()
street = models.TextField()
city = models.TextField()
rooms = models.TextField()
size = models.TextField()
floor = models.TextField()
porch = models.TextField()
storage = models.TextField()
mamad = models.TextField()
parking = models.TextField()
elevator = models.TextField()
phone = models.TextField()
price = models.TextField()
user_date = models.TextField()

网站上的

Python在查询中输出的所有数据都在哪里?我做错了什么?救命求你了!
P.S-我不知道它是否有任何相关性,但当我运行
sudo -u postgres psql然后我没有看到任何桌子。
当我在views.py中运行打印(Group_names)时,会得到一个空的查询!为什么?
发布于 2022-08-11 09:49:08
好吧,在几乎精神错乱之后我发现了问题。看起来这个网站在我的数据库中使用了一个名为- to_excel_toexcel的表。"to_excel“是我在DB中创建的表,"toexcel”是我的模型的名称!
我将Python配置为写入新表,所有操作都很完美!

https://stackoverflow.com/questions/73311797
复制相似问题