django.db.utils.ProgrammingError:关系“ bot_trade”不存在

多米尼克·M。

我试图在cookeicutter上建立一个网站,我创建了一个名为“ bots”的新应用,并在模型内添加了一个名为Trade的类,该类列出了2个参数,即“ titles”和“ units”。迁移并运行服务器后,当我打开管理面板并单击面板内的“ +添加”按钮以创建交易时(请参见图片)。Django网页返回此错误:

django.db.utils.ProgrammingError: relation "bot_trade" does not exist
LINE 1: ...."id", "bots_unit"."sell", "bots_unit"."buy" FROM "bots_unit...

附加信息:使用postgreSQL在docker中运行django

管理面板的图片

型号

from django.db import models
from datetime import date
#from django.contrib.auth.models import AbstractUser
#from .models import User
from django.urls import reverse
from django.urls import reverse_lazy
from django.conf import settings
import uuid


class Unit(models.Model):

TRADE_UNIT = (
    ('ETH', 'Ethereum'),
    ('BTC', 'Bitcoin'),
    ('LTC', 'Litecoin'),
    ('IOT', 'IOTA'),
    ('OMG', 'OmiseGo'),
    ('BCH', 'BitcoinCash'),

)

sell = models.CharField(max_length=3, choices=TRADE_UNIT, blank=True, default='ETH', help_text='Currency to Sell')
buy = models.CharField(max_length=3, choices=TRADE_UNIT, blank=True, default='BTC', help_text='Currency to Buy')

def get_absolute_url(self):
    """
    Returns the url to access a particular author instance.
    """
    return reverse('unit-detail', args=[str(self.id)])

def __str__(self):
    """
    String for representing the Model object.
    """
    return '%s, %s' % (self.sell, self.buy)

class Meta:
    db_table = 'bots_unit'
    ordering = ['sell','buy']


class Trade(models.Model):
title = models.CharField(max_length=200)
unit = models.ForeignKey('Unit', on_delete=models.SET_NULL, null=True)


def __str__(self):
    """
    String for representing the Model object.
    """
    return self.title

def get_absolute_url(self):
    """
    Returns the url to access a particular book instance.
    """
    return reverse('trade-detail', args=[str(self.id)])

class Meta:
    db_table = 'bots_trade'


class TradeInstance(models.Model):
"""
Model representing a specific copy of a book (i.e. that can be borrowed from the library).
"""
id = models.UUIDField(primary_key=True, default=uuid.uuid4, help_text="Unique ID for this particular trade across whole database")
trade = models.ForeignKey('Trade', on_delete=models.SET_NULL, null=True)
amount = models.CharField(max_length=200)
price = models.CharField(max_length=200)
imprint = models.CharField(max_length=200)
time_initiated = models.DateTimeField(null=True, blank=True)
#initiator = models.ForeignKey(AbstractUser, 
on_delete=models.SET_NULL, null=True, blank=True)

position_status = (
    ('L', 'Long'),
    ('S', 'Short'),
)

position = models.CharField(max_length=1, choices=position_status, blank=True, default='L', help_text='Order Type')

class Meta:
    ordering = ["position"]


def __str__(self):
    """
    String for representing the Model object
    """
    return '%s (%s)' % (self.id,self.trade.title)

管理员

from django.contrib import admin
from .models import Trade, TradeInstance, Unit



# Define the admin class
@admin.register(Trade)
class TradeAdmin(admin.ModelAdmin):
    pass


@admin.register(Unit)
class UnitAdmin(admin.ModelAdmin):
    pass

UPDATE1:几次删除了migrations文件夹中的内容,但这是在运行“ makemigrations”和“ migrate”之后当前在“ 0001.initial.py”内部的内容:

# -*- coding: utf-8 -*-
# Generated by Django 1.10.8 on 2017-10-12 17:55
from __future__ import unicode_literals

from django.db import migrations, models
import django.db.models.deletion
import uuid


class Migration(migrations.Migration):

    initial = True

    dependencies = [
    ]

    operations = [
        migrations.CreateModel(
            name='Trade',
            fields=[
                ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
                ('title', models.CharField(max_length=200)),
            ],
        ),
        migrations.CreateModel(
            name='TradeInstance',
            fields=[
                ('id', models.UUIDField(default=uuid.uuid4, help_text='Unique ID for this particular trade across whole database', primary_key=True, serialize=False)),
                ('amount', models.CharField(max_length=200)),
                ('price', models.CharField(max_length=200)),
                ('imprint', models.CharField(max_length=200)),
                ('time_initiated', models.DateTimeField(blank=True, null=True)),
                ('position', models.CharField(blank=True, choices=[('L', 'Long'), ('S', 'Short')], default='L', help_text='Order Type', max_length=1)),
                ('trade', models.ForeignKey(null=True, on_delete=django.db.models.deletion.SET_NULL, to='bots.Trade')),
            ],
            options={
                'ordering': ['position'],
            },
        ),
        migrations.CreateModel(
            name='Unit',
            fields=[
                ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
                ('sell', models.CharField(blank=True, choices=[('ETH', 'Ethereum'), ('BTC', 'Bitcoin'), ('LTC', 'Litecoin'), ('IOT', 'IOTA'), ('OMG', 'OmiseGo'), ('BCH', 'BitcoinCash')], default='ETH', help_text='Currency to Sell', max_length=3)),
                ('buy', models.CharField(blank=True, choices=[('ETH', 'Ethereum'), ('BTC', 'Bitcoin'), ('LTC', 'Litecoin'), ('IOT', 'IOTA'), ('OMG', 'OmiseGo'), ('BCH', 'BitcoinCash')], default='BTC', help_text='Currency to Buy', max_length=3)),
            ],
            options={
                'ordering': ['sell', 'buy'],
            },
        ),
        migrations.AddField(
            model_name='trade',
            name='unit',
            field=models.ForeignKey(blank=True, null=True, on_delete=django.db.models.deletion.SET_NULL, to='bots.Unit'),
        ),
    ]

当我运行“ showmigrations”时:

dominic@dom-Inspiron-7559:~/Desktop/Projects/vickibot/vicki$ docker-compose -focal.yml run django python manage.py showmigrations
Postgres is up - continuing...
account
 [X] 0001_initial
 [X] 0002_email_max_length
admin
 [X] 0001_initial
 [X] 0002_logentry_remove_auto_add
auth
 [X] 0001_initial
 [X] 0002_alter_permission_name_max_length
 [X] 0003_alter_user_email_max_length
 [X] 0004_alter_user_username_opts
 [X] 0005_alter_user_last_login_null
 [X] 0006_require_contenttypes_0002
 [X] 0007_alter_validators_add_error_messages
 [X] 0008_alter_user_username_max_length
bots
 [X] 0001_initial
contenttypes
 [X] 0001_initial
 [X] 0002_remove_content_type_name
sessions
 [X] 0001_initial
sites
 [X] 0001_initial
 [X] 0002_alter_domain_unique
 [X] 0003_set_site_domain_and_name
socialaccount
 [X] 0001_initial
 [X] 0002_token_max_lengths
 [X] 0003_extra_data_default_dict
users
 [X] 0001_initial

UPDATE2:

'manage.py migration --fake bots零'输出:

dominic@dom-Inspiron-7559:~/Desktop/Projects/vickibot/vicki$ **docker-compose -f local.yml run django python manage.py migrate --fake bots zero**
Postgres is up - continuing...
Operations to perform:
  Unapply all migrations: bots
Running migrations:
  Rendering model states... DONE
  Unapplying bots.0001_initial... FAKED

'manage.py migration bots'输出:

dominic@dom-Inspiron-7559:~/Desktop/Projects/vickibot/vicki$ docker-compose -f local.yml run django python manage.py migrate bots
Postgres is up - continuing...
Operations to perform:
  Apply all migrations: bots
Running migrations:
  Applying bots.0001_initial... OK
阿拉斯代尔

您可能尚未为机器人应用程序创建任何迁移。您需要指定应用名称来创建初始迁移:

./manage.py makemigrations bot

然后运行迁移运行迁移并创建缺少的表:

./manage migrate

运行时showmigrations,您会看到Django认为它已经为您的bots应用程序应用了初始迁移这可能是因为您--fake为该应用程序奔波。

bots
 [X] 0001_initial

您可以告诉Django将迁移标记为未应用,然后使用以下命令重新运行迁移:

manage.py migrate --fake bots zero
manage.py migrate bots

只要bots尚未创建应用程序中的表,此方法就应该起作用如果仅创建了一些表,则修复数据库将非常棘手。

本文收集自互联网,转载请注明来源。

如有侵权,请联系 [email protected] 删除。

编辑于
0

我来说两句

0 条评论
登录 后参与评论

相关文章

解决“ django.db.utils.ProgrammingError:关系django_migrations的权限被拒绝”的步骤

ProgrammingError:关系“ django_site”不存在

django.db.utils.ProgrammingError:OenBSD vps已经存在关系

django.db.utils.OperationalError:严重:角色“ django”不存在

django.db.utils.ProgrammingError:表不存在

“ django.db.utils.ProgrammingError:关系“ auth_user”不存在” Django V2.0

Docker-psql:django.db.utils.OperationalError:致命:角色“ admin”不存在

ProgrammingError:关系“ django_session”不存在

django.db.utils.ProgrammingError:关系“ django_site_domain_v2339b81_uniq”已存在

将Django连接到Postgres:django.db.utils.OperationalError:严重:数据库“ DATABASENAME”不存在

django.db.utils.ProgrammingError:无法加载:关系“”的列“”不存在

django.db.utils.ProgrammingError:(1146,“表'med_portal.Custparent'不存在”)

django.db.utils.ProgrammingError:使用heroku和djongo不存在column Calculator_calculation._id

django.db.utils.ProgrammingError:类型“ raster”不存在

django.db.utils.OperationalError:致命:数据库不存在(postgres /部署到digitalocean)

Python Django-内部错误ProgrammingError关系不存在

Django测试失败,出现“ django.db.utils.ProgrammingError:关系“ django_content_type”不存在”

django.db.utils.ProgrammingError:关系“ ...”不存在

django.db.utils.OperationalError:严重:数据库“路径”不存在

syncdb django.db.utils.ProgrammingError时出错:关系django_migrations的权限被拒绝

django.db.utils.ProgrammingError:类型“ int4range”不存在

Django Rest框架“ django.db.utils.ProgrammingError:关系“患者”不存在”

django.db.utils.ProgrammingError:列am.amcanorder不存在

django.db.utils.ProgrammingError:关系“choices_keyword”的列“image”已经存在

还有一个“django.db.utils.ProgrammingError:关系“device_gclouddevice”不存在”

django.db.utils.ProgrammingError: 运行 makemigrations 时关系“company_company”不存在

Django 错误“django.db.utils.ProgrammingError:子查询有太多列”

django.db.utils.ProgrammingError:递归模型不存在关系

找不到 django/mysql 表 - django.db.utils.ProgrammingError: (1146, "表 'trustline.authentication_user' 不存在")