TappNetwork/laravel-airtable

Multiple base connection

Opened this issue · 1 comments

Is there a way of having multiple base connection like :
'base' => [
'base1' => env('AIRTABLE_BASEID1'),
'base2' => env('AIRTABLE_BASEID2'),
...
],

And so, directly from this previous connection, picking table name like this :
Airtable::table('TableName')->get();

Bc if i have like 5 base with 20 tables in each i would have to hard write 100 table connection in airtable.php like this :
'tables' => [
'Table1FromBase1' => [
'name' => 'Table1_name',
'base' => 'baseid1'
],
... (x100)
],

Or am i missing something ?

I have found an alternative solution tho, You can put something like this in the top of airtable.php before the return :
$tables = [
'TableName1',
'TableName2'
...
];
$basekey = [
"BaseNamePrefix1" => "basekey1",
"BaseNamePrefix2" => "basekey2"
];

$airtableTables = [];

foreach ($basekey as $key => $value) {
foreach ($tables as $k => $v) {
$airtableTables[$key . '_' . $v] = [
'name' => $v,
'base' => $value
];
}
}

And in the return "Default Airtable Table" section :
'tables' => $airtableTables,