| bluebomber | So, Florida LoCo, what's up? | 13:48 |
|---|---|---|
| bluebomber | What kind of ideas do we have for Software Freedom Day, 11.10 launch, anything else...? | 13:49 |
| bluebomber | Or are we going to discuss some of the above the next IRC meeting? | 13:49 |
| mhall119 | hey bluebomber | 13:54 |
| bluebomber | Hey, mhall119 | 13:54 |
| mhall119 | bluebomber: you can add those as items to discuss in the next meetin | 13:54 |
| munz | morning all :) | 13:55 |
| munz | sorry been soooo busy lately | 13:55 |
| mhall119 | bluebomber: http://loco.ubuntu.com/meetings/ubuntu-us-florida/193/detail/ | 13:55 |
| mhall119 | log in and you should be able to add agenda items | 13:55 |
| bluebomber | I thought I could add those, too, seeing as it's a wiki, but kept overlooking the incredibly-easy-to-overlook login button at the top left. | 13:55 |
| mhall119 | it's not a wiki | 13:56 |
| bluebomber | Ahh, you're right, but I always click over to it from https://wiki.ubuntu.com/FloridaTeam | 14:00 |
| bluebomber | Anyway, agenda items added. | 14:00 |
| mhall119 | awesome | 14:13 |
| DammitJim | hey guys | 15:17 |
| jamalta | hey | 15:17 |
| DammitJim | hey jamalta maybe you can help me... totally off topic, though | 15:18 |
| jamalta | what's up? | 15:18 |
| DammitJim | are you familiar with SQL stuff? | 15:18 |
| jamalta | yeah | 15:18 |
| jamalta | well, depends | 15:18 |
| DammitJim | so, I have a table that holds something like this: | 15:18 |
| DammitJim | http://pastebin.com/e9CViUqp | 15:20 |
| DammitJim | and I want it either SQL or another program to return what's under the +++++s | 15:20 |
| DammitJim | what's more effective? to use SQL or something else like awk? | 15:21 |
| DammitJim | of course, there are 800 locations and about 40 channels | 15:21 |
| DammitJim | I think they call this pivoting or something like that | 15:21 |
| jamalta | you can do that with sql | 15:23 |
| jamalta | i have no clue how you would do it with awk though | 15:23 |
| DammitJim | oh really? I can do this in sql? | 15:24 |
| DammitJim | I'm using mysql | 15:24 |
| jamalta | there's a simple way | 15:24 |
| jamalta | which would be to query the locations and then loop through them and query for the person for each channel | 15:24 |
| jamalta | and then i'm sure there's a way to do it with a group by which i would need to create the table to make sure i did right, since i'm a bit rusty with that | 15:24 |
| DammitJim | hhhmmmm... I guess that's the piece where I don't know how to approach... the looping piece. Sounds like I'd need a procedure? | 15:25 |
| jamalta | although, it might just require sub-queries | 15:25 |
| jamalta | You're accessing the DB directly? | 15:25 |
| DammitJim | do you know what this is called? what I want to do... so I can search online? | 15:25 |
| DammitJim | yes | 15:25 |
| jamalta | Ohh | 15:25 |
| jamalta | So it's not an application you're building? You just want to pull the data? | 15:26 |
| DammitJim | well, I have flexibility to make it an app | 15:26 |
| DammitJim | I was just trying to figure out what gets done in SQL and what gets done in the application layer | 15:26 |
| DammitJim | I'll have scripts that run automatically to do all this stuff | 15:27 |
| jamalta | I mean, something like this _might_ work but I haven't tested it | 15:28 |
| jamalta | SELECT Location, (SELECT Owner FROM Table WHERE Channel = 1 AND Location = ParentTable.Location) AS Channel1, (SELECT Owner FROM Table WHERE Channel = 2 AND Location = ParentTable.Location) AS Channel2 FROM Table as ParentTable | 15:28 |
| jamalta | Oh, add a Group by in there | 15:28 |
| jamalta | GROUP BY Location | 15:28 |
| DammitJim | oh ok, but at the end of the day, I have to hard code the channel column, don't I? | 15:29 |
| jamalta | Yep, that's why I wouldn't do it that way | 15:29 |
| DammitJim | lol | 15:29 |
| jamalta | Instead, I would have a Locations table, a Channels table and then a user/owner table | 15:29 |
| jamalta | Then a table that joins all 3 | 15:29 |
| DammitJim | no biggie... the channels aren't going to change | 15:29 |
| DammitJim | oh, I have the locations table and the channels table already | 15:29 |
| jamalta | Does an owner have it's own table? | 15:30 |
| jamalta | Or do you only ever need a name / username? | 15:30 |
| jamalta | If you have an owner table then you just want a table that has owner_id, location_id, channel_id | 15:30 |
| DammitJim | the table example I pastebin'd is derived from other tables so yeah, the owner has it's own table at the beginning | 15:31 |
| jamalta | Ah | 15:31 |
| DammitJim | yup, that makes sens | 15:31 |
| DammitJim | e | 15:31 |
| DammitJim | but I still don't get how to do the pivoting | 15:31 |
| jamalta | So what you want is a list of locations with each channel, right? | 15:31 |
| DammitJim | I want to see a matrix of locations vs channels with the owners in the corresponding cells | 15:32 |
| DammitJim | it's like a report, ya know? | 15:32 |
| jamalta | and a location always has an entry for every channel? | 15:33 |
| jamalta | well, that doesn't matter really | 15:33 |
| DammitJim | jamalta, I'll check with you later, if this is distracting, I'm sorry | 15:33 |
| DammitJim | I have to run an errand and I'll be back later if you have any other ideas | 15:34 |
| DammitJim | I just wanted some pointers so I could google what I need to do, but I don't even know what to call it LOL | 15:34 |
| jamalta | well, i don't know if there's a term for this but it's just getting data and printing it | 15:35 |
| jamalta | i would do it outside the sql level though | 15:35 |
| jamalta | for example | 15:35 |
| jamalta | here's some pseudo-code on how i would go about it | 15:35 |
| jamalta | http://pastebin.com/CaTvRwDQ | 15:35 |
| jamalta | the {} in the query is how i was referring to data coming from the script and not the DB | 15:35 |
| jamalta | so {channel.id} is coming from the channel that's being looped on | 15:35 |
| jamalta | etc. | 15:35 |
| jamalta | OwnerChannel is what I called the table that joins Owner, Channel and Location | 15:36 |
| jamalta | brb | 15:36 |
| jamalta | back | 15:40 |
| jamalta | global jam is at 9:45am? | 17:31 |
| DammitJim | thanks jamalta | 17:35 |
| jamalta | ah, np! | 17:35 |
| jamalta | hopefully it was helpful, rather than confusing :\ | 17:35 |
| DammitJim | it's a different approach | 17:35 |
| DammitJim | I've been reading on http://www.artfulsoftware.com/infotree/queries.php#78 | 17:35 |
| jamalta | Ahh | 17:36 |
| jamalta | That's all SQL then :) | 17:36 |
| DammitJim | yeah, but again, I've just been trying to figure out if I should do it all in SQL or part sql and part application | 17:37 |
| DammitJim | so, I guess there are many approaches to this problem and you did it with one | 17:37 |
| cjohnston | jamalta: my house tomorrow.. can you come? | 18:40 |
| jamalta | cjohnston: ohh, the loco site has something in lakeland listed | 18:40 |
| jamalta | what itme? | 18:40 |
| jamalta | time* | 18:40 |
| jamalta | and where? | 18:40 |
| jamalta | rather, where is your house? :) | 18:40 |
| cjohnston | ya.. we changed it.. but i didnt put up my address | 18:41 |
| cjohnston | pine hills | 18:41 |
| jamalta | ah, alright | 18:41 |
| cjohnston | during the day | 18:41 |
| jamalta | ah alright, down by colonial? | 18:41 |
| jamalta | (down considering i'm in sanford) | 18:41 |
| cjohnston | statik: ping | 18:42 |
| cjohnston | jamalta: pm | 18:42 |
| statik | hi there cjohnston | 18:45 |
| jamalta | statik: he just left, i sent you a pm | 18:47 |
| jck77 | hello | 18:49 |
| jck77 | is anybody from the broward or dade county? | 18:49 |
| mhall119 | I think jcastro is close now | 19:14 |
| mhall119 | some others too, I don't remember which though | 19:15 |
| mhall119 | reya, but he's offline | 19:15 |
| jck77 | umm ok | 19:19 |
| jck77 | I would like to participate in a meeting or software release party down here | 19:20 |
| jcastro | I am in Boca | 19:27 |
| jcastro | but I thought I was all by myself! | 19:27 |
| itnet7 | jcastro: there are close to 10 Florida Team members that live within an hour south of you, You're about 2 hours 10 Min. south from me | 19:32 |
| itnet7 | zus also lives closer to you and jck77 | 19:33 |
| jamalta | is ubuntu-us-fl@lists.ubuntu.com the right address for our mailing list? | 19:33 |
| itnet7 | jamalta: yes, but you're no longer subscribed | 19:33 |
| itnet7 | I just let it through | 19:33 |
| jamalta | oh :( | 19:33 |
| jamalta | oh thanks! | 19:33 |
| itnet7 | I can try and add that address you used for ya | 19:34 |
| itnet7 | but I moderated it using listadmin | 19:34 |
| jamalta | that'd be great! :) | 19:34 |
| itnet7 | cool | 19:34 |
| jamalta | is anything else going on for the jam this weekend? | 19:35 |
| itnet7 | Not sure, I was planning to get a group together up here, but haven't had time to plan it | 19:35 |
| jamalta | Ah, alright | 19:36 |
| jcastro | jck77: we should get beer. | 19:37 |
| jcastro | oops, I mean "jam this weekend". | 19:38 |
| bluebomber_satel | Would someone provide me cjohnston's address for the event tomorrow, please? | 19:38 |
| bluebomber_satel | He appears away. | 19:38 |
| bluebomber_satel | Thanks, everyone. I guess there's nothing like asking for a physical address to silence an IRC chat. | 19:55 |
| itnet7 | bluebomber_satel: lol | 19:56 |
| itnet7 | I don't have it, otherwise I'd PM you | 19:56 |
| itnet7 | bluebomber_satel: you have off from school tomorrow? | 19:56 |
| bluebomber_satel | itnet7: I might be able to make it for a couple hours. I'm a grad student => Few classes. | 20:04 |
| itnet7 | bluebomber_satel: cool! I was going to try and swing by, but I found out I have to work tomorrow for coverage | 20:07 |
| itnet7 | Hope everyone has some fun! | 20:07 |
| bluebomber_satel | itnet7: Thanks, I'll have some extra fun on your behalf if I make it and you don't. | 20:14 |
| bluebomber_satel | How have you been? | 20:14 |
| itnet7 | +1 | 20:14 |
| itnet7 | I have been pretty good, and you? | 20:14 |
| bluebomber_satel | Fine, thanks, busy. | 20:27 |
| bluebomber_satel | Kindasorta | 20:27 |
| bluebomber_satel | We had an amazing time in Portland. | 20:27 |
| bluebomber_satel | I loved that city so much, I'm seriously considering moving out there. I hear a lot of good things about the pacific northwest in general. | 20:27 |
| itnet7 | Oh, you went there for Linuxcon? | 20:27 |
| itnet7 | I'll bet it was awesome! | 20:28 |
| jck77 | hey itnet7 | 20:30 |
| jck77 | jcastro: I live in fort Lauderdale, well is almost Davie cuz is close to i95 and 595 | 20:31 |
| jck77 | jcastro: I dont know my plans for this weekend, my mother in law is in town and that sucks | 20:32 |
| jck77 | lol | 20:32 |
| bluebomber_satel | Not Linuxcon (I wish). For IEEENano. | 20:38 |
| itnet7 | Ah! | 20:39 |
| bluebomber_satel | Well, should I email cjohnston? | 20:39 |
| itnet7 | jamalta: If you get a chance, can you PM bluebomber_satel the address please | 20:39 |
| itnet7 | for the Community Web Jam tomorrow | 20:39 |
| mhall119 | jamalta: are you going to be at the jam tomorrow? | 20:44 |
| mhall119 | itnet7: should check with cjohnston before sending out his address | 20:44 |
| itnet7 | mhall119: thanks | 20:45 |
| jamalta | mhall119: yeah :) | 20:46 |
| jamalta | although i'll be working and won't be able to participate on the jam too much | 20:46 |
| jamalta | oh, bluebomber left.. i guess he can get it when he comes back. | 20:47 |
| mhall119 | jamalta: are you still with flickr? | 20:49 |
| jamalta | mhall119: yeah | 20:50 |
| mhall119 | working remote now or something? | 20:52 |
| jamalta | sorry keep going away from irc and not checking back | 20:56 |
| jamalta | yeah, i'm working remotely now | 20:56 |
| mhall119 | cool | 21:00 |
| === nosoynadie is now known as jck77 | ||
Generated by irclog2html.py 2.7 by Marius Gedminas - find it at mg.pov.lt!