Skip to content

Add sample for connecting to SQL Server with SQLAlchemy/pyodbc#3135

Merged
shubha-rajan merged 16 commits intoGoogleCloudPlatform:masterfrom
shubha-rajan:sqlserver-connection
Apr 15, 2020
Merged

Add sample for connecting to SQL Server with SQLAlchemy/pyodbc#3135
shubha-rajan merged 16 commits intoGoogleCloudPlatform:masterfrom
shubha-rajan:sqlserver-connection

Conversation

@shubha-rajan
Copy link
Copy Markdown
Contributor

@shubha-rajan shubha-rajan commented Mar 24, 2020

Also includes setup for deploying to App Engine Flexible. I'd like some guidance on how to go about resolving the Kokoro failures, PTAL. The reason I had to deploy with a custom runtime was to resolve that specific error, which is a result of not having unixODBC installed.

@shubha-rajan shubha-rajan requested a review from a team as a code owner March 24, 2020 21:00
@googlebot googlebot added the cla: yes This human has signed the Contributor License Agreement. label Mar 24, 2020
@shubha-rajan shubha-rajan force-pushed the sqlserver-connection branch 3 times, most recently from 85f54ed to 250a97b Compare March 24, 2020 21:57
@kurtisvg
Copy link
Copy Markdown
Contributor

Test errors are because the container we run tests are in doesn't have the pyodbc driver installed. Normally I would recommend using a pure python driver, but it seems like pymssql is deprecated.

We may need to update the testing container to include this driver.

@shubha-rajan
Copy link
Copy Markdown
Contributor Author

@kurtisvg yeah, Microsoft has officially said that they're only supporting pyodbc. The container also needs to include the Microsoft ODBC driver. Steps for installing are in the Dockerfile.

Copy link
Copy Markdown
Contributor

Choose a reason for hiding this comment

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

Can we inline this logic below so it's included in the sample?

Copy link
Copy Markdown
Contributor Author

Choose a reason for hiding this comment

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

I moved the region tag up to include getting the parameters from the env vars, so this is already included. I can still inline it if that's more readable

@shubha-rajan shubha-rajan requested a review from kurtisvg April 7, 2020 00:57
@kurtisvg
Copy link
Copy Markdown
Contributor

kurtisvg commented Apr 7, 2020

@shubha-rajan
Copy link
Copy Markdown
Contributor Author

@kurtisvg I opened a PR here googleapis/testing-infra-docker#60 but Github won't let me add reviewers (possibly because I'm not a collaborator on that repo?)

@shubha-rajan shubha-rajan requested a review from busunkim96 April 8, 2020 20:46
@shubha-rajan shubha-rajan added the kokoro:force-run Add this label to force Kokoro to re-run the tests. label Apr 13, 2020
@kokoro-team kokoro-team removed kokoro:force-run Add this label to force Kokoro to re-run the tests. labels Apr 13, 2020
@busunkim96 busunkim96 added the kokoro:force-run Add this label to force Kokoro to re-run the tests. label Apr 14, 2020
@kokoro-team kokoro-team removed the kokoro:force-run Add this label to force Kokoro to re-run the tests. label Apr 14, 2020
shubha-rajan and others added 9 commits April 15, 2020 11:14
Co-Authored-By: Bu Sun Kim <8822365+busunkim96@users.noreply.github.com>
Co-Authored-By: Kurtis Van Gent <31518063+kurtisvg@users.noreply.github.com>
Co-Authored-By: Kurtis Van Gent <31518063+kurtisvg@users.noreply.github.com>
Co-Authored-By: Kurtis Van Gent <31518063+kurtisvg@users.noreply.github.com>
shubha-rajan and others added 7 commits April 15, 2020 11:14
Co-Authored-By: Kurtis Van Gent <31518063+kurtisvg@users.noreply.github.com>
Co-Authored-By: Kurtis Van Gent <31518063+kurtisvg@users.noreply.github.com>
Co-Authored-By: Kurtis Van Gent <31518063+kurtisvg@users.noreply.github.com>
@shubha-rajan shubha-rajan force-pushed the sqlserver-connection branch from d03b8b7 to f280496 Compare April 15, 2020 18:15
@shubha-rajan shubha-rajan merged commit c8daaa5 into GoogleCloudPlatform:master Apr 15, 2020
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment

Labels

cla: yes This human has signed the Contributor License Agreement.

Projects

None yet

Development

Successfully merging this pull request may close these issues.

5 participants