node ssh上传本地文件到服务器指定路径

大年初一 2021/03/02

来自：北京市-电信

/*
 * @Date: 2021-03-02 10:40:49
 * @Description: ssh文件上传
 * @FilePath: /put/put.js
 */

 'use strict'

 const Client = require('ssh2-sftp-client')
 const config = {
   path: {
     // 远程地址
     romotePath: '/data/app/vue/dist',
     // 本地路径
     localpath: './dist'
   },
   romote: {
     // 服务器ip
     host: 'x.x.x.x',
     // 端口默认22
     port: '22',
     // 用户名
     username: 'root',
     // 密码
     password: 'xxxxxx'
   },
 }

/*
 * 主方法
 * localPath 本地路径
 * romotePath 远程路径
 */
 function main (localPath, romotePath) {
    const sftp = new Client()
    sftp.connect(config.romote).then(() => {
      console.log('-----链接成功------')
      return sftp.uploadDir(localPath, romotePath)
    }).then((data) => {
      console.log(data)
      console.log('-----上传完成，及时清除缓存------')
    }).catch(err => {
      console.log(err)
      console.log('-----TMD失败了，出事了，快看看怎么回事-----')
    }).finally(() => {
       // 断开链接
       sftp.end()
    })
 }

 main(config.path.localpath, config.path.romotePath)

• 

  大年初一 2021/04/09 第1楼

  来自：北京市-电信
  mysql删除重复值

  DELETE
  FROM 
  	recruit 
  WHERE 
  	phone IN (
  		SELECT 
  			t.phone 
  		FROM
  			(
  				SELECT
  					phone
  				FROM	
  					recruit
  				GROUP BY
  					phone
  				HAVING
  					COUNT(1) > 1
  			) t
  	)

  回复
• 

  大年初一 2021/04/09 第2楼

  来自：北京市-电信
  查询重复的

  SELECT
  	phone
  FROM
  	recruit
  WHERE
  	phone IN (
  		SELECT 
  			phone
  		FROM
  			recruit
  		GROUP BY
  			phone
  		HAVING
  			COUNT(1) > 1
  	)

  回复