会员可以在此提问,百战程序员老师有问必答
对大家有帮助的问答会被标记为“推荐”
看完课程过来浏览一下别人提的问题,会帮你学得更全面
截止目前,同学们一共提了 132600个问题
Python 全系列/第十九阶段:数据分析-数据管理/数据分析案例_案例1_足球数据分析 27376楼

1570705651(1).png

老师为什么输出不是66而是把22复制3次

Python 全系列/第一阶段:Python入门/编程基本概念 27377楼
JAVA 全系列/(隐藏)第三十阶段:设计模式/框架源码分析(拓展)/GOF23 设计模式 27378楼

微信图片java.png


为什么我的命令和代码不一样

JAVA 全系列/第一阶段:JAVA 快速入门/JAVA入门和背景知识 27381楼

from django.db import models

# Create your models here.
class Question(models.Model):
    question_text = models.CharField(max_length=200)
    pub_date = models.DateTimeField()

上面是orm类

下面是python manage.py makemigrations mosel_app创建得0001

# Generated by Django 2.2.6 on 2019-10-25 02:46

from django.db import migrations, models


class Migration(migrations.Migration):

    initial = True

    dependencies = [
    ]

    operations = [
        migrations.CreateModel(
            name='Question',
            fields=[
                ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
                ('question_text', models.CharField(max_length=200)),
                ('pub_date', models.DateTimeField()),
            ],
        ),
    ]

但是在cmd运行python manage.py migrate  出现下面错误

Operations to perform:

  Apply all migrations: admin, auth, contenttypes, model_app, sessions

Running migrations:

Traceback (most recent call last):

  File "D:\python_virtualEnv\django_env\lib\site-packages\django\db\backends\utils.py", line 82, in _execute

    return self.cursor.execute(sql)

  File "D:\python_virtualEnv\django_env\lib\site-packages\django\db\backends\mysql\base.py", line 71, in execute

    return self.cursor.execute(query, args)

  File "D:\python_virtualEnv\django_env\lib\site-packages\MySQLdb\cursors.py", line 209, in execute

    res = self._query(query)

  File "D:\python_virtualEnv\django_env\lib\site-packages\MySQLdb\cursors.py", line 315, in _query

    db.query(q)

  File "D:\python_virtualEnv\django_env\lib\site-packages\MySQLdb\connections.py", line 226, in query

    _mysql.connection.query(self, query)

MySQLdb._exceptions.ProgrammingError: (1064, "You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '(6) NOT NULL)' at line 1")


The above exception was the direct cause of the following exception:


Traceback (most recent call last):

  File "D:\python_virtualEnv\django_env\lib\site-packages\django\db\migrations\recorder.py", line 67, in ensure_schema

    editor.create_model(self.Migration)

  File "D:\python_virtualEnv\django_env\lib\site-packages\django\db\backends\base\schema.py", line 307, in create_model

    self.execute(sql, params or None)

  File "D:\python_virtualEnv\django_env\lib\site-packages\django\db\backends\base\schema.py", line 137, in execute

    cursor.execute(sql, params)

  File "D:\python_virtualEnv\django_env\lib\site-packages\django\db\backends\utils.py", line 99, in execute

    return super().execute(sql, params)

  File "D:\python_virtualEnv\django_env\lib\site-packages\django\db\backends\utils.py", line 67, in execute

    return self._execute_with_wrappers(sql, params, many=False, executor=self._execute)

  File "D:\python_virtualEnv\django_env\lib\site-packages\django\db\backends\utils.py", line 76, in _execute_with_wrappers

    return executor(sql, params, many, context)

  File "D:\python_virtualEnv\django_env\lib\site-packages\django\db\backends\utils.py", line 84, in _execute

    return self.cursor.execute(sql, params)

  File "D:\python_virtualEnv\django_env\lib\site-packages\django\db\utils.py", line 89, in __exit__

    raise dj_exc_value.with_traceback(traceback) from exc_value

  File "D:\python_virtualEnv\django_env\lib\site-packages\django\db\backends\utils.py", line 82, in _execute

    return self.cursor.execute(sql)

  File "D:\python_virtualEnv\django_env\lib\site-packages\django\db\backends\mysql\base.py", line 71, in execute

    return self.cursor.execute(query, args)

  File "D:\python_virtualEnv\django_env\lib\site-packages\MySQLdb\cursors.py", line 209, in execute

    res = self._query(query)

  File "D:\python_virtualEnv\django_env\lib\site-packages\MySQLdb\cursors.py", line 315, in _query

    db.query(q)

  File "D:\python_virtualEnv\django_env\lib\site-packages\MySQLdb\connections.py", line 226, in query

    _mysql.connection.query(self, query)

django.db.utils.ProgrammingError: (1064, "You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '(6) NOT NULL)' at line 1")


During handling of the above exception, another exception occurred:


Traceback (most recent call last):

  File "manage.py", line 21, in <module>

    main()

  File "manage.py", line 17, in main

    execute_from_command_line(sys.argv)

  File "D:\python_virtualEnv\django_env\lib\site-packages\django\core\management\__init__.py", line 381, in execute_from_command_line

    utility.execute()

  File "D:\python_virtualEnv\django_env\lib\site-packages\django\core\management\__init__.py", line 375, in execute

    self.fetch_command(subcommand).run_from_argv(self.argv)

  File "D:\python_virtualEnv\django_env\lib\site-packages\django\core\management\base.py", line 323, in run_from_argv

    self.execute(*args, **cmd_options)

  File "D:\python_virtualEnv\django_env\lib\site-packages\django\core\management\base.py", line 364, in execute

    output = self.handle(*args, **options)

  File "D:\python_virtualEnv\django_env\lib\site-packages\django\core\management\base.py", line 83, in wrapped

    res = handle_func(*args, **kwargs)

  File "D:\python_virtualEnv\django_env\lib\site-packages\django\core\management\commands\migrate.py", line 234, in handle

    fake_initial=fake_initial,

  File "D:\python_virtualEnv\django_env\lib\site-packages\django\db\migrations\executor.py", line 91, in migrate

    self.recorder.ensure_schema()

  File "D:\python_virtualEnv\django_env\lib\site-packages\django\db\migrations\recorder.py", line 69, in ensure_schema

    raise MigrationSchemaMissing("Unable to create the django_migrations table (%s)" % exc)

django.db.migrations.exceptions.MigrationSchemaMissing: Unable to create the django_migrations table ((1064, "You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '(6) NOT NULL)' at line 1"))

提示我一个语法错误,什么NOT NULL,这是什么意思???

Python 全系列/第十二阶段:Python_Django3框架/Django初级 27382楼
JAVA 全系列/第十六阶段:前后端分离技术VUE/Vue3 27383楼
大数据全系列/第二十四阶段:CDH集群管理/Cloudera Manager 安装及CDH安装 27384楼
JAVA 全系列/第四阶段:网页编程和设计/Javascript 语言(旧) 27385楼
WEB前端全系列/第二十一阶段:Angular知识体系/Angular基础 27386楼

常量.png

Python 全系列/第一阶段:Python入门/编程基本概念 27387楼
JAVA 全系列/第十八阶段:亿级高并发电商项目_架构/编码(旧)/电商:使用RabbitMQ实现大广告异步缓存 27389楼

struct
math
threading
time
sys
multiprocessing
multiprocessing Process


read_csv(filename):

    start_time = time.time()

    sem
    sem = threading.Semaphore()

    file
    file = (filename, )
    (% file.read().decode())

    encoded_triangles = file.read()
    triangles = .from_bytes(encoded_triangles, )

    manager = multiprocessing.Manager()
    return_tot = manager.dict()
    totals = []

    return_coord = manager.dict()
    coords = []


    index (, ):
        p = Process(=thread_compute, =(index, triangles, return_tot, return_coord))
        totals.append(p)
        coords.append(p)
        p.start()
    
    index (, ):
        p.join()

    total_area = index (, ):
        total_area += return_tot[index]

    min_box = find_box(return_coord[], return_coord[], return_coord[], return_coord[])

    end_time = time.time()
    total_time = end_time - start_time

    triangles, total_area, min_box, total_time

thread_compute(index, triangles, return_tot, return_coord):
    total_area = min_max = []

    start = (index * triangles / )
    (triangles / )  > triangles - :
        end = triangles
    :
        end = start + (triangles / )

    triangle (start, end):
        
        sem.acquire()
        = [file.read(), file.read(), file.read()]
        p1 = [file.read(), file.read(), file.read()]
        p2 = [file.read(), file.read(), file.read()]
        p3 = [file.read(), file.read(), file.read()]
        = file.read()
        sem.release()

        p1, p2, p3 = process_coord(p1, p2, p3)
        tri_area = compute(p1, p2, p3)

        total_area += tri_area

        temp = []
        i (,):
            temp.append(([p1[i], p2[i], p3[i]]))
        i (,):
            temp.append(([p1[i], p2[i], p3[i]]))

        triangle == start:
            min_max = temp
        :
            i (,):
                temp[i] < min_max[i]:
                    min_max[i] = temp[i]
            i (,):
                temp[i] > min_max[i]:
                    min_max[i] = temp[i]

    return_coord[index] = min_max
    return_tot[index] = total_area

process_coord(p1, p2, p3):
    p1 = convert_values(p1)
    p2 = convert_values(p2)
    p3 = convert_values(p3)
    p1, p2, p3

convert_values(point):
    [struct.unpack(, point[])[],
            struct.unpack(, point[])[],
            struct.unpack(, point[])[]]

compute(p1, p2, p3):
    a = math.sqrt((p2[] - p1[]) ** + (p2[] - p1[]) ** + (p2[] - p1[]) ** )
    b = math.sqrt((p3[] - p1[]) ** + (p3[] - p1[]) ** + (p3[] - p1[]) ** )
    c = math.sqrt((p3[] - p2[]) ** + (p3[] - p2[]) ** + (p3[] - p2[]) ** )
    p = (a + b + c) / area = math.sqrt(p * (p - a) * (p - b) * (p - c))
    area

find_box(min_max1, min_max2, min_max3, min_max4):

    = []
    min_max = min_max1

    i (,):
        min_max2[i] < min_max[i]:
            min_max[i] = min_max2[i]
    i (,):
        min_max2[i] > min_max[i]:
            min_max[i] = min_max2[i]
    i (,):
        min_max3[i] < min_max[i]:
            min_max[i] = min_max3[i]
    i (,):
        min_max3[i] > min_max[i]:
            min_max[i] = min_max3[i]
    i (,):
        min_max4[i] < min_max[i]:
            min_max[i] = min_max4[i]
    i (,):
        min_max4[i] > min_max[i]:
            min_max[i] = min_max4[i]
    
    
    line1 = math.sqrt((min_max[] - min_max[]) ** )
    line2 = math.sqrt((min_max[] - min_max[]) ** )
    line3 = math.sqrt((min_max[] - min_max[]) ** )
    box = % (line1, line2, line3)
    box

show_output(triangles, total_area, min_box, ):
    (% triangles)
    (% total_area)
    (% min_box)
    (% )

__name__ == :
    (sys.argv) < :
        ()
    filename = (sys.argv[])
    triangles, total_area, min_box, total_time = read_csv(filename)
    show_output(triangles, total_area, min_box, total_time)


image.png

老师,您帮我看看,这个报这个错误,我应该在哪里输入文件名字

Python 全系列/第二阶段:Python 深入与提高/游戏开发-坦克大战 27390楼

课程分类

百战程序员微信公众号

百战程序员微信小程序

©2014-2025百战汇智(北京)科技有限公司 All Rights Reserved 北京亦庄经济开发区科创十四街 赛蒂国际工业园
网站维护:百战汇智(北京)科技有限公司
京公网安备 11011402011233号    京ICP备18060230号-3    营业执照    经营许可证:京B2-20212637