这是indexloc提供的服务,不要输入任何密码
Skip to content

Adding DBI methods #3296

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

Merged
merged 18 commits into from
Jun 21, 2023
Merged

Adding DBI methods #3296

merged 18 commits into from
Jun 21, 2023

Conversation

alibell
Copy link
Contributor

@alibell alibell commented Oct 13, 2022

Hello,

I submit this proposal of pull request on Sparklyr project.
The main idea is to add some DBI methods and a tiny changes.

New methods:

  • dbIsValid
  • dbDisconnect

Changes:

  • dbWriteTable:
    • Adding an overwrite parameter
  • dbListTables:
    • Adding a database parameter

I am mainly motivated because of my use of a library that rely on DBI methods. The absence of these methods breaks the compatibility with this library.

Thank you,
Ali Bellamine

@alibell
Copy link
Contributor Author

alibell commented Oct 17, 2022

I've added the support for the dbColumnInfo DBI method.

I've created dedicated unit-tests and locally evaluated with success the test-dbi.R unit test.
Some unit-test doesn't pass due to broken HTTP link.

This work is performed in order to use sparklyr as a DBI interface with the DatabaseConnector package which is used for collaborative studies around health databases.

Is there something else needed to be compliant with the contribution process ?

edgararuiz and others added 17 commits October 17, 2022 15:12
…mments

Signed-off-by: Ali <contact@alibellamine.me>
Signed-off-by: Ali <contact@alibellamine.me>
Signed-off-by: Ali <contact@alibellamine.me>
Signed-off-by: Ali <contact@alibellamine.me>
Signed-off-by: Ali <contact@alibellamine.me>
Signed-off-by: Ali <contact@alibellamine.me>
Signed-off-by: Ali <contact@alibellamine.me>
Signed-off-by: Ali <contact@alibellamine.me>
…riteTable

Signed-off-by: Ali <contact@alibellamine.me>
Signed-off-by: Ali <contact@alibellamine.me>
Signed-off-by: Ali <contact@alibellamine.me>
Signed-off-by: Ali <contact@alibellamine.me>
Signed-off-by: Ali <contact@alibellamine.me>
Signed-off-by: Ali <contact@alibellamine.me>
Signed-off-by: Ali <contact@alibellamine.me>
Signed-off-by: Ali <contact@alibellamine.me>
@edgararuiz
Copy link
Collaborator

Hi Ali, thank you so much for this PR. I'll be reviewing it shortly.

@edgararuiz edgararuiz merged commit f67ec62 into sparklyr:main Jun 21, 2023
@edgararuiz
Copy link
Collaborator

Thank you!

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

Successfully merging this pull request may close these issues.

2 participants