irclog2html for #asterisk-doc on 20060420

07:06.29*** join/#asterisk-doc ToTo (n=ToTo@81.174.33.2)
12:11.59*** join/#asterisk-doc ChanServ (ChanServ@services.)
12:12.00*** mode/#asterisk-doc [+o ChanServ] by irc.freenode.net
12:12.00*** mode/#asterisk-doc [-o jsmith-asleep] by ChanServ
13:42.07*** mode/#asterisk-doc [+o jsmith] by ChanServ
14:55.56*** join/#asterisk-doc jsmith (n=jsmith@smithfam.dsl.xmission.com)
14:55.56*** mode/#asterisk-doc [+o jsmith] by ChanServ
15:02.00blitzragejsmith: ping!
15:02.04jsmithPong!
15:02.08blitzragejsmith: easy question for you
15:02.37blitzragewhen I do a contraint (foreign key) to do a cascade up delete or update, do I need to put the FK on both tables, or just one?
15:02.56blitzragei.e. if a PBX name is updated, I want the PBX name updated in the DID Master List
15:02.59blitzrageand Vice-Versa
15:03.07jsmithYou just need one.
15:03.15blitzrageand it'll go both ways right?
15:03.23jsmithYes
15:03.27blitzrageok, thats what I thought
15:03.28blitzragethanks!
15:03.35jsmithAs long as have cascading set up
15:03.40blitzrageright
15:03.45blitzrageand that's what the FK is set to
15:03.47jsmithOne column is the actual key
15:03.56blitzrageto cascade on update and delete
15:03.59jsmithAnd any other tables that refer to it point to that "foreign" key
15:04.21blitzrageif I do a cascade on delete though, and delete a DID, is it going to delete the PBX ?
15:05.32blitzrageI think I probably want my contraint put on the PBX table, and not the DID master table -- because if I delete a PBX, I want the DIDs associated with it deleted too -- actually, no -- I probably just want to set them to NULL since they are just not assigned, but I still own the DIDs
15:08.16blitzrageguess I can't put it on ast_pbx due to a non-unique constraint
15:09.23blitzrageI guess I have to think of it as: If I place a FK here, then when the referenced table changes, then I'll change too
15:09.39blitzragei.e. changes will cascade down TO me FROM there
15:10.27jsmithNo, you're not understanding.
15:10.34blitzrageobviously not
15:10.43jsmithLet's create two tables:
15:10.56blitzrageast_pbx and ast_did_master
15:12.32jsmithWell, for simplicity sake, let's call it "master" and "slave"
15:13.17jsmithjsmith=# create table master (
15:13.17jsmithjsmith(# master_id serial,
15:13.17jsmithjsmith(# master_name text,
15:13.17jsmithjsmith(# PRIMARY KEY(master_id));
15:13.17jsmithNOTICE:  CREATE TABLE will create implicit sequence "master_master_id_seq" for serial column "master.master_id"
15:13.18jsmithNOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index "master_pkey" for table "master"
15:13.20jsmithCREATE TABLE
15:13.22jsmithjsmith=#
15:16.02jsmithCREATE TABLE slave (
15:16.02jsmith<PROTECTED>
15:16.02jsmith<PROTECTED>
15:16.02jsmith);
15:16.17jsmithOK, now let's add the foreign key to the slave table
15:16.38jsmithALTER TABLE ONLY slave
15:16.38jsmith<PROTECTED>
15:16.45jsmithYou with me so far?
15:17.36blitzrageok -- I know how to create the stuff, its the flow I don't get :)
15:17.54blitzragebut to answer your question -- yes :)
15:18.43jsmithOK, so let's add some data to the master table
15:18.48blitzragecoolio
15:19.17jsmithjsmith=# INSERT INTO master VALUES (DEFAULT,'Leif');
15:19.18jsmithINSERT 26827 1
15:19.18jsmithjsmith=# INSERT INTO master VALUES (DEFAULT,'Jared');
15:19.18jsmithINSERT 26828 1
15:19.18jsmithjsmith=# INSERT INTO master VALUES (DEFAULT,'Steve');
15:19.18jsmithINSERT 26829 1
15:19.24jsmith<PROTECTED>
15:19.32jsmithNow, let's add some data to the slave table
15:21.42blitzragebtw: just got my cheque from O'Reilly finally :)
15:22.22jsmithjsmith=# INSERT INTO SLAVE VALUES (1,'Toronto');
15:22.23jsmithINSERT 26830 1
15:22.23jsmithjsmith=# INSERT INTO SLAVE VALUES (2,'Riverton');
15:22.23jsmithINSERT 26831 1
15:22.23jsmithjsmith=# INSERT INTO SLAVE VALUES (3,'Kansas City');
15:22.23jsmithINSERT 26832 1
15:22.33jsmithjsmith=# INSERT INTO SLAVE VALUES (4,'Toquerville');
15:22.35jsmithERROR:  insert or update on table "slave" violates foreign key constraint "master_id_fk"
15:22.37jsmithDETAIL:  Key (master_id)=(4) is not present in table "master".
15:23.07jsmithOK, so you with me so far?
15:23.21blitzragewhy did the fourth addition fail?
15:24.17jsmithBecause there wasn't a master_id value of 4 in the master table...
15:24.28jsmithMaking sure the foreign key contstraint is actually working...
15:24.44blitzrageright -- oh I see now
15:24.53blitzragethere is no 4th entry -- thus no ID of 4 :)
15:24.57blitzrageto assign it to
15:24.58jsmithBingo!
15:25.05jsmithThe whole reason we use foreign keys.
15:25.21jsmithOK, now let's try updating the Master table
15:25.57jsmithjsmith=# UPDATE master set master_id = 4 where master_id = 1;
15:25.57jsmithUPDATE 1
15:25.58jsmithjsmith=# select * from master;
15:25.58jsmith<PROTECTED>
15:25.58jsmith-----------+-------------
15:25.59jsmith<PROTECTED>
15:26.01jsmith<PROTECTED>
15:26.03jsmith<PROTECTED>
15:26.05jsmith(3 rows)
15:26.07jsmithjsmith=# select * from slave;
15:26.09jsmith<PROTECTED>
15:26.11jsmith-----------+-------------
15:26.13jsmith<PROTECTED>
15:26.15jsmith<PROTECTED>
15:26.17jsmith<PROTECTED>
15:26.19jsmith(3 rows)
15:26.21jsmithNow, your master_id is 4, instead of 1.
15:27.21blitzrageok -- thats what I was thinking
15:27.52blitzrageso I add the FK to the slave table (ast_did_master in this case), and when ast_pbx changes, then the name in ast_did_master changes too
15:28.10blitzrageit cascades down to the table with the FK on it
15:29.14blitzrageALTER TABLE ast_did_master ADD CONSTRAINT ast_pbx_fk FOREIGN KEY (did_pbx) REFERENCES ast_pbx (name)
15:29.17blitzrage<PROTECTED>
15:29.20blitzrageCREATE INDEX fki_ast_pbx_fk ON ast_did_master(did_pbx);
15:30.20jsmithNow, let's try updating the master_id on the slave, and see if it updates on the master.
15:30.27jsmithjsmith=# update slave set master_id = 5 where master_id = 4;
15:30.27jsmithERROR:  insert or update on table "slave" violates foreign key constraint "master_id_fk"
15:30.27jsmithDETAIL:  Key (master_id)=(5) is not present in table "master".
15:31.00jsmithObviously not, because the master_id column in the slave table is just a foreign key of the master table.
15:31.16blitzrageright
15:31.20blitzrageok -- that makes sense
15:31.22jsmithIn other words, and update to the slave table doesn't update the master.
15:31.41jsmithSo that explains cascading updates to you -- do you need help understanding cascading deletes as well?
15:31.44blitzrageright -- but I could switch the ID to something that existed in the Masterisk table, yes?
15:31.55jsmithYes.
15:32.11blitzragelol
15:32.15blitzragewow -- thats a crazy typo
15:32.50jsmithyour fingers are used to typing "isk" after "aster"
15:33.37blitzrageok -- for the delete -- basically, I think that if I delete ID 4 in Master, then anything in Slave that references master_id = 4 would get deleted (on cascade) -- or set to NULL if SET NULL is the method
15:35.28jsmithExactly.
15:35.31jsmithYou've got it!
15:35.33blitzrageperfect
15:35.38blitzragethanks so much
15:35.42blitzrageDr. Smith
15:35.44jsmithno problem
15:55.27*** join/#asterisk-doc ToTo (n=ToTo@81.174.33.2)
15:58.55ToToif i want to set staticcally From: section in sip header where i must touch in chan_sip.c?
15:59.25jsmithToTo: Check out the "fromuser" setting in sip.conf
16:00.48ToTojsmith, i want to set hostname, such as toto@emmequadro.net, but now it crate toto@123.456.787.123...
16:01.21ToTojsmith, i can use litteral address?
16:04.11ToTojsmith, fromuser=toto@emmequadro.net?
16:04.57jsmithThat should work.
16:05.20blitzrageI don't think that will work.....
16:05.29blitzrageI'm not sure if it parses the whole @ section
16:05.44jsmithOh...
16:06.02blitzrageunless the whole name can contain the @domain part
16:06.06blitzragenever tried to be honest
16:06.29blitzragewould be interested if that would work :)
16:06.50blitzrageok -- need to go find food
16:07.15ToTobut i have eneable debug mode, and from section is in toto@<numerical_type>..
16:07.47jsmithToTo: You might want to find oej and ask him... he'll know
16:07.58blitzrageoej doesn't know anything about chan_sip :)
16:09.03*** mode/#asterisk-doc [-o blitzrage] by jsmith
16:42.17jsmithblitzrage: Tim is still happy w/ our book :-)
16:42.20jsmithhttp://radar.oreilly.com/archives/2006/04/state_of_the_computer_book_mar_3.htm
17:09.10*** join/#asterisk-doc ToTo (n=ToTo@host125-166.pool879.interbusiness.it)
17:31.46*** join/#asterisk-doc ToTo (n=ToTo@host125-166.pool879.interbusiness.it)
18:05.57*** join/#asterisk-doc Alric (n=nbowyer@masq.hyperusa.com)
18:18.13AlricJared!
20:02.16*** join/#asterisk-doc ToTo (n=ToTo@host125-166.pool879.interbusiness.it)
20:17.54jsmithAlric!
20:19.08ToTojsmith, do you know the chan_sip.c structure?
20:21.07jsmithToTo: No, not very well... Why?
20:21.12jsmithAlric: Why doesn't it work?
20:21.25AlricAs a native OS X app.
20:21.48jsmithThere's a native version of it?
20:21.52AlricNope.
20:22.16blitzragejsmith: cool!
20:22.29ToTojsmith, i need to know where the from value is set
20:22.57jsmithToTo: You'd have to ask oej... I have no idea.
20:23.26ToTojsmith, ok
20:25.06AlricJust trying to get XCode to play nicely with this source code...
20:34.11jsmithAlric: Uh, you realize that XCode wants Objective C, and you're passing it straight C, right?
20:34.26AlricOh well.
20:34.32jsmithAlric: And Ethereal doesn't have an Aqua/Cocoa interface, it has a GTK interface, right?
20:34.46AlricYeah.
20:34.47jsmithAlric: And the code probably won't even compile cleanly on OS X, right?
20:35.04AlricSo you're saying this isn't going to work :(
20:35.13jsmithAnd you probably don't even have the libpcap libraries installed, right?
20:36.18Alrichrm
20:36.21AlricI have an Interface Builder
20:36.57jsmithAnd you're a good enough coder to make it work (in Objective C) with Ethereal (in C)?
20:37.18jsmithI have an Interface Builder too, but I'm not that naive to think I could do anything with it in less than a few days...
20:37.42jsmithRight...
20:37.43jsmithXCode isn't magic, my friend.
20:38.39AlricYeah
20:38.41AlricIf it was this easy...
20:38.44AlricSomeone would have done it.
20:44.25jsmithAlric: Install X11, and then use fink to install Ethereal, and live with that.
20:44.51*** join/#asterisk-doc [ToTo] (n=ToTo@host125-166.pool879.interbusiness.it)
21:01.53blitzragejsmith: cool -- someone is starting the PHP style docu-project :)
21:02.30jsmithCool...
21:36.41AlricI just don't want to do things that way.
21:36.45AlricI want my native OS X App!
21:48.43jsmithThen become a programme.r
21:48.55AlricYeah.
22:17.17jsmithNot enough sales.
22:25.08Alric??
22:25.39jsmith9?
22:25.46AlricYeah
22:27.20Alricsorry, 8.
22:28.01AlricYou posting that somewhere? :)
22:28.07AlricOr is that a consulting project?
22:28.23jsmithYeah... I'm posting it on my local hard drive :-)
22:28.26AlricHehe.
22:28.29jsmithYes, it's a consulting project.
22:28.34jsmithI'm stealing away your clients
22:29.45jsmith:-)
22:29.52AlricBiggest job I have 95 seats.
22:30.41AlricYou do sales yourself?
22:31.33jsmithI do sales.
22:31.35jsmithI do consulting.
22:31.38jsmithI do training.
22:31.46jsmithI do mentoring (if blitzrage is listening)
22:32.03jsmithI answer the phones
22:32.08jsmithI do it all!
22:32.12jsmithWell, OK, not quite that much...
22:32.59AlricHmmm
22:33.02AlricSounds like me.
22:33.10AlricExcept mentoring.
22:34.16jsmithOh, and did I mention that I do all the travelling around the country, since blitzrage and the border patrol don't get along?
22:34.31Alrichehe
23:17.12AlricI hate losing code :)
23:36.55blitzragementor!
23:37.39blitzrageAlric: if you ever ask if jsmith does something, the answer is always yes
23:38.58Alricjsmith: Is Asterisk incapable of being performing a Dial(), given a programmer of your skill?
23:39.06Alricerr, drop the being :)
23:40.41AlricI don't think that was a yes!

Generated by irclog2html.pl by Jeff Waugh - find it at freshmeat.net! Modified by Tim Riker to work with blootbot logs, split per channel, etc.