Wednesday, 2017-02-08

*** diablo_rojo has quit IRC00:46
*** yarkot has quit IRC01:10
*** zara_the_lemur__ has quit IRC04:55
*** fay has joined #storyboard08:29
*** fay is now known as Guest6469308:30
*** openstackgerrit has quit IRC09:34
*** pedroalvarez_ has joined #storyboard09:39
*** pleia2_ has joined #storyboard09:40
*** SotK_ has joined #storyboard09:41
*** pleia2 has quit IRC09:45
*** jtomasek has quit IRC09:45
*** dmsimard has quit IRC09:45
*** SotK has quit IRC09:45
*** pedroalvarez has quit IRC09:45
*** dmsimard has joined #storyboard09:51
*** jtomasek has joined #storyboard09:52
Zaramorning, storyboard!10:25
SotK_morning!10:26
SotK_oh I grew a tail10:26
*** SotK_ is now known as SotK10:26
ZaraI must be tired; I thought you meant irl for a second10:27
ZaraI was like 'huh, he's calm about that'10:27
Zara'does it happen often?'10:27
Zarathen I remembered that people don't normally grow tails10:28
Zaraapparently sleepy!me put it in the same bracket as 'I grew a beard'10:29
* persia imagines a special section at the chemists where the daily-use tail snippers are stocked10:33
Zara:D11:48
*** bethwhite has quit IRC11:52
*** bethwhite has joined #storyboard11:54
*** bethwhite has quit IRC11:59
*** bethwhite has joined #storyboard12:13
Zarafinally got it to work12:41
ZaraI needed to cast to an enum12:42
ZaraI thought it was already an enum and the constituent parts wanted casting12:42
Zaraposting a story and tasks works12:42
Zarathis is still with the permissions query commented out12:43
Zaraworklists and boards seem fine12:44
Zarasearch freaks out, but are we really surprised (browses work, though)12:45
Zara`500: GET /api/v1/stories/search: <class 'sqlalchemy_fulltext.FullTextSearch'> construct has no default compilation handler.` is the search error; the use of fulltext there suggests it's mysql-specific to me12:46
SotKyeah, me too12:48
Zara\o\ /o/ ~o~ \o/12:49
SotKhttps://github.com/mengzhuo/sqlalchemy-fulltext-search12:49
SotK"Fulltext search support with MySQL & SQLAlchemy"12:50
Zarayeah, I missed it yesterday because I read sqlalchemy_fulltext as sqlalchemy.fulltext12:50
pedroalvarez_migrations that enable the fulltext indexes will be ignored with non-mysql12:51
pedroalvarez_so, you won't see a failure when running them12:51
Zara(came to it this morning, 'oh. my fix from yesterday is only working by chance.')12:51
Zaraheh12:51
Zaramy current drafty migration for this is: https://review.openstack.org/#/c/430395/1/storyboard/db/migration/alembic_migrations/versions/1f2509a98c77_test_for_postgres.py12:52
*** pleia2_ is now known as pleia212:57
*** openstackgerrit has joined #storyboard13:12
openstackgerritZara proposed openstack-infra/storyboard master: Hacky WIP to provide postgresl support for StoryBoard  https://review.openstack.org/43039513:12
openstackgerritZara proposed openstack-infra/storyboard master: Hacky WIP to provide postgresql support for StoryBoard  https://review.openstack.org/43039513:16
Zaraso, that leaves the permissions bit to sort out13:19
Zara(well and search but I'm ignoring that for now)13:19
SotK\o/13:23
Zaranow I know why you were like 'just comment out the permissions bit for now' xD13:26
SotKyeah13:26
SotKI have no idea how to fix it13:26
Zaramaybe there's a chance there's one thing somewhere in there that needs casting?13:27
Zaraor, if it can't handle the union itself, I guess it's time to search the whole internet13:28
ZaraI wish it was clearer *what* it was failing to convert13:44
SotKthat would certainly make it easier to debug13:45
ZaraI'm wondering if it's interpreting nearly everything as text; the other one gave a clearer indication13:46
* Zara formats logs a bit http://paste.openstack.org/show/598094/13:50
Zara'postgresql hates my whole query' gives me no useful search results14:17
Zaratime for tea.14:17
*** diablo_rojo_phon has joined #storyboard15:27
Zarahm, getting another 500 on the subscriptions page; will fix that and see what happens15:32
fungiSotK: Zara: betherly: i've updated https://wiki.openstack.org/wiki/Meetings/StoryBoard to link to the official schedule of meetings (the time and channel stated in the wiki page were incorrect) and to remove the direct link to the most recent meeting log which nobody had updated since 201515:45
fungijpmaxman: ^ sorry about the confusion!15:46
Zarafungi: oh, thanks!15:46
Zarasorry about that15:46
ZaraI thought I'd updated that recently, maybe it's duplicated (or I imagined it)15:47
fungiit's hard to remember to update things consistently in two places15:47
Zaraaha, yeah, I think it was updated on storyboard's own wiki page15:47
Zararather than meetings/storyboard15:47
SotKoops, sorry for not keeping that up to date15:47
Zara(just glad I wasn't imagining it)15:47
fungiyou might consider linking to the main schedule site from the sb project page too so you don't have to remember to keep updating it if the meeting moves15:48
fungiup to you15:49
Zarayeah, we should do15:50
Zara(though we do; I think it was repeated so it was quicker to find... but that doesn't work when it's out of date)15:51
Zaraupdated, thanks :)15:53
Zarathat whole page is looking a bit unloved.15:53
jpmaxmanhah no worries16:01
jpmaxmanjust trying to become "project aware" ;)16:02
Zarayay! :)16:30
openstackgerritZara proposed openstack-infra/storyboard master: Hacky WIP to provide postgresql support for StoryBoard  https://review.openstack.org/43039516:34
Zara(for anyone who may have missed earlier context, that stuff is a proof-of-concept to demonstrate storyboard plugging into different databases; we don't have any plans to provide serious postgres support upstream, just seemed like the easiest place to start and get familiar with things)16:36
Zara(so it's as much for me to get a clear idea of how the pieces fit together as anything else)16:39
Zarahm...17:02
Zarateam_membership.user_id \nWHERE story_summary.id = %(id_1)s AND (story_summary.private = false OR story_summary.id IS NULL))17:02
Zarathat seems strange17:02
*** Guest64693 has quit IRC17:03
Zaraactually maybe not17:04
Zarait's definitely different to the successful mysql query from the other day; going to look at logs for those again17:07
Zaraoh, those match at that point17:11
*** diablo_rojo has joined #storyboard17:55
*** zara_the_lemur__ has joined #storyboard18:17
*** sparkycollier has quit IRC18:35
*** jpmaxman has quit IRC18:35
*** jamesmcarthur has quit IRC18:35
*** zara_the_lemur__ has quit IRC18:35
*** zaro has quit IRC18:37
*** francoblanco has quit IRC18:45
*** betherly has quit IRC18:45
*** zara_the_lemur__ has joined #storyboard18:49
zara_the_lemur__apparently irccloud is down18:49
zara_the_lemur__for me18:49
zara_the_lemur__so this could be an interesting meeting-chairing experience18:49
zara_the_lemur__reminder that the storyboard meeting is in 3 minutes!18:57
diablo_rojoGood chat19:43
zara_the_lemur__\o/19:44
zara_the_lemur__I was trying to eat a plate of fish and chips at the same time19:45
zara_the_lemur__surprisingly complicated19:45
diablo_rojoI learned that cheesesticks resting on trackpads are enough like a finger to confuse a computer.19:45
diablo_rojofunfact19:45
zara_the_lemur__:D19:45
* SotK was distracted trying to cook food at the same time as having a meeting19:45
zara_the_lemur__every so often I get that with long sleeves19:45
zara_the_lemur__well, not distracted, the trackpad thing19:46
diablo_rojoHa ha ha trackpads are complicated.19:47
zara_the_lemur__:)19:48
diablo_rojozara_the_lemur__, Might be coming to the UK in september for the OSD.19:48
zara_the_lemur__ooh, nice!19:48
zara_the_lemur__hm, the only programme I can find is the 2016 one19:49
zara_the_lemur__oh, though the website also mentions a 2017 one in london19:50
diablo_rojoIts still in its early stages.19:50
diablo_rojoYeah that sounds right.19:51
diablo_rojoI volunteered to do a keynote *shudders*19:51
zara_the_lemur__hahaha19:51
zara_the_lemur__you'll be great!19:51
*** betherly has joined #storyboard19:51
*** jpmaxman has joined #storyboard19:51
*** sparkycollier has joined #storyboard19:51
zara_the_lemur__what are you planning to talk about?19:52
diablo_rojozara_the_lemur__, no idea19:52
diablo_rojojust talked to the organizer about it. Still waiting for confirmation he even wants me to talk.19:53
zara_the_lemur__heh19:54
diablo_rojozara_the_lemur__, yep, should be fun :)19:56
zara_the_lemur__it's good, that way you have lots of freedom!19:56
zara_the_lemur__'fun facts about cheesesticks and trackpads'19:57
zara_the_lemur__that's easily 20mins of content19:57
diablo_rojoLol that would be so good.19:57
diablo_rojoIt'll be the last slide.19:57
zara_the_lemur__would watch19:57
diablo_rojoFIll in whatever time I have left.19:57
diablo_rojoI hope you will watch either way :)19:57
zara_the_lemur__sure, as long as you don't throw cheesesticks into the crowd at the end.19:58
zara_the_lemur__'now take what you've learned with you'19:58
zara_the_lemur__then I might have second thoughts19:58
diablo_rojoHow about I pass a bag around full of cheesticks?20:00
diablo_rojoGo forth and cheesetick20:00
zara_the_lemur__:)20:01
*** francoblanco has joined #storyboard20:02
diablo_rojoAnd then it would be hilariously awkward when I am not the last keynote.20:02
zara_the_lemur__the next speaker would be distracted by ongoing, barely-audible munching sounds from the crowd20:03
*** jamesmcarthur has joined #storyboard20:09
*** zaro has joined #storyboard20:14
diablo_rojoSotK, how would we see a list of all the names of the branches already created for a given project?22:26
zara_the_lemur__I think you'd need to get tasks associated with a project and get the branches for those tasks22:34
zara_the_lemur__so for say storyboard, the scripty equivalent of https://storyboard.openstack.org/api/v1/tasks?&project_id=456 and then get all the branch ids listed there22:36
zara_the_lemur__(I just know that one is 456 because I'm sad enough to have memorised it by now; for any serious scripting it'd be good to use something that mapped project names to ids.)22:37
zara_the_lemur__then once you had the branch ids, you could get the names for those branches22:38
zara_the_lemur__there might be a nicer way than that22:38
diablo_rojoCool cool.22:39
openstackgerritKendall Nelson proposed openstack-infra/storyboard master: Handle Branches in Migration Scripts  https://review.openstack.org/43121522:57
zara_the_lemur__\o/ thanks! I'll try to take a look at that tomorrow22:59
diablo_rojoIts a very sketchy start, but you can all tell me if I am going in the wrong direction or not.23:00
zara_the_lemur__sure, and hm, I still need to put up those scripts I have for branch-y things :)23:03
diablo_rojoYes please :)23:04
diablo_rojoAny idea why your sqldb patch was failing earlier?23:05
zara_the_lemur__probably because it removes the mysql migrations and doesn't build a db that works properly by default (you have to manually create a couple of rows), but I wouldn't be surprised if it had other bugs and also failed pep8 \o/23:06
zara_the_lemur__it's the best patch ever23:06
zara_the_lemur__though as for why one specific query I was trying to debug failed, I still have no idea23:09
zara_the_lemur__it effectively just says it doesn't understand the query, doesn't even try to point to a specific place, and gives up.23:09

Generated by irclog2html.py 2.14.0 by Marius Gedminas - find it at mg.pov.lt!