summaryrefslogtreecommitdiff
path: root/item/db_actions.go
blob: 36f8364ceb2ca45c7e7a74cf2338549b68581769 (plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
/* OpenBills-server - Server for libre billing software OpenBills-web
 * Copyright (C) 2022  Vidhu Kant Sharma <vidhukant@vidhukant.xyz>

 * This program is free software: you can redistribute it and/or modify
 * it under the terms of the GNU General Public License as published by
 * the Free Software Foundation, either version 3 of the License, or
 * (at your option) any later version.

 * This program is distributed in the hope that it will be useful,
 * but WITHOUT ANY WARRANTY; without even the implied warranty of
 * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
 * GNU General Public License for more details.

 * You should have received a copy of the GNU General Public License
 * along with this program.  If not, see <https://www.gnu.org/licenses/>.
 */

package item

import (
	"context"
	"go.mongodb.org/mongo-driver/bson"
	"go.mongodb.org/mongo-driver/bson/primitive"
	"github.com/MikunoNaka/OpenBills-server/database"
	"github.com/MikunoNaka/OpenBills-server/brand"
	"go.mongodb.org/mongo-driver/mongo"
)

var brands *mongo.Collection = database.DB.Collection("Brands")

// Add item to db
func saveItem(i Item) (primitive.ObjectID, error) {
	res, err := db.InsertOne(context.TODO(), i)
	return res.InsertedID.(primitive.ObjectID), err
}

// Delete item from DB
func deleteItem(id primitive.ObjectID) error {
	_, err := db.DeleteOne(context.TODO(), bson.M{"_id": id})
	return err
}

// modify item in DB
func modifyItem(id primitive.ObjectID, ni Item) error {
	_, err := db.UpdateOne(context.TODO(), bson.D{{"_id", id}}, bson.D{{"$set", ni}})
	return err
}

/* GetItems queries the database and
 * returns items based on the given filter
 * if filter is nil every item is returned
 */
func getItems(filter bson.M) ([]Item, error) {
	var items []Item

	cursor, err := db.Find(context.TODO(), filter)
	if err != nil {
		return items, err
	}

	err = cursor.All(context.TODO(), &items)
	if err != nil {
	    return items, err
	}

	for id, i := range items {
    // continue if item doesn't have a brand
    if (i.Brand.Id == primitive.ObjectID{}) {
      continue
    }

		var b brand.Brand

		err := brands.FindOne(context.TODO(), bson.M{"_id": i.Brand.Id}).Decode(&b)
		if err != nil {
			return items, err
		}
		items[id].Brand = b
	}

	return items, err
}