登录 注册
开源 企业版 高校版 私有云 Gitee AI NEW
扫描微信二维码支付
取消
支付完成
Watch
不关注 关注所有动态 仅关注版本发行动态 关注但不提醒动态
1 Star 0 Fork 0

liubinan/digoal_blog

代码 Issues 0 Pull Requests 0 Wiki 统计 流水线
服务
加入 Gitee
与超过 1200万 开发者一起发现、参与优秀开源项目，私有仓库也完全免费 ：）
免费加入
克隆/下载
generate_readme.sh 15.00 KB
一键复制 编辑 原始数据 按行查看 历史
Digoal.zhou 提交于 2024-09-14 10:28 . Update generate_readme.sh
123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222
#!/bin/bash



# 在blog目录调用

# 如果文件格式不对, 使用dos2unix转换

# 例如 file 201608/20160823_01.md

#      201608/20160823_01.md: UTF-8 Unicode C program text, with CRLF line terminators 说明需要转换 

# 例如 dos2unix -c ASCII -o ./20161031_02.md 

#      dos2unix: converting file ./20161031_02.md to UNIX format ...

# 迁移从163 blog 63页 <数据挖掘学习站点收集>开始算新文章迁移到本级目录,之前的算老文章迁移到old_blogs_from_163



> ./README.md

echo "#### [About me](me/readme.md) " >> ./README.md

echo "  "  >> ./README.md

echo "### 一、PostgreSQL, Greenplum 学习视频  " >> ./README.md

echo "  "  >> ./README.md

echo "1、视频下载链接： https://pan.baidu.com/s/1Q5u5NSrb0gL5-psA9DCBUQ   (提取码：5nox   如果链接失效请通知我, 谢谢)  " >> ./README.md

echo "- PostgreSQL 9.3 数据库管理与优化 4天  " >> ./README.md

echo "- PostgreSQL 9.3 数据库管理与优化 5天  " >> ./README.md

echo "- PostgreSQL 9.3 数据库优化 3天  " >> ./README.md

echo "- PostgreSQL 9.1 数据库管理与开发 1天  " >> ./README.md

echo "- PostgreSQL 专题讲座  " >> ./README.md

echo "  "  >> ./README.md

echo "2、[《2021-重新发现PG之美 系列 - 适合架构师与业务开发者》](202105/20210526_02.md)  " >> ./README.md

echo "3、[《2021-DB吐槽大会 系列 - 适合产品经理、架构师与内核开发者》](202108/20210823_05.md)  " >> ./README.md

echo "4、[《2020-PostgreSQL 应用场景最佳实践 - 适合架构师与业务开发者》](202009/20200903_02.md)  " >> ./README.md

echo "5、[《2020-PostgreSQL+MySQL 联合解决方案课程 - 适合架构师与业务开发者》](202001/20200118_02.md)  " >> ./README.md

echo "6、[《2019-PostgreSQL 2天体系化培训 - 适合DBA》](201901/20190105_01.md)  " >> ./README.md 

echo "7、[《2017-PostgreSQL 应用场景实践 - 适合架构师与业务开发者》](201805/20180524_02.md)  " >> ./README.md 

echo "8、[《2019-PG天天象上沙龙纪录 - 适合DBA》](201801/20180121_01.md)  " >> ./README.md 

echo "9、[《2019-Oracle迁移到PostgreSQL - 适合DBA与业务开发者》](201906/20190615_03.md)    " >> ./README.md 

echo "10、[《2021-Ask 德哥 系列 - 适合DBA与业务开发者》](202109/20210928_01.md)    " >> ./README.md 

echo "11、[《2018-PG生态、案例、开发实践系列 - 适合架构师与业务开发者》](https://edu.aliyun.com/course/836/lesson/list)  "  >> ./README.md

echo "12、[《2018-阿里云POLARDB for Oracle|RDS for PPAS 讲解视频》](https://yq.aliyun.com/live/582)  "  >> ./README.md   

echo "13、[《2022-每天5分钟,PG聊通透 - 系列1 - 热门问题》](202112/20211209_02.md)   "  >> ./README.md   

echo "14、[《2023-PostgreSQL|PolarDB 学习实验手册》](202308/20230822_02.md)     "  >> ./README.md   

echo "15、[《2023-PostgreSQL|PolarDB 永久免费实验环境》](https://developer.aliyun.com/adc/scenario/f55dbfac77c0467a9d3cd95ff6697a31)     "  >> ./README.md    

echo "16、[《2024-开源PolarDB|PostgreSQL 应用开发者&DBA 公开课》](202310/20231030_02.md)     "  >> ./README.md    

echo "17、[《2023-PostgreSQL Docker镜像学习环境 ARM64版, 已集成热门插件和工具》](202308/20230814_02.md)     "  >> ./README.md    

echo "18、[《2023-PostgreSQL Docker镜像学习环境 AMD64版, 已集成热门插件和工具》](202307/20230710_03.md)     "  >> ./README.md    

echo "19、[《2024-应用开发者 数据库筑基课》](202409/20240914_01.md)     "  >> ./README.md    

echo "  "  >> ./README.md

echo "### 二、学习资料  " >> ./README.md

echo "  "  >> ./README.md

echo "1、[《Oracle DBA 增值+转型 PostgreSQL 学习方法、路径》](201804/20180425_01.md)   " >> ./README.md 

echo "2、[《PostgreSQL、Greenplum 技术+108个场景结合最佳实践《如来神掌》》](201706/20170601_02.md)    " >> ./README.md

echo "3、[《PostgreSQL 数据库安全指南 - 以及安全合规》](201506/20150601_01.md)    " >> ./README.md

echo "4、[《PostgreSQL 持续稳定使用的小技巧 - 最佳实践、规约、规范》](201902/20190219_02.md)    " >> ./README.md

echo "5、[《PostgreSQL DBA最常用SQL》](202005/20200509_02.md)    " >> ./README.md

echo "6、[《PostgreSQL 数据库开发规范》](201609/20160926_01.md)    " >> ./README.md

echo "7、[《企业数据库选型规则》](197001/20190214_01.md)    " >> ./README.md

echo "8、[《PostgreSQL 规格评估 - 微观、宏观、精准 多视角估算数据库性能(选型、做预算不求人)》](201709/20170921_01.md)    " >> ./README.md

echo "9、[《数据库选型之 - 大象十八摸 - 致 架构师、开发者》](201702/20170209_01.md)    " >> ./README.md

echo "10、[《数据库选型思考(PostgreSQL,MySQL,Oracle)》](201702/20170208_03.md)    " >> ./README.md

echo "11、[《快速入门PostgreSQL应用开发与管理 - 1 如何搭建一套学习、开发PostgreSQL的环境》](201704/20170411_01.md)    " >> ./README.md

echo "12、[《快速入门PostgreSQL应用开发与管理 - 2 Linux基本操作》](201704/20170411_02.md)    " >> ./README.md

echo "13、[《快速入门PostgreSQL应用开发与管理 - 3 访问数据》](201704/20170411_03.md)    " >> ./README.md

echo "14、[《快速入门PostgreSQL应用开发与管理 - 4 高级SQL用法》](201704/20170411_04.md)    " >> ./README.md

echo "15、[《快速入门PostgreSQL应用开发与管理 - 5 数据定义》](201704/20170411_05.md)    " >> ./README.md

echo "16、[《快速入门PostgreSQL应用开发与管理 - 6 事务和锁》](201704/20170412_01.md)    " >> ./README.md

echo "17、[《快速入门PostgreSQL应用开发与管理 - 7 函数、存储过程和触发器》](201704/20170412_02.md)    " >> ./README.md

echo "18、[《快速入门PostgreSQL应用开发与管理 - 8 PostgreSQL 管理》](201704/20170412_04.md)    " >> ./README.md

echo "19、[PolarDB开源数据库高校工作室 发布《PostgreSQL+PolarDB开源数据库人才认证培训》教程+实验手册 下载](202306/20230616_03.md)    " >> ./README.md

echo "  "  >> ./README.md

echo "### 三、[感恩](201803/20180322_12.md)  " >> ./README.md

echo "### 四、[思考](class/35.md)  " >> ./README.md

echo "  "  >> ./README.md

echo "1、[《德说》](202108/20210818_02.md)     " >> ./README.md 

echo "2、[《读书分享 第1期 - 《臣服实验》》](202203/20220312_01.md)       " >> ./README.md 

echo "3、[《PG社区建设方法论 - 五看三定》](202103/20210329_01.md)     " >> ./README.md 

echo "4、[《PostgreSQL 社区建设思考》](202004/20200426_01.md)    " >> ./README.md

echo "5、[《PostgreSQL 社区建设商业策划 {未完}》](202008/20200828_01.md)      " >> ./README.md

echo "6、[《[未完] PostgreSQL\Greenplum 社区管理 TODO》](201710/20171017_05.md)    " >> ./README.md

echo "7、[《[未完] PostgreSQL\Greenplum Customer视角TODO》](201710/20171017_01.md)    " >> ./README.md

echo "8、[《为什么企业应该参与PG社区建设?》](202003/20200321_01.md)    " >> ./README.md

echo "9、[《为什么数据库选型和找对象一样重要》](202003/20200322_01.md)    " >> ./README.md

echo "10、[《云、商业、开源数据库终局之战 - 商业角度解读PG如何破局 - openapi 、 扩展能力、插件开源协议》](202007/20200727_04.md)    " >> ./README.md

echo "11、[《[直播]大话数据库终局之战》](202009/20200926_03.md)      " >> ./README.md

echo "12、[《未来数据库方向 - 以及PostgreSQL 有价值的插件、可改进功能、开放接口 (202005)》](202005/20200527_06.md)    " >> ./README.md

echo "13、[《《引爆点》原理, 如何影响PG发展》](197001/20200804_01.md)      " >> ./README.md

echo "14、[《打破惯性思维, 引导创新, 引爆流行, PG》](202104/20210411_01.md)        " >> ./README.md

echo "15、[《PostgreSQL 核心卖点提取方法》](202006/20200609_02.md)   " >> ./README.md 

echo "16、[《开源数据库全球化协作浪潮 思考 - 24问》](202101/20210120_02.md)       " >> ./README.md

echo "17、[《企业CxO数据库选型应该回答清楚的 15 个问题》](202101/20210117_04.md)         " >> ./README.md

echo "  "  >> ./README.md

echo "PG官方微信 | PG技术进阶钉钉群</br>每周直播 | digoal </br>个人微信  " >> ./README.md

echo "---|---|---  " >> ./README.md

echo "[pic](./pic/pg_weixin.jpg) | [pic](./pic/dingding_pg_chat.png) | [image.png](https://ucc.alicdn.com/pic/developer-ecology/24ff1d42e2cf4f3a8ae166a243f58cb3.png)  " >> ./README.md

echo "  "  >> ./README.md

#echo "PG社区认证 | PG社区认证</br>联系人微信 " >> ./README.md

#echo "---|---  " >> ./README.md

#echo "![pic](./pic/pgcert.jpg) | ![pic](./pic/huhui.jpg)  " >> ./README.md

#echo "  "  >> ./README.md

echo "如发现错误, 请万望指正, 非常感谢.  "  >> ./README.md

echo "  "  >> ./README.md

echo "欢迎转载(注明出处), 如有问题, 请发issue讨论或微信与我联系, 定抽空尽快回复  " >> ./README.md

echo "  "  >> ./README.md

echo "### 五、已归类文档(大部分文章未归类, 请看第六部分 ... ...)  " >> ./README.md

sed 's/](/](class\//g' class/README.md >> ./README.md

echo "  "  >> ./README.md

echo "### Star History  "  >> ./README.md 

echo "[![Star History Chart](https://api.star-history.com/svg?repos=digoal/blog&type=Date)](https://star-history.com/#digoal/blog&Date)  "   >> ./README.md

echo "  "  >> ./README.md

echo "### 六、所有文档如下  " >> ./README.md



for dir in `ls -lr|awk '{print $9}'|grep -E '^[0-9]{6}'` 

do

  cd $dir

  echo "<a rel=\"nofollow\" href=\"http://info.flagcounter.com/h9V1\"  ><img src=\"http://s03.flagcounter.com/count/h9V1/bg_FFFFFF/txt_000000/border_CCCCCC/columns_2/maxflags_12/viewers_0/labels_0/pageviews_0/flags_0/\"  alt=\"Flag Counter\"  border=\"0\"  ></a>  " > ./readme.md

  echo "  " >> ./readme.md

  echo "### 文章列表  "  >> ./readme.md

  echo "----  "  >> ./readme.md

  echo "----  " >> ../README.md

  for file in `ls -lr *.md|awk '{print $9}'|grep -E '^[0-9]{8}'` 

  do 

    title=`head -n 1 ${file}|awk -F "##" '{print $2}'|sed 's/^[ ]*//; s/[ ]*$//'`

    echo "##### ${file}   [《${title}》](${file})  " >> ./readme.md

    echo "##### ${dir}/${file}   [《${title}》](${dir}/${file})  " >> ../README.md

# ######################  go go go

# macos 例子 sed -i "" '/57258f76c37864c6e6d23383d05714ea/d' ${file}

# linux 例子 sed -i '/57258f76c37864c6e6d23383d05714ea/d' ${file}

# ###XYQ###

#sed -i "" '/269ac3d1c492e938c0191101c7238216/d' ${file}

# ###FREEURL###   

#sed -i "" '/57258f76c37864c6e6d23383d05714ea/d' ${file}

# ###POLARONEURL###

#sed -i "" '/8642f60e04ed0c814bf9cb9677976bd4/d' ${file}

# ###ALIPGURL###   

#sed -i "" '/40cff096e9ed7122c512b35d8561d9c8/d' ${file}

# ###LINK###   

#sed -i "" '/22709685feb7cab07d30f30387f0a9ae/d' ${file}

# ###WXLINK###   

#sed -i "" '/f7ad92eeba24523fd47a6e1a0e691b59/d' ${file}

# ###ABOUTDIGOAL###   

#sed -i "" '/a37735981e7704886ffd590565582dd0/d' ${file}

# ###POLARDBYUNDASHI###   

#sed -i "" '/e0495c413bedacabb75ff1e880be465a/d' ${file}

## 

    XYQ=`grep "269ac3d1c492e938c0191101c7238216" ${file}|grep -c "269ac3d1c492e938c0191101c7238216"`

    if [ $XYQ -lt 1 ]; then

      echo "  " >> ./${file}

      echo "#### [期望 PostgreSQL|开源PolarDB 增加什么功能?](https://github.com/digoal/blog/issues/76 \"269ac3d1c492e938c0191101c7238216\")" >> ./${file}

      echo "  " >> ./${file}

    fi

##

    FREEURL=`grep "57258f76c37864c6e6d23383d05714ea" ${file}|grep -c "57258f76c37864c6e6d23383d05714ea"`

    if [ $FREEURL -ne 1 ]; then

      echo "  " >> ./${file}

      echo "#### [PolarDB 开源数据库](https://openpolardb.com/home \"57258f76c37864c6e6d23383d05714ea\")" >> ./${file}

      echo "  " >> ./${file}

    fi

##

    POLARONEURL=`grep "8642f60e04ed0c814bf9cb9677976bd4" ${file}|grep -c "8642f60e04ed0c814bf9cb9677976bd4"`

    if [ $POLARONEURL -ne 1 ]; then

      echo "  " >> ./${file}

      echo "#### [PolarDB 学习图谱](https://www.aliyun.com/database/openpolardb/activity \"8642f60e04ed0c814bf9cb9677976bd4\")" >> ./${file}

      echo "  " >> ./${file}

    fi

## 

###    POLARDBYUNDASHI=`grep "e0495c413bedacabb75ff1e880be465a" $file|grep -c "e0495c413bedacabb75ff1e880be465a"`

###    if [ $POLARDBYUNDASHI -ne 1 ]; then

###      echo "  " >> ./$file

###      echo "#### [PolarDB 安可版](https://www.aliyun.com/activity/database/polardb-v2 \"e0495c413bedacabb75ff1e880be465a\")" >> ./$file

###      echo "  " >> ./$file

###    fi

##

    ALIPGURL=`grep "40cff096e9ed7122c512b35d8561d9c8" ${file}|grep -c "40cff096e9ed7122c512b35d8561d9c8"`

    if [ $ALIPGURL -ne 1 ]; then

      echo "  " >> ./${file}

      echo "#### [PostgreSQL 解决方案集合](../201706/20170601_02.md \"40cff096e9ed7122c512b35d8561d9c8\")" >> ./${file}

      echo "  " >> ./${file}

    fi

## 

    LINK=`grep "22709685feb7cab07d30f30387f0a9ae" $file|grep -c "22709685feb7cab07d30f30387f0a9ae"`

    if [ $LINK -ne 1 ]; then

      echo "  " >> ./$file

      echo "#### [德哥 / digoal's Github - 公益是一辈子的事.](https://github.com/digoal/blog/blob/master/README.md \"22709685feb7cab07d30f30387f0a9ae\")" >> ./$file

      echo "  " >> ./$file

    fi

## 

    ABOUTDIGOAL=`grep "a37735981e7704886ffd590565582dd0" $file|grep -c "a37735981e7704886ffd590565582dd0"`

    if [ $ABOUTDIGOAL -ne 1 ]; then

      echo "  " >> ./$file

      echo "#### [About 德哥](https://github.com/digoal/blog/blob/master/me/readme.md \"a37735981e7704886ffd590565582dd0\")" >> ./$file

      echo "  " >> ./$file

    fi

## 

    WXLINK=`grep "f7ad92eeba24523fd47a6e1a0e691b59" $file|grep -c "f7ad92eeba24523fd47a6e1a0e691b59"`

    if [ $WXLINK -ne 1 ]; then

      echo "  " >> ./$file

      echo "![digoal's wechat](../pic/digoal_weixin.jpg \"f7ad92eeba24523fd47a6e1a0e691b59\")" >> ./$file

      echo "  " >> ./$file

    fi

##

#    DSLINK=`grep "acd5cce1a143ef1d6931b1956457bc9f" ${file}|grep -c "acd5cce1a143ef1d6931b1956457bc9f"`

#    if [ $DSLINK -ne 1 ]; then

#      echo "  " >> ./${file}

#      echo "#### 打赏都逃不过老婆的五指山 －_－b  " >> ./$file

#      echo "![wife's weixin ds](../pic/wife_weixin_ds.jpg \"acd5cce1a143ef1d6931b1956457bc9f\")" >> ./$file

#      echo "  " >> ./$file

#    fi

# ######  sed -i '/打赏都逃不过老婆的五指山/d' ${file}

# ######  sed -i '/acd5cce1a143ef1d6931b1956457bc9f/d' $file

#

#    FLAG=`grep "flagcounter" $file|grep -c "href"`

#    if [ $FLAG -ne 1 ]; then

#      echo "  " >> ./$file

#      echo "<a rel=\"nofollow\" href=\"http://info.flagcounter.com/h9V1\"  ><img src=\"http://s03.flagcounter.com/count/h9V1/bg_FFFFFF/txt_000000/border_CCCCCC/columns_2/maxflags_12/viewers_0/labels_0/pageviews_0/flags_0/\"  alt=\"Flag Counter\"  border=\"0\"  ></a>  " >> ./$file

#      echo "  " >> ./$file

#    fi

# ######   sed -i '/href=\"http:\/\/info.flagcounter.com\/h9V1/d' $file

  done

  cd ..

done



echo "### digoal,德哥的PostgreSQL私房菜, 老文章 : [进入](old_blogs_from_163/README.md)  " >> ./README.md



echo "<a rel=\"nofollow\" href=\"http://info.flagcounter.com/h9V1\"  ><img src=\"http://s03.flagcounter.com/count/h9V1/bg_FFFFFF/txt_000000/border_CCCCCC/columns_2/maxflags_12/viewers_0/labels_0/pageviews_0/flags_0/\"  alt=\"Flag Counter\"  border=\"0\"  ></a>  " >> ./README.md

echo "  " >> ./README.md



cd old_blogs_from_163

. ./generate_readme.sh

cd ..
马建仓 AI 助手
尝试更多
代码解读
代码找茬
代码优化
1
https://gitee.com/liubinan/digoal_blog.git
[email protected]:liubinan/digoal_blog.git
liubinan
digoal_blog
digoal_blog
master
点此查找更多帮助

搜索帮助

Git 命令在线学习 如何在 Gitee 导入 GitHub 仓库
Git 仓库基础操作
企业版和社区版功能对比
SSH 公钥设置
如何处理代码冲突
仓库体积过大，如何减小？
如何找回被删除的仓库数据
Gitee 产品配额说明
GitHub仓库快速导入Gitee及同步更新
什么是 Release（发行版）
将 PHP 项目自动发布到 packagist.org
评论
仓库举报
回到顶部