我需要让用户添加文字和图片
但是在releaseyear那里就一直显示语法错误找不到问题在哪儿
这是代码:
import sqlite from 'sqlite-async'
import mime from 'mime-types'
import fs from 'fs-extra'
class Contacts {
constructor(dbName = ':memory:'){
return (async() => {
this.db = await sqlite.open(dbName)
const sql = 'CREATE TABLE IF NOT EXISTS contacts(\
id INTEGER PRIMARY KEY AUTOINCREMENT,\
userid INTEGER,\
photo TEXT,\
gamename TEXT NOT NULL,\
publisher TEXT,\
releaseyear TEXT,\
avatar TEXT,\
FOREIGN KEY(userid) REFERENCES users(id)\
);'
await this.db.run(sql)
return this
})()
}
async all() {
const sql = 'SELECT users.user, contacts.* FROM contacts, users\
WHERE contacts.userid = users.id;'
const contacts = await this.db.all(sql)
for(const index in contacts) {
if(contacts[index].photo === null)contacts[index].photo = 'placeholder.jpg'
const dateTime = new Date(contacts[index].lastcontact)
const date = `${dateTime.getDate()}/${dateTime.getMonth()+1}/${dateTime.getFullYear()}`
contacts[index].lastcontact = date
}
return contacts
}
async add(data) {
console.log(data)
let filename
if(data.fileName) {
filename = `${Date.now()}.${mime.extension(data.fileType)}`
console.log(filename)
await fs.copy(data.filePath, `public/images/${filename}`)
}
try {
const sql = `INSERT INTO contacts(userid, gamename, publisher, releaseyear, avatar)\
VALUES(${data.account}, "${data.gamename}", "${data.publisher}"\
"${data.releaseyear}", "${filename}")`
console.log(sql)
await this.db.run(sql)
return true
} catch(err) {
console.log(err)
throw(err)
}
}
async close() {
await this.db.close()
}
}
export default Contacts