/search.css" rel="stylesheet" type="text/css"/> /search.js">
| Classes | Job Modules | Data Objects | Services | Algorithms | Tools | Packages | Directories | Tracs |

In This Package:

Classes | Variables
DybDbi::cleaner Namespace Reference

Classes

class  DbiCleaner

Variables

tuple log = logging.getLogger(__name__)
tuple db = DB( os.environ['DBCONF'] )
tuple dc = DbiCleaner( db, src, tgt )

Detailed Description

Try to cleanup a DBI pair using DybDbi ...

    1) create CalibFeeSpecCleanup pair using DybDbi
    2) migrate useful entries from CalibFeeSpec into it
       (DBI will give them new SEQNO)
    3) drop CalibFeeSpec (or rename to CalibFeeSpecToBeDropped)
    4) rename CalibFeeSpecCleanup to CalibFeeSpec
    5) fixups in LOCALSEQNO to accommodate table renaming


mysql> select * from CalibFeeSpecCleanupVld order by VERSIONDATE limit 10 ;
+-------+---------------------+---------------------+----------+---------+---------+------+-------------+---------------------+---------------------+
| SEQNO | TIMESTART           | TIMEEND             | SITEMASK | SIMMASK | SUBSITE | TASK | AGGREGATENO | VERSIONDATE         | INSERTDATE          |
+-------+---------------------+---------------------+----------+---------+---------+------+-------------+---------------------+---------------------+
|     1 | 2010-01-07 05:37:16 | 2038-01-19 03:14:07 |       32 |       1 |       1 |    0 |          -1 | 2010-01-07 13:37:16 | 2011-06-16 08:46:43 | 
|     2 | 2010-01-07 05:37:16 | 2038-01-19 03:14:07 |       32 |       1 |       1 |    0 |          -1 | 2010-01-07 13:38:16 | 2011-06-16 08:46:43 | 
|     3 | 2010-01-07 05:37:16 | 2038-01-19 03:14:07 |       32 |       1 |       1 |    0 |          -1 | 2010-01-07 13:39:16 | 2011-06-16 08:46:43 | 
|     4 | 2010-01-07 05:37:16 | 2038-01-19 03:14:07 |       32 |       1 |       1 |    0 |          -1 | 2010-01-07 13:40:16 | 2011-06-16 08:46:43 | 
|     5 | 2010-01-07 05:37:16 | 2038-01-19 03:14:07 |       32 |       1 |       1 |    0 |          -1 | 2010-01-07 13:41:16 | 2011-06-16 08:46:43 | 
|     6 | 2010-01-07 05:37:16 | 2038-01-19 03:14:07 |       32 |       1 |       1 |    0 |          -1 | 2010-01-07 13:42:16 | 2011-06-16 08:46:43 | 
|     7 | 2010-01-07 05:37:16 | 2038-01-19 03:14:07 |       32 |       1 |       1 |    0 |          -1 | 2010-01-07 13:43:16 | 2011-06-16 08:46:43 | 
|     8 | 2010-01-07 05:37:16 | 2038-01-19 03:14:07 |       32 |       1 |       1 |    0 |          -1 | 2010-01-07 13:44:16 | 2011-06-16 08:46:43 | 
|     9 | 2010-01-07 05:37:16 | 2038-01-19 03:14:07 |       32 |       1 |       1 |    0 |          -1 | 2010-01-07 13:45:16 | 2011-06-16 08:46:43 | 
|    10 | 2010-01-07 05:37:16 | 2038-01-19 03:14:07 |       32 |       1 |       1 |    0 |          -1 | 2010-01-07 13:46:16 | 2011-06-16 08:46:43 | 
+-------+---------------------+---------------------+----------+---------+---------+------+-------------+---------------------+---------------------+
10 rows in set (0.00 sec)

mysql> select * from CalibFeeSpecVld order by VERSIONDATE limit 10 ;
+-------+---------------------+---------------------+----------+---------+---------+------+-------------+---------------------+---------------------+
| SEQNO | TIMESTART           | TIMEEND             | SITEMASK | SIMMASK | SUBSITE | TASK | AGGREGATENO | VERSIONDATE         | INSERTDATE          |
+-------+---------------------+---------------------+----------+---------+---------+------+-------------+---------------------+---------------------+
|     4 | 2010-01-07 05:37:16 | 2038-01-19 03:14:07 |       32 |       1 |       1 |    0 |          -1 | 2010-01-07 13:37:16 | 2010-03-10 17:36:31 | 
|     5 | 2010-01-07 05:37:16 | 2038-01-19 03:14:07 |       32 |       1 |       1 |    0 |          -1 | 2010-01-07 13:38:16 | 2010-03-10 17:36:31 | 
|     6 | 2010-01-07 05:37:16 | 2038-01-19 03:14:07 |       32 |       1 |       1 |    0 |          -1 | 2010-01-07 13:39:16 | 2010-03-10 17:36:31 | 
|     7 | 2010-01-07 05:37:16 | 2038-01-19 03:14:07 |       32 |       1 |       1 |    0 |          -1 | 2010-01-07 13:40:16 | 2010-03-10 17:36:31 | 
|     8 | 2010-01-07 05:37:16 | 2038-01-19 03:14:07 |       32 |       1 |       1 |    0 |          -1 | 2010-01-07 13:41:16 | 2010-03-10 17:36:31 | 
|     9 | 2010-01-07 05:37:16 | 2038-01-19 03:14:07 |       32 |       1 |       1 |    0 |          -1 | 2010-01-07 13:42:16 | 2010-03-10 17:36:31 | 
|    10 | 2010-01-07 05:37:16 | 2038-01-19 03:14:07 |       32 |       1 |       1 |    0 |          -1 | 2010-01-07 13:43:16 | 2010-03-10 17:36:31 | 
|    11 | 2010-01-07 05:37:16 | 2038-01-19 03:14:07 |       32 |       1 |       1 |    0 |          -1 | 2010-01-07 13:44:16 | 2010-03-10 17:36:31 | 
|    12 | 2010-01-07 05:37:16 | 2038-01-19 03:14:07 |       32 |       1 |       1 |    0 |          -1 | 2010-01-07 13:45:16 | 2010-03-10 17:36:31 | 
|    13 | 2010-01-07 05:37:16 | 2038-01-19 03:14:07 |       32 |       1 |       1 |    0 |          -1 | 2010-01-07 13:46:16 | 2010-03-10 17:36:31 | 
+-------+---------------------+---------------------+----------+---------+---------+------+-------------+---------------------+---------------------+
10 rows in set (0.00 sec)



Variable Documentation

Definition at line 49 of file cleaner.py.

tuple DybDbi::cleaner::db = DB( os.environ['DBCONF'] )

Definition at line 153 of file cleaner.py.

Definition at line 154 of file cleaner.py.

| Classes | Job Modules | Data Objects | Services | Algorithms | Tools | Packages | Directories | Tracs |

Generated on Fri May 16 2014 09:57:24 for DybDbi by doxygen 1.7.4