PHPackages                             rvkulikov/yii2-scheduler - PHPackages - PHPackages  [Skip to content](#main-content)[PHPackages](/)[Directory](/)[Categories](/categories)[Trending](/trending)[Leaderboard](/leaderboard)[Changelog](/changelog)[Analyze](/analyze)[Collections](/collections)[Log in](/login)[Sign up](/register)

1. [Directory](/)
2. /
3. [Utility & Helpers](/categories/utility)
4. /
5. rvkulikov/yii2-scheduler

ActiveProject[Utility & Helpers](/categories/utility)

rvkulikov/yii2-scheduler
========================

1.4(4y ago)1425MITPHPPHP >=8.0

Since Jul 19Pushed 4y ago2 watchersCompare

[ Source](https://github.com/rvkulikov/yii2-scheduler)[ Packagist](https://packagist.org/packages/rvkulikov/yii2-scheduler)[ RSS](/packages/rvkulikov-yii2-scheduler/feed)WikiDiscussions main Synced 3d ago

READMEChangelog (2)Dependencies (1)Versions (11)Used By (0)

### Подключение к приложению через docker-compose

[](#подключение-к-приложению-через-docker-compose)

```
  myapp.scheduler:
    restart: always
    image: ghcr.io/rvkulikov/yii2-scheduler/scheduler:latest
    environment:
      - PORT=3000
      - REFRESH_INTERVAL=60
      - BASE_URL=myapp.nginx-internal
    links:
      - myapp.nginx-internal
```

### Миграции для схемы бд

[](#миграции-для-схемы-бд)

```
-- noinspection SqlNoDataSourceInspectionForFile
set role "postgres";

do $$ begin
  create user "_app_admin" with createrole password 'password';
  exception
    when duplicate_object
      then raise notice 'not creating user "_app_admin"';
end $$;

do $$ begin
  create role "_app_reader" with noinherit;
  exception
    when duplicate_object
      then raise notice 'not creating role "_app_reader"';
end $$;

create schema if not exists "_app_schedule";
alter schema "_app_schedule" owner to "_app_admin";

grant all on schema "_app_schedule" to "_app_admin";

grant all on all tables in schema "_app_schedule" to "_app_admin";
grant all on all sequences in schema "_app_schedule" to "_app_admin";
grant all on all functions in schema "_app_schedule" to "_app_admin";
grant all on all routines in schema "_app_schedule" to "_app_admin";

alter default privileges in schema "_app_schedule" grant all on tables to "_app_admin";
alter default privileges in schema "_app_schedule" grant all on sequences to "_app_admin";
alter default privileges in schema "_app_schedule" grant all on functions to "_app_admin";
alter default privileges in schema "_app_schedule" grant all on routines to "_app_admin";

-- grant reader
grant usage on schema "_app_schedule" to "_app_reader";

grant select on all tables in schema "_app_schedule" to "_app_reader";
grant select on all sequences in schema "_app_schedule" to "_app_reader";

alter default privileges in schema "_app_schedule" grant select on tables to "_app_reader";
alter default privileges in schema "_app_schedule" grant select on sequences to "_app_reader";

set role "_app_admin";
  alter default privileges in schema "_app_schedule" grant select on tables to "_app_reader";
  alter default privileges in schema "_app_schedule" grant select on sequences to "_app_reader";
set role postgres;

```

### Настройки в конфиге приложения

[](#настройки-в-конфиге-приложения)

```