| --- Log opened Tue May 23 00:00:18 2017 |
| 00:38 | <~Vornicus> | Things that I have done today that I didn't think I'd ever do: help someone with programming in spanish. |
| 00:38 | <&McMartin> | The help or the program? |
| 00:38 | <~Vornicus> | The help. Also all the homemade variable names. |
| 00:40 | <~Vornicus> | It is kind of jarring to write code with english keywords and standard library calls but spanish variables and custom function names. |
| 00:41 | <&McMartin> | What verb inflection is used in function names? |
| 00:44 | <~Vornicus> | The only one I've seen - most of the functions have been to an english-language spec - is a bool one, "esAnagrama", which may not be very representative. |
| 00:47 | <&McMartin> | Yeah, that wasn't what I was asking about |
| 00:47 | <&McMartin> | I was intending to ask whether doStuff() is in the infinitive, imperative, third-person-singular-indicative, or wha |
| 00:47 | <&McMartin> | esAnagrama, like the English equivalent, is clearly using its argument as a subject |
| 00:47 | <~Vornicus> | Yeah. |
| 00:48 | <~Vornicus> | I'll ask next time |
| 00:49 | <~Vornicus> | actually apparently there's now stackoverflow en espanol now |
| 00:49 | | himi-cat [sjjf@Nightstar-dm0.2ni.203.150.IP] has joined #code |
| 00:49 | | mode/#code [+o himi-cat] by ChanServ |
| 01:37 | | Derakon[AFK] is now known as Derakon |
| 01:58 | | Reiv [NSkiwiirc@Nightstar-ih0uis.global-gateway.net.nz] has quit [[NS] Quit: http://www.kiwiirc.com/ - A hand crafted IRC client] |
| 02:01 | | Reiv [NSkiwiirc@Nightstar-ih0uis.global-gateway.net.nz] has joined #code |
| 02:01 | | mode/#code [+o Reiv] by ChanServ |
| 02:37 | | Reiv [NSkiwiirc@Nightstar-ih0uis.global-gateway.net.nz] has quit [Ping timeout: 121 seconds] |
| 03:26 | | mac [macdjord@Nightstar-a1fj2k.mc.videotron.ca] has joined #code |
| 03:26 | | mode/#code [+o mac] by ChanServ |
| 03:29 | | macdjord [macdjord@Nightstar-a1fj2k.mc.videotron.ca] has quit [Ping timeout: 121 seconds] |
| 03:52 | | Turaiel is now known as Turaiel[Offline] |
| 04:59 | | Derakon is now known as Derakon[AFK] |
| 05:15 | | celticminstrel is now known as celmin|sleep |
| 05:38 | | mac is now known as macdjord |
| 05:50 | | Reiv [NSkiwiirc@Nightstar-ih0uis.global-gateway.net.nz] has joined #code |
| 05:50 | | mode/#code [+o Reiv] by ChanServ |
| 07:36 | | himi-cat [sjjf@Nightstar-dm0.2ni.203.150.IP] has quit [The TLS connection was non-properly terminated.] |
| 07:37 | <~Vornicus> | uch. reeeiiiiiv, need sql help |
| 07:41 | <~Vornicus> | I have users, item slots, item placements, inventory items, and generic items. inventory items are the mapping between users and generic items (and also have other data); item placements are mapping between slots and inventory items (and also have other data). |
| 07:45 | <~Vornicus> | I have a query that fills out all the required data for each placement - data about the slot, placement, inventory item, and generic item, along with the user ID. What I *want* is a query that gives nulls for placements that don't exist. |
| 07:48 | <~Vornicus> | Which is to say, for each slot-user combo that doesn't exist as a placement, I want a row. |
| 07:51 | | * McMartin eyes KDE |
| 07:52 | <~Vornicus> | Also, I should actually use your name. |
| 07:52 | <~Vornicus> | Reiv! |
| 07:53 | <&McMartin> | (I seem to be getting my GUI assigned to random ttys.) |
| 07:58 | | Jessikat [Jessikat@Nightstar-ofsu3t.dab.02.net] has joined #code |
| 07:58 | | McMartin [mcmartin@Nightstar-rpcdbf.sntcca.sbcglobal.net] has quit [[NS] Quit: brb] |
| 08:01 | | McMartin [mcmartin@Nightstar-rpcdbf.sntcca.sbcglobal.net] has joined #code |
| 08:01 | | mode/#code [+ao McMartin McMartin] by ChanServ |
| 08:03 | | * Vornicus gets what he think should work, but it's actually a syntax error! |
| 08:10 | | Netsplit Deepthought.Nightstar.Net <-> Krikkit.Nightstar.Net quits: @PinkFreud |
| 08:25 | <&McMartin> | Zorp |
| 08:25 | | RchrdB [RchrdB@Nightstar-qe9.aug.187.81.IP] has quit [Ping timeout: 121 seconds] |
| 08:30 | <~Vornicus> | Unpleasant. |
| 08:33 | <~Vornicus> | Got it. |
| 08:33 | <@macdjord> | Vornicus: I beleive an outer join is what you want. I can't be more specific without seeing table definitions. |
| 08:33 | <~Vornicus> | I was putting the on clause in the wrong place. |
| 08:34 | | macdjord is now known as macdjord|slep |
| 08:34 | <~Vornicus> | (users join slots) left join (placement join inventory on inventory_id join item on item_id) on placement_id |
| 08:34 | <~Vornicus> | only more verbose in the real thing |
| 08:34 | | Kindamoody[zZz] is now known as Kindamoody |
| 08:35 | <&[R]> | There's also implicit joins (which IIRC are effectively left joins) |
| 08:36 | <~Vornicus> | anyway that figured out, slep |
| 08:37 | <&[R]> | Night |
| 08:42 | | Vornicus [Vorn@ServerAdministrator.Nightstar.Net] has quit [Ping timeout: 121 seconds] |
| 08:58 | | Kindamoody is now known as Kindamoody|afk |
| 09:04 | | PinkFreud [WhyNot@NetworkAdministrator.Nightstar.Net] has joined #code |
| 09:04 | | ServerMode/#code [+o PinkFreud] by *.Nightstar.Net |
| 09:06 | | Netsplit Traal.Nightstar.Net <-> Krikkit.Nightstar.Net quits: @PinkFreud |
| 09:11 | | Netsplit over, joins: @PinkFreud |
| 09:31 | | Netsplit Traal.Nightstar.Net <-> Krikkit.Nightstar.Net quits: @PinkFreud |
| 09:32 | | Netsplit over, joins: @PinkFreud |
| 09:54 | | himi [sjjf@Nightstar-v37cpe.internode.on.net] has joined #code |
| 09:54 | | mode/#code [+o himi] by ChanServ |
| 09:58 | <&Reiver> | Vornicus: I am terribly sorry, I had been eaten by Consultants(tm) |
| 09:58 | <&Reiver> | A terrible fate if there ever was one ( |
| 09:58 | <&Reiver> | :( |
| 10:01 | <&Reiver> | SELECT * FROM slots LEFT JOIN placements ON slots.foo = placements.bar WHERE placements.bar IS NULL |
| 10:02 | <&Reiver> | Left joins return everything on the left (ie, non-left-joined) table(s), and then try to match data from the right (left-joined) table. You've matched on a key. |
| 10:02 | <&Reiver> | So where there is no key existing in the joined table... you have an empty data row. |
| 10:03 | <&Reiver> | Apply extra stuff to the WHERE clause and joins as appropriate, just be careful of your nulls theory: Placing a restriction of 'only show up if BAZ is true' on the left-joined table will turn the thing into an inner join by accident. |
| 10:03 | | himi [sjjf@Nightstar-v37cpe.internode.on.net] has quit [Ping timeout: 121 seconds] |
| 10:03 | <&Reiver> | If someone would be so kind to paste that to Vorn when he awakes, I would be much obliged. |
| 10:04 | <@TheWatcher> | I shall do so |
| 10:26 | | himi [sjjf@Nightstar-v37cpe.internode.on.net] has joined #code |
| 10:26 | | mode/#code [+o himi] by ChanServ |
| 10:33 | | Netsplit Deepthought.Nightstar.Net <-> Krikkit.Nightstar.Net quits: @PinkFreud |
| 10:34 | | Netsplit over, joins: @PinkFreud |
| 10:36 | | Netsplit Traal.Nightstar.Net <-> Krikkit.Nightstar.Net quits: @PinkFreud |
| 10:39 | | himi [sjjf@Nightstar-v37cpe.internode.on.net] has quit [Ping timeout: 121 seconds] |
| 10:43 | | PinkFreud [WhyNot@NetworkAdministrator.Nightstar.Net] has joined #code |
| 10:43 | | ServerMode/#code [+o PinkFreud] by *.Nightstar.Net |
| 10:44 | | himi [sjjf@Nightstar-v37cpe.internode.on.net] has joined #code |
| 10:45 | | Netsplit Deepthought.Nightstar.Net <-> Krikkit.Nightstar.Net quits: @PinkFreud |
| 10:53 | | PinkFreud [WhyNot@NetworkAdministrator.Nightstar.Net] has joined #code |
| 10:53 | | ServerMode/#code [+o PinkFreud] by *.Nightstar.Net |
| 12:05 | | Netsplit Deepthought.Nightstar.Net <-> Krikkit.Nightstar.Net quits: @PinkFreud |
| 12:10 | | Jessikat` [Jessikat@Nightstar-in7la7.dab.02.net] has joined #code |
| 12:14 | | Jessikat [Jessikat@Nightstar-ofsu3t.dab.02.net] has quit [Ping timeout: 121 seconds] |
| 12:20 | | PinkFreud [WhyNot@NetworkAdministrator.Nightstar.Net] has joined #code |
| 12:20 | | ServerMode/#code [+o PinkFreud] by *.Nightstar.Net |
| 12:21 | | Netsplit Traal.Nightstar.Net <-> Krikkit.Nightstar.Net quits: @PinkFreud |
| 12:25 | | PinkFreud [WhyNot@NetworkAdministrator.Nightstar.Net] has joined #code |
| 12:25 | | ServerMode/#code [+o PinkFreud] by *.Nightstar.Net |
| 12:27 | | Netsplit Deepthought.Nightstar.Net <-> Krikkit.Nightstar.Net quits: @PinkFreud |
| 12:28 | | Netsplit over, joins: @PinkFreud |
| 13:24 | | Jessikat` [Jessikat@Nightstar-in7la7.dab.02.net] has quit [The TLS connection was non-properly terminated.] |
| 13:24 | | Jessikat [Jessikat@Nightstar-in7la7.dab.02.net] has joined #code |
| 13:26 | | Jessikat` [Jessikat@Nightstar-in7la7.dab.02.net] has joined #code |
| 13:26 | | Jessikat [Jessikat@Nightstar-in7la7.dab.02.net] has quit [The TLS connection was non-properly terminated.] |
| 13:58 | | Jessikat` [Jessikat@Nightstar-in7la7.dab.02.net] has quit [The TLS connection was non-properly terminated.] |
| 13:59 | | Jessikat [Jessikat@Nightstar-in7la7.dab.02.net] has joined #code |
| 14:07 | | Jessikat [Jessikat@Nightstar-in7la7.dab.02.net] has quit [The TLS connection was non-properly terminated.] |
| 14:08 | | Jessikat` [Jessikat@Nightstar-in7la7.dab.02.net] has joined #code |
| 14:10 | | Jessikat [Jessikat@Nightstar-in7la7.dab.02.net] has joined #code |
| 14:10 | | Jessikat` [Jessikat@Nightstar-in7la7.dab.02.net] has quit [The TLS connection was non-properly terminated.] |
| 14:20 | | Jessikat` [Jessikat@Nightstar-in7la7.dab.02.net] has joined #code |
| 14:20 | | Jessikat [Jessikat@Nightstar-in7la7.dab.02.net] has quit [The TLS connection was non-properly terminated.] |
| 14:30 | | Jessikat` [Jessikat@Nightstar-in7la7.dab.02.net] has quit [Ping timeout: 121 seconds] |
| 14:31 | | Jessikat [Jessikat@Nightstar-in7la7.dab.02.net] has joined #code |
| 14:45 | | * TheWatcher aargh, stabs the fuckiong Swagger tools |
| 14:49 | | Jessikat [Jessikat@Nightstar-in7la7.dab.02.net] has quit [The TLS connection was non-properly terminated.] |
| 14:49 | | Jessikat [Jessikat@Nightstar-in7la7.dab.02.net] has joined #code |
| 14:52 | | Jessikat [Jessikat@Nightstar-in7la7.dab.02.net] has quit [The TLS connection was non-properly terminated.] |
| 14:52 | | Jessikat [Jessikat@Nightstar-in7la7.dab.02.net] has joined #code |
| 14:54 | | Jessikat [Jessikat@Nightstar-in7la7.dab.02.net] has quit [The TLS connection was non-properly terminated.] |
| 14:54 | | Jessikat` [Jessikat@Nightstar-in7la7.dab.02.net] has joined #code |
| 15:12 | | Jessikat [Jessikat@Nightstar-in7la7.dab.02.net] has joined #code |
| 15:13 | | Jessikat` [Jessikat@Nightstar-in7la7.dab.02.net] has quit [The TLS connection was non-properly terminated.] |
| 15:19 | | Jessikat [Jessikat@Nightstar-in7la7.dab.02.net] has quit [Ping timeout: 121 seconds] |
| 17:18 | | mac [macdjord@Nightstar-a1fj2k.mc.videotron.ca] has joined #code |
| 17:18 | | mode/#code [+o mac] by ChanServ |
| 17:21 | | macdjord|slep [macdjord@Nightstar-a1fj2k.mc.videotron.ca] has quit [Ping timeout: 121 seconds] |
| 17:29 | | Vorntastic [Vorn@Nightstar-uhn82m.ct.comcast.net] has joined #code |
| 17:33 | <@Azash> | Vorntastic: http://paste.debian.net/plainh/7bedda2d |
| 17:35 | < Vorntastic> | Thank you sir. Though I solved it, I was not correctly moving clauses. |
| 17:42 | | RchrdB [RchrdB@Nightstar-qe9.aug.187.81.IP] has joined #code |
| 18:09 | | Vornicus [Vorn@ServerAdministrator.Nightstar.Net] has joined #code |
| 18:09 | | mode/#code [+qo Vornicus Vornicus] by ChanServ |
| 18:10 | | Vorntastic [Vorn@Nightstar-uhn82m.ct.comcast.net] has quit [[NS] Quit: Bye] |
| 19:04 | <&[R]> | Huzzah! |
| 19:05 | <&[R]> | Found out why my ALFS builds were stopping |
| 19:05 | <&[R]> | Disk was full. |
| 19:05 | < RchrdB> | ouch |
| 19:31 | | RchrdB [RchrdB@Nightstar-qe9.aug.187.81.IP] has quit [Connection closed] |
| 19:49 | <&McMartin> | DOOM |
| 19:49 | <@Tamber> | d00m? |
| 19:49 | <&McMartin> | YAY DOOM |
| 19:49 | | * McMartin sings the doom song |
| 19:50 | <&McMartin> | Also this doesn't seem to have been linked in here, so: |
| 19:50 | <&McMartin> | https://stackoverflow.blog/2017/05/23/stack-overflow-helping-one-million-develop ers-exit-vim/ |
| 19:51 | <@Tamber> | hehe |
| 20:21 | | mac is now known as macdjord|gaming |
| 20:45 | | RchrdB [RchrdB@Nightstar-qe9.aug.187.81.IP] has joined #code |
| 20:59 | | Jessikat [Jessikat@Nightstar-slh6uh.dab.02.net] has joined #code |
| 21:16 | | Kindamoody|afk is now known as Kindamoody |
| 21:19 | <@Azash> | [R]: Reminds me of an Excellent(tm) situation at $CLIENT yesterday |
| 21:19 | <@Azash> | "Well, normally we have to clear out all the test results once or twice a day because we're running out of space, but good news! Our new HDDs have arrive" |
| 21:20 | <@Azash> | "We're installing them now, syncing the data will probably take 10-12 hours though and we need to disable the pipeline meanwhile" |
| 21:20 | <@Azash> | So, nobody got anything done all day |
| 21:20 | <@Azash> | Very cheap HDDs, in other words |
| 21:35 | | Alek [Alek@Nightstar-7or629.il.comcast.net] has quit [[NS] Quit: bbl] |
| 21:36 | <&[R]> | You had a bunch of the drives DIA? |
| 22:01 | <@Azash> | [R]: No, just being installed (I have no idea what they actually were doing) |
| 22:03 | | Alek [Alek@Nightstar-7or629.il.comcast.net] has joined #code |
| 22:03 | | mode/#code [+o Alek] by ChanServ |
| 22:05 | <&[R]> | The "Very cheap HDDs" line confuses me then. I don't understand the purpose of it in context. |
| 22:05 | <&[R]> | It just seems random and out of place (though on subject) |
| 22:08 | <@Azash> | Referring to how they had the alternate cost of something like 900-950 man hours |
| 22:18 | | macdjord|gaming is now known as macdjord |
| 22:20 | | mac [macdjord@Nightstar-a1fj2k.mc.videotron.ca] has joined #code |
| 22:20 | | mode/#code [+o mac] by ChanServ |
| 22:23 | | macdjord [macdjord@Nightstar-a1fj2k.mc.videotron.ca] has quit [Ping timeout: 121 seconds] |
| 22:27 | | RchrdB [RchrdB@Nightstar-qe9.aug.187.81.IP] has quit [Ping timeout: 121 seconds] |
| 22:31 | <@Reiv> | Vornicus! |
| 22:31 | <@Reiv> | Did you get my message! |
| 22:31 | <@Reiv> | Or do I need to pastie |
| 22:32 | <~Vornicus> | I got it |
| 22:32 | <@Reiv> | Have you any commentary or queries |
| 22:32 | <~Vornicus> | but by the time I had gotten it I had in fact figured out what the hell I was doing wrong |
| 22:32 | <@Reiv> | ahahaha, oh well, sorry dude |
| 22:32 | <~Vornicus> | Which was primarily "I had the on in the wrong place" |
| 22:32 | <@Reiv> | I've been getting Consultant'd recently :/ |
| 22:54 | | himi [sjjf@Nightstar-v37cpe.internode.on.net] has quit [Ping timeout: 121 seconds] |
| 22:59 | | Kindamoody is now known as Kindamoody[zZz] |
| 23:02 | | mac is now known as macdjord|fude |
| 23:21 | < Mahal> | I have a question. |
| 23:21 | < Mahal> | *why* are some powershell modules designed SO BLOODY BADLY |
| 23:21 | < ToxicFrog> | Go for it |
| 23:21 | < ToxicFrog> | oh |
| 23:21 | < ToxicFrog> | I have no idea, but if I were to guess it would be "MS has, collectively, effectively no experience with shell scripting" |
| 23:22 | < Mahal> | the only way to capture all my warnings AND errors from a script to a log file is thus: |
| 23:22 | < Mahal> | .\ComplicatedScriptINeedLoggingFor.ps1 *>&1 | tee -filepath C:\temp\MyLogFileForSaidScript.txt |
| 23:23 | < Mahal> | instead of, say, commandlets actually understanding the concept of "not everyone sits over the console all the time and is able to read the errors as they go past" |
| 23:23 | < Mahal> | entirely aside from this being a TERRIBAD MESSAGE, MICROSOFT |
| 23:23 | < Mahal> | "Set-MsolUserLicense : Unable to assign this license because it is invalid. Use the Get-MsolAccountSku cmdlet to retrieve a list of valid licenses." actually means "this user already has a valid license, so you didn't need to do this" |
| 23:24 | < Mahal> | SERIOUSLY |
| 23:24 | < Mahal> | how about you try what you do with a shitload of OTHER commandlets liek |
| 23:24 | < Mahal> | Object with identity "blerpblerp" was not changed. |
| 23:24 | | * Mahal flails. |
| 23:25 | < ToxicFrog> | That looks pretty similar to how it would look in bash |
| 23:25 | < ToxicFrog> | foo 2>&1 | tee path/to/logfile |
| 23:28 | < Mahal> | I object to the fact that I can't do this /inside my actual powershell script/ though. |
| 23:28 | < Mahal> | so now I have to wrap a ps1 inside a .bat in order to automagically schedule this bullshit. |
| 23:28 | < ToxicFrog> | wait, you can't? |
| 23:28 | < Mahal> | well |
| 23:28 | < Mahal> | warnings & errors aren't the same thing, which is fine |
| 23:29 | < Mahal> | but structures like try {} catch {} are only for errors |
| 23:29 | < Mahal> | and I need to capture warnings too |
| 23:29 | < Mahal> | and I can write-warning but it goes a bit pearshaped if I'm using try-catch on errors |
| 23:29 | < Mahal> | and just |
| 23:29 | < Mahal> | .\ComplicatedScriptINeedLoggingFor.ps1 *>&1 | tee -filepath C:\temp\MyLogFileForSaidScript.txt |
| 23:30 | < ToxicFrog> | Right but I mean |
| 23:31 | < ToxicFrog> | In every shell I've used, the verbs for IO redirection available on the command line are also available in noninteractive scripts |
| 23:31 | < ToxicFrog> | But in powershell they aren't? |
| 23:31 | <&McMartin> | Right, hence the .bat? |
| 23:31 | <&McMartin> | I believe the issue is with the scheduling here, which, um, my metaphors are failing... |
| 23:31 | < Mahal> | If I'm understanding this correctly |
| 23:31 | <&McMartin> | ... but I think is that there's no windows equivalent of "shell=true" for subprocess |
| 23:31 | < Mahal> | and to be fair, I may not be, because I am vastly underskilled in the code arena |
| 23:32 | < Mahal> | all the ps1 is doing is calling commandlets. the commandlets know how to spit out errors and/or warnings, but explicitly are not designed to care about where they're sending them, that's the job of "powershell" to manage? |
| 23:33 | < Mahal> | and if I'm not running something in a console I'm watching, then when I call the overall script I have to tell it where to send that output? |
| 23:33 | < Mahal> | I think? |
| 23:33 | < Mahal> | instead of being able to tell a commandlet "do this thing and then log the results Here" |
| 23:33 | <&McMartin> | Yeah, there's two places PowerShell and Bash don't match up, I think... |
| 23:33 | <&McMartin> | ... and one of them is commandlets, which I have to admit I don't fully understand |
| 23:34 | <&McMartin> | Other than that they are treated as modules and not as, um, weird scripts in their own right, which is how bash treats binary executables |
| 23:35 | <&McMartin> | And so the other possible point of mismatch is that while TF's statement about cmdline vs noninteractive is true for shell scripts... |
| 23:35 | <&McMartin> | ... it's not true for a straight-up fork()/exec() |
| 23:35 | < Mahal> | (I have spent quite a lot of the last two days trying to figure out how to google the question I want to ask) |
| 23:35 | < Mahal> | (I have eventually got there.) |
| 23:36 | <&McMartin> | So the exact details of what Windows is doing when you schedule stuff automatically matters here too, and if it *is* that, the UNIX solution is the one you're using "put the call with appropriate plumbing into a shell script, and invoke that script by execcing the interpreter" |
| 23:36 | < Mahal> | Most of what I've learned is only loosely relevant to my current script (an abomination to apply o365 licensing and Skype Unified Messaging setup to users pre-o365 migrations) |
| 23:36 | <&McMartin> | Needs more punctuation, but |
| 23:36 | < Mahal> | but at least I know for next time |
| 23:36 | < Mahal> | (err... is it normal to keep a folder of Random Text Files that contain snippets to re-use next time you're doing a thing?) |
| 23:37 | <&McMartin> | (Yes) |
| 23:37 | < Mahal> | (oh good) |
| 23:38 | <&McMartin> | (My ~/devel directory is now like 5 gigs) |
| 23:39 | <&McMartin> | (Granted, most of that is the git repository that holds all the media editions of UQM's content archives) |
| 23:40 | <@TheWatcher> | Mahal: bonus points if half of them are called 'fooX'~ |
| 23:41 | | * Mahal bleh. |
| 23:42 | < Mahal> | 10:41am and today all I've done is figure out how to log the output of a script to a file |
| 23:42 | < ToxicFrog> | Mahal: I tend to hoist those into tools/libraries in their own right, but yes |
| 23:42 | | * Mahal is a server monkey trying to learn enough powershell to automate things instead of GUI them, is the thing |
| 23:42 | | * Mahal is not a programmer. |
| --- Log closed Wed May 24 00:00:19 2017 |