Manager Pattern Package for Laravel

 The DeGraciaMathieu/Manager package is an implementation of the Manager pattern for the Laravel framework. The job of this package is to make it convenient to create various implementations that adhere to an interface and a manager class to resolve them:

 1use DeGraciaMathieu/Manager/Manager;
 2 
 3class LoggerManager extends Manager {
 4 
 5    public function createMonologDriver(): LoggerDriver
 6    {
 7        return new MonologDriver();
 8    }
 9 
10    public function createMockDriver(): LoggerDriver
11    {
12        return new MockDriver();
13    }
14 
15    public function getDefaultDriver()
16    {
17        return 'monolog';
18    }
19}

Here’s an example of how you can use the manager class to do anything the interface allows conveniently:

1(new LoggerManager())->doAnything();
2 
3// Or pick a driver
4(new LoggerManager())->driver('monolog')->doAnything();

Imagine that you wanted to allow consumers to define a default implementation (similar to things like the DatabaseManager in Laravel):

1public function getDefaultDriver()
2{
3    return config('some_package.default');
4}

To learn more about the package, the author provides a manager-examples GitHub repo. Check out this package on GitHub at DeGraciaMathieu/Manager.

Read More

Using Google Sheets with Eloquent

 Eloquent Sheets is a package by Ed Grosvenor that lets you work with Google Sheets via Eloquent models:

This package provides an Eloquent model that sits on top of a Google Sheet. In order for it to work, there are two things your sheet needs to have. One is a heading row that holds the name of your columns. This defaults to row 1 (the top row) but it can be any row in the sheet. The other is a primary key column. Eloquent assumes that your primary key column is named id. If it’s not, set it in your model like you would normally.

Going through the readme will get you set up, and once you have a generated model class, it will look something like the following example:

 1use Grosv\EloquentSheets\SheetModel;
 2 
 3class YourGoogleSheetsModel extends SheetModel
 4{
 5    // The id of the spreadsheet
 6    protected $spreadsheetId = '1HxNqqLtc614UVLoTLEItfvcdcOm3URBEM2Zkr36Z1rE';
 7    // The id of the sheet within the spreadsheet (gid=xxxxx on the URL)
 8    protected $sheetId = '0';
 9    // The row containing the names of your columns (eg. id, name, email, phone)
10    protected $headerRow = '1';
11}

With the Google Sheet model, you can use basic eloquent features; however, the model can only use read and list methods at this time. Update and insert won’t work, but this package does provide a way to read sheet data via Eloquent. Insert and update functionality might be added in the future.

If you’d like to learn more about this package, check it out on GitHub at grosv/eloquent-sheets.

Read More