主页 / user-197719

Tihon's questions

Martin Hope
Tihon
Asked: 2020-01-22 07:10:31 +0800 CST
  • 4

如果我设置了参数border-collapse: collapse，那么边框是可见的。是什么规范了这种行为？

table { 
  width: 100%;
  border-collapse: collapse;
}
thead {
 border-top: solid 1px;
}
 <table>
   <thead>
     <tr> 
      <th>&nbsp;</th><th>2013</th>
      <th>2014</th><th>2015</th>
     </tr>
   </thead>
   <tbody>
     <tr> 
      <td>Нефть</td><td>43</td>
      <td>51</td><td>79</td>
     </tr>
     <tr> 
      <td>Золото</td><td>29</td>
      <td>34</td><td>48</td>
     </tr>
     <tr> 
      <td>Дерево</td><td>38</td>
      <td>57</td><td>36</td>
     </tr>
   </tbody>
  </table>

否则：

table { width: 100%; border-collapse: separate; }
thead { border-top: solid 1px; }
<table>
   <thead>
     <tr> 
      <th>&nbsp;</th><th>2013</th>
      <th>2014</th><th>2015</th>
     </tr>
   </thead>
   <tbody>
     <tr> 
      <td>Нефть</td><td>43</td>
      <td>51</td><td>79</td>
     </tr>
     <tr> 
      <td>Золото</td><td>29</td>
      <td>34</td><td>48</td>
     </tr>
     <tr> 
      <td>Дерево</td><td>38</td>
      <td>57</td><td>36</td>
     </tr>
   </tbody>
  </table>

html
Martin Hope
Tihon
Asked: 2020-04-27 20:12:11 +0800 CST
  • 0

我想得到一个数据透视表，其值是code/name/plan/actual/。

当尝试执行下面的代码时，当执行union_all()时，我们得到一个没有subquery()方法的CompoundSelect对象。应该如何重写查询以获得期望的结果？

meta = request.sa.base.metadata
classifier_table = Table('classifier', meta, autoload=True, 
    autoload_with=request.sa.engine)
plan_table = Table('revenueplan', meta, autoload=True, 
    autoload_with=request.sa.engine)
fact_table = Table('revenuefact', meta, autoload=True, 
    autoload_with=request.sa.engine)

_base_classifier_columns = [
    classifier_table.c.id.label('id'),
    classifier_table.c.full_name.label('name'),
    classifier_table.c.code.label('code')
]

_mock_null = literal_column(text='0')
_mock_null_plan = _mock_null.label(name='plan')
_mock_null_fact = _mock_null.label(name='fact')

_mock_at_start_of_year = datetime(datetime.now().year, 1, 1)
_mock_today = datetime.now()

_sum_plan = func.sum(plan_table.c.value).label('plan')
_sum_fact = func.sum(fact_table.c.value).label('fact')

_join_plan_w_classifier = join(classifier_table, plan_table, 
     classifier_table.c.id == plan_table.c.classifier_id)
_join_fact_w_classifier = join(classifier_table, fact_table, 
     classifier_table.c.id == fact_table.c.classifier_id)

_plan_1st = select(
    _base_classifier_columns + [
        plan_table.c.value.label('plan'), _mock_null_fact
     ]).select_from(_join_plan_w_classifier)\
     .where(between(plan_table.c.date, _mock_at_start_of_year, _mock_today))\
    .group_by(classifier_table.c.id)
 _fact_1st = select(
     _base_classifier_columns + [
         _mock_null_plan, fact_table.c.value.label('fact')
     ]).select_from(_join_fact_w_classifier)\
     .where(between(fact_table.c.date, _mock_at_start_of_year, _mock_today))\
     .group_by(classifier_table.c.id)
_union_year = union_all(_plan_1st, _fact_1st)
_sub_union_year = _union_year.subquery('_sub_union_year')
#                            ^
#                            Здесь ошибка, 
stmt = select([
    _sub_union_year.c.id,
    _sub_union_year.c.name,
    _sub_union_year.c.code,
    func.Sum(_sub_union_year.c.plan).label('plan'),
    func.Sum(_sub_union_year.c.fact).label('fact')
]).where.select_from(_sub_union_year).group_by(_sub_union_year.c.id)
python
Martin Hope
Tihon
Asked: 2020-04-16 21:27:12 +0800 CST
  • 0

是否可以从模型创建一个 QuerySet 并在选择中定义一个所有值都等于“0.0”的字段，而不会像使用 QuerySet 那样失去使用查询对象及其字段的能力？联合之后，我想用另一个选择做一个“联合所有”，并计算“计划”和“事实”字段的总和。

除了 RAW 请求之外，还应该考虑哪些其他解决方案？

from django.db.models import Model, ForeignKey, TextField, DecimalField, DateField, CASCADE

class ModelValueMixin(Model):
    date = DateField(auto_now=True)
    value = DecimalField()
    classifier = ForeignKey('Catalog', on_delete=CASCADE)

    class Meta:
        abstract = True

class ModelValue1(ModelValueMixin):
    pass

class ModelValue2(ModelValueMixin):
    pass

class Catalog(Model):
    code = TextField()
    name = TextField()

我如何使用 SQLAlchemy 查看它的示例：

session.query(
    ModelValues1.value.label('plan'),
    literal_column('0').label('fact'),
    ModelCatalog.code.label('code'), 
    ModelCatalog.name.label('name')
).select_from(ModelValues1).outerjoin(ModelCatalog)

直接在 SQL 中——我是这样看的：

SELECT
  "catalog"."id",
  "catalog"."code",
  "catalog"."full_name",
  "values1"."value" AS "plan",
  (0) AS "fact"
FROM "catalog"
  LEFT OUTER JOIN "values1"
    ON (catalog."id" = "values1"."catalog_id")

最终目标是获得一个包含字段“code”、“name”、“sum_plan”、“sum_fact”的数据透视表。

python
Martin Hope
Tihon
Asked: 2020-03-02 22:22:47 +0800 CST
  • 1

当您尝试向服务器发出请求时 - 不会发送标头。

<!DOCTYPE html>
<head>
  <title>Devpage</title>
</head>
<body>
</body>
<script type="text/javascript">
  const myHeaders = new Headers();
  myHeaders.set('Authorization', 'Basic dXNlcjpwd2Q='); // user:pwd
  fetch(
    'http://tihonv.pythonanywhere.com/', {
      method: 'POST',
      mode: 'no-cors',
      headers: myHeaders,
    }).then((resp) => console.log(resp));
</script>

发送请求时，不发送标头。

您可以通过在此处发送请求进行检查

javascript
Martin Hope
Tihon
Asked: 2020-02-20 00:14:03 +0800 CST
  • 1

我用一个自己写的脚本通过ods文档从一个遗留产品上传数据。

当前实施：

import ezodf
from . import db

ezodf.config.set_table_expand_strategy('all')
current_spreadsheet = ezodf.opendoc(filename='./table1.ods')
current_table = current_spreadsheet.sheets[-1]
for row_num in range(current_table.nrows()):
    db.session.add(
        Model_1(
            id=current_table['a%s' % row_num].value,
            name=current_table['b%s' % row_num].value
            )
    )

db.session.commit()

由于表的数量非常可观并且它们具有不同的结构，所以我想像这样梳理代码：

with ezodf.opendoc(filename='./table1.ods') as spreadsheet:
    with spreadsheet.sheets[-1] as table:
        for row_num in range(table.nrows()):
            db.session.add(
                Model_1(
                    id=table['a%s' % row_num].value,
                    name=table['b%s' % row_num].value
                 )
            )

但是当我运行第二个选项时，我得到以下信息：

File "uploader.py", line 36, in <module>
    with ezodf.opendoc(filename='./table_1.ods') as spreadsheet:
AttributeError: __exit__

如何绕过/捕获此错误？

ezodf - 0.3.2
lxml - 3.7.2
python - 3.5
python
Martin Hope
Tihon
Asked: 2020-12-19 18:23:52 +0800 CST
  • 1

我正在学习 NodeJS。我想确保每个项目都有自己的环境，同时不存储系统范围的依赖项。

这是如何正确完成的（使用 python-nodeenv、chroot、docker，或者只是一个带有 node_modules+package.json 的目录）？

JebBrains 产品（调试、检查、自动完成）是否会与具有此类用途的项目一起使用？

javascript
Martin Hope
Tihon
Asked: 2020-11-19 03:35:21 +0800 CST
  • 0
$>dialplan show in
[ Context 'in' created by 'pbx_config' ]
'0123456789' =>   1. NoOp()                                     [pbx_config]
                  2. Answer()                                   [pbx_config]
                  3. Stasis(myapp)                              [pbx_config]
                  4. Hangup()                                   [pbx_config]

$> pjsip show endpoint pnt
Endpoint:  pnt                                   Not in use    0 of inf
context                                           in

$>module show like  res_stasis
Module                         Description                               Use Count  Status      Support Level
res_stasis.so                  Stasis application support               12         Running              core
res_stasis_answer.so           Stasis application answer support        0          Running              core
res_stasis_device_state.so     Stasis application device state support  0          Running              core
res_stasis_playback.so         Stasis application playback support      0          Running              core
res_stasis_recording.so        Stasis application recording support     0          Running              core
res_stasis_snoop.so            Stasis application snoop support         0          Running              core
6 modules loaded

当呼叫到达“in”上下文时，我得到：

res_stasis.c:1268 stasis_app_exec: Stasis app 'myapp' not registered

星号 13.12.1

如何处理？

asterisk