yii: soft delete

by prettyscripts on 2011-03-28 12:31:00 • Leave a comment »

phpyii

as with most of my projects, i do not want to physically delete most records so that they can be re-instated later. however, since i can't seem to find any info regarding this topic, i guess soft delete is not available in yii. you need to implement th… more »

Tags: behavior, database, delete, yii

smf: recover deleted topic

by prettyscripts on 2010-07-14 12:51:00 • Leave a comment »

smfsql

important: you must have a backup of the database with deleted topic. if not, you might as well skip this post. instruction here is based on smf v1.1.x and uses phpmyadmin. it's a free browser based mysql administration tool. but if you're a mysql expe… more »

Tags: delete, phpmyadmin, retrieve, smf, topic

symfony and doctrine: keep the deleted record

by prettyscripts on 2010-05-21 10:39:38 • 3 comments »

phpsymfony

in most of the projects i work on, when 'deleting' a record, it's preferred to mark it as deleted than actually deleting the record. this makes re-instating a record easier. the common practice is to add a status field to every record. in doctrine, thi… more »

Tags: database, delete, doctrine, symfony