Owner fix

gistfile1.txt

[lloyd@desktop buddycloud-server]$ psql -d buddycloud-server -c "update affiliations set \"user\" = 'memememme' where node = '/user/lloyd@evilprofessor.co.uk/posts' and affiliation = 'owner';"UPDATE 1
[lloyd@desktop buddycloud-server]$ psql -d buddycloud-server -c "select * from affiliations where node IN (select node from node_config where key = 'channelType' and value = 'personal') and affiliation = 'owner';"                   node                   |             user             | affiliation | updated 
------------------------------------------+------------------------------+-------------+---------
 /user/lloyd@evilprofessor.co.uk/posts    | memememme                    | owner       | 
 /user/ashward@buddycloud.org/posts       | ashward@buddycloud.org       | owner       | 
 /user/dave@buddycloud.org/posts          | dave@buddycloud.org          | owner       | 
 /user/schnouki@pouet.im/posts            | schnouki@pouet.im            | owner       | 
 /user/cookie@evilprofessor.co.uk/posts   | cookie@evilprofessor.co.uk   | owner       | 
 /user/jdeisenberg@dsn-test.com/posts     | jdeisenberg@dsn-test.com     | owner       | 
 /user/simon@buddycloud.org/posts         | simon@buddycloud.org         | owner       | 
 /user/lloyd@buddycloud.org/posts         | lloyd@buddycloud.org         | owner       | 
 /user/lloyd@pi.evilprofessor.co.uk/posts | lloyd@pi.evilprofessor.co.uk | owner       | 
 /user/denisw@buddycloud.org/posts        | denisw@buddycloud.org        | owner       | 
 /user/andy@highfellow.org/posts          | andy@highfellow.org          | owner       | 
 /user/abmargb@buddycloud.org/posts       | abmargb@buddycloud.org       | owner       | 
 /user/fahrertuer@buddycloud.org/posts    | fahrertuer@buddycloud.org    | owner       | 
(13 rows)

[lloyd@desktop buddycloud-server]$ psql -d buddycloud-server -c "update affiliations set \"user\" = substring(node from '^/user/(.*)/.*$') where node IN (select node from node_config where key = 'channelType' and value = 'personal') and affiliation = 'owner';"
UPDATE 13
[lloyd@desktop buddycloud-server]$ psql -d buddycloud-server -c "select * from affiliations where node IN (select node from node_config where key = 'channelType' and value = 'personal') and affiliation = 'owner';"                   node                   |             user             | affiliation | updated 
------------------------------------------+------------------------------+-------------+---------
 /user/lloyd@evilprofessor.co.uk/posts    | lloyd@evilprofessor.co.uk    | owner       | 
 /user/ashward@buddycloud.org/posts       | ashward@buddycloud.org       | owner       | 
 /user/dave@buddycloud.org/posts          | dave@buddycloud.org          | owner       | 
 /user/schnouki@pouet.im/posts            | schnouki@pouet.im            | owner       | 
 /user/cookie@evilprofessor.co.uk/posts   | cookie@evilprofessor.co.uk   | owner       | 
 /user/jdeisenberg@dsn-test.com/posts     | jdeisenberg@dsn-test.com     | owner       | 
 /user/simon@buddycloud.org/posts         | simon@buddycloud.org         | owner       | 
 /user/lloyd@buddycloud.org/posts         | lloyd@buddycloud.org         | owner       | 
 /user/lloyd@pi.evilprofessor.co.uk/posts | lloyd@pi.evilprofessor.co.uk | owner       | 
 /user/denisw@buddycloud.org/posts        | denisw@buddycloud.org        | owner       | 
 /user/andy@highfellow.org/posts          | andy@highfellow.org          | owner       | 
 /user/abmargb@buddycloud.org/posts       | abmargb@buddycloud.org       | owner       | 
 /user/fahrertuer@buddycloud.org/posts    | fahrertuer@buddycloud.org    | owner       | 
(13 rows)