-- ADA HANDLES FROM STAKE-KEY
SELECT convert_from(multi_asset.name, 'UTF8') FROM utxo_view JOIN stake_address ON stake_address.id = utxo_view.stake_address_id RIGHT JOIN tx_metadata ON utxo_view.tx_id = tx_metadata.tx_id RIGHT JOIN ma_tx_mint ON ma_tx_mint.tx_id = tx_metadata.tx_id LEFT JOIN multi_asset ON ma_tx_mint.ident = multi_asset.id WHERE view = ? AND multi_asset.policy='\xf0ff48bbb7bbe9d59a40f1ce90e9e9d0ff5002ec48f232b49ca0fb9a';
(test skey on preview: 'stake_test1urc63cmezfacz9vrqu867axmqrvgp4zsyllxzud3k6danjsn0dn70')
-- w/ naming shortened --
SELECT convert_from(ma.name, 'UTF8') FROM utxo_view uv JOIN stake_address sa ON sa.id = uv.stake_address_id RIGHT JOIN tx_metadata txm ON uv.tx_id = txm.tx_id RIGHT JOIN ma_tx_mint ON ma_tx_mint.tx_id = txm.tx_id LEFT JOIN multi_asset ma ON ma_tx_mint.ident = ma.id WHERE view = ? AND ma.policy='\xf0ff48bbb7bbe9d59a40f1ce90e9e9d0ff5002ec48f232b49ca0fb9a';
Tknott95
/ query_ex_00.MD
Created
February 23, 2023 05:41
cardano-db-sync query example to interact with ada handles
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| import openai | |
| openai.api_key = "<YOUR-API-KEY-HERE>" | |
| def makeGPT(prompt_using): | |
| completion = openai.Completion.create( | |
| engine="text-davinci-003", | |
| prompt=prompt_using, | |
| max_tokens=1024, | |
| n=1, |
Tknott95
/ nix_single_user.MD
Last active
June 7, 2023 08:02
cannot connect to socket at '/nix/var/nix/daemon-socket/socket': No such file or directory
if you are trying to remove a multi user install on linux and revert to a single user install
you need to remove your NIX_REMOTE variable
or just set it to export NIX_REMOTE=
so this is blank and not calling the daemon - as you are installing without it for single user
“Through the darkness of futures past
The magician longs to see;
One chants out between two worlds
‘Fire walk with me.’”
The lights glowed inside, soon supper would ring
And he would go home where his father was King.
But no he was here with the wind and the sea
And all the things he was going to be.
He would build empires
And he would have sons
Others would fall
Tknott95
/ Art_Trolls_For_Future_Self.MD
Last active
March 20, 2020 12:08
Stages of Growth, Archetype of all. https://www.shortform.com/blog/monomyth-stages-heros-journey/