smol-workflow/cheatsheet at main · kalepail/smol-workflow · GitHub

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
npx wrangler d1 execute smol-d1 --remote --file=./schema.sql

npx wrangler d1 execute smol-d1 --remote --command="UPDATE Smols SET Public = 1 WHERE Id = 'cca0af311ffc644607b6d21de10b7e75ff6e0de7d2a62ff813c76161988ffe05'"

npx wrangler d1 execute smol-d1 --remote --command="ALTER TABLE Smols RENAME COLUMN Holders TO Views"

npx wrangler d1 execute smol-d1 --remote --command="SELECT * FROM Smols WHERE Address <> 'GAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAWHF'"

npx wrangler d1 execute smol-d1 --remote --command="SELECT * FROM Smols WHERE Id = '8ffb9ff59f8b38b6dea778f4f571ae87239e2b2bfbf3ad9d327e53f0dfb88e7a'"

npx wrangler d1 execute smol-d1 --remote --command="SELECT COUNT(*) FROM Smols"

npx wrangler d1 execute smol-d1 --remote --command="SELECT COUNT(DISTINCT Address) FROM Smols"

npx wrangler d1 execute smol-d1 --remote --command="UPDATE Smols SET Public = 1 WHERE Id = 'efd530037ff48ad7da5f77875a062880cd20483b85c0ab769132cfc18f25e15a'"

npx wrangler d1 execute smol-d1 --remote --command="ALTER TABLE Smols ADD COLUMN Mint_Token TEXT DEFAULT NULL"

npx wrangler d1 execute smol-d1 --remote --command="ALTER TABLE Smols ADD COLUMN Mint_Amm TEXT DEFAULT NULL"

npx wrangler d1 execute smol-d1 --remote --command="UPDATE Smols SET Mint_Token = NULL, Mint_Amm = NULL"

npx wrangler d1 execute smol-d1 --remote --command="DELETE FROM Mixtapes"