• Replies 4 replies
  • Subscribers 337 subscribers
  • Views 247 views
  • Users 0 members are here
Related

Deleting Old Extractions

Christopher Wright
$organization

Hi

 

We're looking to delete a lot of our old extractions and are trying to find a way of doing this en mass.

 

So far, I have run a SQL trace and have identified the following sql commands that are executed during an extraction delete.

  • DELETE FROM t_cust_keycode WHERE ka_no =2376 
  • DELETE FROM t_cust_keycode WHERE ka_no =2376 
  • DELETE FROM t_list_extraction FROM t_list_extraction , v_keycode WHERE v_keycode.ka_no =2376 AND v_keycode.keycode_id =t_list_extraction.list_id 
  • DELETE FROM v_keycode WHERE ka_no =2376 
  • DELETE FROM v_keycode_hist WHERE ka_no =2376 
  • DELETE FROM v_ka_header WHERE ka_no =2376 
  • execute ap_get_nextid @type = 'DL'
  • INSERT INTO t_dl_header ( dl_no , dl_dt , pitch_desc , ka_no ) VALUES ( 5822 , {ts '2017-05-22 12:08:00.030'} , 'Deleted' , 2376 ) 

 

Has anyone done anything like this before, or does anyone know if there are any tables that are afftected, that are missing from the above list?

 

Thanks,

Chris.

 

  • $organization

    Looks like you've found the same tables I did, via the same method, e.g. I send the each ka_no through a cursor that deletes files from

    impresario..t_list_extraction
    impresario..v_keycode
    impresario..v_keycode_hist
    impresario..v_ka_header
    impresario_cci..T_CUST_KEYCODE

    ... in that order. 

    I've been housekeeping old Exts this way since late 2013, with no ill effects.

  • $organization in reply to Chris Jensen

    Hi Chris

     

    Thanks, that's reassuring to know that I'm looking along the right lines and that you've found the same tables as I have.

     

    Thanks,

    Chris.

  • $organization

    I would definitely be interested in this.  We have so many very old extractions and I keep telling myself I need to tackle them, then the thought exhausts me.

     

    Michelle Usadel
    Tessitura Application Specialist | The Phoenix Symphony | Tel.  602-452-0441 | Fax. 602-253-1772
    www.phoenixsymphony.org | 1 N. 1st Street, Ste. 200, Phoenix, AZ 85004


     

    From: Tessitura Technical Forum [mailto:forums-technical@tessituranetwork.com] On Behalf Of Brian Wilbur Grundstrom
    Sent: Tuesday, May 23, 2017 8:47 AM
    To: Michelle Usadel <musadel@phoenixsymphony.org>
    Subject: RE: [Tessitura Technical Forum] Deleting Old Extractions

     

    Chris,

    Would you mind please sharing your code?  I need to do some housekeeping here.

    Thanks!

     

    BRIAN WILBUR GRUNDSTROM | Database Administrator
    SHAKESPEARE THEATRE COMPANY
    Recipient of the 2012 Regional Theatre Tony Award®
    516 Eighth Street, SE | Washington, DC 20003-2834
    p 202.547.3230 ext. 2216 | c 917.952.7957
    bwg@shakespearetheatre.org
    www.shakespearetheatre.org
    www.brianwilbur.com
    2016|2017 SEASON •• Shakespeare’s ROMEO & JULIET • Norman, Simon & Burnett’s THE SECRET GARDEN • Bartlett’s KING CHARLES III • Elevator Repair Service’s THE SELECT (THE SUN ALSO RISES) • Shakespeare’s MACBETH • Ives’s THE SCHOOL FOR LIES

     

     

     

    From: Tessitura Technical Forum [mailto:forums-technical@tessituranetwork.com] On Behalf Of Christopher Wright
    Sent: Tuesday, May 23, 2017 9:30 AM
    To: Brian W. Grundstrom
    Subject: Re: [Tessitura Technical Forum] Deleting Old Extractions

     

    Hi Chris

     

    Thanks, that's reassuring to know that I'm looking along the right lines and that you've found the same tables as I have.

     

    Thanks,

    Chris.

    From: Chris Jensen <bounce-chrisjensen8841@tessituranetwork.com>
    Sent: 5/22/2017 2:18:36 PM

    Looks like you've found the same tables I did, via the same method, e.g. I send the each ka_no through a cursor that deletes files from

    impresario..t_list_extraction
    impresario..v_keycode
    impresario..v_keycode_hist
    impresario..v_ka_header
    impresario_cci..T_CUST_KEYCODE

    ... in that order. 

    I've been housekeeping old Exts this way since late 2013, with no ill effects.




    This message was sent automatically to you by www.tessituranetwork.com because you subscribed to the Tessitura Technical Forum. You may reply to this message to post to the Technical forum or visit the site to search, read and post to the forums. In the interest of keeping the forum posts from becoming cluttered, we encourage you to delete previous message text from your reply before sending. Thank you!




    This message was sent automatically to you by www.tessituranetwork.com because you subscribed to the Tessitura Technical Forum. You may reply to this message to post to the Technical forum or visit the site to search, read and post to the forums. In the interest of keeping the forum posts from becoming cluttered, we encourage you to delete previous message text from your reply before sending. Thank you!
  • $organization
    Me too please!  I was doing some deleting manually but that's a time suck. 

    Jenny

    On May 24, 2017, at 6:19 AM, Christopher Wright <bounce-christopherwright7817@tessituranetwork.com> wrote:

    Hi

     

    Could I be included on the code sharing too please? It would really help us out at the moment.

     

    Thanks,

    Chris.

    From: Chris Jensen <bounce-chrisjensen8841@tessituranetwork.com>
    Sent: 5/23/2017 1:30:13 PM

    Sure, I will get in touch offline.




    This message was sent automatically to you by www.tessituranetwork.com because you subscribed to the Tessitura Technical Forum. You may reply to this message to post to the Technical forum or visit the site to search, read and post to the forums. In the interest of keeping the forum posts from becoming cluttered, we encourage you to delete previous message text from your reply before sending. Thank you!