0.00.0100011YY5000YN1000charlie10.85.16.58081clusterEncrypted 2be98c2a906cea2a19936ff228dc6ee9bNN2013/08/22 22:40:59.5662007/09/11 21:34:50.919H4sIAAAAAAAAAAMAAAAAAAAAAAA=Novo dodaje slike nastavnika, treba paziti u prvoj kontroli direktorij iz kojeg se ucitavaju slike i moraju biti nazivi po username.u tak da se lakse inserta
PARAMETRI:
slikedirnastavnici6441683078Noto Sans9NN000255205112100100100Yanketa-parametar${proddbhost}MYSQLNative${proddbname}3306${proddbuser}${proddbpass}EXTRA_OPTION_MYSQL.characterEncodingutf8EXTRA_OPTION_MYSQL.useUnicodetrueFORCE_IDENTIFIERS_TO_LOWERCASENFORCE_IDENTIFIERS_TO_UPPERCASENIS_CLUSTEREDNPORT_NUMBER3306PRESERVE_RESERVED_WORD_CASEYQUOTE_ALL_FIELDSNSTREAM_RESULTSYSUPPORTS_BOOLEAN_DATA_TYPEYSUPPORTS_TIMESTAMP_DATA_TYPEYUSE_POOLINGNJava Script ValueinsertPicture_PARAMETARYReplace in stringDatabase joinYDatabase joinJava Script ValueYGet variablesGet File NamesYGet File NamesSelect valuesYSelect valuesReplace in stringYDatabase joinDBJoinY1noneanketa-parametar0select * from uzer where username=?NNusernameString1056240YGet File NamesGetFileNamesY1noneall_filesNNNNN0${slikedirnastavnici}.*\.jpgNN40080YGet variablesGetVariableY1noneslikedirnastavnici${slikedirnastavnici}String-1-1none19264YJava Script ValueScriptValueModY1noneY90ScriptValueif (getFileSize(filename)>0) then
{
file = new Packages.java.io.File(filename.getString());
fileInputStream = new Packages.java.io.FileInputStream(file);
var content = Packages.org.pentaho.di.core.Const.createByteArray(file.length());
fileInputStream.read(content, 0, file.length());
fileInputStream.close();
}contentcontentBinary-1-1N1248144YReplace in stringReplaceStringN1noneshort_filenameusernameno.jpg@efzg.hrNnonono816192YinsertPicture_PARAMETARInsertUpdateY1noneanketa-parametar100N