func archiveNote(rq rsrq.ArchiveNoteRQ) error {
db, dbErr := data.GetDataConnection()
if dbErr != nil {
log.Fatal(dbErr)
}
defer db.Close()
archiveNoteUpdate := data.ARCHIVE_NOTE_UPDATE
archiveNoteUpdate = strings.Replace(archiveNoteUpdate, "{ID}", rq.NoteId, 1)
archiveNoteUpdate = strings.Replace(archiveNoteUpdate, "{USERID}", rq.UserToken, 1)
return data.ExecStatement(db, archiveNoteUpdate)
}
//TODO add this to Note Data Controller (DAO / Registry)
func insertNewNote(user string, noteId string, parentId string) error {
db, dbErr := data.GetDataConnection()
if dbErr != nil {
log.Fatal(dbErr)
}
defer db.Close()
insertQuery := data.INSERT_NOTE
insertQuery = strings.Replace(insertQuery, "{ID}", noteId, 1)
insertQuery = strings.Replace(insertQuery, "{PARENTID}", parentId, 1)
insertQuery = strings.Replace(insertQuery, "{NAME}", "New Note", 1) //todo constant for new note name
insertQuery = strings.Replace(insertQuery, "{CONTENT}", "", 1)
insertQuery = strings.Replace(insertQuery, "{STATUS}", strconv.Itoa(data.NEW), 1)
insertQuery = strings.Replace(insertQuery, "{CREATED}", strconv.FormatInt(time.Now().UnixNano(), 10), 1)
insertQuery = strings.Replace(insertQuery, "{MODIFIED}", strconv.FormatInt(time.Now().UnixNano(), 10), 1)
insertQuery = strings.Replace(insertQuery, "{USERID}", user, 1) //TODO put in order
return data.ExecStatement(db, insertQuery)
}