The 2nd Monitor

7:00 PM

@rolfl Those are some good guidelines... that SE seems to not be following when it comes to Code Review...

I've just gone and done a count, and based on most metrics (pageviews, users, questions etc.) CR is as big as the 10-15 smallest graduates sites combined (ignoring things like Meta SE)

Ethan Bierlein

dang

rolfl

@Zak - you must be new here .... ;-)

Mat's Mug

lol

3

rolfl

See: data.stackexchange.com/stackoverflow/query/199310/…

Mat's Mug

7:04 PM

wait 'till Winter Bash comes along

Captain Obvious

1

Q: Variable length string validation against whitelisted characters

I need to validate a variable length string against some white-listed characters. The algorithm that I have works but I have a sneaking suspicion that there is a more elegant solution. The code below hasn't been identified as a bottleneck so ease of maintenance is preferred over a clever but conf...

rolfl

Of the 149 sites on the exchange, not counting meta's, Code Review is the 20th most awarded site. It is bigger than most graduated sites "by a long way".

Mat's Mug

and I'm 2 days short of adding another [badge:epic] to the lot

haven't really been trying for a while

Phrancis

@rolfl s/if/of/

Mast

So, we didn't learn anything new, did we?

Ethan Bierlein

7:11 PM

Nope.

TopinFrassi

There wasn't really anything new to be learned. It's more of a discussion that had to happen

Zak

And even if we did, would you believe it?

janos

daaamn, the design of RPi is pretty awesome

TopinFrassi

@janos Looking at it, I don't get why it's so long to do a design. I see 2-3 different colors and maybe 5 new images. But yeah, it's cool!

janos

it's beyond me, just like the fact that raising privilege thresholds appears to be blocked by the design change

Mat's Mug

7:22 PM

@janos all site designs are pretty awesome.. there's a reason we want our own!

Mast

@janos Yup, I don't understand that either.

janos

@Pops so which other sites are in front of us in the queue?

Mat's Mug

there is no queue

(thought it was obvious by now)

janos

yeah, I meant the imaginary queue

Pops

It's more of a heap, at best.

And I don't know how the weights are assigned.

janos

7:23 PM

now you're talking

Pops

(I guess if you're one of those weirdos who calls it a "priority queue" then everyone can be right.)

Zak

@Pops The only explanation that seems to make sense is that it's down to the personal whims of some person/people

janos

appears to be a min-heap

Mast

I prefer a FIFO

Mat's Mug

HI JAMAL!!

Jamal

7:25 PM

HI MUG
HI POPS

Mat's Mug

@Pops sorry you had to take all the venting

Pops

I don't know anything about creating a site design (which also should be obvious by now) but I have picked up that designs, like computer programs, are not all the same. Some are simpler, some more complex. Some have a lot of architecture and algorithms and frameworks and others are more quick-and-dirty spaghetti jobs. Okay the analogy is pretty weak here but hopefully you sorta get the idea?

TopinFrassi

@Pops Sooner you said that the design team had its own backlog and stuff. Is there anyone from that team our mods could contact? This way we wouldn't need a mediator to take the venting as Mat said!

Mat's Mug

hides

TopinFrassi

@Mat'sMug Don't go too far :p

Pops

7:29 PM

@Mat'sMug No worries. I just need to be better at what I do and then people will be happy all the time.

Mat's Mug

@Pops that's what your boss told you? :D

Pops

If by "your boss" you mean me, then yes!

@TopinFrassi Nah. Part of the point of having CMs is to simplify the communication structure.

rolfl

@TopinFrassi it has been made relatively clear, in the past, that the design team is the tail that wags the dog. It is understaffed (they are hiring, and have been for years, but apparently can't hire anyone), and it does whatever it likes, unless someone (Joel) tells them personally to do something specific. Their creative process is otherwise something that is ... creative.

Mast

@Pops I hate to be that guy, but something in that idea is not working, apparently.

rolfl

In addition, apparenty the design, and graduation, are intimately linked, but there's some things that can be decoupled.....

Pops

7:32 PM

Generally you hear from a designer when the "here's the draft of your design" meta post is ready.

Zak

@Pops Also, probably not a good idea to provide a direct conduit between us and people we can directly blame for our situation.

Pops

@Mast The implication (well, one of them) is that we should be able to improve overall communication by getting the entire picture from both sides, and I've failed to do that in this case.

TopinFrassi

@Pops Don't blame yourself over all this. You're doing what you can with what you have. You have the dirty job of speaking with us when the design team made a mistake

rolfl

again.

and again.

It's a good thing that SE has stopped sending swag out to people with 100K.... I mean, what would they send to us.... Stack Exchange mugs?

Pops

As much as I enjoy not being blamed, I gotta stick up for the design team too. They're not "making mistakes" so much as "prioritizing their work in a way that justifiably causes you to feel unhappy."

rolfl

7:41 PM

To be clear, the part that makes us unhappy is that their efforts are wasted on small, tiny, minorities that don't deserve it..... (I thought before writing that, but I think it's accurate).

2

Zak

@Pops For ~~over a year!~~ sorry, I mean 6-8 weeks™

TopinFrassi

@Pops I get that you stick with your team, you need to do this :p But we consider it a mistake. RaspberryPi just graduated. It's a joke.

janos

what makes me unhappy is these pointless discussions. Where we just realize again and again that we're completely powerless. We've exhausted all puns about Pops, and the mythical 6-8 weeks promises too, a long long time ago. Pops if you think our stress is even a little bit released by using you as our verbal punching bag, it's not working, at all.

8

Phrancis

@janos Amen

Ethan Bierlein

Aand, my stars are gone.

TopinFrassi

7:46 PM

@EthanBierlein I got your back

rolfl

Let's crunch the numbers....... Code Review is about the size of the combined (traffic per day): Theoretical comp sci, biology, expression engine, craft-cms, so.jp, network engineering, COMBINED

(add in Meta.stackexchange as well, which also sort of graduated after our announcement).

We are bigger than those sites combined, and they all got colors after our announcement.

@janos I "walked away" for a while. It's about the only thing that works.

Ethan Bierlein

Actually, walking away would only hurt us. With less active users, we lost some of the activity that got us here in the first place.

200_success

Activity doesn't seem to matter, though.

Ethan Bierlein

For all we know, if we all just "walked away", SE would shut down Code Review and move on.

200_success

In 6-8 weeks.

janos

7:52 PM

@EthanBierlein I think Rolf meant that for the unhappiness part. For proper graduation it doesn't work, of course (evidently)

Mast

More like 6-8 years with this speed... — Mast Aug 14 at 21:49

I hate being right.

Those 6-8 weeks have been passed at least 6-8 times.

janos

@Mast I think 200 meant, SE will forget us and move on in 6-8 weeks

Mast

@janos We're too much a pain in their behind to be forgot.

I mean, we're the only site which initially resisted DIG, right?

rolfl

@Pops - by the way, this is another lie the SE folk told us:

21

Q: Site Graduated!

As you can see the new design just went live. Which means this site has been officially launched! Congratulations! Thank you for your valuable design feedback. We have also themed the twitter account and newsletter template for this site. If you see any CSS/styling bugs, please start a new post...

discussion featured design

We were told that all graduations would now be "progressive".

janos

@Mast maybe in the behind of Pops. I don't know how much further we reach, maybe not at all

rolfl

7:57 PM

That elections and other things would always happen before colors.

Duga

This code could really benefit from a refactor, if you can get it working and want some advice on improving the code then this would be a really good candidate to post over on codereview.stackexchange.com — shuttle87 12 secs ago

rolfl

Apparently that's not true.... that elections can still now happen after design is applied.

Jamal

@200_success: "vandalism"

200_success

Ha. I suspected it would happen. I'll leave it alone.

Mast

@Jamal I'm not going to mingle in it now, but had I encountered that on my own I'd have rolled back to Rev 4 in a heartbeat.

janos

8:00 PM

200 removed "hello" and "thank you for reading" ?!?! VANDALISM!!!

Jamal

And... deleted? Okay, I guess.

TopinFrassi

Steve, I know. Just saying that people joining these days and not being around since '11 will really have a hard time. This is not SF&F; there's little to none voting around here. — Ghanima Nov 10 at 22:02

Oh look, RaspberryPi has voting problems :

Like CR did... in 2013

Duga

You're actually totally right. I was using an old tutorial that was using only pylab for this. I guess a lot has changed since that tutorial was made, but I got it working now. (Just had to use numpy instead.) Also, thanks for the pointer to codereview.stackexchange. — Teldridge11 20 secs ago

Mast

RPI got some seriously shiny swag.

rolfl

Heh, seriously embarassing: raspberrypi.stackexchange.com/users?tab=voters

Pops

8:05 PM

@rolfl Yeah, that is definitely the new guy. RPi was the case I suspected it was, where the design team used it as a test and then it was so close to being ready they just implemented it. It's an exception, not the rule. None of that is really the point though; I completely see how all this makes you feel dismissed.

Ethan Bierlein

@rolfl Oh man, lol.

Sad amounts of voting.

TopinFrassi

@rolfl They got like.. 350 votes in the month??

Ethan Bierlein

The biggest amount of votes on singular user has is 2446 votes.

TopinFrassi

@Pops Yeah I guess. Is there any reasons why RPi was chosen for this case?

Pops

Also, if you want to lay into something, then pick on our poor processes on the team, not the Raspberry Pi SE community. RPi may not measure up to CR along certain metrics, but they did earn their graduation.

3

Zak

8:08 PM

@Pops Okay, no offence but that's b*******

rolfl

@Pops - no, they did not.... not according to the standards we were told to have before we were candidates for graduation.

We were told we needed trusted users, etc.

(more lies).

Zak

if they earned their graduation then every reason we were given for delaying our graduation was a complete lie

Mat's Mug

^^

rolfl

^^

Pops

@TopinFrassi I'm sure there are but I couldn't tell you what. Just like a designer might not be able to tell you how to choose what you ask during a coding interview.

TopinFrassi

8:09 PM

Even there guys, it's not the RPi's community fault. It's SE's team that decided they would graduate. Not the community itself

Pops

I said graduation, not design.

Mat's Mug

which part of this doesn't apply to RPi?

43

Q: How is Code Review doing right now?

I’m Grace Note, a Community Manager at Stack Exchange. Normally for most sites we run a community site evaluation, as explained in this Meta Stack Overflow post under Public Beta sites. However, these reviews involve comparing our site content against searches on the internet for competing answer...

discussion beta-progress

Zak

@TopinFrassi I don't think anyone here is having a go at RPi

rolfl

@Pops - graduation happens with reputation threshold changes, design, and a name in the footer of stack exchnage - that's what makes a site official.

Mat's Mug

they have > 10% unanswered

they have voting issues

200_success

8:11 PM

@Mat'sMug Those criteria have been superseded.

Mat's Mug

they have 0 post-grad trusted users

200_success

213

Q: Feedback Requested: Design-Independent Graduation

Last month's announcement about our updated criteria for graduation and site closure sparked some solid examination into the intended nature of public beta and graduation. One thing these discussions showed us is that, contrary to what the Community Team had long believed, getting a custom desig...

discussion design beta-phase graduating-sites

Ethan Bierlein

@Mat'sMug 10% unanswered!!?

TopinFrassi

@Pops But someone had to make a decision regarding this. That person should be able to justify it, shouldn't it? I mean, if I was to look at my job's backlog and pick the last added item in the backlog and push it to the top because I wanted to, my boss would come and have a chat with me real quick.

Pops

@Mat'sMug That's a really old post. We've since updated our graduation criteria. CR happens to have met both sets of criteria, and that's something to be proud of, but RPi also met the newer one.

Mat's Mug

8:12 PM

1,725/9,288= 18.6% unanswered actually

200_success

Raspberry Pi deserves its place in the queue/heap/bag/whatever according to the new criteria.

Mast

Unbelievable.

Mat's Mug

@Zak please

Captain Obvious

0

Q: DI and Generic Interface - Constructor needs concrete types

So I'm trying to figure out the ins and outs of DI and IOC. I have a multi tiered web application. API Service (This is where I have a problem with DI) DTO (Factories live here) DAL I thought of creating a generic factory interface that would look like the following public interface IFactory<...

c# dependency-injection

Zak

@Mat'sMug Okay, sorry. Going to cool off

back in 5 or so

Mat's Mug

8:14 PM

np

Pops

:25514585 You're already graduated. I think we're talking past each other a little here because we're using the terminology differently?

Zak

@Pops You can say we're graduated all you like. Doesn't make it true.

200_success

Some of us don't like the new terminology.

2

Ethan Bierlein

I agree.

Mast

@Pops Most of us don't accept the new thing the team calls graduation as actual graduation.

Mat's Mug

8:15 PM

graduated == beta-blue gone

Pops

@TopinFrassi That makes sense. But in this case it's more like the last added item in the work backlog was also already like 99% done.

200_success

Or graduated == graduated privilege levels.

Mast

Colors and reputation changes, those are the most important at the moment.

Mat's Mug

colors for reputation thresholds adjusted to grad-level, actually

Mast

> I think that CR is unanimously stating that this is a step in the right direction, but not enough. We all want the privilege levels changed now. We fear that if you strip the Beta label, we would be officially out of Beta, you can declare Mission Accomplished, and leave us waiting indefinitely again.

Pops

8:16 PM

Okay. Then assuming that I am already doing what I can regarding the colors/privilege levels package (which I am), what else can I be doing to help make this better for you?

Mast

(source)

200_success

Transparency and honesty, from someone with authority on the matter.

TopinFrassi

@Pops Then again, it was 99% done because someone decided the "interview challenge" would be using RPi? Someone somewhere didn't follow the priority?

Mat's Mug

@Pops does that include singing "over the rainbow" to the design team every morning?

TopinFrassi

@Pops I'd take a Snickers. :p

Mast

8:17 PM

Does anyone actually know what has been the progress on our graduation the past 3 months?

TopinFrassi

@Mast Oh oh!!! I know I know. Nothing. At. All.

Mat's Mug

^

janos

^

Mat's Mug

are there sketches, or something like a sprout of a beginning of an idea for our design?

Ethan Bierlein

If so, I'd love to see them.

Pops

8:19 PM

@TopinFrassi To continue the analogy, then, and at the risk of becoming increasingly inaccurate: when you interview a new developer, do you pick interview questions that are good measures of the person's general ability to code/think/solve problems, or do you pick the oldest item from your production bug queue?

Mat's Mug

I don't care to see them

200_success

Even so, surely there was another deserving site that was already cleared for graduation.

TopinFrassi

@Pops But in such a case, isn't our old item in the backlog the same difficulty as the new one? If not, you've got a point! But also we'd like to know what makes CR's design more difficult for a designer than RPi.

200_success

Picking a site that wasn't even previously mentioned for graduation is a slap in the face for every site that had already been cleared.

10

TopinFrassi

@Pops This isn't your fault I don't want to be rude towards you. It's just that you're the only "bridge" we got to try and push things.

rolfl

8:22 PM

2 hours ago, by rolfl

Frankly, even if Joel does respond, I would not even trust his word on the state of Code Review at this point.

Captain Obvious

0

Q: Java xml parsing, attempting to use a single method multiple times to further populate the same form

I am essentially brand new to programming and I apologize ahead of time if the way I've constructed the code is done so poorly. I am attempting to create xml forms using user input to populate certain areas that would appear when loaded into a STIG viewer. Right now everything is working enough ...

java parsing

CommitStrip

CommitStrip: The Sysadmin’s Apprentice – Joyeux Anniversaire Mickey Mouse !

posted on November 18, 2015 by CommitStrip

Paul Dukas – The Sorcerer’s Apprentice Votre navigateur ne supporte pas l’élément audio element.

2

Ethan Bierlein

Oh hey, look at that! The commitstrip feed has styles now!

Zak

I think that's the crux of it really. We don't care as much about not being graduated yet. But what is really a slap in the face is being passed over again. And again. And again. In favour of sites which haven't got a tenth of what we've got.

TopinFrassi

I'm glad I kept all my stars today

Zak

8:25 PM

I actually had quite a healthy stock going into this discussion. 2 hours ago.

Needless to say I'm starred out by this point.

Dan Pantry

Oh dear. Did I miss something?

5

Zak

@DanPantry lol

Dan Pantry

Ah yes. I missed everything.

Zak

@DanPantry juuuuust a little

Dan Pantry

Ive got the gist though.

And I agree.

Mat's Mug

8:29 PM

0

A: Tracking Graduation Progress

Raspberry Pi Announcement : 2015-11-17 Design Meta : 2015-11-06 Colors : 2015-11-17 Elections :

Dan Pantry

Don't get why another site was graduated ahead of us.. Code Review is gaining a lot of traction even on Stack Overflow, albeit sometimes for the wrong reasons.

2

TopinFrassi

All this talk about RaspberryPi made me hungry for a raspberry pie.

Dan Pantry

The reasons given above are, well, excuses at best

Mat's Mug

something tells me we're going to end up with some "angry zombie coding monkey" theme

Zak

@DanPantry that's the start if you want to read the whole thing. chat.stackexchange.com/transcript/message/25510787#25510787

Dan Pantry

8:31 PM

It's not our fault that the resource isn't there for the design. The resource is obviously there as another design was made for another site. It just appears that we are lower priority than the Pi.

Captain Obvious

0

Q: Which Design Pattern combination do I use to Simplify my code base while Preserving Functionality?

Note This question was born in request to post more details from this question: http://programmers.stackexchange.com/questions/302845/which-pattern-can-i-use-for-doing-computations-involving-similar-yet-different-o Since details may uncover new/different complexity, I deemed to ask new question...

php oop design-patterns

Mast

@Mat'sMug Better than nothing...

Dan Pantry

Our job is to run a successful community, not to manage SO's resource for them... so I don't think it's an acceptable reason to come and say "Sorry guys, just don't have the resource to do it". It's been 14 months now.

Mast

So we knew nothing, we know nothing and we can guess pretty good we won't be learning anything on this front for the foreseeable future.

Dan Pantry

You're telling me in 14 months you've not had the resource to sit down and at least plan what you're going to do for this (very active) community? :S

Mast

8:32 PM

Motivational.

Mat's Mug

@DanPantry telling all of us actually

Dan Pantry

@Mat'sMug When I say you, I of course mean the royal you. Not anyone in this chatroom specifically.

Mat's Mug

> You're telling me ...

s/me/us ;-)

Dan Pantry

My mistake :)

I can't maths.

Duga

This seems like a question for Code Review as you're asking about where to add some code rather than how to make the code work. — 31eee384 39 secs ago

Dan Pantry

8:38 PM

^^^^ and thats the funniest part of all of this.

Duga

If you can get this code into a working state and are looking for advice on how to improve it then you might wish to post over on codereview.stackexchange.com as there's a few suggestions I can see here to improve this code. — shuttle87 6 secs ago

TopinFrassi

lol

Duga

@31eee384 code that's not yet written isn't ready to be peer reviewed - that would be off-topic for Code Review — Mat's Mug 9 secs ago

Dan Pantry

i.imgur.com/CLJmBN9.webm

3

"How it feels to study Computer Science"

Mast

Second opinion?

Dan Pantry

8:46 PM

Looks more conceptual than review.

Accurate description of 2nd tonight:

R2D2 crashing into a wall, screaming

TopinFrassi

@Mast You've had 2 opinions for the price of... zero. :D

Dan Pantry

@TopinFrassi I agree with that, programmers might be a better home for that questino.

(But it would likely be closed as duplicate given how common that question is)

Mast

@TopinFrassi 2 and a mod opinion, closed.

TopinFrassi

@DanPantry Yup, but in that case it's not my problem! :p

Dan Pantry

I actually asked something similar a few years ago

s/few/1 and a half

Duga

8:51 PM

Thank you. I x/posted this on Code Review and the answer there and yours have really completed the picture for me! — zerohedge 53 secs ago

Dan Pantry

R2D2 crashing into a wall while screaming.

Details ;-)

Thank you (I'm going to assume, @200_success)

200_success

@Duga That's the one that holroy pointed out was off-topic.

Dan Pantry

@200_success lol

That's awkward

Mast

@200_success Apparently jonrsharpe send him this way.

If this is working code that you think could be improved, have you considered Code Review? — jonrsharpe 5 hours ago

Captain Obvious

1

Q: Swift 2: Paring JSON with generics

I get back two dictionaries, I need to parse through them and put in an array two objects. Below is the code that I am using but I think I did a very poor job. I have a feeling there is a better way to make the code more compact and generic. I'm a newbie to generics. I think there is definite...

ios swift

200_success

9:04 PM

^ @jonrsharpe Caution about the your-own-code rule.

Zak

Hi @JeroenVannevel

You missed all the drama

Mast

And another project ready for the fridge...

Just like CR's graduation ^^

Zak

I would star that, but I'm out of stars, and I've drained all my Graduation-frustration-energy

I kinda feel sorry for Pops though

Jeroen Vannevel

9:21 PM

I don't really want to be involved at all with drama

so that's okay

Mat's Mug

raspberrypi.stackexchange.com

Y U NO ONEBOX

lol, they did it again

Y U NO DROP SHADOW

Mast

Who made that logo, an intern?

FFS, readability much?

Zak

I think it's a pretty neat design

Mast

*** unreadable, that's what it is.

Mat's Mug

no different ^^

Phrancis

9:27 PM

lol

Mast

I didn't even notice there was text in the logo until I checked the source.

Zak

@Mast not that I mind personally, but, language.

Mast

!Code Review

Markdown...

Mat's Mug

^^ beta blue without the "beta" part

Simon Forsberg

17

Q: Speaking of UserExperience

I occasionally browse this site, but it wasn't until today that I was encouraged to create an account--and only to post on the meta. As many of you know, when certain links are pasted into StackExchange chat, the chat will automatically be replaced with some sort of image. However, when http://...

bug design chat

Zak

9:29 PM

@Mat'sMug I didn't even realise there was an image there

Mast

12

A: The "Be Nice Policy" - and Chat

There are more than 20,000 instances of "fuck" present in the chat.SE rooms, not counting private rooms used for moderation. I think this clearly shows that a certain level of crude language is widely tolerated in chat. SE never stated that the "no expletives" rule on the main sites doesn't apply...

RubberDuck

Y R THERE 25 PROJECTS IN HERE?!

OMG..... Y?

Mat's Mug

@RubberDuck hey there

RubberDuck

Sorry to interrupt. Just needed to vent.

Hey Mug!

Mat's Mug

lol, we were just done collectively venting, ...go ahead and vent!

Phrancis

9:31 PM

or, don't... :)

Mast

RubberDuck

Oh, it's nothing. Working on "a fun project" at work and the astronaut has 25 separate projects in a solution.

Phrancis

Astronaut?

Mast

@RubberDuck What's an astronaut and why is he holding 25 projects in one solution?

RubberDuck

Architecture astronaut.

The whole thing is way over-engineered.

Mat's Mug

9:33 PM

lulz

RubberDuck

How big is RD now @Mat'sMug? How many namespaces?

Mast

RubberDuck

And how many projects do we have?

Mat's Mug

uh, 4-5 projects, IDK how many namespaces

RubberDuck

Like, 4 or 5?

Yeah... This app is half the size & complexity as RD.

Mat's Mug

9:34 PM

wow

RubberDuck

Yup. My thoughts exactly.

To be fair, at least 3 or 4 of these are C projects though.

OUT OF 25

Phrancis

Now you have 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 problems.

2

Mat's Mug

@Phrancis the amount of markdown needed to do this.... here, have a star

Duga

If you are looking to improve existing, working code, this may be a better fit for codereview.stackexchange.com — cantido 30 secs ago

Zak

^^

Phrancis

9:39 PM

="---"&H1&"--- "

Done

Mat's Mug

excel-ftw

Phrancis

... for some values of "win"...

Mat's Mug

="---"&COLUMN()&"---"

eh, whatever

Phrancis

That a recursive call to itself?

Mat's Mug

nope

Mast

9:42 PM

FT*W*

What? That W was perfectly recurved last time...

Phrancis

Ohhhhhh it's the column number I see

Captain Obvious

0

Q: Using string based factory method and parameter transferring

Goal: This way a particular class can be created from arbitrary location with no dependencies needed. Simply put, let's say we have a manager class: MyClassMgr, a blueprint-like class: MyClassBlueprint and a class that we entrust with the management of, among others, MyClass_A. MyClass_A can i...

c++ design-patterns factory-method

Duga

10:00 PM

possible answer invalidation by 0x58 on question by 0x58: codereview.stackexchange.com/posts/110927/revisions

RoboSanta

0

A: Python lookup table

Maybe my approach is crude, but the first thought I had was to use a simple dictionary with key as "ping host". If user separates command and parameters with multiple spaces or tabs, that too can be handled by preprocessing the command before indexing the dictionary. Another approach that may be...

Mast

@Duga Perhaps, wouldn't hurt if one of the DB guys would take a look at it.

Captain Obvious

0

Q: Get a row from Excel with different criterias with one method

Using Apache POI, I want to retrieve a Person from my Excel file by id or by name. To keep the example simple, the Person class is only an int id a String name and in the Excel file, the id starts at A2 (A1 is the header) and the name at B2 (B1 is the header). I came up with this code: public P...

java excel

Phrancis

@Mast looking now

Zak

@Mast Can't speak to whether it's now On-Topic. But I would suggest the renaming at least invalidates the answer it does already have.

Mast

10:13 PM

@Zak In that case it should be rolled back.

AND THIS, THIS! THIS is why you shouldn't answer off-topic questions. It breaks stuff.

I'Z OUTTA YR CHAT

Phrancis

I rolled it back

holroy

@Zak The answer already given is way off anyway. The OP asked for a better method to remove leading and trailing zeroes if ordered by date. Not that speed should always be above 0. One of the other unclear aspects is the secondary sort order as it isn't specified, and whether we can trust the ID's.

Jeroen Vannevel

holroy

@Phrancis Actually I think rev5 looks better than the rolled back. It does invalidate the answer, but as the answer is wrong anyway, I think that answer should be deleted or commented upon that it doesn't answer the question correctly

Phrancis

@holroy I fixed it together my merging the OP's English chamges but leaving out the code changes

I also voted to reopen as it looks a good bit better now

holroy

10:27 PM

@Phrancis That looks a lot better...

Phrancis

@holroy I'm pretty certain that the query in the answer doesn't return the same results as the OPs

I'll test it out on my machine when I get home tonight

holroy

@Phrancis Nope, one thing is that it leaves out the row with id=11...

I'm thinking the answer could be something along the lines of:

select * from tableX
   where id >= select min(*) from tableX where date = 'date' order by id
      and id <= select max(*) from tableX where date = 'date' order by id

Phrancis

I think this would actually be a good candidate for a stored routine/proc

holroy

Most likely not correct sql, but you get the gist of the idea... Would even be nicer if one could do a select min(*), max(*) into a between select... But don't know/remember/... how to do that... :-)

Phrancis

@holroy variables, my friend :)

But with MySQL, those would need to be in a stored function/procedure

holroy

10:35 PM

I know... But how to do that in MySql I don't remember

Phrancis

See bottom-right example for MySQL

Duga

possible answer invalidation by Artyom2033 on question by Artyom2033: codereview.stackexchange.com/posts/111146/revisions

Phrancis

10:53 PM

DELIMITER $$
DROP PROCEDURE IF EXISTS `select_todays_ids_between_the_zeroes`$$
CREATE PROCEDURE `select_todays_ids_between_the_zeroes`
(
    IN `target_date` DATE
)
BEGIN
    DECLARE `v_min_id` INT;
    DECLARE `v_max_id` INT;
    SET `v_min_id` = (SELECT MIN(`id`) FROM `tableX` WHERE `speed` <> 0 AND `date` = `target_date`);
    SET `v_max_id` = (SELECT MIN(`id`) FROM `tableX` WHERE `speed` <> 0 AND `date` = `target_date`);
    /* The result from this SELECT will be returned to the caller: */
    SELECT *

@holroy I think something like this^ might work fine - will have to test to be sure

ttqw

Mat's Mug

ugh

think MySQL is a PITA, try setting up a [Model] and a [Material] dimension in SSAS with the data I'm putting up with

holroy

Hmm.... I like this one better:

SELECT * FROM tableX
 WHERE id
  BETWEEN ( SELECT min(id) FROM tableX WHERE speed > 0 AND date = '2015-01-01')
      AND ( SELECT max(id) FROM tableX WHERE speed > 0 AND date = '2015-01-01' )

Phrancis

reddit.com/r/sysadmin/comments/2gt7x5/…

@holroy I think your first subquery is broken

( should only have min(id) )

I'd also recommend against using BETWEEN

holroy

@Phrancis Not anymore... I tried combining them to avoid having two sub-selects...

Phrancis

Oh, right

holroy

11:04 PM

Why not BETWEEN?

Phrancis

What do BETWEEN and the devil have in common?

Anyways, back in a bit

holroy

@Phrancis Interesting reading. I do agree with the inclusive/exclusive part! For this query the rounding part doesn't apply, though.

Humpty, dumpty, whilst waiting for the question to be reopened, here is another version (without BETWEEN, and combining the query):

SELECT tableX.* FROM tableX,
  ( SELECT min(id) as startId, max(id) as endId FROM tableX
     WHERE speed > 0 AND date = '2015-01-01' ) tmp
  WHERE id >= tmp.startId AND id <= tmp.endId

Hi guys, could you reopen the question below, so I can answer it?

0

Q: Select records between the first and last time the speed was positive

I have the following table: id speed date 1 0 01/01/2015 2 0 01/01/2015 3 0 01/01/2015 4 0 01/01/2015 5 0 01/01/2015 6 0 01/01/2015 7 25 01/01/2015 8 78 01/01/2015 9 13 01/01/2015 10 45 01/01...

php sql mysql

Captain Obvious

11:38 PM

0

Q: Name Banner Program

I have a program that takes an input from the user (the user's name) and print a result with their name inside a border such as: ************* * name_here * ************* The code: def style_1(): print "*" * (length_of_name + 4) print "*", name, "*" print "*" * (length_of_name + 4...

python

Transcript for