<commit_before>-- SETUP
INSERT INTO pshai.focal_mechanism(owner_id, gid, strike, dip, rake) VALUES(1, 'focal_mechanism/1', 351.0, 81.0, 171.0);
INSERT INTO pshai.focal_mechanism(owner_id, gid, strike, dip, rake) VALUES(1, 'focal_mechanism/2', 359.0, 89.0, 179.0);

INSERT INTO pshai.mfd_evd(owner_id, gid, min_val, bin_size, mfd_values) VALUES(1, 'mfd_evd/1', 1.0, 2.0, ARRAY[3.0, 4.0, 5.0]);

INSERT INTO pshai.mfd_tgr(owner_id, gid, min_val, max_val, a_val, b_val) VALUES(1, 'mfd_tgr/1', 2.0, 3.0, 4.0, 5.0);

INSERT INTO pshai.simple_fault(owner_id, gid, dip, upper_depth, lower_depth, edge, mfd_tgr_id) VALUES (1, 'sfault/1', 22.0, 77.0, 55.0, ST_GeomFromEWKT('SRID=4326;LINESTRING(-80 28 11,-90 29 9)'), 1);

INSERT INTO pshai.rupture(owner_id, gid, tectonic_region, rake, magnitude, simple_fault_id) SELECT 1, 'rupture/1', 'volcanic', 11.0, 7.6, sfault.id from pshai.simple_fault AS sfault WHERE gid='sfault/1';

INSERT INTO pshai.source(owner_id, gid, tectonic_region, rake, simple_fault_id) SELECT 1, 'source/1', 'intraslab', 11.0, sfault.id from pshai.simple_fault AS sfault WHERE gid='sfault/1';

INSERT INTO pshai.fault_edge(owner_id, gid, top, bottom) VALUES (1, 'fedge/sa/ca/1', ST_GeomFromEWKT('SRID=4326;LINESTRING(-120.461303711 35.9206581116 0.0, -120.462242126 35.9214630127 0.0, -120.462997437 35.9219589233 0.0, -120.463157654 35.9221496582 0.0, -120.463905334 35.9226875305 0.0, -120.465263367 35.9240570068 0.0, -120.466148376 35.9249572754 0.0, -120.466781616 35.9255218506 0.0, -120.467506409 35.9260063171 0.0, -120.468315125 35.9265556335 0.0, -120.468963623 35.9270782471 0.0, -120.469696045 35.9276847839 0.0, -120.469978333 35.9279708862 0.0, -120.470245361 35.9282913208 0.0, -120.470916748 35.9289436340 0.0, -120.471824646 35.9299125671 0.0, -120.472145081 35.9302787781 0.0, -120.472526550 35.9305877686 0.0, -120.473251343 35.9311904907 0.0, -120.474563599 35.9323844910 0.0)'), ST_GeomFromEWKT('SRID=4326;LINESTRING(-120.528236389 35.9759864807 1.87, -120.528327942 35.9760551453 1.87, -120.528457642 35.9761276245 1.87, -120.528625488 35.9762077332 1.87, -120.528732300 35.9762687683 1.87, -120.528808594 35.9763259888 1.87, -120.528892517 35.9764175415 1.87, -120.528976440 35.9765510559 1.87, -120.529029846 35.9766464233 1.87, -120.529129028 35.9767761230 1.87, -120.529235840 35.9769020081 1.87, -120.529350281 35.9770011902 1.87, -120.529510498 35.9771270752 1.87, -120.529640198 35.9772224426 1.87, -120.529785156 35.9773674011 1.87)'));

INSERT INTO pshai.complex_fault(owner_id, gid, mfd_evd_id, fault_edge_id) SELECT 1, 'src/cfault/sa/ca/1', 1, fedge.id FROM pshai.fault_edge AS fedge WHERE gid='fedge/sa/ca/1';

INSERT INTO pshai.source(owner_id, gid, si_type, tectonic_region, complex_fault_id) SELECT 1, 'complex-source/sa/ca/10', 'complex', 'active', cfault.id FROM pshai.complex_fault cfault WHERE gid='src/cfault/sa/ca/1';

INSERT INTO pshai.r_rate_mdl(owner_id, gid, mfd_tgr_id, focal_mechanism_id, source_id) SELECT 1, 'src/1/r_rate_mdl/1', 1, 1, src.id FROM pshai.source AS src WHERE gid='complex-source/sa/ca/10';
<commit_msg>revised test data<commit_after>-- SETUP
INSERT INTO pshai.focal_mechanism(owner_id, gid, strike, dip, rake) VALUES(1, 'focal_mechanism/1', 351.0, 81.0, 171.0);
INSERT INTO pshai.focal_mechanism(owner_id, gid, strike, dip, rake) VALUES(1, 'focal_mechanism/2', 359.0, 89.0, 179.0);

INSERT INTO pshai.mfd_evd(owner_id, min_val, bin_size, mfd_values) VALUES(1, 1.0, 2.0, ARRAY[3.0, 4.0, 5.0]);

INSERT INTO pshai.mfd_tgr(owner_id, min_val, max_val, a_val, b_val) VALUES(1, 2.0, 3.0, 4.0, 5.0);

INSERT INTO pshai.simple_fault(owner_id, gid, dip, upper_depth, lower_depth, edge, mfd_tgr_id) VALUES (1, 'sfault/1', 22.0, 77.0, 55.0, ST_GeomFromEWKT('SRID=4326;LINESTRING(-80 28 11,-90 29 9)'), 1);

INSERT INTO pshai.rupture(owner_id, gid, tectonic_region, rake, magnitude, simple_fault_id) SELECT 1, 'rupture/1', 'volcanic', 11.0, 7.6, sfault.id from pshai.simple_fault AS sfault WHERE gid='sfault/1';

INSERT INTO pshai.source(owner_id, gid, tectonic_region, rake, simple_fault_id) SELECT 1, 'source/1', 'intraslab', 11.0, sfault.id from pshai.simple_fault AS sfault WHERE gid='sfault/1';

INSERT INTO pshai.fault_edge(owner_id, gid, top, bottom) VALUES (1, 'fedge/sa/ca/1', ST_GeomFromEWKT('SRID=4326;LINESTRING(-120.461303711 35.9206581116 0.0, -120.462242126 35.9214630127 0.0, -120.462997437 35.9219589233 0.0, -120.463157654 35.9221496582 0.0, -120.463905334 35.9226875305 0.0, -120.465263367 35.9240570068 0.0, -120.466148376 35.9249572754 0.0, -120.466781616 35.9255218506 0.0, -120.467506409 35.9260063171 0.0, -120.468315125 35.9265556335 0.0, -120.468963623 35.9270782471 0.0, -120.469696045 35.9276847839 0.0, -120.469978333 35.9279708862 0.0, -120.470245361 35.9282913208 0.0, -120.470916748 35.9289436340 0.0, -120.471824646 35.9299125671 0.0, -120.472145081 35.9302787781 0.0, -120.472526550 35.9305877686 0.0, -120.473251343 35.9311904907 0.0, -120.474563599 35.9323844910 0.0)'), ST_GeomFromEWKT('SRID=4326;LINESTRING(-120.528236389 35.9759864807 1.87, -120.528327942 35.9760551453 1.87, -120.528457642 35.9761276245 1.87, -120.528625488 35.9762077332 1.87, -120.528732300 35.9762687683 1.87, -120.528808594 35.9763259888 1.87, -120.528892517 35.9764175415 1.87, -120.528976440 35.9765510559 1.87, -120.529029846 35.9766464233 1.87, -120.529129028 35.9767761230 1.87, -120.529235840 35.9769020081 1.87, -120.529350281 35.9770011902 1.87, -120.529510498 35.9771270752 1.87, -120.529640198 35.9772224426 1.87, -120.529785156 35.9773674011 1.87)'));

INSERT INTO pshai.complex_fault(owner_id, gid, mfd_evd_id, fault_edge_id) SELECT 1, 'src/cfault/sa/ca/1', 1, fedge.id FROM pshai.fault_edge AS fedge WHERE gid='fedge/sa/ca/1';

INSERT INTO pshai.source(owner_id, gid, si_type, tectonic_region, complex_fault_id) SELECT 1, 'complex-source/sa/ca/10', 'complex', 'active', cfault.id FROM pshai.complex_fault cfault WHERE gid='src/cfault/sa/ca/1';

INSERT INTO pshai.r_rate_mdl(owner_id, gid, mfd_tgr_id, focal_mechanism_id, source_id) SELECT 1, 'src/1/r_rate_mdl/1', 1, 1, src.id FROM pshai.source AS src WHERE gid='complex-source/sa/ca/10';

{'fraction_non_alphanumeric': 0.15073409461663947, 'fraction_numerical': 0.3386623164763458, 'mean_word_length': 5.004897159647404, 'pattern_counts': {'":': 0, '<': 3, '<?xml version=': 0, '>': 3, 'https://': 0, 'lorem ipsum': 0, 'www.': 0, 'xml': 0}, 'pii_count': 0, 'substrings_counts': 0, 'word_list_counts': {'cursed_substrings.json': 0, 'profanity_word_list.json': 0, 'sexual_word_list.json': 0, 'zh_pornsignals.json': 0}}
{'dir': 'git-commits-cleaned', 'id': '80450', 'n_tokens_mistral': 4156, 'n_tokens_neox': 2839, 'n_words': 564}