Skip to content

Instantly share code, notes, and snippets.

% flox -v -v install python  INT ✘ 
`$FLOX_CONFIG_HOME` not set, using "/Users/rturk/.config/flox/"
no default user nix.conf found - weird
Attempting to read own UUID from file
installing packages [python] to Unspecified
[DEBUG] [flox_rust_sdk::models::environment] looking for .flox: starting_path=/Users/rturk/projects/sd-notebook/.flox
[DEBUG] [flox_rust_sdk::models::environment] .flox found: path=/Users/rturk/projects/sd-notebook/.flox
detected concrete environment type: path
[DEBUG] [flox_rust_sdk::models::environment::path_environment] attempting to open .flox directory: /Users/rturk/projects/sd-notebook/.flox
Writing new metrics buffer entry
projects % sqlite3 ~/.cache/flox/pkgdb-v2/1360681c88df2c468545c993bb3615b3adc51a9af0ac5fbc713873df0c4564f3.sqlite
SQLite version 3.39.5 2022-10-14 20:58:05
Enter ".help" for usage hints.
sqlite> create view v_PnamesPathnames as select json_extract(v.path, "$[#-1]") as pathName, p.pname from v_PackagesPaths v, Packages p where v.id = p.id and pathName != p.pname;
sqlite> select * from v_PnamesPathnames where pathName != pname limit 100;
ArchiSteamFarm|archisteamfarm
EmptyEpsilon|empty-epsilon
Fabric|fabric
@rossturk
rossturk / astro-cli-hb-analytics.py
Created December 16, 2022 22:44
Grab Homebrew download stats
from datetime import datetime
from astro import sql as aql
from astro.sql.table import Table
from airflow.models import DAG
from git import Repo
from os.path import exists
from airflow.operators.python import get_current_context
from airflow.exceptions import AirflowSkipException
import pandas as pd
import io
@rossturk
rossturk / astro-cli-downloads.py
Created December 16, 2022 22:40
Snapshot downloads of a GitHub package
from datetime import datetime
from astro import sql as aql
from astro.sql.table import Table
from airflow.models import DAG
import pandas as pd
import requests
CONN_ID = "dwh"
@rossturk
rossturk / git-commits-by-file.py
Created December 16, 2022 22:36
Gather commits by file
from datetime import datetime
from pydriller import Repository, ModificationType
from astro import sql as aql
from astro.sql.table import Table
from airflow.models import DAG
from git import Repo
from os.path import exists
from airflow.operators.python import get_current_context
from airflow.exceptions import AirflowSkipException
import pandas as pd
@rossturk
rossturk / awario-mentions.py
Created December 16, 2022 22:31
Gather Awario mentions
from datetime import datetime
import requests
from include.autopaginate_api_call import AutoPaginate
from astro import sql as aql
from astro.sql.table import Table, Metadata
from airflow.models import DAG, Variable
from pandas import DataFrame
from airflow.exceptions import AirflowSkipException
@rossturk
rossturk / orbit-activities.py
Created December 16, 2022 22:21
Get Orbit activities
from datetime import datetime
import requests
from include.autopaginate_api_call import AutoPaginate
from airflow.operators.python import get_current_context
from astro import sql as aql
from astro.sql.table import Table, Metadata
from airflow.models import DAG, Variable
import pandas as pd
from airflow.exceptions import AirflowSkipException
@rossturk
rossturk / orbit-members-orgs.py
Last active December 16, 2022 21:31
Import Orbit members and orgs
from datetime import datetime
import requests
from include.autopaginate_api_call import AutoPaginate
from astro import sql as aql
from astro.sql.table import Table
from airflow.models import DAG, Variable
import pandas as pd
CONN_ID = "dwh"
@rossturk
rossturk / astro-homebrew-history.py
Last active September 16, 2022 19:22
astro-homebrew-history
from datetime import datetime
from astro import sql as aql
from astro.sql.table import Table
from airflow.models import DAG
from git import Repo
from os.path import exists
from airflow.operators.python import get_current_context
import pandas as pd
import io
import json
@rossturk
rossturk / astro-cli-downloads.py
Created September 16, 2022 01:15
Grab Astro CLI downloads
from datetime import datetime
from astro import sql as aql
from astro.sql.table import Table
from airflow.models import DAG
import pandas as pd
import requests
CONN_ID = "dwh"