pip install -r requirements.txt
-- ※開発時 現在のライブラリの状態でrequirementsを書き出す
pip freeze > requirements.txt
python manage.py flush --noinput
python3
にしてバッククォートを /
に置換するpython manage.py makemigrations vietnam_research gmarker shopping linebot_engine warehouse taxonomy soil_analysis securities
python manage.py migrate
python manage.py createsuperuser
auth_user
の seeder は soil_analysis/fixtures/user.json
にあるauth_user
の初期パスワードは test#1234
/
に置換するdaily_industry_chart_and_uptrend
を動かすときは industry
の seeder は14日ぶん用意しましょう
-- 何月のデータがあるの?の確認
SELECT x.recorded_date
FROM vietnam_research_industry x
GROUP BY x.recorded_date
ORDER BY x.recorded_date;
-- ある日付を別の日付に編集する
UPDATE portfolio_db.vietnam_research_industry
SET recorded_date = '2024-05-02'
WHERE recorded_date = '2023-01-17';
python manage.py loaddata .\vietnam_research\fixtures\indClass.json
python manage.py loaddata .\vietnam_research\fixtures\market.json
python manage.py loaddata .\vietnam_research\fixtures\symbol.json
python manage.py loaddata .\vietnam_research\fixtures\sbi.json
python manage.py loaddata .\vietnam_research\fixtures\unit.json
python manage.py loaddata .\vietnam_research\fixtures\vnIndex.json
python manage.py loaddata .\vietnam_research\fixtures\articles.json
python manage.py loaddata .\vietnam_research\fixtures\basicInformation.json
python manage.py loaddata .\vietnam_research\fixtures\financialResultWatch.json
python manage.py loaddata .\vietnam_research\fixtures\industry.json
python manage.py loaddata .\vietnam_research\fixtures\watchlist.json
python manage.py loaddata .\gmarker\fixtures\signageMenuName.json
python manage.py loaddata .\gmarker\fixtures\storeInformation.json
python manage.py loaddata .\shopping\fixtures\store.json
python manage.py loaddata .\shopping\fixtures\staff.json
python manage.py loaddata .\shopping\fixtures\products.json
python manage.py loaddata .\warehouse\fixtures\warehouse.json
python manage.py loaddata .\warehouse\fixtures\staff.json
python manage.py loaddata .\warehouse\fixtures\rentalStatus.json
python manage.py loaddata .\warehouse\fixtures\company.json
python manage.py loaddata .\warehouse\fixtures\billingPerson.json
python manage.py loaddata .\warehouse\fixtures\billingStatus.json
python manage.py loaddata .\taxonomy\fixtures\kingdom.json
python manage.py loaddata .\taxonomy\fixtures\phylum.json
python manage.py loaddata .\taxonomy\fixtures\classification.json
python manage.py loaddata .\taxonomy\fixtures\family.json
python manage.py loaddata .\taxonomy\fixtures\genus.json
python manage.py loaddata .\taxonomy\fixtures\species.json
python manage.py loaddata .\taxonomy\fixtures\naturalMonument.json
python manage.py loaddata .\taxonomy\fixtures\tag.json
python manage.py loaddata .\taxonomy\fixtures\breed.json
python manage.py loaddata .\taxonomy\fixtures\breedTags.json
python manage.py loaddata .\soil_analysis\fixtures\companycategory.json
python manage.py loaddata .\soil_analysis\fixtures\company.json
python manage.py loaddata .\soil_analysis\fixtures\user.json
python manage.py loaddata .\soil_analysis\fixtures\crop.json
python manage.py loaddata .\soil_analysis\fixtures\land_block.json
python manage.py loaddata .\soil_analysis\fixtures\land_period.json
python manage.py loaddata .\soil_analysis\fixtures\cultivationtype.json
# ここで soil analysis のバッチをまわす
python manage.py loaddata .\soil_analysis\fixtures\land.json
python manage.py loaddata .\soil_analysis\fixtures\samplingmethod.json
python manage.py loaddata .\soil_analysis\fixtures\samplingorder.json
python manage.py loaddata .\soil_analysis\fixtures\land_ledger.json
python manage.py loaddata .\soil_analysis\fixtures\land_review.json
python manage.py loaddata .\soil_analysis\fixtures\land_score_chemical.json
python manage.py loaddata .\soil_analysis\fixtures\device.json
python manage.py shell
from vietnam_research.models import Industry, IndClass, WatchList
from django.db.models import Sum, F, Case, When, Value
from django.db.models.functions import Concat
:
python manage.py runserver
python manage.py import_soil_hardness /path/to/folder
-R
は recursive
ubuntu:www-data
は ubuntuユーザ:apacheグループの所有者にする
cd /var/www/html/portfolio
git pull
source /var/www/html/venv/bin/activate
systemctl restart apache2
sudo -s
chown -R ubuntu:www-data /var/www/html
python manage.py collectstatic
主に securities がzipを保存するために必要な設定 exists メソッドは file or directory が存在するか確認するがこれには該当のファイルまたはディレクトリへのアクセス権限(実行権限 (x) )が必要
chmod -R 774 /var/www/html/portfolio/media
chmod 774 /var/www
daily_industry_chart_and_uptrend
は 各期間(14日、7日、3日)を遡り、 すべての期間の株価が上昇傾向(斜度が正)であれば passed
がインクリメントされる。つまり時系列データがないと画像は保存されない
python manage.py daily_import_from_bloomberg
のバッチをまわすpython manage.py daily_import_from_sbi
のバッチをまわすpython manage.py daily_import_from_vietkabu
のバッチをまわすpython manage.py daily_industry_chart_and_uptrend
のバッチをまわすpython manage.py daily_industry_stacked_bar_chart
のバッチをまわすpython manage.py fao_food_balance_chart
のバッチをまわすhttps://qiita.com/YoshitakaOkada/items/f51f52a8041439a1dbc9#line
Userが「食べた」と答えた回数を集計して、最近「食べた」と答えなかったらアラート、みたいな
python manage.py import_weather_master
のバッチをまわすpython manage.py import_weather_master_manual
のバッチをまわす(天気コードの取り込み)python manage.py fetch_weather_forecast
のバッチをまわすpython manage.py fetch_weather_warning
のバッチをまわすpython manage.py daily_download_edinet
のバッチをまわす