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