02 2025 档案

mysql字符处理
摘要：select a.liuzhuan_ID from joinleader_app_run.hj_xiaoshoukaiju_lz8yi257 a left join (select * from (select bizkey, ROW_NUMBER() OVER (PARTITION BY bizk 阅读全文
posted @ 2025-02-28 11:53 CrossPython 阅读(12) 评论(0) 推荐(0)
sqlalchemy create_engine 用SSL
摘要：sslargs = ssl_args = { "ssl_verify_cert": True,}master_conn = create_engine(r'mysql+pymysql://U_JL_PROD_RD:W123m@10.79.252.44:3306', connect_args=ssla 阅读全文
posted @ 2025-02-28 09:38 CrossPython 阅读(43) 评论(0) 推荐(0)
游戏4软件
摘要：gamemakerASEPRITE 像素化软件SPRITE PILE 伪3DJSFXR 音效 阅读全文
posted @ 2025-02-24 20:04 CrossPython 阅读(22) 评论(0) 推荐(0)
计划任务 创建和执行,修改, 删除
摘要：def create_subdirectory(folder): task_name = str(int(time.time())) script_path = os.path.join(os.path.dirname(__file__), 'aa.py') # folder_alias = os. 阅读全文
posted @ 2025-02-21 11:04 CrossPython 阅读(13) 评论(0) 推荐(0)
用权限创建文件夹
摘要：import os import win32netcon import win32wnet from win32wnet import WNetAddConnection2, NETRESOURCE def get_parent_directory(path): parent_directory = 阅读全文
posted @ 2025-02-19 17:05 CrossPython 阅读(21) 评论(0) 推荐(0)
持久化凭据
摘要：1. 用 .bat: net use \ccnnsvs115fls01\APP01 /user:yourusername yourpassword /persistent:yes2. WIN+R: control.exe /name Microsoft.CredentialManager新增 阅读全文
posted @ 2025-02-18 11:23 CrossPython 阅读(20) 评论(0) 推荐(0)
重新开启服务
摘要：powershell.exe: script.ps1: # 停止服务 Stop-Service -Name "odooserver" -Force -ErrorAction Stop # 启动服务 Start-Service -Name "odooserver" -ErrorAction Stop 阅读全文
posted @ 2025-02-17 15:26 CrossPython 阅读(11) 评论(0) 推荐(0)
定时开启服务和关闭服务
摘要：创建 PowerShell 脚本 创建一个 PowerShell 脚本来启动和停止服务。 启动服务的脚本（start_service.ps1）： Start-Service -Name "jl-tellus" Write-Output "Service jl-tellus started at $( 阅读全文
posted @ 2025-02-17 14:15 CrossPython 阅读(34) 评论(0) 推荐(0)
查数据库所有表
摘要：sql server SELECT TABLE_NAME FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_TYPE = 'BASE TABLE' AND TABLE_CATALOG = 'hjdb'; mysql SELECT TABLE_NAME FROM i 阅读全文
posted @ 2025-02-15 18:02 CrossPython 阅读(8) 评论(0) 推荐(0)
win 英文系统 postgresql备份
摘要：@echo off :: 设置变量SET PGPATH=C:\Program Files\PostgreSQL\16\binSET BACKUPDIR=D:\odoo_daily_backup\dataSET DBNAME=1232SET PGUSER=123SET PGPASSWORD=123 f 阅读全文
posted @ 2025-02-15 12:08 CrossPython 阅读(16) 评论(0) 推荐(0)
postgresql自动备份和还原 .
摘要：实测OK 设置win定时任务每天执行即可. @echo off :: 设置变量 SET PGPATH=C:\Program Files\PostgreSQL\16\bin SET BACKUPDIR=C:\test\ SET DBNAME=spring SET PGUSER=postgres SET 阅读全文
posted @ 2025-02-15 09:21 CrossPython 阅读(43) 评论(0) 推荐(0)
loco
摘要：开始 cargo loco start 获取routes cargo loco routes 增加一个 controller $ cargo loco generate controller guide --api added: "src/controllers/guide.rs" injected 阅读全文
posted @ 2025-02-05 22:01 CrossPython 阅读(22) 评论(0) 推荐(0)
rust源配置
摘要：打开终端，编辑~/.bash_profile或~/.zshrc文件（取决于您使用的Shell）。 添加以下内容来配置Rustup的镜像源。这里以阿里云镜像为例： export RUSTUP_UPDATE_ROOT=https://mirrors.aliyun.com/rustup/rustup ex 阅读全文
posted @ 2025-02-05 16:58 CrossPython 阅读(325) 评论(0) 推荐(0)