Bits and Bobs 37

MaliA · **Posted:** Wed Nov 28, 2012 15:28

Someone has seen my CV and "really wants to interview me". The role is a Junior Data Specialist working with sql and oracle."Needs a strong understanding of sql and knowledge of oracle database systems". I'm not terribly interested in it, to be honest, but might go along for the interview practice. I know not a lot about sql, other than I can look at a bit of code and decide what it might possibly do. Pay isn't great, either, spending time as an aprpentice doing that sort of thing. I might say "interested, but drop the "junior" and I'll want to be in the top end of the pay band and a team leader in 18 months". Anyone want a look at the job spec?

Grim... · **Posted:** Wed Nov 28, 2012 15:45

MaliA wrote:

I know not a lot about sql, other than I can look at a bit of code and decide what it might possibly do.

Code:

WITH RECURSIVE supplytree AS
(SELECT si_id, si_item, si_parentid, CAST(si_item As varchar(1000)) As si_item_fullname
FROM supplyitem
WHERE si_parentid IS NULL
UNION ALL
SELECT si.si_id,si.si_item,
    si.si_parentid,
    CAST(sp.si_item_fullname || '->' || si.si_item As varchar(1000)) As si_item_fullname
FROM supplyitem As si
    INNER JOIN supplytree AS sp
    ON (si.si_parentid = sp.si_id)
)
SELECT si_id, si_item_fullname
FROM supplytree
ORDER BY si_item_fullname;

GO!

MaliA · **Posted:** Wed Nov 28, 2012 15:46

I clearly have the junior book.

Grim... · **Posted:** Wed Nov 28, 2012 15:48

Code:

SELECT * FROM user WHERE email LIKE '%yahoo%' LIMIT 3000,1000

GO!

Curiosity · **Posted:** Wed Nov 28, 2012 15:48

Just tell 'em the old Bobby Tables anecdote and you'll be fine.

MaliA · **Posted:** Wed Nov 28, 2012 15:50

I does things like:

Delete from view_header where list_name=’Defunct lists’;
Commit;

MaliA · **Posted:** Wed Nov 28, 2012 15:51

Curiosity wrote:

Just tell 'em the old Bobby Tables anecdote and you'll be fine.

"As long as your data inputs are sanitised, that's one of the first steps to ensuring good quality results, then you don't have to begin to worry about hash table integrities"

Curiosity · **Posted:** Wed Nov 28, 2012 15:52

At least you remembered the commit statement. Someone left it off a command on one of our databases and it broke the whole damn thing. Or something.

MaliA · **Posted:** Wed Nov 28, 2012 15:57

Grim... wrote:

MaliA wrote:

I know not a lot about sql, other than I can look at a bit of code and decide what it might possibly do.

Code:

WITH RECURSIVE supplytree AS
(SELECT si_id, si_item, si_parentid, CAST(si_item As varchar(1000)) As si_item_fullname
FROM supplyitem
WHERE si_parentid IS NULL
UNION ALL
SELECT si.si_id,si.si_item,
    si.si_parentid,
    CAST(sp.si_item_fullname || '->' || si.si_item As varchar(1000)) As si_item_fullname
FROM supplyitem As si
    INNER JOIN supplytree AS sp
    ON (si.si_parentid = sp.si_id)
)
SELECT si_id, si_item_fullname
FROM supplytree
ORDER BY si_item_fullname;

GO!

I think that'll produce a list of things which don't have a parent ID, from teh supply tree table and put them in name order.

MaliA · **Posted:** Wed Nov 28, 2012 15:59

Grim... wrote:

Code:

SELECT * FROM user WHERE email LIKE '%yahoo%' LIMIT 3000,1000

GO!

that will retrieve anything with a "yahoo" in the email address and returns 3000 instances?

% being a wildcard.

MaliA · **Posted:** Wed Nov 28, 2012 16:16

I've told them that I'm free form tuesday afternoon onwards. might as well have some practive, eh?

Dimrill · **Posted:** Wed Nov 28, 2012 16:28

Trooper wrote:

There is a guy who lives in my block of flats, nice enough chap, chinese dude, married with a young child. Seems perfectly normal and pleasant enough.
I always know if he has recently left the flat or come home. How you may wonder?

Because he absolutely reeks of BO, enough that for the next 5-10 minutes of him walking down the stairs, you can still smell it.

How is that possible? How does he not know? How has his wife not said anything?

The neighbours who used to live next door to me Mam didn't clean their teeth and consequently stank. Really badly. I remember once my sister child sat for them one night. For one reason or another she had to phone round to me Ma's for something, when we went round she said "just pick up the phone and smell the mouthpiece". Retched.

Old work colleague also didn't clean his teeth. Ginger lad. Had green teeth. No joke.

Grim... · **Posted:** Wed Nov 28, 2012 16:29

MaliA wrote:

Grim... wrote:

MaliA wrote:

I know not a lot about sql, other than I can look at a bit of code and decide what it might possibly do.

Code:

WITH RECURSIVE supplytree AS
(SELECT si_id, si_item, si_parentid, CAST(si_item As varchar(1000)) As si_item_fullname
FROM supplyitem
WHERE si_parentid IS NULL
UNION ALL
SELECT si.si_id,si.si_item,
    si.si_parentid,
    CAST(sp.si_item_fullname || '->' || si.si_item As varchar(1000)) As si_item_fullname
FROM supplyitem As si
    INNER JOIN supplytree AS sp
    ON (si.si_parentid = sp.si_id)
)
SELECT si_id, si_item_fullname
FROM supplytree
ORDER BY si_item_fullname;

GO!

I think that'll produce a list of things which don't have a parent ID, from teh supply tree table and put them in name order.

It's hard to know without looking at the tables and data, really. It does lots of stuff

MaliA wrote:

Grim... wrote:

Code:

SELECT * FROM user WHERE email LIKE '%yahoo%' LIMIT 3000,1000

GO!

that will retrieve anything with a "yahoo" in the email address and returns 3000 instances?

% being a wildcard.

Close, but not quite - it will return 1,000 instances, starting at the 3,000th (so instances 3,000 to 4,000).

KovacsC · **Posted:** Wed Nov 28, 2012 16:32

I am learning today..

TheVision · **Posted:** Wed Nov 28, 2012 16:34

I'm skiving today. I've just bought a MegaBlocks Halo Warthog. Only £7! Bargain.

Dimrill · **Posted:** Wed Nov 28, 2012 16:35

Dimrill wrote:

Old work colleague also didn't clean his teeth. Ginger lad. Had green teeth. No joke.

Suddenly my brain has taken me back the 10 years since I worked with him. I remember one day him arriving at work and telling us how his (16 year old) girlfriend was pregnant. All I could envisage was his scrunched up cum face while he guffed a green miasma of stench into her face and coughed his yoghurt inside her. Brbbrrrrrr.

DavPaz · **Joined:** 27th Jun, 2008 **Posts:** 38659

Dimrill wrote:

Old work colleague also didn't clean his teeth. Ginger lad. Had green teeth. No joke.

Suddenly my brain has taken me back the 10 years since I worked with him. I remember one day him arriving at work and telling us how his (16 year old) girlfriend was pregnant. All I could envisage was his scrunched up cum face while he guffed a green miasma of stench into her face and coughed his yoghurt inside her. Brbbrrrrrr.

And I'm glad it's not lunchtime.

Dimrill · **Posted:** Wed Nov 28, 2012 16:48

It was enough to turn me lesbian. He was in his late 20s and she was 16. He had a car. Personally if it was up to me to choose, I'd walk.

MaliA · **Posted:** Wed Nov 28, 2012 16:57

Dimrill wrote:

It was enough to turn me lesbian. He was in his late 20s and she was 16. He had a car. Personally if it was up to me to choose, I'd walk.

A good example of partner choice. The younger woman wants a man who is financially secure to support and take care of her offspring and he has ornamentations to attract the younger mate. He had a job, and a car to show he had a job and money, so he was the chosen father of her child.

Cras · **Joined:** 30th Mar, 2008 **Posts:** 49244

Also he had a red shirt.

Zardoz · **Posted:** Wed Nov 28, 2012 17:04

TheVision wrote:

I'm skiving today. I've just bought a MegaBlocks Halo Warthog. Only £7! Bargain.

Cool!

I saw Mecchano are punting a Gears of War range too! Advert on telly last night.

Grim... · **Posted:** Wed Nov 28, 2012 17:05

Craster wrote:

Also he had a red shirt.

And red hair.

Zardoz · **Posted:** Wed Nov 28, 2012 17:06

Dimrill wrote:

Old work colleague also didn't clean his teeth. Ginger lad. Had green teeth. No joke.

Suddenly my brain has taken me back the 10 years since I worked with him. I remember one day him arriving at work and telling us how his (16 year old) girlfriend was pregnant. All I could envisage was his scrunched up cum face while he guffed a green miasma of stench into her face and coughed his yoghurt inside her. Brbbrrrrrr.

Recalled Memory of the Week.

Grim... · **Posted:** Wed Nov 28, 2012 17:07

We need a jingle.

Mr Dave · **Posted:** Wed Nov 28, 2012 17:07

Dimrill wrote:

All I could envisage was his scrunched up cum face while he guffed a green miasma of stench into her face and coughed his yoghurt inside her. Brbbrrrrrr.

You imagine the strangest things.

Zardoz · **Posted:** Wed Nov 28, 2012 17:14

I wonder what she looked like.

In general, not just when he shot his muck.

KovacsC · **Posted:** Wed Nov 28, 2012 17:17

Dimrill wrote:

Old work colleague also didn't clean his teeth. Ginger lad. Had green teeth. No joke.

Suddenly my brain has taken me back the 10 years since I worked with him. I remember one day him arriving at work and telling us how his (16 year old) girlfriend was pregnant. All I could envisage was his scrunched up cum face while he guffed a green miasma of stench into her face and coughed his yoghurt inside her. Brbbrrrrrr.

TheVision · **Posted:** Wed Nov 28, 2012 17:47

Zardoz wrote:

TheVision wrote:

I'm skiving today. I've just bought a MegaBlocks Halo Warthog. Only £7! Bargain.

Cool!

I saw Mecchano are punting a Gears of War range too! Advert on telly last night.

Yeah, I've heard about this. I reckon that all the good franchises had already gone. Lego has Marvel and Harry Potter et al, Megablocks has Halo and all that's left is Meccano. Nice one Gears!

(Still looking forward to seeing some of it in action though)

DavPaz · **Joined:** 27th Jun, 2008 **Posts:** 38659

"Ooh, what have you built out of your new Meccano set, little Timmy?"

"CHAINSAW GUN"

*SCREAMS OF TERROR*

TheVision · **Posted:** Wed Nov 28, 2012 17:53

I've just had a look at the sets and they seem quite nice actually, a bit vehicle heavy though. Gears wasn't about the vehicles was it? It was more about the gay love interest story between Marcus and Dom.

Zardoz · **Posted:** Wed Nov 28, 2012 18:09

TheVision wrote:

I've just had a look at the sets and they seem quite nice actually, a bit vehicle heavy though. Gears wasn't about the vehicles was it? It was more about the gay love interest story between Wullie and Zardoz.

Glory days...

MaliA · **Posted:** Wed Nov 28, 2012 19:05

Trying to get to Bradford for a beer. Trains mostly delayed due to locals fighting the noisy smelly demons. Should have been in pub 40 minutes ago. Could have walked.

Joans · **Joined:** 31st Mar, 2008 **Posts:** 8655

Grim... wrote:

Close, but not quite - it will return 1,000 instances, starting at the 3,000th (so instances 3,000 to 4,000).

Wouldn't that be 1001 instances?

Grim... · **Posted:** Wed Nov 28, 2012 20:12

Hush, you.

Joans · **Joined:** 31st Mar, 2008 **Posts:** 8655

Yessir.

throughsilver · **Joined:** 30th Mar, 2008 **Posts:** 6197

Trooper wrote:

There is a guy who lives in my block of flats, nice enough chap, chinese dude, married with a young child. Seems perfectly normal and pleasant enough.
I always know if he has recently left the flat or come home. How you may wonder?

Because he absolutely reeks of BO, enough that for the next 5-10 minutes of him walking down the stairs, you can still smell it.

How is that possible? How does he not know? How has his wife not said anything?

Maybe she likes the musk.

MaliA wrote:

I've told them that I'm free form tuesday afternoon onwards. might as well have some practive, eh?

Bit more rigid in the morning, then?

metalangel · **Posted:** Wed Nov 28, 2012 21:44

iPads vs laptops today... someone one of my project groups had filmed her assignment (as was required) but didn't know how to get the video off her iPad, or edit it, or upload it to the teacher. She doesn't have a computer, see, just an iPad.

I insisted that I wouldn't get frustrated, that I bet I could do it, just let me try. From plugging the iPad into my laptop to having the finished video edited together, rotated (for some reason it was sideways) and saved back onto her USB stick to be handed in was about ten minutes.

TheFireFaerie · **Joined:** 1st Jul, 2012 **Posts:** 1609

Curiosity wrote:

At least you remembered the commit statement. Someone left it off a command on one of our databases and it broke the whole damn thing. Or something.

Was it you?

Curiosity · **Posted:** Wed Nov 28, 2012 23:44

TheFireFaerie wrote:

Curiosity wrote:

At least you remembered the commit statement. Someone left it off a command on one of our databases and it broke the whole damn thing. Or something.

Was it you?

I'm a risk manager, not a code monkey!

Cras · **Joined:** 30th Mar, 2008 **Posts:** 49244

Like he'd be allowed anywhere near things that actually do stuff.

Curiosity · **Posted:** Wed Nov 28, 2012 23:51

Craster wrote:

Like he'd be allowed anywhere near things that actually do stuff.

I could kill you.

I'll put strychnine in the guacamole.

Grim... · **Posted:** Thu Nov 29, 2012 8:34

Bonusingly, I'd be fine

DavPaz · **Joined:** 27th Jun, 2008 **Posts:** 38659

You don't like guacamole?

Cras · **Joined:** 30th Mar, 2008 **Posts:** 49244

I know, right? Freak.

MaliA · **Posted:** Thu Nov 29, 2012 9:34

DavPaz wrote:

You don't like guacamole?

He's a dwarf.

MrChris · **Joined:** 1st Apr, 2008 **Posts:** 30498

Guacamole looks, smells and tastes like a vegetarian's vomit.

Cras · **Joined:** 30th Mar, 2008 **Posts:** 49244

You're dead to me. Again.

Dimrill · **Posted:** Thu Nov 29, 2012 9:45

Mr Kissyfur wrote:

Guacamole looks, smells and tastes like a vegetarian's vomit.

MrChris · **Joined:** 1st Apr, 2008 **Posts:** 30498

Is it Dimrill?

MrChris · **Joined:** 1st Apr, 2008 **Posts:** 30498

I can say this with some authority as I'm married to one, btw.

A vegetarian, I mean, not a guacamole.

Be Excellent To Each Other

Bits and Bobs 37
Poor form Vision...

Who is online

Be Excellent To Each Other

Bits and Bobs 37 Poor form Vision...

Who is online

Bits and Bobs 37
Poor form Vision...