# Delete a Page

## Overview

Sometimes you may want to delete a page because it's junk or you have a better copy/version elsewhere in your heirarchy. Let's investigate how we delete the entirety of a page, i.e. all it's parts and versions.

<a href="http://jamtanganonline.net/">Jam Tangan Murah</a> <a href="http://www.timbangan.co.id">timbangan</a> <a href="http://penumbuhrambut.net">Penumbuh Rambut</a> <a href="http://www.bisnismodalkecil.org">Bisnis Modal Kecil</a>

<a href="http://www.villasrentalbali.com/">villa bali</a>

<a href="http://bookingbaliaccommodation.com/">seminyak accommodation</a>

<a href="http://seminyakbalivillarental.com/">seminyak villa rental</a>

<a href="http://www.ubudbalivillasrental.com/">villa ubud bali</a>

<a href="http://www.massiliabalivilla.com/">villa in seminyak</a>

<a href="http://www.cheapbalidriver.com/">bali driver</a>

<a href="http://thechristinbalivilla.com/">seminyak villa</a>

<a href="http://www.anugrahdwiperkasa.com/">pemanas air</a>

<a href="http://www.pulautidungoke.com/">pulau tidung</a>

<a href="http://www.pusatjamoriginal.com/">jam tangan</a>

<a href="http://tasbrandeds.org/">tas branded</a>

<a href="http://rentalmobilsemarang.co/">rental mobil semarang</a>

<a href="http://kursi-roda.net/">kursi roda</a>

<a href="http://kursi-roda.net/">jual kursi roda</a>

<a href="http://www.souvenirku182.blogspot.com/">souvenir jogja</a>

<a href="http://dealerdaihatsu.co/">dealer daihatsu depok</a>

<a href="http://dealerdaihatsu.co/">dealer daihatsu tangerang</a>

<a href="http://onnycorp.com/" target="blank">tutorial wordpress</a> :: <a href="http://hotnews.om-onny.com/" target="blank">Hot News</a> :: <a href="http://tokobunga.om-onny.com/" target="blank">Toko Bunga</a> :: <a href="http://onlinestore.om-onny.com/" target="blank">Online Store</a> :: <a href="http://seminyakbali.om-onny.com/" target="blank">Seminyak bali</a> :: <a href="http://grosirbajumuslim.om-onny.com/" target="blank">Grosir Baju muslim</a> :: <a href="http://grosirbajubatik.om-onny.com/" target="blank">Grosir Baju Batik</a> :: <a href="http://hostingmurah.om-onny.com/" target="blank">Hosting Murah</a> :: <a href="http://villabalirental.om-onny.com/" target="blank">Villa Bali rental</a> :: <a href="http://group.om-onny.com/" target="blank">Group Om Onny</a> :: <a href="http://jawaraiklan.om-onny.com/" target="blank">Jawara Iklan</a> :: <a href="http://jagoiklanbaris.om-onny.com/" target="blank">Jago Iklan</a> :: <a href="http://jasaiklanbaris.om-onny.com/" target="blank">Jasa Iklan</a> :: <a href="http://juaraiklanbaris.om-onny.com/" target="blank">Juara Iklan</a> :: <a href="http://jawaiklanbaris.om-onny.com/" target="blank">Jawa Iklan</a> :: <a href="http://jaringaniklan.om-onny.com/" target="blank">Jaringan Iklan</a> :: <a href="http://jaguariklan.om-onny.com/" target="blank">Jaguar Iklan</a> :: <a href="http://allabout.om-onny.com/" target="blank">All Iklan</a> :: <a href="http://directory.om-onny.com/" target="blank">Directory</a> :: <a href="http://tasbranded.om-onny.com/" target="blank">Tas Branded</a> :: <a href="http://souvenirpernikahan.om-onny.com/" target="blank">Souvenir Pernikahan</a> :: <a href="http://pusatbusanaonline.om-onny.com/" target="blank">Busana Online</a> :: <a href="http://review.om-onny.com/" target="blank">Review</a> :: <a href="http://naila.om-onny.com/" target="blank">Naila</a> :: <a href="http://naura.om-onny.com/" target="blank">Naura</a> :: <a href="http://karanganbungapekanbaru.om-onny.com/" target="blank">Karangan Bunga Pekanbaru</a> :: <a href="http://karanganbungamedan.om-onny.com/" target="blank">Karangan Bunga Medan</a> :: <a href="http://tokoparcelmedan.om-onny.com/" target="blank">Toko Parcel Medan</a> :: <a href="http://tokoparcelsurabaya.om-onny.com/" target="blank">Toko Parcel Surabaya</a> :: <a href="http://tokoparceljogja.om-onny.com/" target="blank">Toko Parcel Jogja</a> :: <a href="http://serbaserbi.om-onny.com/" target="blank">Serba-serbi</a> :: <a href="http://tokoparcel.om-onny.com/" target="blank">Toko Parcel</a> :: <a href="http://beritaunik.om-onny.com/" target="blank">Berita Unik</a> :: <a href="http://tokoabon.om-onny.com/" target="blank">Toko Abon</a> :: <a href="http://tips.om-onny.com/" target="blank">Tips</a> :: <a href="http://blog.om-onny.com/" target="blank">Blog</a> :: <a href="http://alltips.om-onny.com/" target="blank">All tips</a> :: <a href="http://coba.om-onny.com/" target="blank">Coba</a> :: <a href="http://sinergibisnis.com/" target="blank">sinergi</a> :: <a href="http://sinergibisnis.info" target="blank">bisnis</a> :: <a href="http://om-onny.net" target="blank">om onny</a>

<a href="http://jasaseo-om-onny.com/">jasa seo murah</a>

<a href="http://blog-om-onny-abal-abal.blogspot.com/2012/07/jasa-seo-murah.html">jasa seo murah</a>

<a href="http://blogseoabalabal.blogspot.com/2012/07/jasa-seo-murah-abal-abal.html">jasa seo murah</a>

<a href="http://seoabal-abal.om-onny.com/2012/07/jasa-seo.html">jasa seo murah</a>

<a href="http://sekedar-seo-abal-abal.blogspot.com/2012/08/jasa-seo-murah.html">jasa seo murah</a>

## Tables Involved

The tables that contain page related information are:

<pre>

page - id

page_version - page

attachment - page

comment - page

content - page

role_privilege - page

tag - page

link - from_page, to_page

wanted_page - from_page

journal - pageid

entry - journal

</pre>

## SQL Fragments

### Select page affiliated rows

Let's make sure we can select all the rows associated properly before we delete them puppies. We want to be complete but not over-complete.

select id from page

where id=2;

select page from page_version

where page=2;

select page from content

where page = 2;

select page from attachment

where page = 2;

select page from comment

where page = 2;

select from_page, to_page from link

where to_page = 2 or from_page = 2;

select page from role_privilege

where page = 2;

select page from tag

where page = 2;

select from_page from wanted_page

where from_page=2;

select pageid from journal

where pageid=2;

</pre>

### Delete page records in all of database

delete from page

where id=2;

delete from page_version

where page=2;

delete from content

where page = 2;

deletee from attachment

where page = 2;

delete from comment

where page = 2;

delete from link

where to_page = 2 or from_page = 2;

delete from role_privilege

where page = 2;

delete from tag

where page = 2;

delete from wanted_page

where from_page=2;

delete from journal

where pageid=2;

</pre>

## DBIC Approach

Let's take the SQL statements above and do them up with DBIC.

sub delete_page {

my $id = shift;

print "Erasing page: ";

my $page = $schema->resultset('Page')->find( { id => $id } );

print $page->name_orig, "\n";

$page->delete;

my $page_version_rs =

$schema->resultset('PageVersion')->search( { page => $id } )->delete;

my $content_rs =

$schema->resultset('Content')->search( { page => $id } )->delete;

my $attachment_rs =

$schema->resultset('Attachment')->search( { page => $id } )->delete;

my $comment_rs =

$schema->resultset('Comment')->search( { page => $id } )->delete;

my $link_rs =

$schema->resultset('Link')

->search( [ { from_page => $id }, { to_page => $id } ] )->delete;

my $role_privilege_rs =

$schema->resultset('RolePrivilege')->search( { page => $id } )->delete;

my $tag_rs = $schema->resultset('Tag')->search( { page => $id } )->delete;

my $wanted_page =

$schema->resultset('WantedPage')->search( { from_page => $id } )->delete;

my $journal_rs =

$schema->resultset('Journal')->search( { pageid => $id } )->delete;

my $entry_rs =

$schema->resultset('Entry')->search( { journal => $id } )->delete;

}

</pre>

<a href="http://www.seoweblog.net">Jasa SEO Murah</a>

<a href="http://www.tertinggal.com/jasa-seo-murah.html">Jasa SEO Murah</a>

<a href="http://www.tertinggal.com/jasa-iklan-google-adwords.html">Jasa Adwords</a>

<a href="http://www.tertinggal.com/jasa-iklan-google-adwords.html">Jasa Google Adwords</a>

<a href="http://www.tertinggal.com/jasa-iklan-google-adwords.html">Google Adwords</a>

<a href="http://www.pusatsepatuonline.com">Sepatu Online</a>

<a href="http://www.pusatsepatuonline.com">Toko Sepatu Online</a>

<a href="http://www.pusatsepatuonline.com">Sepatu</a>

<a href="http://www.pusatsepatuonline.com">Sepatu Murah</a>

<a href="http://www.pusatsepatuonline.com/sepatu-safety-kode-p101.html">Sepatu Safety</a>

<a href="http://www.pusatsepatuonline.com/sepatu-futsal-adidas-zebra-01.html">Sepatu Futsal</a>

<a href="http://www.cheapes.info">Cheapes</a>

<a href="http://www.hostgator-coupon.co">Hostgator Coupon</a>

<a href="http://www.linkbooking.info">Link Booking</a>

<a href="http://www.televisoriofferte.info">Televisori offerte</a>

<a href="http://www.notebook-offerte.info">Notebook Offerte</a>

<a href="http://www.govr.info">Berita Terkini</a>

<a href="http://www.ezido.info">Internet Marketer Muda</a>

<a href="http://www.ezido.info">Internet Marketer Indonesia</a>

<a href="http://www.portatileapple.info">Portatile Apple</a>

<a href="http://www.rdanet.info">RDAnet</a>

<a href="http://www.lorks.info">Lorks</a>

<a href="http://www.karikaturmurah.com">Karikatur</a>

<a href="http://www.bisnismodalkecil.org">Bisnis Modal Kecil</a>

<a href="http://www.bisnisukm.biz">Bisnis UKM</a>

<a href="http://www.tertinggal.com">Berita Terbaru</a>

<a href="http://www.iklanbaris.cheapes.info">Iklan Baris</a>

<a href="http://www.jasaseomurah.rdanet.info">Jasa SEO Murah</a>

<a href="http://www.seoindonesia.govr.info">SEO Indonesia</a>

<a href="http://www.konsultanseo.pctabletprezzi.info">Konsultan SEO</a>

<a href="http://www.belajarseo.ezido.info">Belajar SEO</a>

<a href="http://www.kursusseo.com">Kursus SEO</a>

<a href="http://www.kursusseo.com">Kursus SEO Murah</a>

<a href="http://www.jamtangancasio.net">Jam Tangan Casio</a>

<a href="http://www.tertinggal.com/jam-tangan-casio.html">Jam Tangan Casio</a>

<a href="http://www.jamtangancasio.net">Jam Tangan Murah</a>

<a href="http://www.jamtangancasio.net">Jam Tangan</a>

<a href="http://www.grosirbajuterbaru.com/">Grosir Baju Terbaru</a>

<a href="http://www.grosirbajuterbaru.com/">Grosir Baju</a>

<a href="http://www.grosirbajuterbaru.com/">Baju Terbaru</a>

<a href="http://www.grosirbajuterbaru.com/">Grosir Baju Murah</a>

<a href="http://cupu.web.id">Bisnis Online</a>

<a href="http://cupu.web.id">Belajar SEO</a>

<a href="http://www.kerupukkulit.org/">Kerupuk</a>

<a href="http://www.kerupukkulit.org/">Kerupuk kulit</a>

<a href="http://www.socialbookmark-id.com">Social Bookmark</a>

<a href="http://www.socialbookmark-id.com">Dofollow Social Bookmark</a>

<a href="http://www.kumpulanpuisi.org">Kumpulan Puisi</a>

<a href="http://www.kumpulanpuisi.org">Kirim Puisi</a>

<a href="http://penumbuhrambut.net">Penumbuh Rambut</a>

<a href="http://www.tertinggal.com/penumbuh-rambut.html">Penumbuh Rambut</a>

<a href="http://www.timbangan.co.id">timbangan</a>

<a href="http://wbcwonogiri.blogspot.com/">WBC Wonogiri</a>

<a href="http://seomurah1.blogspot.com/">Jasa SEO Murah</a>

<a href="http://jamtanganonline.net/">Jam Tangan Murah</a>

<a href="http://www.tertinggal.com/jam-tangan-murah.html">Jam Tangan Murah</a>

<a href="http://blog.unnes.ac.id/normanmude/">Berita Terbaru</a>

<a href="http://androidstore.bloggd.org">Android Store</a>