import sqlite3

class CustomerSearchModel:
    def __init__(self, db_path="z:/beta_desktop/db/beta_sb_pos_sqlite.db"):
        self.db_path = db_path

    def load_all_customers(self):
        conn = sqlite3.connect(self.db_path)
        conn.row_factory = sqlite3.Row
        cursor = conn.cursor()
        cursor.execute("SELECT id, nama, alamat_1, tlp_1 FROM per_customers")
        results = cursor.fetchall()
        conn.close()

        return [dict(row) for row in results]