Skip to content

Instantly share code, notes, and snippets.

@mattm
mattm / check.rs
Created Dec 9, 2021
Solana Ownership Check
View check.rs
if account.owner != program_id {
msg!("Greeted account does not have the correct program id");
return Err(ProgramError::IncorrectProgramId);
}
View keypair58.rb
require_relative "base58"
def bytes_to_base58(bytes)
hex = bytes.pack("C*").unpack("H*").first
Base58.encode(hex)
end
keypair = "6Tyktf6mEqUMEKm2ZpLn3srEwk9zsT5jiE54EgPgToikMFYww1LGFUXgwgr6hvc9CikpaNaBH2vmkmqN3Usrxpd"
keypair_hex = Base58.decode(keypair).rjust(128, "0")
keypair_bytes = [keypair_hex].pack('H*').bytes.to_a
View keypair.rb
require_relative "base58"
def bytes_to_base58(bytes)
hex = bytes.pack("C*").unpack("H*").first
Base58.encode(hex)
end
keypair_bytes = [4,182,130,247,119,117,227,207,112,73,170,126,222,197,244,99,215,107,255,202,33,43,36,17,104,111,157,246,196,192,174,95,240,23,238,206,118,215,154,238,229,96,11,37,156,123,51,223,5,231,17,117,86,136,103,14,75,95,175,132,148,54,1,46]
private_key_bytes = keypair_bytes[0, 32]
public_key_bytes = keypair_bytes[32..-1]
@mattm
mattm / fb_conversions.lookml
Last active Oct 2, 2018
Facebook Conversions View
View fb_conversions.lookml
view: fb_conversions {
derived_table: {
sql:
select *
from fivetran.fb_ad_insights_action_values
where action_type = "offsite_conversion.fb_pixel_purchase" ;;
}
dimension: primary_key {
type: string
View facebook-ad-insights-view.lookml
view: fb_ad_insights {
sql_table_name: fivetran.fb_ad_insights ;;
dimension: primary_key {
type: string
sql: concat(cast(${date_date} as string), ${campaign_id}, ${country}) ;;
hidden: yes
primary_key: yes
}
@mattm
mattm / facebook-ad-insights-joining.lookml
Last active Oct 2, 2018
Facebook Ad Insights Modeling
View facebook-ad-insights-joining.lookml
explore: fb_ad_insights {
label: "Facebook"
view_label: "Facebook"
join: fb_conversions {
view_label: "Facebook"
type: left_outer
relationship: one_to_one
sql_on: ${fb_ad_insights.primary_key} = ${fb_conversions.primary_key} ;;
}
@mattm
mattm / ad-insights-primary-key.lookml
Last active Oct 1, 2018
Ad Insights Primary Key
View ad-insights-primary-key.lookml
dimension: primary_key {
type: string
sql: concat(cast(${date_date} as string), ${campaign_id}, ${country}) ;;
hidden: yes
primary_key: yes
}
@mattm
mattm / facebook-conversion-value.sql
Last active Oct 1, 2018
Facebook Ad Insights Conversion Value
View facebook-conversion-value.sql
select
campaign_id,
sum(value) as total_conversion_value
from facebook_ad_insights.ad_insights_action_values
where
action_type = 'offsite_conversion.fb_pixel_purchase' and
date = '2018-10-01'
group by 1
order by 1
@mattm
mattm / facebook-ad-insights-spend.sql
Last active Oct 1, 2018
Facebook Ad Insights Spend
View facebook-ad-insights-spend.sql
select
campaign_id,
sum(spend) as total_spend,
sum(impressions) as total_impressions,
sum(spend) / sum(impressions) * 1000 as cpm,
sum(inline_link_clicks) as link_clicks,
sum(inline_link_clicks) / sum(impressions) as ctr
from facebook_ad_insights.ad_insights
where date = '2018-10-01'
group by 1
@mattm
mattm / base-model-macro-variable.sql
Created Jun 11, 2018
dbt base model macro variable
View base-model-macro-variable.sql
select
id,
email
from {{ source(var('base.users')) }}