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;
//         }
//     });
// });

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 < ?', [0, 500]);
        console.log(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 < ?', [500, 1000]);
        console.log(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 < ?', [1000, 1500]);
        console.log(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 < ?', [1500, 2000]);
        console.log(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 < ?', [2000, 2500]);
        console.log(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 < ?', [2500, 3000]);
        console.log(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 < ?', [3000, 3500]);
        console.log(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 < ?', [4000, 4500]);
        console.log(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 < ?', [4500, 5000]);
        console.log(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 < ?', [5000, 5500]);
        console.log(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 < ?', [5500, 6000]);
        console.log(tenders.length);
        for (const t of tenders) {
            yield ctx.service.tenderCache.refreshTenderCache(t);
            console.log(`complete ${t.name}(${t.id})`);
        }
    });
});