waveform/server/db/seed.js
2019-04-10 22:51:35 -04:00

68 lines
1.1 KiB
JavaScript
Executable File

const db = require('../db')
const { Vote, Comment, User } = require('./models')
const testComment = {
secs: 82,
text: 'this is a great song!',
}
const tsvote = {
upvote: 1,
downvote: 0,
userId: 1
}
const downvote = {
upvote: 0,
downvote: 1,
userId: 3
}
const upvote = {
upvote: 0,
downvote: 1,
userId: 4
}
const nnvote = {
upvote: 1,
downvote: 0,
userId: 2
}
const testUser = {
name: 'tsr'
}
const testUser2 = {
name: 'notnull'
}
const testUser3 = {
name: 'anon'
}
const testUser4 = {
name: 'm'
}
async function runSeed() {
await db.sync({ force: true })
console.log('db synced!')
console.log('seeding...')
try {
await User.bulkCreate([testUser, testUser2, testUser3, testUser4])
await Vote.bulkCreate([upvote, downvote, tsvote, nnvote])
const comment = await Comment.create(testComment)
await comment.setUser(2)
await comment.addVotes([1,2,3,4])
console.log('seeded successfully')
} catch (err) {
console.error(err)
process.exitCode = 1
} finally {
console.log('closing db connection')
await db.close()
console.log('db connection closed')
}
}
runSeed()