Spaces:

lucharo
/

etymology

Running

App Files Files Community

etymology / backend /sql /ingestion /06_create_macros.sql

lucharo

Luis Chaves Rodriguez

Super-squash branch 'main' using huggingface_hub

13812dc 9 months ago

Raw History Blame Contribute Delete

373 Bytes

CREATE OR REPLACE MACRO is_phrase(lexeme) AS
    lexeme LIKE '% %';

CREATE OR REPLACE MACRO is_proper_noun(lexeme) AS
    regexp_matches(lexeme, '^[A-Z][a-z]');

CREATE OR REPLACE MACRO is_clean_word(lexeme) AS
    NOT is_phrase(lexeme) AND NOT is_proper_noun(lexeme);

CREATE OR REPLACE MACRO has_etymology(word_ix) AS
    word_ix IN (SELECT DISTINCT source FROM links);

	CREATE OR REPLACE MACRO is_phrase(lexeme) AS
	lexeme LIKE '% %';

	CREATE OR REPLACE MACRO is_proper_noun(lexeme) AS
	regexp_matches(lexeme, '^[A-Z][a-z]');

	CREATE OR REPLACE MACRO is_clean_word(lexeme) AS
	NOT is_phrase(lexeme) AND NOT is_proper_noun(lexeme);

	CREATE OR REPLACE MACRO has_etymology(word_ix) AS
	word_ix IN (SELECT DISTINCT source FROM links);