functions.py 5.19 KB
Newer Older
Timothy J. Baek's avatar
refac  
Timothy J. Baek committed
1
2
3
4
5
6
7
from pydantic import BaseModel
from peewee import *
from playhouse.shortcuts import model_to_dict
from typing import List, Union, Optional
import time
import logging
from apps.webui.internal.db import DB, JSONField
Timothy J. Baek's avatar
Timothy J. Baek committed
8
from apps.webui.models.users import Users
Timothy J. Baek's avatar
refac  
Timothy J. Baek committed
9
10

import json
11
12
import copy

Timothy J. Baek's avatar
refac  
Timothy J. Baek committed
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30

from config import SRC_LOG_LEVELS

log = logging.getLogger(__name__)
log.setLevel(SRC_LOG_LEVELS["MODELS"])

####################
# Functions DB Schema
####################


class Function(Model):
    id = CharField(unique=True)
    user_id = CharField()
    name = TextField()
    type = TextField()
    content = TextField()
    meta = JSONField()
Timothy J. Baek's avatar
Timothy J. Baek committed
31
32
    valves = JSONField()
    is_active = BooleanField(default=False)
Timothy J. Baek's avatar
refac  
Timothy J. Baek committed
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
    updated_at = BigIntegerField()
    created_at = BigIntegerField()

    class Meta:
        database = DB


class FunctionMeta(BaseModel):
    description: Optional[str] = None


class FunctionModel(BaseModel):
    id: str
    user_id: str
    name: str
    type: str
    content: str
    meta: FunctionMeta
Timothy J. Baek's avatar
Timothy J. Baek committed
51
    is_active: bool
Timothy J. Baek's avatar
refac  
Timothy J. Baek committed
52
53
54
55
56
57
58
59
60
61
62
63
    updated_at: int  # timestamp in epoch
    created_at: int  # timestamp in epoch


####################
# Forms
####################


class FunctionResponse(BaseModel):
    id: str
    user_id: str
Timothy J. Baek's avatar
refac  
Timothy J. Baek committed
64
    type: str
Timothy J. Baek's avatar
refac  
Timothy J. Baek committed
65
66
    name: str
    meta: FunctionMeta
Timothy J. Baek's avatar
Timothy J. Baek committed
67
    is_active: bool
Timothy J. Baek's avatar
refac  
Timothy J. Baek committed
68
69
70
71
72
73
74
75
76
77
78
    updated_at: int  # timestamp in epoch
    created_at: int  # timestamp in epoch


class FunctionForm(BaseModel):
    id: str
    name: str
    content: str
    meta: FunctionMeta


Timothy J. Baek's avatar
Timothy J. Baek committed
79
80
81
82
class FunctionValves(BaseModel):
    valves: Optional[dict] = None


Timothy J. Baek's avatar
Timothy J. Baek committed
83
class FunctionsTable:
Timothy J. Baek's avatar
refac  
Timothy J. Baek committed
84
85
86
87
88
    def __init__(self, db):
        self.db = db
        self.db.create_tables([Function])

    def insert_new_function(
Timothy J. Baek's avatar
refac  
Timothy J. Baek committed
89
        self, user_id: str, type: str, form_data: FunctionForm
Timothy J. Baek's avatar
refac  
Timothy J. Baek committed
90
91
92
93
94
    ) -> Optional[FunctionModel]:
        function = FunctionModel(
            **{
                **form_data.model_dump(),
                "user_id": user_id,
Timothy J. Baek's avatar
refac  
Timothy J. Baek committed
95
                "type": type,
Timothy J. Baek's avatar
refac  
Timothy J. Baek committed
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
                "updated_at": int(time.time()),
                "created_at": int(time.time()),
            }
        )

        try:
            result = Function.create(**function.model_dump())
            if result:
                return function
            else:
                return None
        except Exception as e:
            print(f"Error creating tool: {e}")
            return None

    def get_function_by_id(self, id: str) -> Optional[FunctionModel]:
        try:
            function = Function.get(Function.id == id)
            return FunctionModel(**model_to_dict(function))
        except:
            return None

    def get_functions(self) -> List[FunctionModel]:
        return [
            FunctionModel(**model_to_dict(function)) for function in Function.select()
        ]

    def get_functions_by_type(self, type: str) -> List[FunctionModel]:
        return [
            FunctionModel(**model_to_dict(function))
            for function in Function.select().where(Function.type == type)
        ]

Timothy J. Baek's avatar
Timothy J. Baek committed
129
130
131
132
133
    def get_user_valves_by_id_and_user_id(
        self, id: str, user_id: str
    ) -> Optional[dict]:
        try:
            user = Users.get_user_by_id(user_id)
134
            user_settings = user.settings.model_dump()
Timothy J. Baek's avatar
Timothy J. Baek committed
135
136

            # Check if user has "functions" and "valves" settings
137
138
139
140
            if "functions" not in user_settings:
                user_settings["functions"] = {}
            if "valves" not in user_settings["functions"]:
                user_settings["functions"]["valves"] = {}
Timothy J. Baek's avatar
Timothy J. Baek committed
141

142
            return user_settings["functions"]["valves"].get(id, {})
Timothy J. Baek's avatar
Timothy J. Baek committed
143
144
145
146
147
148
149
150
151
        except Exception as e:
            print(f"An error occurred: {e}")
            return None

    def update_user_valves_by_id_and_user_id(
        self, id: str, user_id: str, valves: dict
    ) -> Optional[dict]:
        try:
            user = Users.get_user_by_id(user_id)
152
            user_settings = user.settings.model_dump()
Timothy J. Baek's avatar
Timothy J. Baek committed
153
154

            # Check if user has "functions" and "valves" settings
155
156
157
158
            if "functions" not in user_settings:
                user_settings["functions"] = {}
            if "valves" not in user_settings["functions"]:
                user_settings["functions"]["valves"] = {}
Timothy J. Baek's avatar
Timothy J. Baek committed
159

160
            user_settings["functions"]["valves"][id] = valves
Timothy J. Baek's avatar
Timothy J. Baek committed
161
162

            # Update the user settings in the database
163
            query = Users.update_user_by_id(user_id, {"settings": user_settings})
Timothy J. Baek's avatar
Timothy J. Baek committed
164
165
            query.execute()

166
            return user_settings["functions"]["valves"][id]
Timothy J. Baek's avatar
Timothy J. Baek committed
167
168
169
170
        except Exception as e:
            print(f"An error occurred: {e}")
            return None

Timothy J. Baek's avatar
refac  
Timothy J. Baek committed
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
    def update_function_by_id(self, id: str, updated: dict) -> Optional[FunctionModel]:
        try:
            query = Function.update(
                **updated,
                updated_at=int(time.time()),
            ).where(Function.id == id)
            query.execute()

            function = Function.get(Function.id == id)
            return FunctionModel(**model_to_dict(function))
        except:
            return None

    def delete_function_by_id(self, id: str) -> bool:
        try:
            query = Function.delete().where((Function.id == id))
            query.execute()  # Remove the rows, return number of rows removed.

            return True
        except:
            return False


Timothy J. Baek's avatar
Timothy J. Baek committed
194
Functions = FunctionsTable(DB)