sql/insert_statements.sql - master - kotkov/vvsu_db2024

sql/insert_statements.sql
51 строка3 KB
Arseny Kotkov
Added README.md and SQL-files
17 янв 2025, 08:47
17 янв 2025, 08:47ea391c8
USE `mydb`;

INSERT INTO parameter_type (name) VALUES
('text'),
('string'),
('int');

INSERT INTO agent_type (name) VALUES
('TextAnalyzer'),
('TextTransformer'),
('TextGenerator');

INSERT INTO method (name, agent_type_id) VALUES
('analyze_sentiment', (SELECT id FROM agent_type WHERE name = 'TextAnalyzer')),
('extract_keywords', (SELECT id FROM agent_type WHERE name = 'TextAnalyzer')),
('translate', (SELECT id FROM agent_type WHERE name = 'TextTransformer')),
('summarize', (SELECT id FROM agent_type WHERE name = 'TextTransformer')),
('generate_from_context', (SELECT id FROM agent_type WHERE name = 'TextGenerator'));

INSERT INTO parameter (name, parameter_type_id) VALUES
('text', (SELECT id FROM parameter_type WHERE name = 'text')),
('language', (SELECT id FROM parameter_type WHERE name = 'string')),
('output_format', (SELECT id FROM parameter_type WHERE name = 'string')),
('count', (SELECT id FROM parameter_type WHERE name = 'int')),
('source_language', (SELECT id FROM parameter_type WHERE name = 'string')),
('target_language', (SELECT id FROM parameter_type WHERE name = 'string')),
('length', (SELECT id FROM parameter_type WHERE name = 'int')),
('context', (SELECT id FROM parameter_type WHERE name = 'text')),
('style', (SELECT id FROM parameter_type WHERE name = 'string'));

INSERT INTO parameter_to_method (parameter_id, method_id) VALUES
((SELECT id FROM parameter WHERE name = 'text'), (SELECT id FROM method WHERE name = 'analyze_sentiment')),
((SELECT id FROM parameter WHERE name = 'language'), (SELECT id FROM method WHERE name = 'analyze_sentiment')),
((SELECT id FROM parameter WHERE name = 'output_format'), (SELECT id FROM method WHERE name = 'analyze_sentiment')),
((SELECT id FROM parameter WHERE name = 'text'), (SELECT id FROM method WHERE name = 'extract_keywords')),
((SELECT id FROM parameter WHERE name = 'language'), (SELECT id FROM method WHERE name = 'extract_keywords')),
((SELECT id FROM parameter WHERE name = 'count'), (SELECT id FROM method WHERE name = 'extract_keywords')),
((SELECT id FROM parameter WHERE name = 'text'), (SELECT id FROM method WHERE name = 'translate')),
((SELECT id FROM parameter WHERE name = 'source_language'), (SELECT id FROM method WHERE name = 'translate')),
((SELECT id FROM parameter WHERE name = 'target_language'), (SELECT id FROM method WHERE name = 'translate')),
((SELECT id FROM parameter WHERE name = 'text'), (SELECT id FROM method WHERE name = 'summarize')),
((SELECT id FROM parameter WHERE name = 'length'), (SELECT id FROM method WHERE name = 'summarize')),
((SELECT id FROM parameter WHERE name = 'language'), (SELECT id FROM method WHERE name = 'summarize')),
((SELECT id FROM parameter WHERE name = 'context'), (SELECT id FROM method WHERE name = 'generate_from_context')),
((SELECT id FROM parameter WHERE name = 'length'), (SELECT id FROM method WHERE name = 'generate_from_context')),
((SELECT id FROM parameter WHERE name = 'style'), (SELECT id FROM method WHERE name = 'generate_from_context'));

INSERT INTO agent (name, ip, port, agent_type_id) VALUES
('Analyzer1', '192.168.1.100', 8080, (SELECT id FROM agent_type WHERE name = 'TextAnalyzer')),
('Transformer1', '192.168.1.101', 8081, (SELECT id FROM agent_type WHERE name = 'TextTransformer')),
('Generator1', '192.168.1.102', 8082, (SELECT id FROM agent_type WHERE name = 'TextGenerator'));