- JAVA_HOMEを設定しておく
- KibanaをDL
- elasticsearchをDL
- それぞれ展開してコマンドラインから起動
function main(path){ | |
var fs = new ActiveXObject('Scripting.FileSystemObject'); | |
var folder = fs.GetFolder(path); | |
var i = new Enumerator(folder.Files); | |
var names = {}; | |
for(;!i.atEnd();i.moveNext()){ | |
var fpath = i.item() + ''; |
<?xml version="1.0" encoding="UTF-8" ?> | |
<project name="pomcheck" basedir="." > | |
<property name="m2dir" value="${user.home}/.m2/repository/" /> | |
<target name="all" depends="list-parent,concat-list-parent" /> | |
<target name="list-parent"> | |
<xslt | |
basedir="${m2dir}" | |
destdir="${basedir}/result" | |
includes="**/*.pom" | |
extension=".pom" |
<?xml version="1.0" encoding="utf-8"?> | |
<xsl:stylesheet version="2.0" | |
xmlns:xsl="http://www.w3.org/1999/XSL/Transform" | |
xmlns:xs="http://www.w3.org/2001/XMLSchema" | |
xmlns:fn="http://www.w3.org/2005/xpath-functions" | |
xmlns:ss="http://www.intra-mart.jp/document/ssjsdoc" | |
exclude-result-prefixes="xsl xs fn" | |
> | |
<xsl:output method="text" /> |
package test; | |
import javax.servlet.http.HttpServletRequest; | |
import javax.servlet.http.HttpServletResponse; | |
import jp.co.intra_mart.foundation.admin.tenant.model.Administrator; | |
import jp.co.intra_mart.foundation.security.certification.CertificationStatus; | |
import jp.co.intra_mart.foundation.security.certification.model.LoginInfo; | |
import jp.co.intra_mart.foundation.security.certification.provider.AdministratorCertification; |
select | |
table_name, | |
to_number( | |
extractvalue( | |
xmltype( | |
dbms_xmlgen.getxml('select count(*) c from '||table_name)) | |
,'/ROWSET/ROW/C')) count | |
from user_tables | |
WHERE TABLE_NAME NOT LIKE 'BIN$%' | |
and (iot_type != 'IOT_OVERFLOW' or iot_type is null) |
Sub getSheetNames() | |
Dim s As Worksheet | |
Dim r As Integer | |
set s = ActiveWorkbook.Sheets.Add | |
r = 1 | |
For Each x In ActiveWorkbook.Sheets | |
s.Cells(r, 1).Value = x.Name |
$files = ls $Pwd; | |
foreach($file1 in ls){ | |
$cont1 = Get-Content $file1 | |
#$cont1 = Get-Content -Tail 15 $file1 | |
foreach($file2 in ls){ | |
echo $file1.Name $file2.Name | |
$cont2 = Get-Content $file2 | |
#$cont2 = Get-Content -Tail 15 $file2 | |
diff -ReferenceObject $cont1 -DifferenceObject $cont2 | |
} |
DROP USER IAP_USER CASCADE; | |
-- USER SQL | |
CREATE USER "IAP_USER" IDENTIFIED BY iap_user | |
ACCOUNT UNLOCK ; | |
-- ROLES | |
GRANT "RESOURCE" TO "IAP_USER" ; | |
GRANT "CONNECT" TO "IAP_USER" ; | |
-- SYSTEM PRIVILEGES |
<driver> | |
<type>oracle.jdbc.driver.OracleDriver</type> | |
<url>jdbc:oracle:thin:@localhost:1521:sid</url> | |
<user>user</user> | |
<password>pass</password> | |
</driver> |