Index: backend/pom.xml
===================================================================
--- backend/pom.xml	(revision 49aec502dc66ec833b4b9f2f87ed8e6baa74bab4)
+++ backend/pom.xml	(revision 282b5d6e1720db5c9b799ecbd12f524d10a0133d)
@@ -51,4 +51,10 @@
             <scope>test</scope>
         </dependency>
+        <!-- PostgreSQL JDBC driver -->
+        <dependency>
+            <groupId>org.postgresql</groupId>
+            <artifactId>postgresql</artifactId>
+        </dependency>
+
     </dependencies>
 
Index: backend/src/main/java/com/tradingmk/backend/BackendApplication.java
===================================================================
--- backend/src/main/java/com/tradingmk/backend/BackendApplication.java	(revision 49aec502dc66ec833b4b9f2f87ed8e6baa74bab4)
+++ backend/src/main/java/com/tradingmk/backend/BackendApplication.java	(revision 282b5d6e1720db5c9b799ecbd12f524d10a0133d)
@@ -1,6 +1,10 @@
 package com.tradingmk.backend;
 
+import com.tradingmk.backend.model.Stock;
+import com.tradingmk.backend.repository.StockRepository;
+import org.springframework.boot.CommandLineRunner;
 import org.springframework.boot.SpringApplication;
 import org.springframework.boot.autoconfigure.SpringBootApplication;
+import org.springframework.context.annotation.Bean;
 
 @SpringBootApplication
@@ -9,5 +13,22 @@
     public static void main(String[] args) {
         SpringApplication.run(BackendApplication.class, args);
+
     }
 
+
+//    @Bean
+//    public CommandLineRunner demo(StockRepository repo) {
+//        return args -> {
+//            Stock s = new Stock();
+//            s.setSymbol("ALK");
+//            s.setCurrentPrice(1200.0);
+//            s.setName("Alkaloid");
+//            repo.save(s);
+//        };
+//    }
+
+
+
+
+
 }
Index: backend/src/main/java/com/tradingmk/backend/model/Stock.java
===================================================================
--- backend/src/main/java/com/tradingmk/backend/model/Stock.java	(revision 49aec502dc66ec833b4b9f2f87ed8e6baa74bab4)
+++ backend/src/main/java/com/tradingmk/backend/model/Stock.java	(revision 282b5d6e1720db5c9b799ecbd12f524d10a0133d)
@@ -2,12 +2,10 @@
 
 
-import jakarta.persistence.Entity;
-import jakarta.persistence.GeneratedValue;
-import jakarta.persistence.GenerationType;
-import jakarta.persistence.Id;
+import jakarta.persistence.*;
 
 import java.time.LocalDateTime;
 
 @Entity
+@Table(name = "stock", uniqueConstraints = @UniqueConstraint(columnNames = "symbol"))
 public class Stock {
 
Index: backend/src/main/java/com/tradingmk/backend/model/User.java
===================================================================
--- backend/src/main/java/com/tradingmk/backend/model/User.java	(revision 49aec502dc66ec833b4b9f2f87ed8e6baa74bab4)
+++ backend/src/main/java/com/tradingmk/backend/model/User.java	(revision 282b5d6e1720db5c9b799ecbd12f524d10a0133d)
@@ -1,11 +1,10 @@
 package com.tradingmk.backend.model;
 
-import jakarta.persistence.Entity;
-import jakarta.persistence.GeneratedValue;
-import jakarta.persistence.GenerationType;
-import jakarta.persistence.Id;
+import jakarta.persistence.*;
 
 @Entity
+@Table(name = "users")
 public class User {
+
 
     @Id
Index: backend/src/main/resources/application.yml
===================================================================
--- backend/src/main/resources/application.yml	(revision 49aec502dc66ec833b4b9f2f87ed8e6baa74bab4)
+++ backend/src/main/resources/application.yml	(revision 282b5d6e1720db5c9b799ecbd12f524d10a0133d)
@@ -2,5 +2,5 @@
   datasource:
     url: jdbc:postgresql://localhost:5432/tradingmk
-    username: davor
+    username: postgres
     password: 12345
   jpa:
Index: scraper/scraper.py
===================================================================
--- scraper/scraper.py	(revision 282b5d6e1720db5c9b799ecbd12f524d10a0133d)
+++ scraper/scraper.py	(revision 282b5d6e1720db5c9b799ecbd12f524d10a0133d)
@@ -0,0 +1,60 @@
+import requests
+from bs4 import BeautifulSoup
+
+BASE_URL = "https://www.mse.mk"
+
+
+def get_stock_name(detail_url):
+    response = requests.get(detail_url)
+    soup = BeautifulSoup(response.text, "html.parser")
+
+
+    name_element = soup.select_one(".title")
+    if name_element:
+        return name_element.text.strip()
+
+
+    return "Unknown"
+
+
+def get_stocks():
+    url = f"{BASE_URL}/en"
+    response = requests.get(url)
+    soup = BeautifulSoup(response.text, "html.parser")
+
+    stocks = []
+
+    for row in soup.select(".tab-content-market-summary table tr")[1:]:
+        cols = row.find_all("td")
+        if len(cols) >= 3:
+            symbol_link = cols[0].find("a")
+            if not symbol_link:
+                continue
+
+            symbol = symbol_link.text.strip()
+            detail_path = symbol_link.get("href")
+            detail_url = BASE_URL + detail_path
+
+            name = get_stock_name(detail_url)
+
+
+
+            stock = {
+                "symbol": symbol,
+                "name": name,
+                "currentPrice": float(cols[1].text.strip().replace(",", "")),
+            }
+            stocks.append(stock)
+
+    return stocks
+
+
+def post_to_backend(stocks):
+    url = "http://localhost:8080/api/stocks/update"
+    res = requests.post(url, json=stocks)
+    print(f"Posted {len(stocks)} stocks: {res.status_code}")
+
+
+if __name__ == "__main__":
+    data = get_stocks()
+    post_to_backend(data)