boto3 DDB scan using ScanFilter?
Is this the correct way to compare equality for string attribute values in DDB scan operation. It does not pull the required data from my table however works when ScanFilter is not used and returns all records. (Note that the model and name are the column field names and store String Values). Im new to this and apologies if i'm missing something silly.
I know we can use FilterExpression, but my use case is served best by using ScanFilter.
db_client = boto3.resource('dynamodb')
scan_filter = 'model': 'ComparisonOperator': 'EQ', 'AttributeValueList': ['S': '<some_model_val>'], 'name': 'ComparisonOperator': 'EQ', 'AttributeValueList': ['S': 'some_name_val']
table = db_client.Table("<table_name>")
response = table.scan(
Select='ALL_ATTRIBUTES',
ScanFilter=scan_filter
)
print response
python python-2.7 aws-sdk boto3 boto
asked Nov 14 '18 at 3:31
MurphyMurphy
33429
add a comment |
Is this the correct way to compare equality for string attribute values in DDB scan operation. It does not pull the required data from my table however works when ScanFilter is not used and returns all records. (Note that the model and name are the column field names and store String Values). Im new to this and apologies if i'm missing something silly.
I know we can use FilterExpression, but my use case is served best by using ScanFilter.
db_client = boto3.resource('dynamodb')
scan_filter = 'model': 'ComparisonOperator': 'EQ', 'AttributeValueList': ['S': '<some_model_val>'], 'name': 'ComparisonOperator': 'EQ', 'AttributeValueList': ['S': 'some_name_val']
table = db_client.Table("<table_name>")
response = table.scan(
Select='ALL_ATTRIBUTES',
ScanFilter=scan_filter
)
print response
python python-2.7 aws-sdk boto3 boto
asked Nov 14 '18 at 3:31
MurphyMurphy
33429
add a comment |
Is this the correct way to compare equality for string attribute values in DDB scan operation. It does not pull the required data from my table however works when ScanFilter is not used and returns all records. (Note that the model and name are the column field names and store String Values). Im new to this and apologies if i'm missing something silly.
I know we can use FilterExpression, but my use case is served best by using ScanFilter.
db_client = boto3.resource('dynamodb')
scan_filter = 'model': 'ComparisonOperator': 'EQ', 'AttributeValueList': ['S': '<some_model_val>'], 'name': 'ComparisonOperator': 'EQ', 'AttributeValueList': ['S': 'some_name_val']
table = db_client.Table("<table_name>")
response = table.scan(
Select='ALL_ATTRIBUTES',
ScanFilter=scan_filter
)
print response
python python-2.7 aws-sdk boto3 boto
asked Nov 14 '18 at 3:31
MurphyMurphy
33429
Is this the correct way to compare equality for string attribute values in DDB scan operation. It does not pull the required data from my table however works when ScanFilter is not used and returns all records. (Note that the model and name are the column field names and store String Values). Im new to this and apologies if i'm missing something silly.
I know we can use FilterExpression, but my use case is served best by using ScanFilter.
db_client = boto3.resource('dynamodb')
scan_filter = 'model': 'ComparisonOperator': 'EQ', 'AttributeValueList': ['S': '<some_model_val>'], 'name': 'ComparisonOperator': 'EQ', 'AttributeValueList': ['S': 'some_name_val']
table = db_client.Table("<table_name>")
response = table.scan(
Select='ALL_ATTRIBUTES',
ScanFilter=scan_filter
)
print response
python python-2.7 aws-sdk boto3 boto
python python-2.7 aws-sdk boto3 boto
asked Nov 14 '18 at 3:31
MurphyMurphy
33429
asked Nov 14 '18 at 3:31
MurphyMurphy
33429
edited Nov 14 '18 at 17:49
Murphy
asked Nov 14 '18 at 3:31
MurphyMurphy
33429
asked Nov 14 '18 at 3:31
MurphyMurphy
33429
asked Nov 14 '18 at 3:31
MurphyMurphy
33429
33429
add a comment |
add a comment |
0
active
oldest
votes
Your Answer
StackExchange.ifUsing("editor", function ()
StackExchange.using("externalEditor", function ()
StackExchange.using("snippets", function ()
StackExchange.snippets.init();
);
);
, "code-snippets");
StackExchange.ready(function()
var channelOptions =
tags: "".split(" "),
id: "1"
;
initTagRenderer("".split(" "), "".split(" "), channelOptions);
StackExchange.using("externalEditor", function()
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled)
StackExchange.using("snippets", function()
createEditor();
);
else
createEditor();
);
function createEditor()
StackExchange.prepareEditor(
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: true,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: 10,
bindNavPrevention: true,
postfix: "",
imageUploader:
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
,
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
);
);
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function ()
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f53292798%2fboto3-ddb-scan-using-scanfilter%23new-answer', 'question_page');
);
Post as a guest
Required, but never shown
0
active
oldest
votes
0
active
oldest
votes
active
oldest
votes
active
oldest
votes
Thanks for contributing an answer to Stack Overflow!
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function ()
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f53292798%2fboto3-ddb-scan-using-scanfilter%23new-answer', 'question_page');
);
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
