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)
}
Beispiel #2
0
//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)
}
func getNotes(rq rsrq.ListNotesRQ) ([]model.Note, error) {
	db, dbErr := data.GetDataConnection()
	if dbErr != nil {
		log.Fatal(dbErr)
	}
	defer db.Close()

	listQuery := data.SELECT_NOTES_BY_PARENT

	listQuery = strings.Replace(listQuery, "{PARENTID}", rq.ParentId, 1)
	listQuery = strings.Replace(listQuery, "{USERID}", rq.UserToken, 1)
	listQuery = strings.Replace(listQuery, "{STATUS}", strconv.Itoa(rq.Status), 1)

	rows, err := db.Query(listQuery)
	if err != nil {
		return nil, err
	}
	defer rows.Close()
	noteList := []model.Note{}

	for rows.Next() {
		var (
			id       string
			userid   string
			name     string
			parentid string
			content  string
			status   int
			created  int64
			modified int64
		)

		rows.Scan(&id, &userid, &parentid, &name, &content, &status, &created, &modified)

		note := model.Note{id, userid, name, content, status, created, modified, parentid}
		noteList = append(noteList, note)
	}
	rows.Close()

	return noteList, nil
}