主页 / user-234134

Violet's questions

Martin Hope
Violet
Asked: 2020-06-20 17:18:42 +0000 UTC
  • 4

有3个列表：

a = [12, 12, 12, 12, 1, 1, 1]
b = [20, 21, 22, 23, 200, 201, 202]
c = ['04-04', '05-05', '06-06', '07-07', '008-008', '009-009', '100-100']

需要一个唯一值 froma来导出一个映射 fromb等于c值的重复次数a，即：

uid=12

  • 20 04-04
  • 21 05-05
  • 22 06-06
  • 23 07-07

uid=1

  • 200 008-008
  • 201 009-009
  • 202 100-100

输出唯一值a：

    for i in range(0, len(list(set(a)))):
        print('uid=' + str(sorted(set(a), key=a.index)[i]))
    >>> uid=12
    >>> uid=1

中的重复元素数a：

for i in range(0, len(list(set(a)))):
    print(a.count(sorted(set(a), key=a.index)[i]))
>>> 4
>>> 1

匹配b和c：

x = []
for j, o in zip(b, c):
    x.append(str(j) + ':' + o)
print(x)
>>> ['20:04-04', '21:05-05', '22:06-06', '23:07-07', '200:008-008', '201:009-009', '202:100-100']

进一步昏迷，如何比较我不知道

python
Martin Hope
Violet
Asked: 2020-06-18 02:08:28 +0000 UTC
  • 1

有两个表：

表 A：number, inn, sum, status

表 B：inn, sum, number

需要比较两个表中的 inn 和 sum 的值是否相等（A.inn=B.inn and A.sum=B.sum）

如果我没有搞砸任何事情，那么请求将是这样的：

select A.inn, A.sum, A.number from A LEFT join B on A.inn=B.inn and A.sum=B.sum where B.number is 'not mapped'

现在我需要不断更新A.status，这就是问题所在+，因为据我了解，SQLite 不支持 UPDATE statements 中的 JOIN。B.numberA.number

如何做到这一点，有可能吗？

sql
Martin Hope
Violet
Asked: 2020-01-26 20:12:03 +0000 UTC
  • 1

该页面有一个搜索表单，通过 ajax 处理：

<body>
<script>
    function get_data() {
        $.ajax({
            url: "/get_data",
            data: $('form').serialize(),
            type: 'POST',
            success: function(response) {
                var json = jQuery.parseJSON(response)
                $('#data').html(json.data)
                console.log(response);
            },
            error: function(error) {
                console.log(error);
            }
        });
    }
</script>
<form onsubmit="get_data();return false" action="" method="post" id="form" name="form">
            <div class="input-group mb-3">
                <div class="input-group-prepend">
                    <span class="input-group-text" id="basic-addon1">{{count}}</span>
                </div>
                <input type="text" class="form-control" id="name" name="name" aria-describedby="button-addon2"
                required
                oninvalid="this.setCustomValidity('Заполните это поле')" oninput="setCustomValidity('')">
                <div class="input-group-append">
                    <button class="btn btn-outline-secondary" type="submit" name="finduser" value="Validate" onclick="get_data();">
                        Поиск
                    </button>
                </div>
            </div>
        </form>
<div id="data"></div>

它工作得很好，将数据传递给我的 python 并将数据返回到页面：

        @app.route('/get_data', methods=['POST'])
        def get_data():
        if request.form['name'] == '':
           lst = search_user(request.form['name'].lower())
           return json.dumps({'data': render_template('response.html', 
           lst=lst, len=range(0, len(lst)))})

我需要添加另一个表单，我创建了

@app.route('/add_data', methods=['POST'])
def add_data():
  print(request.form['l_name'])

向页面添加了一个新表单，并复制了该功能：

<script>
    function add_data() {
        $.ajax({
            url: "/add_data",
            data: $('adduser').serialize(),
            type: 'POST',
            success: function(response) {
                console.log(response);
            },
            error: function(error) {
                console.log(error);
            }
        });
    }
</script>

    <form onsubmit="add_data();return false" action="" method="post" id="adduser" name="adduser">
  <div class="form-row">
    <div class="col-md-4 mb-3">
      <input type="text" class="form-control" id="l_name" name="l_name" placeholder="Фамилия" required oninvalid="this.setCustomValidity('Заполните это поле')" oninput="setCustomValidity('')">
  </div>
  </div>
  </form>
  <button class="btn btn-success" type="submit" name="adduser" value="Validate" onclick="add_data();">Добавить</button>

但它没有用。我在 PyCharm 控制台中遇到错误：

print(request.form['l_name'])
raise exceptions.BadRequestKeyError(key)
KeyError: 'l_name'

如何通过 ajax 从不同形式的 python 中获取数据？

python
Martin Hope
Violet
Asked: 2020-07-18 21:26:25 +0000 UTC
  • -2
Array
(
    [id] => 164770127965849081
    [app] => 54680000
    [user_id] => 
    [presence] => offline
    [presence_details] => Array
        (
            [presence] => offline
        )

    [props] => Array
        (
            [$last_seen] => 2016-07-18T10:06:39
            [$sessions] => 1
            [$longitude] => 36.00000
            [$country] => Russia
            [$score] => 26
            [$active_device_guid] => ffffffff-aaaa-4444-cccc-ec82488ff21b
            [$name_placeholder] => honey-brown-sandwich
            [$latitude] => 50.0000
            [$conversations_emails] => 2
            [$email] => 123@123.com
            [$device_type] => mobile
            [$last_contacted] => 2016-07-16T16:20:16
            [$initial_referrer] => https://yandex.ru/
            [$region] => Belgorodskaya Oblast'
            [$last_session_referrer] => https://yandex.ru/
            [$initial_referrer_domain] => yandex.ru
            [$viewed_products] => Array
                (
                    [0] => Двухфазный кондиционер №1 Q3 для сильно поврежд волос
                    [1] => Масло №2 Q3 для поврежденных волос
                    [2] => Набор для заботливой мамы
                    [3] => Сыворотка для волос Манго ESTEL MOHITO 60 мл
                    [4] => Масло-блеск №3 Q3 для всех типов волос
                )

            [$city] => Belgorod
        )

    [props_custom] => Array
        (
        )

)

需要从 [props] => Array 获取 [$email]

php
Martin Hope
Violet
Asked: 2020-02-03 21:26:52 +0000 UTC
  • 2
shiftlist = {'fn': key, 'begin': begintime, 'end': endtime}
    ag = requests.get(URlshiftlist, headers=ST, params=shiftlist)
    string = json.loads(ag.text)
    title = string['records']
    a = [item['closeDateTime'] for item in title]
    print(a)

并且可能包含：

a = [2018-02-03T15:02:57]

a = [None]

a = []

    if a:
        URL = tlgrm
        msg = {'chat_id': 0000, 'text': '✅ ' + value + ' | Bla'}
        r = requests.post(URL, data=msg)

    if not a:
        URL = tlgrm
        msg = {'chat_id': 0000, 'text': 'ℹ️ ' + value + ' | Bla bla'}
        r = requests.post(URL, data=msg)

if a: 当 a = [2018-02-03T15:02:57] 和 a = [None] 时作出反应

如何使 if a：仅在 a = [2018-02-03T15:02:57] 时做出反应？

python