/cakephp-partitionable

Behavior for CakePHP supports MySQL partitioning by date.

Primary LanguagePHP

Usage

  • copy into CakePHP application dir
  • attach behavior on model

Methods

  • createPartition
  • removePartition
  • addPartition
  • dropPartition

Sample Shell

Usage

cake/console/cake partition command [args]

Commands

  • create
    • create partitioning with now date
  • remove
    • remove partitioning
  • add
    • add partition date given arg1 (ex. 20110101)
  • add_bulk
    • add partitions 7 days after a week
  • drop
    • drop partition date given arg1 (ex. 20110101)
  • drop_bulk
    • drop partitions 7 days before a week