DynamodbObject.py 1.8 KB

12345678910111213141516171819202122232425262728293031323334353637383940414243444546474849505152535455565758596061
  1. #!/usr/bin/env python3
  2. # -*- coding: utf-8 -*-
  3. """
  4. @Copyright (C) ansjer cop Video Technology Co.,Ltd.All rights reserved.
  5. @AUTHOR: ASJRD018
  6. @NAME: AnsjerFormal
  7. @software: PyCharm
  8. @DATE: 2019/10/9 16:17
  9. @Version: python3.6
  10. @MODIFY DECORD:ansjer dev
  11. @file: DynamodbObject.py
  12. @Contact: chanjunkai@163.com
  13. """
  14. from boto3 import Session
  15. from botocore.exceptions import ClientError
  16. from boto3.dynamodb.conditions import Key, Attr
  17. import logging
  18. import json
  19. import boto3
  20. from var_dump import var_dump
  21. # AWS_DynamoDB_REGION = ''
  22. # AWS_DynamoDB_ACCESS_KEY = ''
  23. # AWS_DynamoDB_SECRET_KEY = ''
  24. AWS_DynamoDB_REGION = 'us-west-1'
  25. AWS_DynamoDB_ACCESS_KEY = 'AKIA2E67UIMD4PZTYKYD'
  26. AWS_DynamoDB_SECRET_KEY = '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'
  27. class DynamodbObject(object):
  28. def __init__(self, *args, **kwargs):
  29. self.region = AWS_DynamoDB_REGION
  30. self.access_key = AWS_DynamoDB_ACCESS_KEY
  31. self.secret_key = AWS_DynamoDB_SECRET_KEY
  32. self.session = Session(aws_access_key_id=self.access_key,
  33. aws_secret_access_key=self.secret_key,
  34. region_name=self.region)
  35. def do_table_handle(self, table_name):
  36. dynamodb = self.session.resource('dynamodb')
  37. table_handle = dynamodb.Table(table_name)
  38. return table_handle
  39. def do_san(self, filter_data, table_name):
  40. var_dump('xjklfjl;asjl;sdf')
  41. table_handle = self.do_table_handle(table_name)
  42. response = table_handle.scan(
  43. ProjectionExpression="userID",
  44. FilterExpression=Attr('appId').eq('com.ansjer.zccloud'),
  45. )
  46. var_dump('xxloo')
  47. var_dump(response)
  48. var_dump('****************')
  49. items = response['Items']
  50. return ''
  51. # dobj = DynamodbObject()
  52. # res = dobj.do_san(filter_data={'appId': 'com.ansjer.zccloud'}, table_name='user_brand')