| 00:29.46 | *** join/#storm jml (n=jml@ppp121-44-210-95.lns1.hba1.internode.on.net) |
| 03:32.38 | *** join/#storm jamesh (n=james@canonical/launchpad/jamesh) |
| 04:03.37 | radix | Storm talk went well, guys. I'm going to sleep to go to montreal in the morning. night |
| 04:07.39 | tjs | what storm talk? |
| 04:58.33 | jkakar | tjs: radix gave a Storm talk in Cambridge (Boston). |
| 05:08.07 | tjs | ahh |
| 05:08.13 | tjs | for who? |
| 05:20.07 | jkakar | tjs: The local Python users group, I believe. |
| 05:20.15 | tjs | ah cool |
| 06:09.43 | *** join/#storm jukart (n=jukart@lsfw01.lovelysystems.com) |
| 12:10.13 | *** join/#storm tsmithe (n=toby@ubuntu/member/tsmithe) |
| 12:10.58 | tsmithe | ok, i'm using storm, but i don't want to try and create the tables every time my program runs. i'm using postgres, and i was wondering how to check if the tables exist |
| 12:38.28 | *** join/#storm nephish_ (n=piv@63.98.191.58) |
| 13:01.56 | nephish_ | morning all |
| 13:25.02 | *** join/#storm niemeyer (n=niemeyer@modemcable178.77-70-69.static.videotron.ca) |
| 13:40.00 | *** join/#storm oubiwann (n=oubiwann@c-75-71-99-53.hsd1.co.comcast.net) |
| 13:48.52 | tsmithe | ok, i'm using storm, but i don't want to try and create the tables every time my program runs. i'm using postgres, and i was wondering how to check if the tables exist |
| 13:54.58 | niemeyer | tsmithe: The way we do it in Landscape is using patch versions |
| 13:55.16 | niemeyer | tsmithe: We have a table where we store patch numbers to see which patches have been applied |
| 13:55.44 | niemeyer | tsmithe: and we have a system that incrementally applies missing patches on the database |
| 13:55.53 | tsmithe | ah that sounds interesting |
| 13:56.12 | tsmithe | i'll give that kind of thing a shot, thanks |
| 13:56.38 | tsmithe | (allows me to do other things as well, which is nifty) |
| 13:57.08 | niemeyer | tsmithe: Right! |
| 13:57.17 | tsmithe | :) |
| 13:58.04 | niemeyer | tsmithe: I'd like to release that as open source as well at some point.. but it's not such a big deal |
| 13:58.38 | tsmithe | that would be quite cool, but you're right, and i'm sure it's not too hard to implement |
| 14:27.40 | tarjei | niemeyer: is this a system to handle db schema changes? That would be interesting as a separate component. |
| 14:42.47 | *** join/#storm xorAxAx (n=xorAxax@moinmoin/coreteam/alexander) |
| 14:42.57 | *** part/#storm xorAxAx (n=xorAxax@moinmoin/coreteam/alexander) |
| 14:46.24 | *** join/#storm brosner (n=brian@63.150.173.39) |
| 14:50.32 | niemeyer | tarjei: Right, that's it |
| 14:53.02 | tarjei | I'm looking forward to seeing it |
| 15:17.10 | *** join/#storm bigkevmcd (n=kevin@87-194-116-135.bethere.co.uk) |
| 16:49.09 | *** join/#storm ubot3 (n=ubot3@unaffiliated/nalioth/bot/ubot3) |
| 17:54.17 | *** join/#storm btbytes (n=pradeep@59.92.173.152) |
| 17:54.55 | btbytes | Hi all, |
| 17:55.01 | btbytes | <PROTECTED> |
| 17:55.21 | btbytes | is there a good example for that I can refer to ? |
| 17:56.02 | btbytes | something on the lines of tbl=('tblname', metadata=meta, autoload=True) ? |
| 18:01.15 | jkakar | btbytes: This is a good place to start: https://storm.canonical.com/Tutorial |
| 18:01.27 | jkakar | btbytes: So far Storm has support for SQLite, MySQL and PostgreSQL. |
| 18:02.33 | btbytes | jkakar: I've gone through the tutorial. what i want to know is how do I use an existing table without having to declare the class first? |
| 18:03.02 | btbytes | something on the lines of what sqlalchemy does with the autoload parameter. |
| 18:03.35 | jkakar | btbytes: Ah, I see. |
| 18:03.58 | jkakar | btbytes: I think the best you can do is run queries manually: store.execute("SELECT foo, bar FROM quux") |
| 18:04.24 | jkakar | btbytes: Storm doesn't do any kind of schema management, like SQLAlchemy and other ORMs do. |
| 18:04.30 | btbytes | I'm trying that right now |
| 18:04.45 | btbytes | i figured that somewhat, after looking at databases/mysql.py |
| 18:04.57 | btbytes | it does not have any code related to reflection, does it? |
| 18:05.08 | jkakar | btbytes: That's why the tutorial runs manual CREATE TABLE statements. |
| 18:05.41 | jkakar | btbytes: I'm not sure I understand the question. How would storm be useful wrt reflection? |
| 18:07.11 | btbytes | sqlalchemy uses reflection to find out the column names, their types from the existing tables in the database. |
| 18:07.36 | niemeyer | btbytes: Indeed it doesn't do reflection yet.. |
| 18:08.28 | btbytes | I'm trying to write a ORM wrapper for MonetDB and I was thrilled to see the very short driver files under databases/ ;) |
| 18:09.16 | btbytes | I hope reflection is on the roadmap > |
| 18:09.17 | btbytes | ? |
| 18:09.54 | niemeyer | btbytes: I can't say it's in the roadmap, but there's interest on it, even more considering that it should be a lot easier to do it in Smart since it doesn't try to have enough metainformation to be able to recreate the table. |
| 18:10.01 | niemeyer | Erm |
| 18:10.04 | niemeyer | s/Smart/Storm.. |
| 18:10.33 | jkakar | Heh |
| 18:11.01 | niemeyer | Now I have to go back to Smart on Launchpad.. |
| 18:11.05 | niemeyer | I mean, ;-) |
| 18:11.25 | niemeyer | Woah.. i got it wrong even trying to make a joke.. what a shame |
| 18:11.29 | jkakar | Bwahaha |
| 18:13.54 | btbytes | oh... :) |
| 18:16.24 | *** join/#storm bigkev (n=kevin@78.86.128.246) |
| 18:35.34 | *** join/#storm niemeyer_ (n=niemeyer@modemcable178.77-70-69.static.videotron.ca) |
| 19:23.24 | *** join/#storm niemeyer (n=niemeyer@modemcable178.77-70-69.static.videotron.ca) |
| 19:49.43 | *** join/#storm niemeyer (n=niemeyer@modemcable178.77-70-69.static.videotron.ca) |
| 21:57.26 | *** join/#storm niemeyer (n=niemeyer@modemcable178.77-70-69.static.videotron.ca) |
| 22:45.59 | tjs | morning |