mirror of
https://github.com/FlipsideCrypto/bsc-models.git
synced 2026-02-06 14:26:53 +00:00
dd035795e1
* tested new package updates * update package version and re-point macros + tests * missed decode logs delete * update package 1.4.1 --------- Co-authored-by: drethereum <trevor.wenokur@gmail.com>
20 lines
589 B
SQL
20 lines
589 B
SQL
{% macro create_udfs() %}
|
|
{% if var("UPDATE_UDFS_AND_SPS") %}
|
|
{% set sql %}
|
|
CREATE schema if NOT EXISTS silver;
|
|
{{ create_udtf_get_base_table(
|
|
schema = "streamline"
|
|
) }}
|
|
{{ create_udf_get_chainhead() }}
|
|
{{ create_udf_json_rpc() }}
|
|
{{ create_udf_api() }}
|
|
{{ create_udf_decode_array_string() }}
|
|
{{ create_udf_decode_array_object() }}
|
|
{{ create_udf_bulk_decode_logs() }}
|
|
|
|
{% endset %}
|
|
{% do run_query(sql) %}
|
|
{{- fsc_utils.create_udfs() -}}
|
|
{% endif %}
|
|
{% endmacro %}
|