PyCharm でCData ODBC Driver for Pinterest を使ってみた

詳細情報をご希望ですか?

無償トライアル:

ダウンロードへ

製品の詳細情報へ:

Pinterest ODBC Driver

Pinterest ODBC Driver を使って、ODBC 接続をサポートするあらゆるアプリケーション・ツールからPinterest にデータ連携。

Pinterest データにデータベースと同感覚でアクセスして、Pinterest のBoards、Followers、Pins データに使い慣れたODBC インターフェースで連携。



Pinterest にODBC データソースとしてPyCharm から連携。

CData ODBC Drivers は、ODBC をサポートするあらゆる環境から利用可能です。 本記事では、PyCharm からのCData ODBC Driver for Pinterest の利用を説明します。ODBC Deriver をデータソースとして設定する方法、データソースをクエリするPyCharm のベーシックな方法を含みます。

To begin, this tutorial will assume that you have already installed the CData ODBC Driver for Pinterest as well as PyCharm.

Pyodbc をプロジェクトに追加

Follow the steps below to add the pyodbc module to your project.

  1. Click File -> Settings to open the project settings window.
  2. Click Project Interpreter from the Project: YourProjectName menu.
  3. To add pyodbc, click the + button and enter pyodbc.
  4. Click Install Package to install pyodbc.

Pinterest への接続

You can now connect with an ODBC connection string or a DSN. See the Getting Started section in the CData driver documentation for a guide to creating a DSN on your OS.

Pinterest authentication is based on the standard OAuth flow. To authenticate, you must initially create an app via the Pinterest developer platform where you can obtain an OAuthClientId, OAuthClientSecret, and CallbackURL.

Set InitiateOAuth to GETANDREFRESH and set OAuthClientId, OAuthClientSecret, and CallbackURL based on the property values for the app you created.

See the Help documentation for other OAuth authentication flows.

Below is the syntax for a DSN:

[CData Pinterest Source] Driver = CData ODBC Driver for Pinterest Description = My Description OAuthClientId = YourClientId OAuthClientSecret = YourClientSecret CallbackURL = 'https://localhost:33333'

Pinterest へのクエリの実行

Instantiate a Cursor and use the execute method of the Cursor class to execute any SQL statement.

import pyodbc cnxn = pyodbc.connect('DRIVER={CData ODBC Driver for Pinterest};OAuthClientId = YourClientId;OAuthClientSecret = YourClientSecret;CallbackURL = 'https://localhost:33333'') cursor = cnxn.cursor() cursor.execute("SELECT Id, Username FROM Users WHERE FirstName = 'Jane'") rows = cursor.fetchall() for row in rows: print(row.Id, row.Username)

After connecting to Pinterest in PyCharm using the CData ODBC Driver, you will be able to build Python apps with access to Pinterest data as if it were a standard database. If you have any questions, comments, or feedback regarding this tutorial, please contact us at support@cdata.com.