Get all usernames stored in TinyDB database
I'm new to TinyDB, and new to Python.
I have various usernames stored in a TinyDB database, they also have other information stored (age, email addresses etc), however, I wish to return all the usernames only.
"_default": "1": "Username": "John", "Age": "30", "2": "Username":
"Andrew", "Age":"40", "Email": "example@example.com"
My GUI would have the button "Show all usernames".
I can return information about specific users, and I can get all the information stored in the database (db.all()), however I cannot just seem to get all the usernames from the entire database.
Is there a way to do this?
Or am I looking at this problem the wrong way.
Many thanks!
python tinydb
edited Nov 11 '18 at 9:34
Alon
567128
asked Nov 11 '18 at 8:52
rlh123rlh123
83
add a comment |
I'm new to TinyDB, and new to Python.
I have various usernames stored in a TinyDB database, they also have other information stored (age, email addresses etc), however, I wish to return all the usernames only.
"_default": "1": "Username": "John", "Age": "30", "2": "Username":
"Andrew", "Age":"40", "Email": "example@example.com"
My GUI would have the button "Show all usernames".
I can return information about specific users, and I can get all the information stored in the database (db.all()), however I cannot just seem to get all the usernames from the entire database.
Is there a way to do this?
Or am I looking at this problem the wrong way.
Many thanks!
python tinydb
edited Nov 11 '18 at 9:34
Alon
567128
asked Nov 11 '18 at 8:52
rlh123rlh123
83
add a comment |
I'm new to TinyDB, and new to Python.
I have various usernames stored in a TinyDB database, they also have other information stored (age, email addresses etc), however, I wish to return all the usernames only.
"_default": "1": "Username": "John", "Age": "30", "2": "Username":
"Andrew", "Age":"40", "Email": "example@example.com"
My GUI would have the button "Show all usernames".
I can return information about specific users, and I can get all the information stored in the database (db.all()), however I cannot just seem to get all the usernames from the entire database.
Is there a way to do this?
Or am I looking at this problem the wrong way.
Many thanks!
python tinydb
edited Nov 11 '18 at 9:34
Alon
567128
asked Nov 11 '18 at 8:52
rlh123rlh123
83
I'm new to TinyDB, and new to Python.
I have various usernames stored in a TinyDB database, they also have other information stored (age, email addresses etc), however, I wish to return all the usernames only.
"_default": "1": "Username": "John", "Age": "30", "2": "Username":
"Andrew", "Age":"40", "Email": "example@example.com"
My GUI would have the button "Show all usernames".
I can return information about specific users, and I can get all the information stored in the database (db.all()), however I cannot just seem to get all the usernames from the entire database.
Is there a way to do this?
Or am I looking at this problem the wrong way.
Many thanks!
python tinydb
python tinydb
edited Nov 11 '18 at 9:34
Alon
567128
asked Nov 11 '18 at 8:52
rlh123rlh123
83
edited Nov 11 '18 at 9:34
Alon
567128
asked Nov 11 '18 at 8:52
rlh123rlh123
83
edited Nov 11 '18 at 9:34
Alon
567128
edited Nov 11 '18 at 9:34
Alon
567128
edited Nov 11 '18 at 9:34
Alon
567128
567128
asked Nov 11 '18 at 8:52
rlh123rlh123
83
asked Nov 11 '18 at 8:52
rlh123rlh123
83
asked Nov 11 '18 at 8:52
rlh123rlh123
83
83
add a comment |
add a comment |
2 Answers
2
active
oldest
votes
The database itself is iterable, so perhaps this would be more elegant and would avoid having to open the JSON file directly:
db = TinyDB('database_name.json')
usernames = [r['Username'] for r in db]
Gives:
['John', 'Andrew']
answered Nov 11 '18 at 10:12
Will KeelingWill Keeling
11.6k22434
Works perfectly. Thanks very much Will!
– rlh123
Nov 11 '18 at 16:55
add a comment |
Update: I found a (slightly convoluted) workaround.
It involves reading the file as a JSON file and then looping through the dictionary IDs, stopping the loop upon a key error.
with open("database_name.json", "r") as read_file:
data=json.load(read_file)
try:
current_number = 1
while current_number <=100000000000:
current_number = str(current_number)
print(data['_default'][current_number]['Username'])
current_number = int(current_number)
current_number += 1
except:
KeyError
answered Nov 11 '18 at 9:44
rlh123rlh123
83
add a comment |
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%2f53247168%2fget-all-usernames-stored-in-tinydb-database%23new-answer', 'question_page');
);
Post as a guest
Required, but never shown
2 Answers
2
active
oldest
votes
2 Answers
2
active
oldest
votes
active
oldest
votes
active
oldest
votes
The database itself is iterable, so perhaps this would be more elegant and would avoid having to open the JSON file directly:
db = TinyDB('database_name.json')
usernames = [r['Username'] for r in db]
Gives:
['John', 'Andrew']
answered Nov 11 '18 at 10:12
Will KeelingWill Keeling
11.6k22434
Works perfectly. Thanks very much Will!
– rlh123
Nov 11 '18 at 16:55
add a comment |
The database itself is iterable, so perhaps this would be more elegant and would avoid having to open the JSON file directly:
db = TinyDB('database_name.json')
usernames = [r['Username'] for r in db]
Gives:
['John', 'Andrew']
answered Nov 11 '18 at 10:12
Will KeelingWill Keeling
11.6k22434
Works perfectly. Thanks very much Will!
– rlh123
Nov 11 '18 at 16:55
add a comment |
The database itself is iterable, so perhaps this would be more elegant and would avoid having to open the JSON file directly:
db = TinyDB('database_name.json')
usernames = [r['Username'] for r in db]
Gives:
['John', 'Andrew']
answered Nov 11 '18 at 10:12
Will KeelingWill Keeling
11.6k22434
The database itself is iterable, so perhaps this would be more elegant and would avoid having to open the JSON file directly:
db = TinyDB('database_name.json')
usernames = [r['Username'] for r in db]
Gives:
['John', 'Andrew']
answered Nov 11 '18 at 10:12
Will KeelingWill Keeling
11.6k22434
answered Nov 11 '18 at 10:12
Will KeelingWill Keeling
11.6k22434
answered Nov 11 '18 at 10:12
Will KeelingWill Keeling
11.6k22434
answered Nov 11 '18 at 10:12
Will KeelingWill Keeling
11.6k22434
11.6k22434
Works perfectly. Thanks very much Will!
– rlh123
Nov 11 '18 at 16:55
add a comment |
Works perfectly. Thanks very much Will!
– rlh123
Nov 11 '18 at 16:55
Works perfectly. Thanks very much Will!
– rlh123
Nov 11 '18 at 16:55
Works perfectly. Thanks very much Will!
– rlh123
Nov 11 '18 at 16:55
add a comment |
Update: I found a (slightly convoluted) workaround.
It involves reading the file as a JSON file and then looping through the dictionary IDs, stopping the loop upon a key error.
with open("database_name.json", "r") as read_file:
data=json.load(read_file)
try:
current_number = 1
while current_number <=100000000000:
current_number = str(current_number)
print(data['_default'][current_number]['Username'])
current_number = int(current_number)
current_number += 1
except:
KeyError
answered Nov 11 '18 at 9:44
rlh123rlh123
83
add a comment |
Update: I found a (slightly convoluted) workaround.
It involves reading the file as a JSON file and then looping through the dictionary IDs, stopping the loop upon a key error.
with open("database_name.json", "r") as read_file:
data=json.load(read_file)
try:
current_number = 1
while current_number <=100000000000:
current_number = str(current_number)
print(data['_default'][current_number]['Username'])
current_number = int(current_number)
current_number += 1
except:
KeyError
answered Nov 11 '18 at 9:44
rlh123rlh123
83
add a comment |
Update: I found a (slightly convoluted) workaround.
It involves reading the file as a JSON file and then looping through the dictionary IDs, stopping the loop upon a key error.
with open("database_name.json", "r") as read_file:
data=json.load(read_file)
try:
current_number = 1
while current_number <=100000000000:
current_number = str(current_number)
print(data['_default'][current_number]['Username'])
current_number = int(current_number)
current_number += 1
except:
KeyError
answered Nov 11 '18 at 9:44
rlh123rlh123
83
Update: I found a (slightly convoluted) workaround.
It involves reading the file as a JSON file and then looping through the dictionary IDs, stopping the loop upon a key error.
with open("database_name.json", "r") as read_file:
data=json.load(read_file)
try:
current_number = 1
while current_number <=100000000000:
current_number = str(current_number)
print(data['_default'][current_number]['Username'])
current_number = int(current_number)
current_number += 1
except:
KeyError
answered Nov 11 '18 at 9:44
rlh123rlh123
83
answered Nov 11 '18 at 9:44
rlh123rlh123
83
answered Nov 11 '18 at 9:44
rlh123rlh123
83
answered Nov 11 '18 at 9:44
rlh123rlh123
83
83
add a comment |
add a comment |
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%2f53247168%2fget-all-usernames-stored-in-tinydb-database%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
