<?xml version="1.0" encoding="utf-8" ?><rss version="2.0"><channel><title><![CDATA[topalien的博客]]></title><description><![CDATA[]]></description><link>https://blog.youkuaiyun.com/topalien</link><language>zh-cn</language><generator>https://blog.youkuaiyun.com/</generator><copyright><![CDATA[Copyright &copy; topalien]]></copyright><item><title><![CDATA[Kettle ktr、kjb线上任务调度平台]]></title><link>https://blog.youkuaiyun.com/topalien/article/details/140610334</link><guid>https://blog.youkuaiyun.com/topalien/article/details/140610334</guid><author>topalien</author><pubDate>Mon, 22 Jul 2024 15:11:32 +0800</pubDate><description><![CDATA[Kettle在线任务调度平台
1、支持上传、下载ktr/kjb文件

2、支持手动执行、定时执行

3、支持日志实时查看

4、项目管理、登录、注册

5、运行变量在线配置]]></description><category></category></item><item><title><![CDATA[Python快速接入Chat-GPT（OpenAI）]]></title><link>https://blog.youkuaiyun.com/topalien/article/details/130684270</link><guid>https://blog.youkuaiyun.com/topalien/article/details/130684270</guid><author>topalien</author><pubDate>Mon, 15 May 2023 14:45:55 +0800</pubDate><description><![CDATA[【代码】Python快速接入Chat-GPT（OpenAI）]]></description><category></category></item><item><title><![CDATA[python openai设置代理]]></title><link>https://blog.youkuaiyun.com/topalien/article/details/130683711</link><guid>https://blog.youkuaiyun.com/topalien/article/details/130683711</guid><author>topalien</author><pubDate>Mon, 15 May 2023 14:25:11 +0800</pubDate><description><![CDATA[【代码】python openai设置代理。]]></description><category></category></item><item><title><![CDATA[Django Model自定义IF、IFNULL函数]]></title><link>https://blog.youkuaiyun.com/topalien/article/details/129184953</link><guid>https://blog.youkuaiyun.com/topalien/article/details/129184953</guid><author>topalien</author><pubDate>Thu, 23 Feb 2023 16:55:44 +0800</pubDate><description><![CDATA[Django Model自定义IF、IFNULL函数]]></description><category></category></item><item><title><![CDATA[Django models动态默认值配置]]></title><link>https://blog.youkuaiyun.com/topalien/article/details/126351607</link><guid>https://blog.youkuaiyun.com/topalien/article/details/126351607</guid><author>topalien</author><pubDate>Mon, 15 Aug 2022 17:50:05 +0800</pubDate><description><![CDATA[models里可以定义default参数去设置默认值，但是这个值是写死的，不能根据其它字段值去动态调整，这个时候我们可以这么写。]]></description><category></category></item><item><title><![CDATA[antd select组件懒加载，后台搜索]]></title><link>https://blog.youkuaiyun.com/topalien/article/details/125414511</link><guid>https://blog.youkuaiyun.com/topalien/article/details/125414511</guid><author>topalien</author><pubDate>Wed, 22 Jun 2022 18:10:10 +0800</pubDate><description><![CDATA[antd react select 懒加载 后台搜索]]></description><category></category></item><item><title><![CDATA[sonar报错Results are temporarily unavailable. Indexing of issues is in progress.]]></title><link>https://blog.youkuaiyun.com/topalien/article/details/121136153</link><guid>https://blog.youkuaiyun.com/topalien/article/details/121136153</guid><author>topalien</author><pubDate>Thu, 04 Nov 2021 09:49:42 +0800</pubDate><description><![CDATA[不知道怎么出现的，看源码是因为还有问题需要同步，改一下数据库数据就行了。


update project_branches set need_issue_sync=false where need_issue_sync=true;


]]></description><category></category></item><item><title><![CDATA[django多个数据库，跨库查询、跨库关联]]></title><link>https://blog.youkuaiyun.com/topalien/article/details/117255474</link><guid>https://blog.youkuaiyun.com/topalien/article/details/117255474</guid><author>topalien</author><pubDate>Tue, 25 May 2021 14:35:04 +0800</pubDate><description><![CDATA[比如：当前数据库服务中有两个库，我要关联这两个库中的表，django要怎么写？看了很久的源码，原来很简单



首先，我们在settings.py默认连接是“a”库：


DATABASES = {
    'default': {
        'ENGINE': 'django.db.backends.mysql',
        'NAME': 'a', #默认连接a库
        'HOST': '127.0.0.1',
        'PORT': 3306,
        'USER]]></description><category></category></item><item><title><![CDATA[Django使用DBUtils.PooledDB作为数据库连接池]]></title><link>https://blog.youkuaiyun.com/topalien/article/details/115555984</link><guid>https://blog.youkuaiyun.com/topalien/article/details/115555984</guid><author>topalien</author><pubDate>Fri, 09 Apr 2021 17:57:57 +0800</pubDate><description><![CDATA[一、首先肯定要安装相应的模块的：


pip install pymysql
pip install DBUtils



二、在Django项目新建一个包（目录），这里直接建一个包：backends.mysql





三、mysql新建一个py文件，作为Django数据库引擎，名字好像必须用base.py



base.py内容如下：


#coding: utf-8
#author: Alien
#date  : 2021年3月31日

import pymysql
from django....]]></description><category></category></item><item><title><![CDATA[kityminder百度脑图转xmind]]></title><link>https://blog.youkuaiyun.com/topalien/article/details/114641092</link><guid>https://blog.youkuaiyun.com/topalien/article/details/114641092</guid><author>topalien</author><pubDate>Wed, 10 Mar 2021 17:27:02 +0800</pubDate><description><![CDATA[首先需要pip3 install xmind.

更多xmind用法可访问：https://pypi.org/project/XMind/


#coding: utf-8
#author: Alien
#date  : 2021年3月9日

import xmind
from xmind.core.markerref import MarkerId
from xmind.core import const

KitiMarkerValue = {
    'priority-1': 1,
    'pri]]></description><category></category></item><item><title><![CDATA[django中使用mysql连接池]]></title><link>https://blog.youkuaiyun.com/topalien/article/details/103715801</link><guid>https://blog.youkuaiyun.com/topalien/article/details/103715801</guid><author>topalien</author><pubDate>Thu, 26 Dec 2019 15:06:26 +0800</pubDate><description><![CDATA[连接池代码如下，并加入了一些sql生成的方便，便于编码：


#coding: utf-8
#author: alienliang
#date  : 2019年12月26日

import traceback, pymysql
from DBUtils.PooledDB import PooledDB

class MysqlPool:
    config = {
        'creato...]]></description><category></category></item><item><title><![CDATA[unittest+selenium实现断言失败截图]]></title><link>https://blog.youkuaiyun.com/topalien/article/details/100916152</link><guid>https://blog.youkuaiyun.com/topalien/article/details/100916152</guid><author>topalien</author><pubDate>Tue, 17 Sep 2019 11:40:05 +0800</pubDate><description><![CDATA[在用unittest断言的时候，会抛出一个self.failureException异常





所以我们只需要重写这个异常类就可以实现在抛出异常之前进行截图：


#coding: utf-8

import unittest, random, os, traceback
from selenium import webdriver

SCREENSHOT_DIR = 'D:\\'
clas...]]></description><category></category></item><item><title><![CDATA[导出mysql库的中所有表的结构信息]]></title><link>https://blog.youkuaiyun.com/topalien/article/details/86595191</link><guid>https://blog.youkuaiyun.com/topalien/article/details/86595191</guid><author>topalien</author><pubDate>Tue, 22 Jan 2019 15:16:38 +0800</pubDate><description><![CDATA[
#coding: utf-8
#author: Alien
#date  : 2019年1月17日

import pymysql, re, xlsxwriter, os

ROW_IDX = 0

class MySQLHelper(object):

    def __init__(self, host, port, user, passwd, db_name=None):
       ...]]></description><category></category></item><item><title><![CDATA[解决0x80240013]]></title><link>https://blog.youkuaiyun.com/topalien/article/details/79841262</link><guid>https://blog.youkuaiyun.com/topalien/article/details/79841262</guid><author>topalien</author><pubDate>Sat, 07 Apr 2018 14:37:19 +0800</pubDate><description><![CDATA[Win10更新应用时报错代码: 0x80240013的解决办法第一步：搜索并点击进入服务第二步：找到Windows Update，右键停止第三步：进入到 C:\windows\SoftwareDistribution\DataStore，如果找不到可同时按住Windows键+R键，输入%windir%\SoftwareDistribution\DataStore进入第四步：将该目录所有的文件删除，...]]></description><category></category></item><item><title><![CDATA[python获取Win10已保存的WIFI密码]]></title><link>https://blog.youkuaiyun.com/topalien/article/details/79829075</link><guid>https://blog.youkuaiyun.com/topalien/article/details/79829075</guid><author>topalien</author><pubDate>Thu, 05 Apr 2018 20:50:21 +0800</pubDate><description><![CDATA[#coding: gbk
#author: Alien
#date  : 2017年5月13日

import os, re
import xml.dom.minidom

#if is python2
#if sys.getdefaultencoding() != 'gbk': 
#    reload(sys) 
#    sys.setdefaultencoding('gbk')

clas...]]></description><category></category></item><item><title><![CDATA[Java解析JSON]]></title><link>https://blog.youkuaiyun.com/topalien/article/details/79828915</link><guid>https://blog.youkuaiyun.com/topalien/article/details/79828915</guid><author>topalien</author><pubDate>Thu, 05 Apr 2018 20:32:35 +0800</pubDate><description><![CDATA[import java.util.regex.Matcher;
import java.util.regex.Pattern;

import net.sf.json.JSONArray;
import net.sf.json.JSONObject;

/**
 * JSON解析
 * @author Alien
 * @since  2018-04-05
 */
public class JSO...]]></description><category></category></item><item><title><![CDATA[远程计算机或设备将不接受连接的解决方法]]></title><link>https://blog.youkuaiyun.com/topalien/article/details/79825630</link><guid>https://blog.youkuaiyun.com/topalien/article/details/79825630</guid><author>topalien</author><pubDate>Thu, 05 Apr 2018 13:11:43 +0800</pubDate><description><![CDATA[无法访问共享文件夹，诊断时报错“远程计算机或设备将不接受连接， 该设备或资源未设置为接受端口“文件和打印机共享(SMB)”上的连接”。解决办法为：进入网络属性，卸载“文件和打印机共享”然后再点击安装&amp;gt;服务&amp;gt;文件和打印机共享 ...]]></description><category></category></item></channel></rss>