主页 / user-562343

NiK's questions

Martin Hope
NiK
Asked: 2024-11-22 21:37:58 +0000 UTC
  • 5

有2个集装箱。第一个是数据库（PostgreSQL），第二个是Python应用程序。我正在使用sqlalchemy。

SQLAlchemy 网址：postgresql+asyncpg://{USER}:{PASSWORD}@{SERVER}:{PORT}/{DB}

引擎：engine = create_async_engine(url=config.DATABASE_URL)

Docker 组合：

networks:
  network:

services:
  database:
    image: postgres:17.0-alpine3.20
    restart: always
    healthcheck:
      test: ["CMD-SHELL", "pg_isready -U ${POSTGRES_USER} -d ${POSTGRES_DB}"]
      interval: 10s
      retries: 5
      start_period: 10s
      timeout: 5s
    ports:
      - ${POSTGRES_PORT}:${POSTGRES_PORT}
    expose:
      - "${POSTGRES_PORT}"
    volumes:
      - database:${POSTGRES_DATA}
    env_file:
      - .env
    environment:
      - PGDATA=${POSTGRES_DATA}
      - POSTGRES_PASSWORD=${POSTGRES_PASSWORD?Variable not set}
      - POSTGRES_USER=${POSTGRES_USER?Variable not set}
      - POSTGRES_DB=${POSTGRES_DB?Variable not set}
    command: -p ${POSTGRES_PORT}
    deploy:
      resources:
        limits:
          cpus: '1'
          memory: 128M
    networks:
      - network

  bot:
    env_file:
      - .env
    build:
      context: ./bot
    depends_on:
      - database
    deploy:
      resources:
        limits:
          cpus: '1'
          memory: 128M
    networks:
      - network

volumes:
  database:

错误：

bot-1       |   File "/usr/local/lib/python3.12/asyncio/base_events.py", line 1129, in create_connection
bot-1       |     raise OSError('Multiple exceptions: {}'.format(
bot-1       | OSError: Multiple exceptions: [Errno 111] Connect call failed ('::1', 9999, 0, 0), [Errno 111] Connect call failed ('127.0.0.1', 9999)

Postgres 日志：

database-1  | 
database-1  | PostgreSQL Database directory appears to contain a database; Skipping initialization
database-1  | 
database-1  | 2024-11-22 13:33:10.995 UTC [1] LOG:  starting PostgreSQL 17.0 on x86_64-pc-linux-musl, compiled by gcc (Alpine 13.2.1_git20240309) 13.2.1 20240309, 64-bit
database-1  | 2024-11-22 13:33:10.995 UTC [1] LOG:  listening on IPv4 address "0.0.0.0", port 9999
database-1  | 2024-11-22 13:33:10.995 UTC [1] LOG:  listening on IPv6 address "::", port 9999
database-1  | 2024-11-22 13:33:10.999 UTC [1] LOG:  listening on Unix socket "/var/run/postgresql/.s.PGSQL.9999"
database-1  | 2024-11-22 13:33:11.009 UTC [28] LOG:  database system was shut down at 2024-11-22 13:33:10 UTC
database-1  | 2024-11-22 13:33:11.017 UTC [1] LOG:  database system is ready to accept connections
python-3.x
Martin Hope
NiK
Asked: 2023-08-01 01:40:53 +0000 UTC
  • 5

我已经编写了一个机器人（在 pyTelegramBotAPI\telebot 上），我想添加一个后退按钮，该按钮将恢复到之前的“布局”。我没有什么想法=(

代码：

@bot.message_handler(content_types=['text'])
def logic(message):
    if message.text == 'Каталог🛍':
        markup_catalog = types.ReplyKeyboardMarkup(resize_keyboard=True, row_width=1)
        sets = types.KeyboardButton('Кейсы📦')
        popular = types.KeyboardButton('Популярное🎁')
        site = types.KeyboardButton('Весь каталог(На сайте🌐)')
        markup_catalog.add(sets, popular, site)
        status_text(message)
        bot.send_message(message.chat.id, 'Выберите 👇', reply_markup=markup_catalog)
    elif message.text == 'Кейсы📦':
        markup_case = types.ReplyKeyboardMarkup(resize_keyboard=True, row_width=1)
        Flex_Box = types.KeyboardButton('Flex Box')
        Immuno_Box = types.KeyboardButton('Immuno Box')
        Beauty_Box = types.KeyboardButton('Beauty Box')
        Detox_Box = types.KeyboardButton('Detox Box')
        markup_case.add(Flex_Box, Immuno_Box, Beauty_Box, Detox_Box)
        status_photo(message)
        bot.send_photo(message.chat.id, photo=open('photo_box.jpg', 'rb'), caption='Выберите подходящий вам box 👇', reply_markup=markup_case)

等等

PS 我是新人，这是我的第一个机器人。

python