Qiyibaba Blog

Write everything.

Python Title

class P: i = 1 j = 1 k = 1 def __init__(self) -> None: self.i = 3 self.j = 4 def info(self): print(self.i,self.j) class Man(P): @classmethod ...

Posted by Qiyibaba on July 11, 2022

python代码编码的一些常用规范

需要对入参进行合法校验 v = input("please input your ID card:") if re.match("\d{17}[\d|x]|\d{15}",v): print("合法身份证号") else: print("非法身份证号") SQL参数化为防止SQL注入，我们需要在传入参数时进行参数化 def select(sql,params= ...

Posted by Qiyibaba on April 15, 2022

Choose Naifen

奶粉类型选择 (√)原产国产奶粉 (√)国标奶粉（国外原装进口奶粉） (×)国产进口奶粉–奶粉源可能被污染 (×)国外本土奶粉–标准与国内有差异 (√)奶粉添加物质 OPO[1,3-二油酸-2-棕榈酸甘油三酯] （预防便秘） DHA/AA[二十二碳六烯酸和二十碳四烯酸] （增...

Posted by Qiyibaba on March 30, 2022

savepoint的使用

savepoint savepoint是作为回退做的,savepoint的个数没有限制,savepoint和虚拟机中快照类似. savepoint是事务中的一点。用于取消部分事务，当结束事务时，会自动的删除该事务中所定义的所有保存点。基本操作回退事务的几个重要操作 1.设置保存点 savepoint a 2.取消保存点a之后事务 rollback to a 3.取消全部事务 ...

Posted by Qiyibaba on March 1, 2022

oracle用户和权限管理

oracle用户和权限管理 -- 创建基础用户 obclient> create user csdc identified by csdc; -- 创建其他用户 obclient> create user csdc_u1 identified by csdc; Query OK, 0 rows affected (0.02 sec) -- 给基础用户赋权 obclient>...

Posted by Qiyibaba on March 1, 2022

微信小程序开发第一天

app.json { "pages":[ // pages字段用于描述小程序所有页面路径,注意，必须与pages目录下的文件夹对应，直接修改app.json文件，会自动添加目录,删除不会自动清理，需要手动删除 "pages/index/index", // 注意：写在第一位的就是首页 "pages/logs/logs" ], "window":{ // 窗口界面...

Posted by Qiyibaba on February 17, 2022

Docker软件安装

Docker软件安装（shell） #!/bin/bash base_dir=$(cd `dirname $0`;pwd) dockerRootDir=${1:-"/home/docker"} tar -xzvf docker7.tar.gz -C /usr/local/clonescripts/docker rpm -ivh /usr/local/clonescripts/dock...

Posted by Qiyibaba on February 16, 2022

批量插入性能测试脚本

测试代码 package com.qiyibaba.obdemo; import sun.misc.BASE64Encoder; import java.io.UnsupportedEncodingException; import java.sql.Connection; import java.sql.DriverManager; import java.sql.PreparedS...

Posted by Qiyibaba on January 19, 2022

简易性能测试脚本

测试脚本 date;echo {1..500} | xargs -n 1 -P 50 /bin/sh -c "mysql -uroot -proot -e 'xxxxxxxxx' 1>/dev/null 2>/dev/null";date insert..on duplicate key for update, insert ignore性能对比 $date;echo {...

Posted by Qiyibaba on January 13, 2022

端口监听探测程序

#!/bin/bash IPLIST=$1 PORTLIST=$2 if [ $# -ne 2 ]; then echo "Usage:" echo " $0 [IPADDR|DOMAIN] [PORT]" echo "" echo "Examples:" echo " $0 localhost 80" echo " $0 192.168.1.1 ...

Posted by Qiyibaba on January 13, 2022