DevOps 应用集

开发流程之git命令

Posted on 10 11 月, 201910 11 月, 2019 by admin

1. checkout 远端开发branch到本地,

git checkout -b local_dev_branch origin/dev

2. 本地修改代码, 然后提交代码, 例如如下提交java文件.

git commit -m *.java "modified java files"

3. 本地修改后, 提交代码到远端, 远端的branch名可与本地相同,等待review, local_dev_branch_for_remote 就是远端branch名

git push origin local_dev_branch:local_dev_branch_for_remote

4. 当review后需要继续修改,重复步骤 2-3, reviewed通过merge到dev branch后, 可以删除远端branch

git push --delete origin local_dev_branch_for_remote

5.然后删除本地branch

# change to other branch before delete
git checkout other_local_branch
# delete
git branch -D  local_dev_branch
Posted in Git, LinuxTagged git, LinuxLeave a Comment on 开发流程之git命令

Mac上start/stop jenkins服务

Posted on 10 11 月, 2019 by admin
## start 
sudo launchctl load /Library/LaunchDaemons/org.jenkins-ci.plist
## stop 
sudo launchctl unload /Library/LaunchDaemons/org.jenkins-ci.plist
Posted in Jenkins, LinuxTagged JenkinsLeave a Comment on Mac上start/stop jenkins服务

一些常用命令举例

Posted on 22 5 月, 201910 11 月, 2019 by admin

1. Remove all docker containers

docker rm $(docker ps -a -q)

2. Stop all docker containers

docker stop $(docker ps -a -q)

3. 利用pem登录server无需password

ssh -T -o StrictHostKeyChecking=no -o UserKnownHostsFile=/dev/null -i ~/.ssh/someuser.pem username@host
Posted in docker, LinuxTagged docker, LinuxLeave a Comment on 一些常用命令举例

Java 脚本连接hana 数据库

Posted on 29 3 月, 2019 by admin

请见如下code:获取hana kernel信息 和 license 信息
请 google ‘ngdbc jar’ 或直接下载附件zip包,解压后引用jar包即可 连接hana驱动jar

import java.sql.Connection;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;

	static void query_info(String ip, String port, String tename, String user, String password) {
		String perline = "";
		Connection connection = null;
		String hostname = null;
		String lisdate = null;
		String liedate = null;
		String version = null;
		String kernel = null;
		try {

			Class.forName("com.sap.db.jdbc.Driver");
			String url = "jdbc:sap://" + ip + ":" + port + "/" + tename + ""; 

			connection = java.sql.DriverManager.getConnection(url, user, password);

			System.out.println("Connection done");

		} catch (Exception e) {
			System.err.println(ip + " Connection failed!" + e.getMessage());
		}

		if (connection != null) {
			try {
				System.out.println(ip + "  Connection to HANA successful!");

				// query license start/end date
				Statement stmt = connection.createStatement();
				ResultSet resultSet = stmt.executeQuery("select * from SYS.M_LICENSE ");

				resultSet.next();
				lisdate = resultSet.getString("START_DATE");
				liedate = resultSet.getString("EXPIRATION_DATE");

				System.out.println(lisdate);
				System.out.println(liedate);

				// query version info
				stmt = connection.createStatement();
				resultSet = stmt.executeQuery("select value from SYS.M_SYSTEM_OVERVIEW where name='Version'");

				resultSet.next();
				version = resultSet.getString("value");

				// query kernel info
				stmt = connection.createStatement();
				resultSet = stmt
						.executeQuery("select host,value from SYS.M_HOST_INFORMATION where key='os_kernel_version'");

				resultSet.next();
				kernel = resultSet.getString("value");
				hostname = resultSet.getString("host");

				System.out.println(version);
				System.out.println(kernel);
				System.out.println(hostname);

				resultSet.close();
				stmt.close();
				connection.close();


			} catch (SQLException e) {
				System.err.println("Query failed!" + e.getMessage());
			}
		}

	}

Posted in Hana, JavaLeave a Comment on Java 脚本连接hana 数据库

远程调用 selenium server过程

Posted on 12 3 月, 2019 by admin

Server 端:
需要提前安装 firefox 和 selenium jar 还有 gecko packages.

1) 启动 selenium server, e.g.

java -jar selenium-server-standalone-3.141.5.jar -role hub

2) 启动 geckodriver with firefox browser, e.g.

 java -Dwebdriver.gecko.driver=/path/to/geckodriver -Dwebdriver.firefox.bin=/path/to/firefox-bin -jar /path/to/selenium-server-standalone-3.141.5.jar -role node -port 6666 -hub http://serverIP:4444/grid/register -browser browserName=firefox

至此, selenium server 开始接收远程test case调用.

Remote 端:

我们用java code连接, 如下:

//support firefox
DesiredCapabilities capabilities = DesiredCapabilities.firefox();
		
//set firefox path on server 	
String firefoxBinPath="/path/to/firefox-bin";
capabilities.setCapability("firefox_binary",firefoxBinPath);

seleniumHost="ServerIP";
seleniumPort=6666;
//connect remote
WebDriver remoteSelenium = new RemoteWebDriver(
new URL("http://" + seleniumHost + ":" + String.valueOf(seleniumPort) + "/wd/hub"), capabilities);

在运行远端test case之前,需要启动server firefox的伺服,请查看 firefox 启动

Posted in Java, SeleniumLeave a Comment on 远程调用 selenium server过程

文章导航

较旧文章
较新文章

近期文章

  • Oracle表中字段为timestamp值转化为date显示的sql语句
  • 解决idea环境代码保存后不能实时编译的问题
  • 自定义XStream fields序列化顺序
  • Oracle 修改blob为clob,clob为blob
  • Apple Script: 备份Mac Notes到PDFs

近期评论

    归档

    • 2021 年 2 月
    • 2020 年 8 月
    • 2020 年 7 月
    • 2020 年 1 月
    • 2019 年 11 月
    • 2019 年 5 月
    • 2019 年 3 月
    • 2019 年 2 月
    • 2018 年 12 月

    分类

    • Apple Script
    • docker
    • Git
    • gRPC
    • Hana
    • Idea
    • Java
    • Jenkins
    • Linux
    • Maven
    • Mockito
    • Oracle
    • Selenium
    • Sona
    • SpringBoot
    • Tomcat
    • Uncategorized
    • VirtualBox
    • VMWare
    • VPN
    • XML

    其他操作

    • 登录
    • 条目 feed
    • 评论 feed
    • WordPress.org

    bidvertiser

    Powered by DoHints.cn