jinraynor1/table_cleaner

通过删除手动分区表来清理

v0.0.2 2021-10-25 22:39 UTC

This package is auto-updated.

Last update: 2024-09-26 05:19:40 UTC


README

通过正则表达式和时间来删除表以清理

入门指南

使用方法的简要示例

<?php
$date = new DateTime("2019-02-01");
$regex = new \Jinraynor1\TableCleaner\TableRegex("/^dropme([0-9]{8})$/", $date, "Ymd");
$driver = new \Jinraynor1\TableCleaner\Drivers\Sqlite(new PDO('mysql:host=localhost;dbname=testdb','root',''));

$table_cleaner = new \Jinraynor1\TableCleaner\TableCleaner($driver, $regex);
$table_cleaner->drop();

有关如何使用此库的更多示例,请参阅测试目录

先决条件

您至少需要php 5.3和数据库驱动程序的PDO库

安装

您可以通过输入以下命令使用composer安装它

composer require jinraynor1/table_cleaner

对于测试,您需要以下依赖项

composer require-dev phpunit/phpunit "~6.5"
composer require --dev phpunit/dbunit

运行测试

只需输入类似以下的内容

/usr/local/bin/phpunit --configuration phpunit.xml tests