robersonfaria / laravel-database-schedule Goto Github PK
View Code? Open in Web Editor NEWManage your Laravel Task Scheduling in a friendly interface and save schedules to the database.
License: GNU General Public License v3.0
Manage your Laravel Task Scheduling in a friendly interface and save schedules to the database.
License: GNU General Public License v3.0
for example to schedule the command:
whoami
to run on the server.
When selecting to send email on success and failure, when a command fails, duplicate email is sent. I still haven't found a solution to the problem, apparently it's a behavior of the framework.
Case also interests @PedroPMS
Hi, i am using the very most recent laravel version v8.41.0 and unfortunately after installing robersonfaria/laravel-database-schedule the artisan schedule:list
command is always returning nothing, regardless of what i configure in the backend:
# php artisan schedule:list
+---------+----------+-------------+----------+
| Command | Interval | Description | Next Due |
+---------+----------+-------------+----------+
#
When removing robersonfaria/laravel-database-schedule again, the command displays the tasks defined in App\Console\Kernel.php
again as it should. I know this once worked ! Possibly laravel/framework has changed something in recent versions? Can i provide any more debug information ? Or did i forget to register the module somewhere? I am out of clues. Thanks a lot !
Dear @robersonfaria
is this project still maintained? Would you be open to accept a PR for Laravel 11? I like the idea of the project but it seems to be kinda stale. I would be interested in helping out (code review, adding bugfixes, adapt to L11), if you like to bring it up to date.
Kind regards,
christian
Hello,
I have a command that have two arguments, I want to create a schedule passing just the first, but the request is sending all, like the image shows.
Because of this, when cron runs, the method in Schedule model mapArguments
break. I can resolve this is backend but I think is also a problem in the frontend that send invalid data.
I could resolve this too, but I'm terrible at frontend ๐ .
Hey,
It would be great if you could add an example of how to modify the gate in the Dashboard Authorization
section
It's a crucial part of the install and not all users will be familiar with extending vendor Service Providers ๐
The package is growing fast and new features are being added constantly, we need to write tests(PHPUnit) to cover most of the features.
It's becoming more and more difficult to test and ensure that everything keeps working after a new pull request.
### PHP VERSION:
8.3.4
### PHP EXTENSIONS:
Core, date, libxml, openssl, pcre, zlib, filter, hash, json, pcntl, random, Reflection, SPL, session, standard, sodium, mysqlnd, PDO, xml, bcmath, calendar, ctype, curl, dom, mbstring, FFI, fileinfo, ftp, gd, gettext, iconv, igbinary, imagick, imap, intl, ldap, exif, msgpack, mysqli, pcov, pdo_mysql, pdo_pgsql, pdo_sqlite, pgsql, Phar, posix, readline, redis, shmop, SimpleXML, soap, sockets, sqlite3, sysvmsg, sysvsem, sysvshm, tokenizer, xmlreader, xmlwriter, xsl, zip, memcached, swoole, Zend OPcache, xdebug
### LARAVEL VERSION:
11.2.0.0
composer require robersonfaria/laravel-database-schedule
./composer.json has been updated
Running composer update robersonfaria/laravel-database-schedule
Loading composer repositories with package information
Updating dependencies
Lock file operations: 1 install, 0 updates, 0 removals
- Locking robersonfaria/laravel-database-schedule (1.4.0)
Writing lock file
Installing dependencies from lock file (including require-dev)
Package operations: 1 install, 0 updates, 0 removals
- Downloading robersonfaria/laravel-database-schedule (1.4.0)
- Installing robersonfaria/laravel-database-schedule (1.4.0): Extracting archive
Generating optimized autoload files
> Illuminate\Foundation\ComposerScripts::postAutoloadDump
> @php artisan package:discover --ansi
Illuminate\Database\QueryException
SQLSTATE[42S02]: Base table or view not found: 1146 Table 'agilts_backend.schedules' doesn't exist (Connection: mysql, SQL: select * from `schedules` where `status` = 1 and `schedules`.`deleted_at` is null)
at vendor/laravel/framework/src/Illuminate/Database/Connection.php:813
809โ $this->getName(), $query, $this->prepareBindings($bindings), $e
810โ );
811โ }
812โ
โ 813โ throw new QueryException(
814โ $this->getName(), $query, $this->prepareBindings($bindings), $e
815โ );
816โ }
817โ }
i A table was not found: You might have forgotten to run your database migrations.
https://laravel.com/docs/master/migrations#running-migrations
1 [internal]:0
RobersonFaria\DatabaseSchedule\Console\Scheduling\Schedule::__construct()
+13 vendor frames
15 [internal]:0
RobersonFaria\DatabaseSchedule\Console\Scheduling\Schedule::__construct()
Script @php artisan package:discover --ansi handling the post-autoload-dump event returned with error code 1
php artisan migrate
Illuminate\Database\QueryException
SQLSTATE[42S02]: Base table or view not found: 1146 Table 'agilts_backend.schedules' doesn't exist (Connection: mysql, SQL: select * from `schedules` where `status` = 1 and `schedules`.`deleted_at` is null)
at vendor/laravel/framework/src/Illuminate/Database/Connection.php:813
809โ $this->getName(), $query, $this->prepareBindings($bindings), $e
810โ );
811โ }
812โ
โ 813โ throw new QueryException(
814โ $this->getName(), $query, $this->prepareBindings($bindings), $e
815โ );
816โ }
817โ }
i A table was not found: You might have forgotten to run your database migrations.
https://laravel.com/docs/master/migrations#running-migrations
1 [internal]:0
RobersonFaria\DatabaseSchedule\Console\Scheduling\Schedule::__construct()
+13 vendor frames
15 [internal]:0
RobersonFaria\DatabaseSchedule\Console\Scheduling\Schedule::__construct()
In vendor/robersonfaria/laravel-database-schedule/src/DatabaseSchedulingServiceProvider.php file
/**
* Bootstrap any application services.
*
* @return void
*/
public function boot()
{
...
// Comment this line when initializing the project
// $this->app->resolving(BaseSchedule::class, function ($schedule) {
// $schedule = app(Schedule::class, ['schedule' => $schedule]);
// return $schedule->execute();
// });
...
}
Hi,
at first - thanks a lot for this great repository.
Unfortunately Commands that have Arguments with a comment are not recognized by laravel-database-schedule
. Take this Example of the official telescope
module:
class PruneCommand extends Command
{
/**
* The name and signature of the console command.
*
* @var string
*/
protected $signature = 'telescope:prune {--hours=24 : The number of hours to retain Telescope data}';
The argument --hours
is not recognized and therefore can not be set:
The parameters are collected in src/Http/Services/CommandService.php
but unfortunately i can not grasp why
$command->getDefinition()->getArguments())
in line 31 does not retrieve commented arguments. Possibly this is a laravel issue ?
Besides of that, how about an switch to enter a completely custom command as text field in addition to the dropdown for some special cases?
the existence of viewDatabaseSchedule in DatabaseScheduleApplicationServiceProvider.php is causing difficulty in overriding in AppServiceProvider or any custom ServiceProvider.
i think you should remove it allow users to set it rather.
If you create a command that have optional options, and don't set these options, when the command runs will be passed an empty string as a option.
If try to pause and resume it, it will be crushed like this.
thanks
Hi, please add PHP 8 support
robersonfaria/laravel-database-schedule[1.0.0, ..., 1.0.15] require php ^7.0 -> your php version (8.0.0) does not satisfy that requirement.
Could there be a possibility to add "run now" button on every job, so one does not need to wait for the crontab to proc and instead run some, especially maintenance tasks on demand?
Thanks
As the subject, thanks
Various modifications and additions of new functionality have been made, it is necessary to update the documentation(README) to reflect all existing functionality.
If anyone can contribute I appreciate it.
Hi, this might be a really stupid question, but I cannot seem to find a way to specify the verbosity. There is neither a dropdown nor a generic input where I could specify additional parameters like "-vv".
Good logging is pretty important for my use case.
Hello.
I'm trying translate the UI to portuguese creating a file like schedule.php
in my resources/lang/pt_BR folder, and this is not working. If I go to your package folder in vendor and add a pt_BR folder with my translations, it works.
Anyway, I forked the project to add the pt_BR folder directly to your project and already do the translations. I'm sending the PR, this can help those who have projects in pt_BR
Is there any plan to make this compatible with Laravel 11?
I believe the property $fillable
in class src/Models/Schedule.php
should also include 'name'.
hi , its posible active the cron service without Run the artisan command "php artisan schedule:run"?
I carried out all the configuration steps but when I run the php artisan schedule:list command it does not display any scheduled tasks, was I missing something??
Hi, i am using this package and the documentation of this package says i can change timezone with the config file. I have tried but timezone is not picking value from package configuration file (SCHEDULE_TIMEZONE ).
Also i want to put timezone according to user. is there a way to pass timezone in the $schedule array when creating new schedule?
Thankyou
when adding package using composer getting this error, even after doing some tweaks of database migration.
SQLSTATE[42S02]: Base table or view not found: 1146 Table 'schedule_task_laravel.schedules' doesn't exist (Connection: mysql, SQL: select * from schedules
where status
= 1 and schedules
.deleted_at
is null)
at vendor\laravel\framework\src\Illuminate\Database\Connection.php:813
809โ $this->getName(), $query, $this->prepareBindings($bindings), $e
810โ );
811โ }
812โ
โ 813โ throw new QueryException(
814โ $this->getName(), $query, $this->prepareBindings($bindings), $e
815โ );
816โ }
817โ }
i A table was not found: You might have forgotten to run your database migrations.
https://laravel.com/docs/master/migrations#running-migrations
1 [internal]:0
RobersonFaria\DatabaseSchedule\Console\Scheduling\Schedule::__construct(Object(RobersonFaria\DatabaseSchedule\Http\Services\ScheduleService), Object(Illuminate\Console\Scheduling\Schedule))
2 vendor\laravel\framework\src\Illuminate\Database\Connection.php:407
PDOException::("SQLSTATE[42S02]: Base table or view not found: 1146 Table 'schedule_task_laravel.schedules' doesn't exist")
A declarative, efficient, and flexible JavaScript library for building user interfaces.
๐ Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.
TypeScript is a superset of JavaScript that compiles to clean JavaScript output.
An Open Source Machine Learning Framework for Everyone
The Web framework for perfectionists with deadlines.
A PHP framework for web artisans
Bring data to life with SVG, Canvas and HTML. ๐๐๐
JavaScript (JS) is a lightweight interpreted programming language with first-class functions.
Some thing interesting about web. New door for the world.
A server is a program made to process requests and deliver data to clients.
Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.
Some thing interesting about visualization, use data art
Some thing interesting about game, make everyone happy.
We are working to build community through open source technology. NB: members must have two-factor auth.
Open source projects and samples from Microsoft.
Google โค๏ธ Open Source for everyone.
Alibaba Open Source for everyone
Data-Driven Documents codes.
China tencent open source team.