Revize 1597
Přidáno uživatelem Ondřej Fibich před asi 12 roky(ů)
| freenetis/branches/testing/application/models/log.php | ||
|---|---|---|
|
) p GROUP BY partition_name
|
||
|
");
|
||
|
|
||
|
foreach ($partitions as $name)
|
||
|
foreach ($partitions as $partition)
|
||
|
{
|
||
|
$this->db->query("ALTER TABLE logs DROP PARTITION $name");
|
||
|
$this->db->query("
|
||
|
ALTER TABLE logs
|
||
|
DROP PARTITION " . $partition->partition_name
|
||
|
);
|
||
|
}
|
||
|
}
|
||
|
|
||
| freenetis/branches/testing/application/controllers/scheduler.php | ||
|---|---|---|
|
* @author Jiri Svitak
|
||
|
*/
|
||
|
public function run()
|
||
|
{
|
||
|
{self::logs_partitions_daily(); die();
|
||
|
// script needs to be run from its server machine
|
||
|
|
||
|
if (server::remote_addr() != server::server_addr())
|
||
| ... | ... | |
|
{
|
||
|
$model_log = new Log_Model();
|
||
|
// remove log partition
|
||
|
try
|
||
|
{
|
||
|
$model_log->remove_old_partitions();
|
||
|
}
|
||
|
catch (Exception $ignore)
|
||
|
{ // ignore exception - first 30 days do not have older one..
|
||
|
}
|
||
|
$model_log->remove_old_partitions();
|
||
|
// add partition for today
|
||
|
$model_log->add_partition();
|
||
|
}
|
||
Také k dispozici: Unified diff
Opravy:
- oprava mazani logu akci