Charcoal HQ

Rails and ActiveRecord make everything stupidly easy.

One last question before I go home. When using the Ms API by feedback type, if I pass fp, does that get me ONLY fpd posts, and excludes fpu, fpu-, fp- posts?

Kyll

ActiveRecord?

@Andy correct

match type is exact equality

Ok. I can make that work. One small request... "but there are other valid types", can those other types be listed somewhere in the wiki?

9:03 PM

@Andy literally any string is valid

hichris123

Hmm, random thought: should all-caps answer be turned off as well? metasmoke.erwaysoftware.com/reason/74

valid as in "anything you think may have been recorded at some point"

ignore, ignore-, true, trueu, the silent forms of all of those, false, falseu if that was ever a thing

things that won't work are the aliases, because Smokey converts those into the actual feedback types before it sends them to MS

I would think trueu === tpu etc.

It does

but afaik it doesn't get converted

hichris123

!!/addwlu ru.stackoverflow.com/users/221773

9:05 PM

@hichris123 User whitelisted (221773 on ru.stackoverflow.com).

Can you do a select distinct on that column in the DB and post the options?

Does the "vandalism" novelty get converted to tp-?

@JanDvorak yep

yes

aliases

@Andy cc @Undo because I don't have DB access

9:06 PM

@hichris123 I don't think these should have been FPU'd. Maybe add an "edited" feedback type?

@Undo, can you do a select distinct on the feedback type column in the MS database and post the results? I'm looking for a list of all available types for the types parameter to the Posts by feedback API end point

and direct vandalism to this

@JanDvorak why should they not have been fp?

@ArtOfCode they deserve about the same level of attention as NAA, which we do have a feedback type for

@JanDvorak where'd that qualification come from?

9:08 PM

They deserve editing

NAA's at least get deleted. All-caps just needs an edit.

@ArtOfCode Is this done with regex magic? If I said to smokey "falsehood of course" would that match "false"?

@DavidPostill not sure about whether there has to be a space after it

but false xyz would definitely match false

Ah. OK

Second opinion please. Is this spam? superuser.com/questions/1138787/…

Third opinion please

9:19 PM

@JanDvorak Yeah, I'm on the fence :/

CaffeineAddiction

spam

guy has no other activity on his account that I can see ... best case its a poor question worst case its spam

also, even if it is legit ... superusers is a odd place to post it

!!/test plagramme

> Would not be caught for title, body, and username.

I VotedTC as off-topic.

9:52 PM

[ SmokeDetector | MS ] Manually reported answer: Difference between OnActionExecuted and OnResultExecuting by ASS NGGR on stackoverflow.com

tpu- by DavidPostill

Undo

10:04 PM

@Andy You want all feedback types ever recorded?

> ap Feedback.pluck(:feedback_type).uniq
   (4.5ms)  SELECT `feedbacks`.`feedback_type` FROM `feedbacks` WHERE `feedbacks`.`is_invalidated` = 0 AND `feedbacks`.`is_ignored` = 0
[
    [ 0] "fpo",
    [ 1] "fpu",
    [ 2] "fp",
    [ 3] "tpu-",
    [ 4] "tpu",
    [ 5] "tp",
    [ 6] "fp-",
    [ 7] "tpu-spam",
    [ 8] "tp-",
    [ 9] "fpu-",
    [10] "tpu=",
    [11] "fpi-",
    [12] "true",
    [13] "false",
    [14] "trueu",
    [15] "trueu-",
    [16] "false-",
    [17] "falseu",
    [18] "true-",

With rel frequencies:

> ap Hash[Feedback.group(:feedback_type).count.sort_by{|k,v| v}.reverse]
   (0.1ms)  SELECT COUNT(*) AS count_all, `feedbacks`.`feedback_type` AS feedbacks_feedback_type FROM `feedbacks` WHERE `feedbacks`.`is_invalidated` = 0 AND `feedbacks`.`is_ignored` = 0 GROUP BY `feedbacks`.`feedback_type`
{
             "tpu-" => 39052,
               "tp" => 7025,
              "fp-" => 5161,
               "fp" => 3690,
             "naa-" => 1648,
           "trueu-" => 820,
              "tpu" => 680,

[ SmokeDetector | MS ] All-caps answer: How to make a vector using a for loop by Bob on stackoverflow.com

@SmokeDetector f

tpu- by Jan Dvorak