Python 入门
大约 8 分钟
安装
python管理器
curl https://pyenv.run | bash
配置环境变量: vim ~/.zshrc
export PYENV_ROOT="$HOME/.pyenv"
[[ -d $PYENV_ROOT/bin ]] && export PATH="$PYENV_ROOT/bin:$PATH"
eval "$(pyenv init -)"
基本操作
pyenv install 3.12
pvenv
anaconda:https://www.anaconda.com/download
linux
sudo yum install conda
window
需要配置一下环境变量
D:\ProgramData\anaconda3 # python 目录
D:\ProgramData\anaconda3\Scripts # conda目录
列出虚拟环境
conda list
创建虚拟环境
conda create --name py12 python=3.12
激活虚拟环境
conda activate py12
退出
conda deactivate
删除虚拟环境
conda remove --name py12 --all
导出虚拟环境
conda env export > environment.yml
加载虚拟环境
conda env create -f environment.yml
steam 响应
@app.route('/chat/event')
def route_chat_event():
msg = request.args.get("msg")
resp = chat(model="deepseek-r1:7b", messages=[{"role": "user", "content": msg}], stream=True)
def generate():
for chunk in resp:
yield f"data: {chunk.message.content}\n\n"
return Response(generate(), mimetype='text/event-stream')
SET FOREIGN_KEY_CHECKS=0;
ALTER TABLE `xuekatu`.`activities` MODIFY COLUMN `cate_id` int(11) NOT NULL DEFAULT 0 COMMENT '活动分类' AFTER `id`;
ALTER TABLE `xuekatu`.`activities` MODIFY COLUMN `discount` double(8, 2) NOT NULL DEFAULT 0.00 COMMENT '课程的折扣价/元' AFTER `etime`;
ALTER TABLE `xuekatu`.`admin_archives` MODIFY COLUMN `xueli` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL COMMENT '学历' AFTER `health`;
ALTER TABLE `xuekatu`.`admin_grades` ADD COLUMN `money` decimal(8, 2) NOT NULL DEFAULT 0.00 COMMENT '业绩奖励金额' AFTER `number`;
ALTER TABLE `xuekatu`.`admin_grades` ADD COLUMN `mer_id` int(11) NOT NULL DEFAULT 0 COMMENT '商户id' AFTER `money`;
ALTER TABLE `xuekatu`.`admin_grades` DROP COLUMN `model_type`;
ALTER TABLE `xuekatu`.`admin_grades` DROP COLUMN `prize_money`;
ALTER TABLE `xuekatu`.`admin_grades` DROP COLUMN `grade_money`;
ALTER TABLE `xuekatu`.`admin_money_logs` ADD COLUMN `vid` int(11) NOT NULL DEFAULT 0 COMMENT '对应操作数据表的id' AFTER `form`;
ALTER TABLE `xuekatu`.`admin_score_logs` MODIFY COLUMN `form` tinyint(4) NOT NULL DEFAULT 1 COMMENT '默认1：报名奖励，2：系统奖励，3：大转盘,4:积分兑换，5:线索' AFTER `type`;
ALTER TABLE `xuekatu`.`admin_turnovers` MODIFY COLUMN `money` decimal(10, 2) NOT NULL DEFAULT 0.00 COMMENT '业绩金额，下单金额' AFTER `month`;
ALTER TABLE `xuekatu`.`archives` MODIFY COLUMN `age` int(11) NOT NULL DEFAULT 0 COMMENT '年龄' AFTER `birthday`;
ALTER TABLE `xuekatu`.`archives` MODIFY COLUMN `id_card_addr` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL COMMENT '身份证号地址' AFTER `id_card`;
ALTER TABLE `xuekatu`.`archives` MODIFY COLUMN `hunyin` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL COMMENT '婚姻,默认0：未婚，1：已婚，2：离异' AFTER `mz`;
ALTER TABLE `xuekatu`.`archives` MODIFY COLUMN `job` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL COMMENT '职位' AFTER `work_place`;
ALTER TABLE `xuekatu`.`archives` MODIFY COLUMN `xueli` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL COMMENT '学历' AFTER `job`;
ALTER TABLE `xuekatu`.`areas` MODIFY COLUMN `addr` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '1' COMMENT '地址' AFTER `name`;
ALTER TABLE `xuekatu`.`award_settings` ADD COLUMN `transfer_ratio` double(8, 2) NOT NULL DEFAULT 0.00 COMMENT '代理划拨业绩' AFTER `id`;
ALTER TABLE `xuekatu`.`award_settings` ADD COLUMN `agent_ratio` double(8, 2) NOT NULL DEFAULT 0.00 COMMENT '代理抽成比例' AFTER `transfer_ratio`;
ALTER TABLE `xuekatu`.`award_settings` DROP COLUMN `show_type`;
ALTER TABLE `xuekatu`.`batch_courses` ADD COLUMN `days` json NULL COMMENT '上课日期' AFTER `etime`;
ALTER TABLE `xuekatu`.`course_cates` MODIFY COLUMN `sort` int(11) NOT NULL DEFAULT 0 COMMENT '数值越大越靠前' AFTER `name`;
ALTER TABLE `xuekatu`.`course_cates` MODIFY COLUMN `pid` int(11) NOT NULL DEFAULT 0 COMMENT '上级id' AFTER `sort`;
ALTER TABLE `xuekatu`.`courses` MODIFY COLUMN `ks` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL COMMENT '课时' AFTER `undeline_price`;
ALTER TABLE `xuekatu`.`courses` DROP COLUMN `type`;
ALTER TABLE `xuekatu`.`courses` DROP COLUMN `setting_type`;
ALTER TABLE `xuekatu`.`courses` DROP COLUMN `setting`;
ALTER TABLE `xuekatu`.`courses` DROP COLUMN `mode_id`;
ALTER TABLE `xuekatu`.`customer_order_logs` MODIFY COLUMN `rep_cate_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL COMMENT '物品分类' AFTER `vid`;
ALTER TABLE `xuekatu`.`customer_order_logs` MODIFY COLUMN `course_cate_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '0' COMMENT '课程分类' AFTER `rep_cate_name`;
ALTER TABLE `xuekatu`.`customer_order_logs` MODIFY COLUMN `course_org_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '0' COMMENT '合作机构名称' AFTER `course_cate_name`;
ALTER TABLE `xuekatu`.`customer_order_logs` MODIFY COLUMN `ks` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL COMMENT '课时' AFTER `activity_id`;
ALTER TABLE `xuekatu`.`customer_orders` ADD COLUMN `ticket` json NULL COMMENT '支付凭证' AFTER `pay_money_type`;
ALTER TABLE `xuekatu`.`customer_orders` ADD COLUMN `reduce_money` decimal(10, 2) NOT NULL DEFAULT 0.00 COMMENT '改价:手动扣除金额' AFTER `addition_money`;
ALTER TABLE `xuekatu`.`customer_orders` ADD COLUMN `reduce_total` decimal(10, 2) NOT NULL DEFAULT 0.00 COMMENT '改价后差异的金额' AFTER `reduce_money`;
ALTER TABLE `xuekatu`.`customer_orders` MODIFY COLUMN `status` tinyint(4) NOT NULL DEFAULT 1 COMMENT '订单状态,默认1：开启，2：关闭,3:退费，4：锁定,5:确定退费，6:退费驳回' AFTER `id`;
ALTER TABLE `xuekatu`.`customer_orders` MODIFY COLUMN `pay_type` tinyint(4) NOT NULL DEFAULT 1 COMMENT '0：无，1：微信支付（线上），2：支付宝（线上），3:现金支付,4:微信转账,5:支付宝转账,6:刷卡,7:其他' AFTER `status`;
ALTER TABLE `xuekatu`.`customer_orders` MODIFY COLUMN `pay_status` tinyint(4) NOT NULL DEFAULT 0 COMMENT '支付状态。0：待支付，1：支付成功，2：支付失败，3：已收款' AFTER `pay_type`;
ALTER TABLE `xuekatu`.`customer_orders` MODIFY COLUMN `pay_money_type` tinyint(4) NOT NULL DEFAULT 0 COMMENT '缴费的钱在哪,1:我处 ,2:合作机构' AFTER `pay_status`;
ALTER TABLE `xuekatu`.`customer_orders` MODIFY COLUMN `pre_pay_type` tinyint(4) NOT NULL DEFAULT 1 COMMENT '0：无，1：微信支付（线上），2：支付宝（线上），3:现金支付,4:微信转账,5:支付宝转账,6:刷卡,7:其他' AFTER `pre_money`;
ALTER TABLE `xuekatu`.`customer_orders` MODIFY COLUMN `pre_money_status` tinyint(4) NOT NULL DEFAULT 0 COMMENT '定金支付状态，0:未支付，1:已支付,2:支付失败,3:已收款' AFTER `pre_pay_type`;
ALTER TABLE `xuekatu`.`customer_orders` MODIFY COLUMN `pre_money_type` tinyint(4) NOT NULL DEFAULT 0 COMMENT '缴费的钱在哪,1:我处 ,2:合作机构' AFTER `pre_ticket`;
ALTER TABLE `xuekatu`.`customer_orders` MODIFY COLUMN `year` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '0' COMMENT '缴费年份' AFTER `archive_id`;
ALTER TABLE `xuekatu`.`customer_orders` MODIFY COLUMN `channel_id` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '0' COMMENT '线索来源id' AFTER `customer_user`;
ALTER TABLE `xuekatu`.`customer_orders` MODIFY COLUMN `money` decimal(10, 2) NOT NULL DEFAULT 0.00 COMMENT '支付金额(定金+尾款)' AFTER `repertory_money`;
ALTER TABLE `xuekatu`.`customer_orders` MODIFY COLUMN `student_id` int(11) NOT NULL DEFAULT 0 COMMENT 'student:id' AFTER `pre_service_money`;
ALTER TABLE `xuekatu`.`customer_orders` MODIFY COLUMN `batch_id` int(11) NOT NULL DEFAULT 0 COMMENT 'course_batch:id' AFTER `student_id`;
ALTER TABLE `xuekatu`.`customer_orders` DROP COLUMN `order_status`;
ALTER TABLE `xuekatu`.`customer_orders` DROP COLUMN `org_status`;
ALTER TABLE `xuekatu`.`customers` MODIFY COLUMN `now_uid` int(11) NOT NULL DEFAULT 0 COMMENT '创建人id' AFTER `uid`;
ALTER TABLE `xuekatu`.`customers` MODIFY COLUMN `type` tinyint(4) NOT NULL DEFAULT 1 COMMENT '默认1:有效，2：无效，3：已成交,4:有订单，不显示,5:争议线索' AFTER `now_uid`;
ALTER TABLE `xuekatu`.`customers` MODIFY COLUMN `course_cate_id` int(11) NOT NULL DEFAULT 0 COMMENT '项目分类' AFTER `course_id`;
ALTER TABLE `xuekatu`.`disbursemet_cates` MODIFY COLUMN `type` tinyint(4) NOT NULL DEFAULT 0 COMMENT '1:类型,2:消耗分类,3:学校' AFTER `id`;
ALTER TABLE `xuekatu`.`dorm_orders` MODIFY COLUMN `status` tinyint(4) NOT NULL DEFAULT 0 COMMENT '0:未支付 1:已支付,2:支付失败,3:待确认' AFTER `sn`;
ALTER TABLE `xuekatu`.`dorm_orders` MODIFY COLUMN `day` int(11) NOT NULL DEFAULT 0 COMMENT '住宿时长' AFTER `etime_at`;
ALTER TABLE `xuekatu`.`dorm_orders` MODIFY COLUMN `remark` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL COMMENT '备注' AFTER `day`;
ALTER TABLE `xuekatu`.`dorm_orders` MODIFY COLUMN `admin_id` int(11) NOT NULL DEFAULT 0 COMMENT 'admin:id' AFTER `remark`;
ALTER TABLE `xuekatu`.`dorm_orders` MODIFY COLUMN `customer_order_id` int(11) NOT NULL DEFAULT 0 COMMENT '线索订单的id' AFTER `admin_id`;
ALTER TABLE `xuekatu`.`dorm_orders` MODIFY COLUMN `pay_type` tinyint(4) NOT NULL DEFAULT 0 COMMENT '支付方式' AFTER `customer_order_id`;
ALTER TABLE `xuekatu`.`dorm_orders` MODIFY COLUMN `pay_ticket` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL COMMENT '支付凭证' AFTER `pay_type`;
ALTER TABLE `xuekatu`.`dorm_orders` MODIFY COLUMN `mer_id` int(11) NOT NULL DEFAULT 0 COMMENT '商户id' AFTER `pay_ticket`;
ALTER TABLE `xuekatu`.`dorm_orders` MODIFY COLUMN `created_at` timestamp NULL DEFAULT NULL AFTER `mer_id`;
ALTER TABLE `xuekatu`.`feed_backs` MODIFY COLUMN `img` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL COMMENT '图片' AFTER `content`;
ALTER TABLE `xuekatu`.`performances` ADD COLUMN `reduce_total` decimal(8, 2) NOT NULL DEFAULT 0.00 COMMENT '改价差异金额累加' AFTER `money`;
ALTER TABLE `xuekatu`.`performances` ADD COLUMN `refund_type` tinyint(4) NOT NULL DEFAULT 0 COMMENT '奖励类型' AFTER `refund_money`;
ALTER TABLE `xuekatu`.`performances` ADD COLUMN `refund_number` decimal(8, 2) NOT NULL DEFAULT 0.00 COMMENT '奖励金额' AFTER `refund_type`;
ALTER TABLE `xuekatu`.`performances` ADD COLUMN `refund_deduct` decimal(8, 2) NOT NULL DEFAULT 0.00 COMMENT '消减金额' AFTER `refund_number`;
ALTER TABLE `xuekatu`.`performances` ADD COLUMN `agent_transfer_money` decimal(8, 2) NOT NULL DEFAULT 0.00 COMMENT '代理划拨业绩总额' AFTER `agent_total`;
ALTER TABLE `xuekatu`.`performances` ADD COLUMN `agent_transfer_number` double(8, 2) NOT NULL DEFAULT 0.00 COMMENT '代理划拨业绩比例' AFTER `agent_transfer_money`;
ALTER TABLE `xuekatu`.`performances` ADD COLUMN `grade_money` decimal(8, 2) NOT NULL DEFAULT 0.00 COMMENT '本月有效业绩金额' AFTER `grade_amount`;
ALTER TABLE `xuekatu`.`performances` ADD COLUMN `grade_last` tinyint(4) NOT NULL DEFAULT 5 COMMENT '咨询师等级' AFTER `grade_money`;
ALTER TABLE `xuekatu`.`performances` MODIFY COLUMN `status` tinyint(4) NOT NULL DEFAULT 0 COMMENT '0:未结算 1:结算 2:结算失败' AFTER `id`;
ALTER TABLE `xuekatu`.`performances` MODIFY COLUMN `amount` decimal(8, 2) NOT NULL DEFAULT 0.00 COMMENT '总奖励金额' AFTER `month`;
ALTER TABLE `xuekatu`.`performances` DROP COLUMN `deduct_money`;
ALTER TABLE `xuekatu`.`personal_access_tokens` DROP COLUMN `expires_at`;
ALTER TABLE `xuekatu`.`plan_month_weeks` ADD COLUMN `start_day` datetime NULL DEFAULT NULL COMMENT '开始日期' AFTER `week`;
ALTER TABLE `xuekatu`.`plan_month_weeks` ADD COLUMN `end_day` datetime NULL DEFAULT NULL COMMENT '结束日期' AFTER `start_day`;
ALTER TABLE `xuekatu`.`plan_month_weeks` DROP COLUMN `start_at`;
ALTER TABLE `xuekatu`.`plan_month_weeks` DROP COLUMN `end_at`;
ALTER TABLE `xuekatu`.`plan_months` MODIFY COLUMN `status` int(11) NOT NULL COMMENT '状态，0：待审核，1：审核通过，2：驳回' AFTER `id`;
ALTER TABLE `xuekatu`.`plan_week_remarks` MODIFY COLUMN `mer_id` int(11) NOT NULL DEFAULT 0 COMMENT '商户id' AFTER `measures`;
ALTER TABLE `xuekatu`.`repertory_cates` MODIFY COLUMN `pid` int(11) NOT NULL DEFAULT 0 COMMENT '父级id' AFTER `status`;
ALTER TABLE `xuekatu`.`repertory_detail_logs` MODIFY COLUMN `fz_uid` int(11) NOT NULL COMMENT '负责领取人的id' AFTER `uid`;
ALTER TABLE `xuekatu`.`score_logs` MODIFY COLUMN `form` tinyint(4) NOT NULL DEFAULT 1 COMMENT '默认1：报名奖励，2：系统奖励，3：大转盘,5:线索' AFTER `score`;
ALTER TABLE `xuekatu`.`site_websites` MODIFY COLUMN `baidu_weight` int(11) NOT NULL DEFAULT 0 COMMENT '百度权重' AFTER `plate`;
ALTER TABLE `xuekatu`.`site_wechats` MODIFY COLUMN `auth_user` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '认证人' AFTER `phone`;
ALTER TABLE `xuekatu`.`site_wechats` MODIFY COLUMN `admin_password` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL COMMENT '后台账号' AFTER `admin_user`;
ALTER TABLE `xuekatu`.`students` MODIFY COLUMN `nickname` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '昵称' AFTER `name`;
ALTER TABLE `xuekatu`.`telescope_entries_tags` DROP INDEX `telescope_entries_tags_entry_uuid_tag_index`;
ALTER TABLE `xuekatu`.`telescope_entries_tags` ADD PRIMARY KEY (`entry_uuid`, `tag`) USING BTREE;
ALTER TABLE `xuekatu`.`telescope_monitoring` ADD PRIMARY KEY (`tag`) USING BTREE;
SET FOREIGN_KEY_CHECKS=1;