Notes up to the point where you bring the data on documentDB on Microsoft Azure to your hand (local PC) and store the documents in the array list

Trial premise

PC OS: Windows 10
Python: Python 2.7
Python library: pydocumentdb --DocumentDB settings on Azure
- server: abc_server.documents.azure.com
- database: abc_database
- collection: abc_collection
- api-key: abc_api --Please rewrite each ʻabc ... `when setting on Azure as appropriate

Collection? --For example, here is the concept: - https://docs.microsoft.com/ja-jp/azure/documentdb/documentdb-introduction

Anyway install & initial setup

pip install pydocumentdb

Let's write in Python.

# -*- coding: utf-8 -*-

## library setting
import pydocumentdb.document_client as document_client

##various settings
HOST = 'abc_server.documents.azure.com:443/'
DATABASE_ID = 'abc_database'
COLLECTION_ID = 'abc_collection'
MASTER_KEY = 'abc_api'

#documentDb client instance created
client = document_client.DocumentClient(HOST,  {'masterKey': MASTER_KEY})

# database/collection definition
database_definition = {'id': DATABASE_ID }
collection_definition = { 'id': COLLECTION_ID }

##Define DB connection
databases = list(client.QueryDatabases({
        'query': 'SELECT * FROM root r WHERE r.id=@id',
        'parameters': [
            { 'name':'@id', 'value': database_definition['id'] }
        ]
    }))

db = databases[0]

##Define Collection
collections = list(client.QueryCollections(
    db['_self'],
    {
        'query': 'SELECT * FROM root',
        'parameters': [
            { 'name':'@id', 'value': collection_definition['id'] }
        ]
    }))

collection = collections[0]

##Store Documents
###Box for Documents
list = []
###Let's put them one by one
for doc in client.ReadDocuments(collection['_self']):
    list.append(doc)

Stored result

--Each document comes in json format, so a separate parse is required-

Remarks

――This time, I felt like bringing the whole amount, but if you want to partially remove it, you need to change query, but that is separate. ――Please use it for the purpose of extracting for the time being.

Recommended Posts

Try to extract Azure document DB document with pydocumentdb

Try to extract Azure SQL Server data table with pyodbc

Try to operate DB with Python and visualize with d3

Try to factorial with recursion

Try to extract the features of the sensor data with CNN

Try to operate Facebook with Python

Try to profile with ONNX Runtime

Try to output audio with M5STACK

Try to extract a character string from an image with Python3

Try to reproduce color film with Python

Try logging in to qiita with Python