И снова вопрос(
Пока писал локально использовал по умолчанию sqlite, когда перенес на внешний сервер подключил postgres.
- дернул проект с гитхаба
- удалил миграции (давно с ними не работал и у меня там бардак)
- подключил postgres
- создал миграцию, сгенерировал базу
вкратце структура
Bicycle отнаследована от Advertisement (OneToOne соответсвенно)
Images ссылается на Advertisement (OneToMany)
проблемы:
-
в админке если захожу в список Bicycle вылетает ошибка
ProgrammingError at /admin/advertisement/bicycle/
column advertisement_bicycle.id does not exist
LINE 1: SELECT "advertisement_bicycle"."id", "advertisement_bicycle"...
-
в пользовательском интерфейсе в добавлении Bicycle было добавление Images, из формы добавление картинок куда-то пропало
(почему-то не форматируется как код :/ )
class ImageForm(forms.ModelForm):
image = forms.ImageField(label='Image')
class Meta:
model = Images
fields = ('image', )
ImageFormSet = inlineformset_factory(Advertisement, Images, fields = 'all')
Приведу таблицы Bicycle и Advertisement на локальной в sqlite и на боевой в porstgres
sqlite
CREATE TABLE "advertisement_bicycle"
(
"advertisement_ptr_id" integer NOT NULL PRIMARY KEY REFERENCES "advertisement_advertisement" ("id"),
"size" integer NOT NULL,
"bicycle_type_id" integer NOT NULL REFERENCES "advertisement_bicycletype" ("id"),
"jumper_back_id" integer NULL REFERENCES "advertisement_bicyclejumper" ("id"),
"jumper_front_id" integer NULL REFERENCES "advertisement_bicyclejumper" ("id")
);
CREATE INDEX "advertisement_bicycle_bicycle_type_id_19b5b2ed" ON "advertisement_bicycle" ("bicycle_type_id");
CREATE INDEX "advertisement_bicycle_jumper_back_id_5e0f152d" ON "advertisement_bicycle" ("jumper_back_id");
CREATE INDEX "advertisement_bicycle_jumper_front_id_6e998268" ON "advertisement_bicycle" ("jumper_front_id");
CREATE TABLE "advertisement_advertisement"
(
"id" integer NOT NULL PRIMARY KEY AUTOINCREMENT,
"title" varchar(255) NOT NULL,
"note" varchar(4000) NOT NULL,
"date" datetime NOT NULL,
"price" integer NOT NULL,
"ident" integer NULL,
"weight" integer NOT NULL,
"year" integer NOT NULL,
"user_id" integer NOT NULL REFERENCES "auth_user" ("id")
);
CREATE INDEX "advertisement_advertisement_user_id_d215b148" ON "advertisement_advertisement" ("user_id");
postgres
Table "public.advertisement_bicycle"
Column | Type | Modifiers
---------------------+---------+-----------
advertisement_ptr_id | integer | not null
size | integer | not null
bicycle_type_id | integer | not null
jumper_back_id | integer |
jumper_front_id | integer |
Indexes:
"advertisement_bicycle_pkey" PRIMARY KEY, btree (advertisement_ptr_id)
"advertisement_bicycle_bicycle_type_id_19b5b2ed" btree (bicycle_type_id)
"advertisement_bicycle_jumper_back_id_5e0f152d" btree (jumper_back_id)
"advertisement_bicycle_jumper_front_id_6e998268" btree (jumper_front_id)
Foreign-key constraints:
"advertisement_bicycl_advertisement_ptr_id_c89e5309_fk_advertise" FOREIGN KEY (advertisement_ptr_id) REFERENCES advertisement_advertisement(id) DEFERRABLE INITIALLY DEFERRED
"advertisement_bicycl_bicycle_type_id_19b5b2ed_fk_advertise" FOREIGN KEY (bicycle_type_id) REFERENCES advertisement_bicycletype(id) DEFERRABLE INITIALLY DEFERRED
"advertisement_bicycl_jumper_back_id_5e0f152d_fk_advertise" FOREIGN KEY (jumper_back_id) REFERENCES advertisement_bicyclejumper(id) DEFERRABLE INITIALLY DEFERRED
"advertisement_bicycl_jumper_front_id_6e998268_fk_advertise" FOREIGN KEY (jumper_front_id) REFERENCES advertisement_bicyclejumper(id) DEFERRABLE INITIALLY DEFERRED
Table "public.advertisement_advertisement"
Column | Type | Modifiers
--------+--------------------------+--------------------------------------------------------------------------
id | integer | not null default nextval('advertisement_advertisement_id_seq'::regclass)
title | character varying(255) | not null
note | character varying(4000) | not null
date | timestamp with time zone | not null
price | integer | not null
ident | integer |
weight | integer | not null
year | integer | not null
user_id | integer | not null
Indexes:
"advertisement_advertisement_pkey" PRIMARY KEY, btree (id)
"advertisement_advertisement_user_id_d215b148" btree (user_id)
Foreign-key constraints:
"advertisement_advertisement_user_id_d215b148_fk_auth_user_id" FOREIGN KEY (user_id) REFERENCES auth_user(id) DEFERRABLE INITIALLY DEFERRED
Referenced by:
TABLE "advertisement_bicycle" CONSTRAINT "advertisement_bicycl_advertisement_ptr_id_c89e5309_fk_advertise" FOREIGN KEY (advertisement_ptr_id) REFERENCES advertisement_advertisement(id) DEFERRABLE INITIALLY DEFERRED
TABLE "advertisement_images" CONSTRAINT "advertisement_images_advertisement_id_8f7bf97d_fk_advertise" FOREIGN KEY (advertisement_id) REFERENCES advertisement_advertisement(id) DEFERRABLE INITIALLY DEFERRED
TABLE "advertisement_ski" CONSTRAINT "advertisement_ski_advertisement_ptr_id_5620aaba_fk_advertise" FOREIGN KEY (advertisement_ptr_id) REFERENCES advertisement_advertisement(id) DEFERRABLE INITIALLY DEFERRED
Подскважите пожалуйста куда копать, в чем может быть проблема? Мне кажется, что с базой это не может быть связанно, но с чем еще... не представляю.
Updated 21 April 2018, 13:47 by Leonid.