Calculation/db_script/tender_cache.js

'use strict';

/**
 *
 *
 * @author Mai
 * @date
 * @version
 */

const { app, assert } = require('egg-mock/bootstrap');
// const completeTenderCache = async function () {
//     const ctx = app.mockContext();
//     const tenders = await ctx.app.mysql.query('SELECT * FROM zh_tender WHERE id > 0');
//     console.log(tenders.length);
//     for (const t of tenders) {
//         await ctx.service.tenderCache.refreshTenderCache(t);
//         console.log(`complete ${t.name}(${t.id})`);
//     }
// };
// completeTenderCache();

// const depart = 100;
// describe('refreshTenderCache.js', () => {
//     it('refreshTenderCache', function* () {
//         let ctx = app.mockContext();
//         const lastTender = yield ctx.app.mysql.queryOne(`Select * From zh_tender WHERE id > 0 ORDER By id DESC`);
//         let iBegin = 0;
//         while (iBegin < lastTender.id) {
//             ctx = app.mockContext();
//             const tenders = yield ctx.app.mysql.query('SELECT * FROM zh_tender WHERE id > ? and id <= ?', [iBegin, iBegin+depart]);
//             for (const t of tenders) {
//                 yield ctx.service.tenderCache.refreshTenderCache(t);
//                 console.log(`complete ${t.name}(${t.id})`);
//             }
//             iBegin = iBegin + depart;
//         }
//     });
// });
const iBegin = 0;
//const iBegin = 5000;
//const iBegin = 10000;
const tenderRange = [
    [iBegin + 0, iBegin + 500],
    [iBegin + 500, iBegin + 1000],
    [iBegin + 1000, iBegin + 1500],
    [iBegin + 1500, iBegin + 2000],
    [iBegin + 2000, iBegin + 2500],
    [iBegin + 2500, iBegin + 3000],
    [iBegin + 3000, iBegin + 3500],
    [iBegin + 3500, iBegin + 4000],
    [iBegin + 4000, iBegin + 4500],
    [iBegin + 4500, iBegin + 5000]
];

describe('refreshTenderCache.js', () => {
    it('refreshTenderCache', function* () {
        const ctx = app.mockContext();
        const tenders = yield ctx.app.mysql.query('SELECT * FROM zh_tender WHERE id > ? and id <= ?', tenderRange[0]);
        console.log(tenderRange[0], tenders.length);
        for (const t of tenders) {
            yield ctx.service.tenderCache.refreshTenderCache(t);
            console.log(`complete ${t.name}(${t.id})`);
        }
    });
    it('refreshTenderCache', function* () {
        const ctx = app.mockContext();
        const tenders = yield ctx.app.mysql.query('SELECT * FROM zh_tender WHERE id > ? and id <= ?', tenderRange[1]);
        console.log(tenderRange[1], tenders.length);
        for (const t of tenders) {
            yield ctx.service.tenderCache.refreshTenderCache(t);
            console.log(`complete ${t.name}(${t.id})`);
        }
    });
    it('refreshTenderCache', function* () {
        const ctx = app.mockContext();
        const tenders = yield ctx.app.mysql.query('SELECT * FROM zh_tender WHERE id > ? and id <= ?', tenderRange[2]);
        console.log(tenderRange[2], tenders.length);
        for (const t of tenders) {
            yield ctx.service.tenderCache.refreshTenderCache(t);
            console.log(`complete ${t.name}(${t.id})`);
        }
    });
    it('refreshTenderCache', function* () {
        const ctx = app.mockContext();
        const tenders = yield ctx.app.mysql.query('SELECT * FROM zh_tender WHERE id > ? and id <= ?', tenderRange[3]);
        console.log(tenderRange[3], tenders.length);
        for (const t of tenders) {
            yield ctx.service.tenderCache.refreshTenderCache(t);
            console.log(`complete ${t.name}(${t.id})`);
        }
    });
    it('refreshTenderCache', function* () {
        const ctx = app.mockContext();
        const tenders = yield ctx.app.mysql.query('SELECT * FROM zh_tender WHERE id > ? and id <= ?', tenderRange[4]);
        console.log(tenderRange[4], tenders.length);
        for (const t of tenders) {
            yield ctx.service.tenderCache.refreshTenderCache(t);
            console.log(`complete ${t.name}(${t.id})`);
        }
    });
    it('refreshTenderCache', function* () {
        const ctx = app.mockContext();
        const tenders = yield ctx.app.mysql.query('SELECT * FROM zh_tender WHERE id > ? and id <= ?', tenderRange[5]);
        console.log(tenderRange[5], tenders.length);
        for (const t of tenders) {
            yield ctx.service.tenderCache.refreshTenderCache(t);
            console.log(`complete ${t.name}(${t.id})`);
        }
    });
    it('refreshTenderCache', function* () {
        const ctx = app.mockContext();
        const tenders = yield ctx.app.mysql.query('SELECT * FROM zh_tender WHERE id > ? and id <= ?', tenderRange[6]);
        console.log(tenderRange[6], tenders.length);
        for (const t of tenders) {
            yield ctx.service.tenderCache.refreshTenderCache(t);
            console.log(`complete ${t.name}(${t.id})`);
        }
    });
    it('refreshTenderCache', function* () {
        const ctx = app.mockContext();
        const tenders = yield ctx.app.mysql.query('SELECT * FROM zh_tender WHERE id > ? and id <= ?', tenderRange[7]);
        console.log(tenderRange[7], tenders.length);
        for (const t of tenders) {
            yield ctx.service.tenderCache.refreshTenderCache(t);
            console.log(`complete ${t.name}(${t.id})`);
        }
    });
    it('refreshTenderCache', function* () {
        const ctx = app.mockContext();
        const tenders = yield ctx.app.mysql.query('SELECT * FROM zh_tender WHERE id > ? and id <= ?', tenderRange[8]);
        console.log(tenderRange[8], tenders.length);
        for (const t of tenders) {
            yield ctx.service.tenderCache.refreshTenderCache(t);
            console.log(`complete ${t.name}(${t.id})`);
        }
    });
    it('refreshTenderCache', function* () {
        const ctx = app.mockContext();
        const tenders = yield ctx.app.mysql.query('SELECT * FROM zh_tender WHERE id > ? and id <= ?', tenderRange[9]);
        console.log(tenderRange[9], tenders.length);
        for (const t of tenders) {
            yield ctx.service.tenderCache.refreshTenderCache(t);
            console.log(`complete ${t.name}(${t.id})`);
        }
    });
});