Table specific export limits

[zzroche]

In function "getTableLimit" i've removed this code:
// if (!is_numeric($limit)) {
// return false;
// }

so I can do a limit partition for extra dimension table.
First tranche "0, 100000"
second tranche "100001, 200000"

[ifsnop]

Maybe it will be easier to permit a number or an array (to support from to syntax in the limit clause). If it is useful, it can be implemented.

[zfmaster]

Maybe it will be easier to permit a number or an array (to support from to syntax in the limit clause). If it is useful, it can be implemented.

I suggest next syntax:

// This still works
$dump->setTableLimits([
    'customer' => 10,
]);

$dump->setTableLimits([
     'customer' => [
          'limit' => 10, // Mandatory parameter
          'offset' => 5, // Optional parameter
          'orderBy' => 'id DESC' // Optional parameter
       ]
]);

What do you think?

[ifsnop]

For me it looks good. Maybe it is a little bit complicated, but I think this could be an "advanced" feature, that needs some preparation from the user. It solves the problem that each table needs its own limit, offset and order clause.

Same was done for the where clause.

[zfmaster]

@ifsnop , ok, I will prepare PR and we could check it one more time when proof of concept will work.

[smalos]

@zfmaster Is there an update from your side?

[megaxorg]

The option to offset would be great