16
\$\begingroup\$

Challenge

Given the name of a PPCG member, output their PPCG ID number. If the user does not exist, you may report an error or return any non-positive number. If there are multiple members with this name, you may choose to output only one ID or all of them.

Test Cases

"musicman523" -> 69054
"Dennis" -> 12012
"xnor" -> 20260
"Leaky Nun" -> 48934
"fəˈnɛtɪk" -> 64505
"Jörg Hülsermann" -> 59107
"Community" -> -1
"Any user that does not exist" -> 0
"Alex" -> 69198 (this is one possible result)
"Leaky N" -> 0
"Jorge" -> 3716
\$\endgroup\$
  • 1
    \$\begingroup\$ Recommended test case: "Leaky N". Should return 0. \$\endgroup\$ – Okx Aug 7 '17 at 14:12
  • 5
    \$\begingroup\$ Can our program result in undefined behaviour for inexistent users (mine prints 48934, for example for a non-existing user)? I think this should be allowed, since errors are. \$\endgroup\$ – Mr. Xcoder Aug 7 '17 at 14:14
  • 4
    \$\begingroup\$ @Okx No, I don't. I am asking the OP if this behaviour is allowed. If it is not, I will delete or fix my answer. \$\endgroup\$ – Mr. Xcoder Aug 7 '17 at 14:16
  • 3
    \$\begingroup\$ @OliverNi Toxic? How? \$\endgroup\$ – Okx Aug 7 '17 at 14:22
  • 5
    \$\begingroup\$ @Okx He is asking a valid question to the OP and you are shooting him down immediately. Let the OP answer. \$\endgroup\$ – Oliver Ni Aug 7 '17 at 14:22
30
\$\begingroup\$

Stack Exchange Data Explorer, 56 54 53 51 46 bytes

-1 byte thanks to Hyper Neutrino. -5 bytes thanks to Giacomo Garabello.

SELECT ID FROM USERS WHERE##S##=DISPLAYNAME--S

Try it online!

Not sure if this is completely valid but... Input must be surrounded in single quotes '.

Also, I still don't get why SQL programmers like to shout but it's apparently good practise so... SELECT EVERYTHING FROM EVERYTHING WHERE EVERYTHING LIKE EVERYTHING!

Explanation

LET ME EXPLAIN.

SELECT ID FROM USERS WHERE##S##=DISPLAYNAME--S

                                           --S  -- DECLARE AN INPUT PARAMETER NAMED S
SELECT                                          -- FIND...
       ID                                       -- ID OF THE USERS...
          FROM USERS                            -- IN THE TABLE USERS...
                     WHERE                      -- THAT SATISFIES THE CONDITION...
                          ##S##=DISPLAYNAME     -- S EQUALS THE USERS' DISPLAY NAME
\$\endgroup\$
  • 13
    \$\begingroup\$ -2 BYTES BY REMOVING THE SPACES AROUND THE EQUALS SIGN \$\endgroup\$ – HyperNeutrino Aug 7 '17 at 15:54
  • 1
    \$\begingroup\$ NINJA'D YOUR NINJA IN CHAT XD \$\endgroup\$ – HyperNeutrino Aug 7 '17 at 15:55
  • 1
    \$\begingroup\$ -1 byte by reversing the order of operands around the equality operator \$\endgroup\$ – HyperNeutrino Aug 7 '17 at 16:00
  • 10
    \$\begingroup\$ +1 for the reference to SQL programmers liking to shout (and for a nice choice of language for your answer :) \$\endgroup\$ – NH. Aug 7 '17 at 23:31
  • 4
    \$\begingroup\$ why have you put the top 1 in this query? OP said "If there are multiple members with this name, you may choose to output only one ID or all of them"... \$\endgroup\$ – Giacomo Garabello Aug 8 '17 at 10:20
6
\$\begingroup\$

Python 2 + requests, 187 bytes

from requests import*
def f(x):t=get("http://api.stackexchange.com/users?inname="+utils.quote(x)+"&site=codegolf").json()["items"];print[k['user_id']for k in t if k['display_name']==x][0]

Returns the user ID if a single user exists, the first user which matches the requirements if more exist, and reports an error otherwise.

\$\endgroup\$
  • \$\begingroup\$ You can remove /2.2 from the API-url. \$\endgroup\$ – Kevin Cruijssen Aug 7 '17 at 14:39
  • \$\begingroup\$ @KevinCruijssen Thanks a lot \$\endgroup\$ – Mr. Xcoder Aug 7 '17 at 14:40
  • \$\begingroup\$ Hint: Do not try to run it with fəˈnɛtɪk, use \u{...} instead, because Python does not tolerate non-ASCII \$\endgroup\$ – Mr. Xcoder Aug 7 '17 at 15:05
  • \$\begingroup\$ Python 2, anyways. \$\endgroup\$ – totallyhuman Aug 7 '17 at 15:22
  • 3
    \$\begingroup\$ fails for "Jorge" \$\endgroup\$ – Felipe Nardi Batista Aug 8 '17 at 12:05
5
\$\begingroup\$

JavaScript, 155 149 142 135 bytes

i=>fetch("//api.stackexchange.com/users?site=codegolf&inname="+i).then(r=>r.json()).then(r=>r.items.find(u=>u.display_name==i).user_id)

f=i=>fetch("//api.stackexchange.com/users?site=codegolf&inname="+i).then(r=>r.json()).then(r=>r.items.find(u=>u.display_name==i).user_id)
<input onchange="f(this.value).then(console.log)"><br>Fill input and press Enter

\$\endgroup\$
  • 1
    \$\begingroup\$ Does it support special characters like in Jörg Hülsermann? \$\endgroup\$ – Arnauld Aug 7 '17 at 15:32
  • 4
    \$\begingroup\$ This returned 0 for Oliver :( \$\endgroup\$ – Oliver Aug 7 '17 at 16:34
  • \$\begingroup\$ Save 7 bytes by replacing r=>r.items[0]).then(r with ({items:[r]}). Destructuring assignment ftw! \$\endgroup\$ – kamoroso94 Aug 7 '17 at 18:55
  • \$\begingroup\$ You can use: i=>fetch('//api.stackexchange.com/users?site=codegolf&inname='+i).then(r=>r.json()).then(r=>r.items[0].user_id) as it'll return a promise error if it failed. You can also just do i=>fetch('/users?site=codegolf&inname='+i).then(r=>r.json()).then(r=>r.items[0].user_id) and say it needs to be run on the api domain \$\endgroup\$ – Downgoat Aug 7 '17 at 21:04
  • 2
    \$\begingroup\$ @Oliver WHAT another oliver???? THERE CAN BE ONLY ONE \$\endgroup\$ – Oliver Ni Aug 8 '17 at 12:21
5
\$\begingroup\$

Python 3 + requests, 196 bytes

Thanks @Wondercricket for -6 bytes!

from requests import*
x=lambda s:all([print(a['user_id'])if s==a['display_name']else''for a in get('http://api.stackexchange.com/users?inname=%s&site=codegolf'%utils.quote(s)).json()['items']])and d

Uses Stack Exchange API. Fixed the Leaky N and Jorge errors.

If there are multiple users with the same name, it prints all of them, which is allowed.

\$\endgroup\$
  • \$\begingroup\$ It gives me gzipped data.. \$\endgroup\$ – Oliver Ni Aug 7 '17 at 14:10
  • \$\begingroup\$ Fails on input Leaky N \$\endgroup\$ – Okx Aug 7 '17 at 14:13
  • \$\begingroup\$ @Okx Fixed. --- \$\endgroup\$ – Oliver Ni Aug 7 '17 at 14:23
  • \$\begingroup\$ Since you can "report an error or return 0" if the user does not exist, can't the last line be just print a['user_id'], which will throw a KeyError? \$\endgroup\$ – Daniel Aug 7 '17 at 14:25
  • 1
    \$\begingroup\$ fails for "Jorge" \$\endgroup\$ – Felipe Nardi Batista Aug 8 '17 at 12:05
3
\$\begingroup\$

Python 2 + requests, 173 bytes

lambda s:[i['user_id']for i in get('http://api.stackexchange.com/users?inname=%s&site=codegolf'%utils.quote(s)).json()['items']if i['display_name']==s]
from requests import*

Sample run

>>> f=\
... lambda s:[i['user_id']for i in get('http://api.stackexchange.com/users?inname=%s&site=codegolf'%utils.quote(s)).json()['items']if i['display_name']==s]
>>> from requests import*
>>>
>>> tests = ['musicman523', 'Dennis', 'xnor', 'Leaky Nun', 'Community', 'Any user that does not exist', 'Alex', 'Leaky N', 'Jorge']
>>> for i in tests: print '%-30r -> %s'%(i, f(i))
... 
'musicman523'                  -> [69054]
'Dennis'                       -> [12012, 13891, 14912, 24937]
'xnor'                         -> [20260]
'Leaky Nun'                    -> [48934]
'Community'                    -> [-1]
'Any user that does not exist' -> []
'Alex'                         -> [21536, 69198, 11192]
'Leaky N'                      -> []
'Jorge'                        -> [3716]

Fun fact: the result is sorted by reputation, highest first.

\$\endgroup\$
  • \$\begingroup\$ Fails on input Leaky N \$\endgroup\$ – Okx Aug 7 '17 at 14:12
  • \$\begingroup\$ Nice trick with %s. \$\endgroup\$ – Mr. Xcoder Aug 7 '17 at 14:12
  • \$\begingroup\$ @Okx Not for me, it doesn't. >>> f('Leaky N')\n48934 \$\endgroup\$ – totallyhuman Aug 7 '17 at 14:13
  • \$\begingroup\$ @totallyhuman It should return 0. Leaky N does not exist \$\endgroup\$ – Okx Aug 7 '17 at 14:14
  • \$\begingroup\$ @Okx Fixed. - - \$\endgroup\$ – totallyhuman Aug 7 '17 at 14:28
3
\$\begingroup\$

JavaScript, 128 119 bytes

-9 bytes thanks to Rogem.

n=>fetch("198.252.206.16/users?site=codegolf&inname="+n).then(r=>r.text()).then(t=>t.match(`\\/([^\\/]*)\\/`+n+`"`)[1])
\$\endgroup\$
  • 1
    \$\begingroup\$ Think you'd save some bytes with the IPv4 address. (198.252.206.16 instead of api.stackexchange.com) \$\endgroup\$ – Rogem Dec 10 '18 at 20:32
-1
\$\begingroup\$

JavaScript (ES6) + HTML, 154 152 151 202 179 161 145 bytes

Sacrificed a few bytes to handle special characters.

Needs to be run under the api.stackexchange.com domain. Returns a Promise containing the ID or Throws an error in the Promise if the username can't be found.

s=>fetch(`/users?site=codegolf&inname=`+s).then(r=>r.json()).then(j=>j.items.find(i=>(o.innerHTML=i.display_name,o.innerText==s)).user_id)

<a id=o

Note: This solution was developed independently of Uriel's and its comments; if Uriel decides to use the find method, I'm happy to roll back to my longer, recursive version.

\$\endgroup\$
  • 2
    \$\begingroup\$ I've created a meta discussion on requiring a certain execution domain, since that does save quite a few bytes. \$\endgroup\$ – Birjolaxew Aug 8 '17 at 11:48
  • 1
    \$\begingroup\$ @Downvoter, please have the decency to leave a comment. \$\endgroup\$ – Shaggy Dec 8 '18 at 9:30
  • \$\begingroup\$ @Shaggy I would assume for the same reason as that meta discussion was started. \$\endgroup\$ – Rogem Dec 10 '18 at 7:16
  • \$\begingroup\$ Downvoter, if you disagree with an established consensus (as @Rogem suggests), please downvote the relevant meta post rather than solutions that adhere to that consensus. \$\endgroup\$ – Shaggy Dec 10 '18 at 12:05

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.