Reconnect on lost DB connection

[michalbundyra]

This functionality allow to enable & configure reconnect functionality using options parameter in adapter.

When you are creating adapter for mysqli:

$adapter = new Adapter([
    'driver' => 'Mysqli',
    'database' => '',
    'username' => '',
    'password' => '',
    'options' => [
        'reconnect_tries' => 3
    ]
]);

You can specify reconnect_tries and if during your work connect will be lost adapter will try automatically reconnect to server.

Fix for #302

---

Originally posted by @tptrixtop at zendframework/zend-db#307

[michalbundyra]

1. Needs addition to documentation about new 'reconnect_tries' option.
2. Needs tests
3. being a general DB tool, having a feature like this only favoring MySQL ignoring other engines does not make the library look good. At the least, if not have the ability to apply to all supported engines, make a statement in documentation that so far only available in MySQL and maintainer could add "help wanted" tag for other databases.

---

Originally posted by @alextech at zendframework/zend-db#307 (comment)

[michalbundyra]

I will try to add support for other engines soon.

I know about unit tests) but when i have written that code i had no idea how to test that functionality)

For now i have some ideas, i will try)

---

Originally posted by @tptrixtop at zendframework/zend-db#307 (comment)

[michalbundyra]

Ok, thats fine :) Does seem like a challenge to test!

For documentation, I actually meant adding entry into docs/book markdown sources.

---

Originally posted by @alextech at zendframework/zend-db#307 (comment)

[michalbundyra]

Ah, get it) i will add docs about that option to adapter.md

---

Originally posted by @tptrixtop at zendframework/zend-db#307 (comment)

[michalbundyra]

@tptrixtop we need some unit test for this new feature. Consider that now we have also integration tests available.

---

Originally posted by @ezimuel at zendframework/zend-db#307 (comment)

[michalbundyra]

Sure, I am now working on same functionality for postgresql, it's almost finished and after i will try add same functionality for MS SQL and i will commit unit tests for all of that changes)

---

Originally posted by @tptrixtop at zendframework/zend-db#307 (comment)

[michalbundyra]

@tptrixtop we still need tests for this feature.

---

Originally posted by @ezimuel at zendframework/zend-db#307 (comment)

[michalbundyra]

@ezimuel I know sir, i am working on it, right now)

---

Originally posted by @tptrixtop at zendframework/zend-db#307 (comment)

[weierophinney]

This package is considered feature-complete, and is now in security-only maintenance mode, following a decision by the Technical Steering Committee.
If you have a security issue, please follow our security reporting guidelines.
If you wish to take on the role of maintainer, please nominate yourself

If you are looking for an actively maintained package alternative, we recommend:

• doctrine/dbal