async function run() { const connection = await createConnection(config.db); await insertAdmin(connection); await insertCrawler(connection); logger.info({ message: 'init db done' }); process.exit(0); }()
async function run() { const connection = await createConnection(config.db); await addColumn(connection); // tslint:disable-next-line: no-console console.log('----------------- all done -----------------'); process.exit(0); }()
async function run() { const connection = await createConnection(config.db); const [ followerCountArr, followCountArr ] = await Promise.all([ queryFollowerCount(connection), queryFollowCount(connection), ]); const userMap: { [user_id: number]: { follower_count: number, follow_count: number } } = {}; followerCountArr.forEach(data => { userMap[data.user_id] = userMap[data.user_id] || { follower_count: 0, follow_count: 0 }; userMap[data.user_id].follower_count = parseInt(data.follower_count, 10) || 0; }); followCountArr.forEach(data => { userMap[data.user_id] = userMap[data.user_id] || { follower_count: 0, follow_count: 0 }; userMap[data.user_id].follow_count = parseInt(data.follow_count, 10) || 0; }); await updateUserFollowerCount(connection, userMap); logger.info({ message: '[cron] user_follower_count done' }); process.exit(0); }()
async function run() { const connection = await createConnection(config.db); const arr = await Promise.all([ queryUserLikedCount(connection, 'like_article_comments'), queryUserLikedCount(connection, 'like_boiling_comments'), queryUserLikedCount(connection, 'like_bookchapter_comments'), queryUserLikedCount(connection, 'like_articles'), queryUserLikedCount(connection, 'like_boilingpoints'), ]); const userLikedMap: { [user_id: number]: number } = {}; arr.forEach(likedArr => { if (likedArr) { likedArr.forEach(data => { userLikedMap[data.user_id] = userLikedMap[data.user_id] || 0; userLikedMap[data.user_id] += data.liked_count; }); } }); await updateUserLikedCount(connection, userLikedMap); logger.info({ message: '[cron] user_liked_count done' }); process.exit(0); }()
async function run() { const connection = await createConnection(config.db); const [ articleCountArr, articleViewCountArr ] = await Promise.all([ queryUserArticleCount(connection), queryUserArticleViewCount(connection), ]); const userMap: { [user_id: number]: { article_count: number, article_view_count: number } } = {}; articleCountArr.forEach(data => { userMap[data.user_id] = userMap[data.user_id] || { article_count: 0, article_view_count: 0 }; userMap[data.user_id].article_count = parseInt(data.article_count, 10) || 0; }); articleViewCountArr.forEach(data => { userMap[data.user_id] = userMap[data.user_id] || { article_count: 0, article_view_count: 0 }; userMap[data.user_id].article_view_count = parseInt(data.article_view_count, 10) || 0; }); await updateUserArticleCount(connection, userMap); logger.info({ message: '[cron] user_article_count done' }); process.exit(0); }()
const openConnection: any = async () => { const config = process.env.IS_PROD ? configProd : configDev; return await createConnection(config); }
async register() { const knexConfig = this.knexConfig() const typeorm = require("typeorm") const createConnection = typeorm.createConnection const Address = require('../orms/models/typeorm/Address') const Contact = require('../orms/models/typeorm/Contact') const Email = require('../orms/models/typeorm/Email') const Phone = require('../orms/models/typeorm/Phone') const typeConn = await createConnection({ type: "postgres", host: knexConfig.connection.host,
async function getConnection() { return await typeorm.createConnection({ type: "mysql", host: "localhost", port: 3306, username: "root", password: "password", database: "setuptourist", synchronize: true, logging: false, entities: [ CreatorSchema ] }) }