Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Some questions about implementation #34

Open
brutalzinn opened this issue Mar 2, 2023 · 3 comments
Open

Some questions about implementation #34

brutalzinn opened this issue Mar 2, 2023 · 3 comments

Comments

@brutalzinn
Copy link

Thank you for sharing this project with the community. I have some questions and I couldn't find the answer in the documentation.

  1. Is it possible to list all customers of a specific user?

  2. Is it reasonable to add a column in the oauth2_clients table to identify the client, if so how do I do that?

@vgarvardt
Copy link
Owner

If I understand your question correctly - you can add a index to the data column based on your need and use it in your system to filter out required records. Since data has JSONB type it allows to set indices on the nested fields and then write queries that filter data based on the nested fields.

@brutalzinn
Copy link
Author

Thanks for your response. I did a database design to adapt with your library without change directly or uses json to store my custom data. The orange database its the unmanagment part. I create a table between oauth2_clients and my custom data that i needed.

dbeaver

@brutalzinn
Copy link
Author

I clone your project and do small changes with some cruds implementations for delete and update oauth clients https://github.com/brutalzinn/go-oauth2-pg

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

2 participants