1 � 2 3 aK�jI% � 4 � � S r SSKrSSKrSSKrSSKrSSKrSSKr\R R S\R R S5 ( a SOM\R R \R R \R R \5 5 S5 5 rS rS rS rSS jrS S 5 jrS S jrS 6 r\S:X GaG \" \R2 5 S:� a# \R2 S S:X a \" 5 \" S5 g\" \R2 5 S :� a@ \R2 S S:X a- \" \R2 S 5 r\" \R8 " \S S95 g\" \R2 5 S:� a� \R2 S S:X a \" 5 r \ R= 5 r \ RA S5 \ RC 5 S r"\ RA S5 \ RC 5 S r#\ RI 5 \" S\" S\# S35 g\" 5 \" S5 gg) z� 7 Graph-Weighted Memory Engine for Distributed Cognitive Cluster 8 Implements Dynamic Edge Reinforcement, Decay, and Spreading Activation 9 � N�GRAPH_MEMORY_DBz'/var/neural_memory/data/graph_memory.dbz.graph_memory_cache.dbc � � [ R " [ 5 n U R S5 U R S5 [ R U l U $ )NzPRAGMA journal_mode = WAL;zPRAGMA foreign_keys = ON;)�sqlite3�connect�DB_PATH�execute�Row� row_factory)�conns �,/Users/shubhamsharma/project/graph_engine.py�get_dbr 10 s; � � �?�?�7� #�D��L�L�-�.��L�L�,�-� �{�{�D�� �K� c � � [ 5 n U R 5 nUR S5 U R 5 U R 5 g )Na� 11 CREATE TABLE IF NOT EXISTS graph_nodes ( 12 id TEXT PRIMARY KEY, 13 label TEXT NOT NULL, 14 entity_type TEXT NOT NULL, 15 content TEXT NOT NULL, 16 embedding BLOB, 17 importance_score REAL DEFAULT 0.50, 18 access_count INTEGER DEFAULT 1, 19 created_at TEXT NOT NULL, 20 last_accessed_at TEXT NOT NULL 21 ); 22 23 CREATE TABLE IF NOT EXISTS graph_edges ( 24 source_id TEXT NOT NULL, 25 target_id TEXT NOT NULL, 26 relation TEXT NOT NULL, 27 weight REAL DEFAULT 0.80, 28 confidence REAL DEFAULT 1.00, 29 last_reinforced_at TEXT NOT NULL, 30 decay_rate REAL DEFAULT 0.005, 31 PRIMARY KEY (source_id, target_id, relation), 32 FOREIGN KEY (source_id) REFERENCES graph_nodes(id) ON DELETE CASCADE, 33 FOREIGN KEY (target_id) REFERENCES graph_nodes(id) ON DELETE CASCADE 34 ); 35 36 CREATE TABLE IF NOT EXISTS graph_episodes ( 37 id INTEGER PRIMARY KEY AUTOINCREMENT, 38 title TEXT NOT NULL, 39 context TEXT NOT NULL, 40 actions TEXT NOT NULL, 41 outcome TEXT NOT NULL, 42 root_node_id TEXT, 43 timestamp TEXT NOT NULL, 44 FOREIGN KEY (root_node_id) REFERENCES graph_nodes(id) ON DELETE SET NULL 45 ); 46 47 CREATE TABLE IF NOT EXISTS graph_skills ( 48 name TEXT PRIMARY KEY, 49 trigger_pattern TEXT NOT NULL, 50 command_template TEXT NOT NULL, 51 description TEXT NOT NULL, 52 associated_node_id TEXT, 53 FOREIGN KEY (associated_node_id) REFERENCES graph_nodes(id) ON DELETE SET NULL 54 ); 55 56 CREATE INDEX IF NOT EXISTS idx_nodes_type ON graph_nodes(entity_type); 57 CREATE INDEX IF NOT EXISTS idx_edges_source ON graph_edges(source_id); 58 CREATE INDEX IF NOT EXISTS idx_edges_target ON graph_edges(target_id); 59 )r 60 �cursor� 61 executescript�commit�close)r �cs r �init_dbr s: � � �8�D� � � � 62 �A��O�O� 1� 1 �d �K�K�M��J�J�Lr c � � [ R R [ R R 5 R 5 $ )N)�datetime�now�timezone�utc� isoformat� r r �now_isor R s. � � � � � � ��!2�!2�!6�!6� 7� A� A� C�Cr c 63 � � [ 5 nUR 5 n[ 5 nUR SXX#XGU45 UR 5 UR 5 g )Na� 64 INSERT INTO graph_nodes (id, label, entity_type, content, importance_score, access_count, created_at, last_accessed_at) 65 VALUES (?, ?, ?, ?, ?, 1, ?, ?) 66 ON CONFLICT(id) DO UPDATE SET 67 label=excluded.label, 68 entity_type=excluded.entity_type, 69 content=excluded.content, 70 importance_score=excluded.importance_score, 71 access_count=access_count+1, 72 last_accessed_at=excluded.last_accessed_at; 73 �r 74 r r r r r )�node_id�label� entity_type�content� 75 importancer r �ts r �add_noder& U sO � � �8�D� � � � 76 �A�� �A��I�I� 77 � �+� 78 �q� A� 79 C� �K�K�M��J�J�Lr c � � [ 5 nUR 5 n[ 5 nUR SXX#XG45 UR 5 UR 5 g )Na& 80 INSERT INTO graph_edges (source_id, target_id, relation, weight, confidence, last_reinforced_at) 81 VALUES (?, ?, ?, ?, ?, ?) 82 ON CONFLICT(source_id, target_id, relation) DO UPDATE SET 83 weight=MIN(1.0, weight + 0.15), 84 last_reinforced_at=excluded.last_reinforced_at; 85 r )� source_id� target_id�relation�weight� 86 confidencer r r% s r �add_edger- g sM � � �8�D� � � � 87 �A�� �A��I�I� � ��*� @� 88 B� �K�K�M��J�J�Lr � c 89 �\ � [ 5 nUR 5 n0 n/ nU SS4/nU( a� UR S5 u p�n X�; a 90 Xi U 91 :� a M* X�U ' UR S[ 5 U 45 X�:� a MQ UR SU 45 UR 5 Hf u p�nX�- U- nX�:� d M UR 92 X�U [ US5 S.5 UR 93 X�U S- 45 UR S[ 5 X�U 94 45 Mh U( a M� UR 5 / n[ UR 5 S S 95 S 9 H] u nn 96 UR S U45 UR 5 nU( d M2 [ U5 n[ U 97 S5 US 98 ' UR 99 U5 M_ UR 5 UUS.$ )N� �?r zQUPDATE graph_nodes SET access_count=access_count+1, last_accessed_at=? WHERE id=?zESELECT target_id, relation, weight FROM graph_edges WHERE source_id=?� )�from�rel�tor+ � zzUPDATE graph_edges SET weight=MIN(1.0, weight+0.05), last_reinforced_at=? WHERE source_id=? AND target_id=? AND relation=?c � � U S $ )Nr5 r )�xs r �<lambda>�#spread_activation.<locals>.<lambda>� s � �1�Q�4r T)�key�reversezTSELECT id, label, entity_type, content, importance_score FROM graph_nodes WHERE id=?�activation_energy)�nodes�edges)r 100 r �popr r �fetchall�append�roundr �sorted�items�fetchone�dictr )�seed_id� max_depth�decay� thresholdr r � 101 visited_nodes� 102 visited_edges�queue�curr_id�energy�depthr) r3 r+ � next_energy� 103 nodes_data�nid�row�ds r �spread_activationrV u s� � � �8�D� � � � 104 �A��M��M��s�A� 105 � �E� 106 �!&���1� � ��� � #� 107 �(>�&�(H� �!'�g� � 108 � � �e�ho�hq�sz�g{�|� � � � � � �Y�\c�[e�f�&'�j�j�l� "�I�F� �/�E�1�K��'� �$�$�g��^c�dj�lm�^n�%o�p�� � �i�e�a�i� @�A�� � � W�"�9�g�#�>�@� 109 '3� �%�, �K�K�M� �J� �m� 1� 1� 3� �QU�V� ��V� � � �h�kn�jp�q��j�j�l�� �3��S� �A�%*�6�1�%5�A�!� "� � � �a� � 110 W� �J�J�L� �-� 8�8r c � � [ 5 / SQn U H u pp4n[ XX4U5 M / SQnU H u pxp�[ XxX�5 M g )N))� node_masterzApple Silicon Mac (Master)�hostzFPrimary cognitive controller, runs DeepSeek-R1 inference on Metal GPU.r0 )� node_dellz"Dell Inspiron 3521 (Tactical Body)rY zN24/7 headless execution worker, persistent memory anchor, mass storage server.r0 )�vol_ssdz Internal ADATA SSD (/dev/sda3)�storagez;146 GB ext4, root OS volume and L1 hot memory graph anchor.�ffffff�?)� vol_d_drivez&Protected Personal Drive D (/dev/sda5)r\ zO77.1 GB NTFS, contains critical non-recoverable operator data. ROE-01 Enforced.r0 )�vol_hdd1z Mass Storage HDD 1 (/dev/sdb1)r\ zC931.5 GB NTFS mounted at /mnt/hdd1 (L2 warm semantic vector store).��������?)�vol_hdd2z Mass Storage HDD 2 (/dev/sdc1)r\ zD931.5 GB Mass storage mounted at /mnt/hdd2 (L3 cold archival vault).r` )� 111 hw_gpu_amdzAMD Radeon HD 8730M�hardwarezKDiscrete GPU with 2GB VRAM, driver amdgpu, render node /dev/dri/renderD129.�333333�?)� hw_gpu_intelzIntel HD Graphics 4000rc zFIntegrated display core, driver i915, render node /dev/dri/renderD128.gffffff�?)�hw_cpuzIntel Core i5-3337Urc z2Ivy Bridge, 2C/4T, 1.80-2.70GHz, AVX, VT-x active.rd )� 112 rule_roe01zROE-01: Sanctity of Drive D�policyz]Under no circumstances may /dev/sda5 be modified, partitioned, or written to. Read-only only.r0 )� 113 rule_caffeinez"Power: Permanent Caffeinate Policyrh z[Systemd sleep, suspend, and hibernate targets masked to /dev/null; wifi powersave disabled.r] )�skill_caffeinate� 114 caffeinate�skillzTsudo systemctl mask sleep.target suspend.target hibernate.target hybrid-sleep.targetr` )�skill_test_gpu�test_gpurl z3cat /sys/class/drm/card1/device/mem_info_vram_total皙�����?)�picoclaw_daemonzPicoClaw Gateway�agentzIUltra-lightweight Go agent daemon running 24/7 in under 10MB RAM on Dell.r] ) 115 )rX rZ �COMMANDSr0 )rZ r[ �CONTAINSr0 )rZ r^ �PROTECTSr0 )rZ r_ �MOUNTSr] )rZ ra ru r] )rZ rb rs r] )rZ re rs ro )rZ rf rs r] )rZ rp �HOSTSr0 )rg r^ �GOVERNSr0 )ri rZ rt r0 )rj ri � 116 IMPLEMENTSr] )rm rb �AUDITSr` )r r& r- ) r= rS �lbl�etype�cnt�impr> �sr% �r�ws r � 117 seed_baseliner� � sN � � �I� 118 �E� &+�!��%�c���5�s�+� &+� 119 �E� � 120 ��a���q� � r �__main__r5 �seed�#GRAPH_MEMORY_INITIALIZED_AND_SEEDED�query)�indent�statusz!SELECT COUNT(*) FROM graph_nodes;z!SELECT COUNT(*) FROM graph_edges;zGraph Status: z Nodes, z Edges�GRAPH_DB_VERIFIED)g �?)ro r0 )r. g �?g �?)%�__doc__r r �math�sys�os�json�environ�get�path�exists�join�dirname�abspath�__file__r r 121 r r r& r- rV r� �__name__�len�argv�print�subgraph�dumpsr r r r rE �nn�ner r r r �<module>r� s� ��� � � � 122 � � � 123 �*�*�.�.��13��� � �@i�1j�1j�-� ��� � �b�g�g�o�o�b�g�g�o�o�h�&?�@�BZ� [� �� �6�pD��$ � +9�Z' �R �z�� 124 �3�8�8�}�q��S�X�X�a�[�F� 2��� 125 �3�4� �S�X�X� �� �s�x�x��{�g� 5�$�S�X�X�a�[�1�� 126 �d�j�j��!�,�-� �S�X�X� �� �s�x�x��{�h� 6��x�� �K�K�M�� � � �5�6� 127 �Z�Z�\�!�_�� � � �5�6� 128 �Z�Z�\�!�_�� � 129 � 130 � � 131 ��r�d�(�2�$�f�5�6�� � 132 �!�"�% r