Supervisor

Use supervisord on http://localhost:9001/

Status column sort issue

Hi when i want to sort by status, get an error:

Column not found: 1054 Unknown column 'status' in 'order clause'

Query:

SELECT
  *
FROM
  `job_manager`
ORDER BY
  `status` ASC
limit
  10 OFFSET 0

Can you manage this?

Thanks!

Z

Testing

Jobs has currently no fully automated tests, but we are on the way to automate testing. We need two kind of tests:

The install and update commands
The installed application itself

and there are some things to consider:

Is Filament already installed or not? Our installer provides auto-installation including Filament.
Is there data to migrate? Our updater migrates existing data and needs demo data for this.
It is important to test different platforms (Linux, Mac, Windows), environments (Forge-Server, Shared Hosts, Local development) and queue drivers (Redis, Database, Sync, SQS, Beanstalkd)

Test installation

composer create-project laravel/laravel moox-test
cd moox-test
mysqladmin -u root -p create moox-test
composer require filament/filament
php artisan filament:install --panels
php artisan make:filament-user
composer require moox/jobs
php artisan mooxjobs:install
mkdir monorepo
cd monorepo
git clone https://github.com/mooxphp/moox
cp app/Jobs/* ../app/Jobs/
cp app/Console/Commands/* ../app/Console/Commands/
cp app/Console/kernel.php ../app/Console/kernel.php
# final steps depend on the target system
composer require laravel/horizon # Forge only
php artisan queue:work
php artisan schedule:work

Run for a few hours on Forge, Vapor, Shared Hosting, Windows and Mac

Test the update

composer create-project laravel/laravel moox-test
cd moox-test
mysqladmin -u root -p create moox-test
composer require filament/filament
php artisan filament:install --panels
php artisan make:filament-user
composer require moox/jobs:2.0.9
php artisan mooxjobs:install
mkdir monorepo
cd monorepo
git clone https://github.com/mooxphp/moox
mysql -u root -p moox-test < database/sql/jobs/v2/failed_jobs.sql
mysql -u root -p moox-test < database/sql/jobs/v2/job_batches.sql
mysql -u root -p moox-test < database/sql/jobs/v2/job_manager.sql
mysql -u root -p moox-test < database/sql/jobs/v2/jobs.sql
cd ..
composer require moox/jobs:3.0
composer update
php artisan mooxjobs:update

Test installation with Filament install

composer create-project laravel/laravel moox-test
cd moox-test
mysqladmin -u root -p create moox-test
composer require filament/filament
composer require moox/jobs
php artisan mooxjobs:install

Test installation with Filament require

composer create-project laravel/laravel moox-test
cd moox-test
mysqladmin -u root -p create moox-test
composer require moox/jobs
php artisan mooxjobs:install

Cleanup after testing

mysql -u root -p drop database moox-test
cd ..
rm -Rf moox-test

Mount Jobs

Let's see the undone.

"Total Execution Time" not working on Jobs page

On both the Jobs and Jobs Waiting page the "Total Execution Time" widget is not working.
See screenshot below.

Cron

Translations

German missing, some strings in Failed and Batch Resources are not translatable yet.

filament 3 install plaguns in authMiddleware

Minor codacy issue

https://app.codacy.com/gh/mooxphp/moox/issues/current?levels=Warning

Tests

Include the tests
Be more welcoming
Github Actions
Badges, of course

Scheduler

Laravel Schedule: https://v2.filamentphp.com/plugins/husam-tariq-database-schedule
require and move in navigation, add to readme
or include

Queue Monitor and Control

Idea:

Controlling the queue worker, running or not
Start, Stop (Gracefully, Hard) and Restart the qw

https://github.com/romanzipp/Laravel-Queue-Monitor/

Prepare for V3

Attention:

Moox Jobs V3.0 is a breaking release. There are some database table changes and an update command. .

There are several reasons to craft this release:

Some column sortings (like Status) are not working
Non-database queue drivers do not support pending jobs
The plugin does not offer control over queue workers or Supervisor

These improvements need additional database tables and change of existing fields, means a breaking change.

Our plan is to craft V3.0 that brings all needed db-changes, as well as an update command that does all the work.

Links:

https://github.com/mooxphp/moox/tree/feature/jobs-v3

Tasks:

After preparation, these features could roll in separate minor releases as non-breaking changes:

Full Redis support
Full SQS support
Full Beanstalkd support
Managing queue workers, with Supervisor or as daemon

With a fresh Laravel installation
With a fresh Filament installation
With a Filament installation that already has plugin(s)
Powershell or CMD vs. Bash

most probably

Refer to https://filamentphp.com/docs/3.x/panels/installation for fresh Laravels
Update the manual installation to have FQNS

Redis

Redis is currently not fully supported.

Plan A:

All features except "Jobs waiting" seem to work with Redis. Fix that!

Plan B:

Check possible features and mention in docs. Refer to:

Moving to Moox

Sorry

for the inconvenience, but we are changing Namespaces from adrolli/filament-job-monitor to mooxphp/jobs

Why?

It is much shorter
We want to start building an ecosystem named Moox

When?

We will

Change namespaces
Incorporate Jobs into the Monorepo
Draft a new release
Publish the package moox/jobs to Packagist, making it available for Composer
Test the package on Live platforms, create update docs
Abandon adrolli/ilament-job-monitor on Packagist, redirecting to moox/jobs, see composer/packagist#47
Cleanup and close issues here, moving them to the Monorepo

in the next few days.

mooxphp / jobs Goto Github PK

jobs's Issues