Arseny Sher arssher
This file contains hidden or 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
| ars@nonlibrem ~ $ mortage.py -y 30 --mortage-payment 71946 -i 6 -r 60000 -s 1 --renovation 2000000 --down-payment 3000000 --loan 12000000 | |
| 30 | |
| inflation factor: 0.0600, skip years: 1, loan: 12000000, down_payment: 3000000, renovation: 2000000 | |
| year 0: monthly payment_i_a=71946.00, payment_sum_i_a=863352.00, payment_sum=863352.00, debt=11852639.37, debt_i_a=11181735.26, monthly rental=60000.00, rental_sum=0.00, yearly b=-863352.00, b=-863352.00, full_b=-2863352.00, rental profit=0.00, investments=5863352.00, owned_value=3818264.74, assets=3818264.74, CAGR=-34.88% | |
| year 1: monthly payment_i_a=67873.58, payment_sum_i_a=1677835.02, payment_sum=1726704.00, debt=11696189.86, debt_i_a=10409567.34, monthly rental=60000.00, rental_sum=720000.00, yearly b=-94483.02, b=-957835.02, full_b=-2957835.02, rental profit=0.00, investments=5957835.02, owned_value=4590432.66, assets=4590432.66, CAGR=-12.22% | |
| year 2: monthly payment_i_a=64031.68, payment_sum_i_a=2446215.23, payment_sum=2590056.00, debt=11530090.89, debt_i_a=9680886.65 |
arssher
/ parse_forte_stmt.py
Last active
March 14, 2025 21:00
This file contains hidden or 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
| #!/usr/bin/env python3 | |
| import sys | |
| import camelot | |
| import argparse | |
| from decimal import * | |
| if __name__ == "__main__": |
arssher
/ prepare.sh
Last active
January 11, 2024 20:26
This file contains hidden or 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
| apt-get update | |
| apt-get install bc | |
| psql -qtA -U cloud_admin postgres -c "select datname from pg_database where datname "'!'"= 'postgres' and datname "'!'"~ 'template.*';" > dbs |
arssher
/ backpatch_neon.sh
Created
October 19, 2023 10:10
This file contains hidden or 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
| #!/bin/bash | |
| ## usage: stand on commit and run, e.g. | |
| # git checkout rm-ws-logging-v16 && branch=rm-ws-logging backpatch_neon.sh | |
| set -e | |
| # set -o xtrace # print each line | |
| commit=$(git rev-parse HEAD) | |
| echo "applying ${commit}" |
arssher
/ neon_create_projects_bench.py
Created
June 15, 2023 15:15
This file contains hidden or 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 os | |
| import time | |
| import requests | |
| HEADERS = { | |
| 'Authorization': 'Bearer ' + os.environ['NEON_STAGING_KEY'], | |
| } | |
| for i in range(0, 10000): | |
| start = time.time() |
arssher
/ gist:aabd2c0db7da2bf5c508db59ee8a6cfd
Created
June 9, 2023 13:39
This file contains hidden or 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
| ================================================================================= FAILURES ================================================================================= | |
| ________________________________________________________________________ test_pgbench[neon-45-400] _________________________________________________________________________ | |
| self = <fixtures.pageserver.http.PageserverHttpClient object at 0x7f7b2bc5aad0>, res = <Response [500]> | |
| def verbose_error(self, res: requests.Response): | |
| try: | |
| > res.raise_for_status() | |
| test_runner/fixtures/pageserver/http.py:119: |
arssher
/ neon_delete_projects.py
Created
May 18, 2023 12:10
This file contains hidden or 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 os | |
| import time | |
| import requests | |
| import sys | |
| HEADERS = { | |
| 'Authorization': 'Bearer ' + os.environ['NEON_API_KEY'], | |
| } | |
| params = {'limit': 100} |
arssher
/ too_long_with_no_output.py
Created
March 7, 2023 12:47
This file contains hidden or 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
| #!/usr/bin/env python3 | |
| import sys | |
| logf = sys.argv[1] | |
| with open(logf) as file: | |
| lines = file.readlines() | |
| # print(lines) |
This file contains hidden or 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
| ars@librem ~/neon/cloud $ make test-e2e RUNTEST_ARGS='-k test_proxy_get_role_secret' | |
| make -C tests_e2e test | |
| make[1]: Entering directory '/home/ars/neon/cloud/tests_e2e' | |
| poetry install | |
| Installing dependencies from lock file | |
| No dependencies to install or update | |
| poetry run pytest -vvs --durations=15 -k test_proxy_get_role_secret | |
| ==================================================================================== test session starts ===================================================================================== | |
| platform linux -- Python 3.10.8, pytest-7.1.1, pluggy-1.0.0 -- /home/ars/.cache/pypoetry/virtualenvs/tests-e2e-CrmeBj7j-py3.10/bin/python |
arssher
/ offcpu_single.svg
Created
March 21, 2018 09:05
Loading
Sorry, something went wrong. Reload?
Sorry, we cannot display this file.
Sorry, this file is invalid so it cannot be displayed.
NewerOlder