Skip to content
This repository was archived by the owner on Jan 29, 2020. It is now read-only.

Fixed problems with incorrect database schema in provided example. #72

Merged
merged 2 commits into from
Dec 28, 2019

Conversation

sheridans
Copy link
Contributor

fixed issues with missing values and iconsistent column types

Provide a narrative description of what you are trying to accomplish:

  • [ X] Are you fixing a bug?

    • Detail how the bug is invoked currently.
    • Detail the original, incorrect behavior.
    • Detail the new, expected behavior.
    • Base your feature on the master branch, and submit against that branch.
    • Add a regression test that demonstrates the bug, and proves the fix.
    • Add a CHANGELOG.md entry for the fix.
  • Are you creating a new feature?

    • Why is the new feature needed? What purpose does it serve?
    • How will users use the new feature?
    • Base your feature on the develop branch, and submit against that branch.
    • Add only one feature per pull request; split multiple features over multiple pull requests
    • Add tests for the new feature.
    • Add documentation for the new feature.
    • Add a CHANGELOG.md entry for the new feature.
  • Is this related to quality assurance?
    The provided database schema is incorrect, has incosistent column types across tables. For example client_id and user_id being integer in one instance and varchar in another, multiple tables missing id files.

  • Is this related to documentation?

@froschdesign
Copy link
Member

@sheridans
Can you explain which problems you had and why all other DBMS than MySQL should be excluded?

Thanks in advance!

Copy link
Member

@geerteltink geerteltink left a comment

Choose a reason for hiding this comment

The reason will be displayed to describe this comment to others. Learn more.

There are some extra points under "Are you fixing a bug?":

  • Detail how the bug is invoked currently.
  • Detail the original, incorrect behavior.
  • Detail the new, expected behavior.
  • Base your feature on the master branch, and submit against that branch.
  • Add a regression test that demonstrates the bug, and proves the fix.

These bullet points are there to give us an inside on why you created the PR. Especially the first 3. I can imagine the current indexes might conflict and this PR fixes it, but some explanation would help.

EDIT: On a side node... the tests are failing as well as they need an update.

CHANGELOG.md Outdated
@@ -24,6 +24,28 @@ All notable changes to this project will be documented in this file, in reverse

- Nothing.

## 1.2.1 - 2019-12-10
Copy link
Member

Choose a reason for hiding this comment

The reason will be displayed to describe this comment to others. Learn more.

Please don't add a release date. Leave that to the person merging your PR and creating a release.

Copy link
Contributor Author

Choose a reason for hiding this comment

The reason will be displayed to describe this comment to others. Learn more.

thank you, new to this :)

CHANGELOG.md Outdated

### Fixed

- Incorrect database schema in provide example.
Copy link
Member

Choose a reason for hiding this comment

The reason will be displayed to describe this comment to others. Learn more.

A changelog entry should be like this:

- [#72](https://github.com/zendframework/zend-expressive-authentication-oauth2/pull/72)
  fixes the incorrect example database schema.

Copy link
Contributor Author

Choose a reason for hiding this comment

The reason will be displayed to describe this comment to others. Learn more.

noted for next time :)

@sheridans
Copy link
Contributor Author

Problems with the provided example file...

oauth_auth_codes.user_id is declared as INT, oauth_users has no relevant for relation

oauth_auth_codes.client_id is declared as INT, oauth_clients has relevant field

oauth_clients.user_id is declared as INT, again oauth_clients has no related field.

@weierophinney
Copy link
Member

I've fixed the CHANGELOG entry and force-pushed back to your branch.

@weierophinney weierophinney merged commit 64f9d4c into zendframework:master Dec 28, 2019
weierophinney added a commit that referenced this pull request Dec 28, 2019
Sign up for free to subscribe to this conversation on GitHub. Already have an account? Sign in.
Projects
None yet
Development

Successfully merging this pull request may close these issues.

4 participants