Get the current AUTO_INCREMENT value for a table

Please review MR.
Thanks

Thanks for working on this @gaurav_manerkar I have rebased the MR to resolve conflicts introduced in recent commits.

I tested the MR and it works, but let's make make some improvements. I don't think we need to worry about adding prefixes or not to tables. Now that ✨ Get a list of all tables Active has landed, people can use that method to check for tables as they exist, prefix included when present.

Also, while not explicitly stated in the issue summary, the query you added to fetch the AUTO_INCREMENT can be adjusted to get the values for all tables. Let's include that in this issue.

I will take a first shot at this. Assigning to myself.

Pushed an update to getTableAutoIncrementValue method and a new getAllTableAutoIncrementValues method.

Please review.

I tested the MR with the following commands. I also updated the readme file.

drush php:eval "\Drupal::service('auto_increment_alter.mysql')->getTableAutoIncrementValue('node');"
drush php:eval "print_r(\Drupal::service('auto_increment_alter.mysql')->getAllTableAutoIncrementValues());"
drush php:eval "print_r(\Drupal::service('auto_increment_alter.mysql')->getAllTableAutoIncrementValues(FALSE));"

Thanks @baltowen and @gaurav_manerkar for working on this. Updating issue summary to reflect the two new methods added to the service.

Automatically closed - issue fixed for 2 weeks with no activity.