WD wd0517

## README.md

      
              1 file
            
          
              0 forks
            
          
              0 comments
            
          
              0 stars
            
          
                wd0517
                / README.md
            
            
              Created
              July 13, 2023 06:16
            
              
                README
              
          
    Hi

  
## auto-gpt-test.log
 Auto-GPT ❯ python scripts/main.py --continuous
Continuous Mode:  ENABLED
WARNING:  Continuous mode is not recommended. It is potentially dangerous and may cause your AI to run forever or carry out actions you would not usually authorise. Use at your own risk.
Welcome back!  Would you like me to return to being TiDB-DBA-GPT2?
Continue with the last settings?
Name:  TiDB-DBA-GPT2
Role:  an AI designed to answer TiDB related quetions (TiDB is developed by PingCAP, its documents locate in https://docs.pingcap.com/)
Goals: ['explain what is TiDB', "find TiDB's latest stable version", 'shutdown upon acheive your goal']
Continue (y/n): y
Using memory of type: RedisMemory

## MySQL 5.7.8+ JSON Array Group By
CREATE TABLE `t1` (
  `jdoc` json DEFAULT NULL
)


insert into t1 values ('[3,4]');
insert into t1 values ('[1,2]');

# https://stackoverflow.com/questions/39906435/convert-json-array-in-mysql-to-rows
SELECT

## ruby_on_rails_v7_auth_secure_session_cookie_decrypt.py
import hashlib
import base64
import json
import urllib.parse
from Crypto.Cipher import AES


# Decrypt Discourse auth sercure session cookie
# Refer: https://gist.github.com/wildjcrt/6359713fa770d277927051fdeb30ebbf?permalink_comment_id=4157641
def decrypt_secure_session_cookie(cookie, secret_key_base):

## china_city_zh_en.csv

          
            City
            City_Admaster
            City_EN
            Province
            Province_EN
            Region
            Tier

            
              七台河
              七台河市
              Qitaihe
              黑龙江
              Heilongjiang
              North
              Tier 5

            
              三亚
              三亚市
              Sanya
              海南
              Hainan
              South
              Tier 3

            
              三明
              三明市
              Sanming
              福建
              Fujian
              East
              Tier 4

            
              三门峡
              三门峡市
              Sanmenxia
              河南
              Henan
              North
              Tier 5

            
              上海
              上海市
              Shanghai
              上海
              Shanghai
              East
              Tier 1

            
              上饶
              上饶市
              Shangrao
              江西
              Jiangxi
              South
              Tier 3

            
              东莞
              东莞市
              Dongguan
              广东
              Guangdong
              South
              new Tier 1

            
              东营
              东营市
              Dongying
              山东
              Shandong
              North
              Tier 4

            
              中卫
              中卫市
              Zhongwei
              宁夏
              Ningxia
              West
              Tier 5

## province_city.json
[
  {
    "statistical_code": "110000000000",
    "code": "11",
    "name": "北京市",
    "cities": [
      {
        "statistical_code": "110100000000",
        "code": "1101",
        "name": "市辖区"
	 Auto-GPT ❯ python scripts/main.py --continuous
	Continuous Mode: ENABLED
	WARNING: Continuous mode is not recommended. It is potentially dangerous and may cause your AI to run forever or carry out actions you would not usually authorise. Use at your own risk.
	Welcome back! Would you like me to return to being TiDB-DBA-GPT2?
	Continue with the last settings?
	Name: TiDB-DBA-GPT2
	Role: an AI designed to answer TiDB related quetions (TiDB is developed by PingCAP, its documents locate in https://docs.pingcap.com/)
	Goals: ['explain what is TiDB', "find TiDB's latest stable version", 'shutdown upon acheive your goal']
	Continue (y/n): y
	Using memory of type: RedisMemory
	CREATE TABLE `t1` (
	`jdoc` json DEFAULT NULL
	)


	insert into t1 values ('[3,4]');
	insert into t1 values ('[1,2]');

	# https://stackoverflow.com/questions/39906435/convert-json-array-in-mysql-to-rows
	SELECT
	import hashlib
	import base64
	import json
	import urllib.parse
	from Crypto.Cipher import AES


	# Decrypt Discourse auth sercure session cookie
	# Refer: https://gist.github.com/wildjcrt/6359713fa770d277927051fdeb30ebbf?permalink_comment_id=4157641
	def decrypt_secure_session_cookie(cookie, secret_key_base):
City	City_Admaster	City_EN	Province	Province_EN	Region	Tier
七台河	七台河市	Qitaihe	黑龙江	Heilongjiang	North	Tier 5
三亚	三亚市	Sanya	海南	Hainan	South	Tier 3
三明	三明市	Sanming	福建	Fujian	East	Tier 4
三门峡	三门峡市	Sanmenxia	河南	Henan	North	Tier 5
上海	上海市	Shanghai	上海	Shanghai	East	Tier 1
上饶	上饶市	Shangrao	江西	Jiangxi	South	Tier 3
东莞	东莞市	Dongguan	广东	Guangdong	South	new Tier 1
东营	东营市	Dongying	山东	Shandong	North	Tier 4
中卫	中卫市	Zhongwei	宁夏	Ningxia	West	Tier 5
	[
	{
	"statistical_code": "110000000000",
	"code": "11",
	"name": "北京市",
	"cities": [
	{
	"statistical_code": "110100000000",
	"code": "1101",
	"name": "市辖区"