def convert_date(self, d): if d is not None: if isinstance(d, basestring): return Timestamp(ReleaseSqlPublisher.ISO_DATE_TIME_FORMAT.parseDateTime(d).getMillis()) else: return Timestamp(DateTime(d).getMillis()) return None
def test_datetime(self): self.assertEquals(datetime.datetime(2008, 1, 1), Py.newDatetime(Timestamp(108, 0, 1, 0, 0, 0, 0))) self.assertEquals(datetime.datetime(2008, 5, 29, 16, 50, 0), Py.newDatetime(Timestamp(108, 4, 29, 16, 50, 0, 0))) self.assertEquals(datetime.datetime(2008, 5, 29, 16, 50, 1, 1), Py.newDatetime(Timestamp(108, 4, 29, 16, 50, 1, 1000)))
def insert_file_data_to_db_batch(): ''' FUNC FOR DATA INSERTING INTO DATABASE ''' ins_log("Adding data to DB...", 'Using JDBC from File') global conn, unarchived_file, lnNum, totalRecords, batch_size conn.setSchema(s_schema) truncate_table() conn.setAutoCommit(False) #jdbc_insert_sql = 'insert into dim_invalid_passports (pass_serial, pass_no, valid_to_dttm) values (?,?,?)'; jdbc_insert_sql = 'insert into dim_invalid_passports (pass_serial, pass_no, sys_actual_flg, sys_deleted_flg, valid_from_dttm, valid_to_dttm, sys_mod_by) values (?, ?, ?, ?, ?, ?, ? )' #print(jdbc_insert_sql); sql_statement = conn.prepareStatement(jdbc_insert_sql) reader = CSVReader(FileReader(unarchived_file)) #/* Read CSV file in OpenCSV */ nextLine = reader.readNext() while reader.readNext() != None: lnNum += 1 sql_statement.setString(1, replace_str(reader.readNext()[0])) sql_statement.setString(2, replace_str(reader.readNext()[1])) sql_statement.setInt(3, 1) sql_statement.setInt(4, 0) sql_statement.setTimestamp(5, Timestamp(System.currentTimeMillis())) sql_statement.setString(6, "01.01.2400") sql_statement.setString(7, "ODI_USER") sql_statement.addBatch() if lnNum % batch_size == 0 or reader.readNext() == None: sql_statement.executeBatch() #print(sql_statement.executeBatch()); conn.commit() sql_statement.close() ins_log('File inserted, ' + str(lnNum) + " rows added;", str(jdbc_insert_sql) + ' batch_size = ' + str(batch_size)) conn.close()
def updateToken(self, tokenObject): self.resetErrors() index = "resumptionTokens-UPDATE" sql = """ UPDATE resumptionTokens SET start = ?, expiry = ? WHERE token = ? """ fields = [ tokenObject.getStart(), Timestamp(tokenObject.getExpiry()), tokenObject.getToken() ] try: self.db.execute(self.dbName, index, sql, fields) #self.log.debug("=== updateToken()") #self.log.debug("=== TOKEN: '{}'", tokenObject.getToken()) #self.log.debug("=== METADATAPREFIX: '{}'", tokenObject.getMetadataPrefix()) #self.log.debug("=== EXPIRY: '{}'", tokenObject.getExpiry()) #self.log.debug("=== TOTALFOUND: '{}'", tokenObject.getTotalFound()) #self.log.debug("=== START: '{}'", tokenObject.getStart()) return True except Exception, e: # Something is wrong self.log.error("ERROR: ", e) self.error = True self.errorMsg = self.parseError(e) return False
def storeToken(self, tokenObject): self.resetErrors() index = "resumptionTokens-STORE" table = "resumptionTokens" fields = { "token": tokenObject.getToken(), "metadataPrefix": tokenObject.getMetadataPrefix(), "expiry": Timestamp(tokenObject.getExpiry()), "nextToken": tokenObject.getNextToken(), "resultJson": "" } FileUtils.writeStringToFile( File( FascinatorHome.getPath("oaipmh-results") + "/" + tokenObject.getToken()), tokenObject.getResultJson()) #self.log.debug("=== storeToken()") #self.log.debug("=== TOKEN: '{}'", tokenObject.getToken()) #self.log.debug("=== METADATAPREFIX: '{}'", tokenObject.getMetadataPrefix()) #self.log.debug("=== EXPIRY: '{}'", tokenObject.getExpiry()) #self.log.debug("=== TOTALFOUND: '{}'", tokenObject.getTotalFound()) #self.log.debug("=== START: '{}'", tokenObject.getStart()) try: self.db.insert(self.dbName, index, table, fields) except Exception, e: msg = self.parseError(e) if msg == "Duplicate record!": # Expected failure self.log.error("Duplicate record already exists in table!") else: # Something is wrong self.log.error("ERROR: ", e) self.error = True self.errorMsg = msg
def _to_timestamp(d): if isinstance(d, datetime.datetime): calendar = GregorianCalendar() calendar.set(d.year, d.month - 1, d.day, d.hour, d.minute, d.second) ts = Timestamp(calendar.getTimeInMillis()) ts.setNanos(d.microsecond * 1000) return ts else: return d
def findTimestamp(self, dateTup, timeTup): str_date = dateTup + " " + timeTup + " GMT" formatter = SimpleDateFormat("dd MMM yyyy HH:mm:ss z") p_date = formatter.parse(str_date) parsed_year = p_date.getYear() if parsed_year > 3000: print "parsed year is too large: " + str(parsed_year) return 0 else: sc_tmstmp = Timestamp(p_date.getTime()) return sc_tmstmp.getTime() / 1000
def testFormat(): dataManager = DALLocator.getDataManager() ws = dataManager.getDatabaseWorkspace("ARENA2_DB") server = ws.getServerExplorer() accidentesParameters = server.get("ARENA2_ACCIDENTES") dataManager = DALLocator.getDataManager() store = dataManager.openStore(accidentesParameters.getProviderName(), accidentesParameters) ft = store.getDefaultFeatureType() ehora = ft.getAttributeDescriptor("HORA_ACCIDENTE") ekm = ft.getAttributeDescriptor("KM") from java.sql import Timestamp from java.util import Date ts = Timestamp(Date().getTime()) print ehora.format(ts) print ekm.format(10.282999895) from java.lang import String print String.format("%.3f", 10.39283) print String.format("%tR", Timestamp(Date().getTime()))
def jTimestamp(da): # print da,type(da) if type(da) == java.sql.Timestamp: return da y = da.year - 1900 m = da.month - 1 d = da.day ho = da.hour mi = da.minute se = da.second ti = Timestamp(y, m, d, ho, mi, se, 0) # print "tttt",ti return ti
def findTimestamp (self, timeField): print "converting time: " + timeField formatter = SimpleDateFormat("yyyy-MM-dd HH:mm:ss z") p_date = formatter.parse(timeField + " HST") sc_tmstmp = Timestamp (p_date.getTime()) return sc_tmstmp.getTime() / 1000
from com.atlassian.jira.component import ComponentAccessor from java.sql import Timestamp import time customFieldManager = ComponentAccessor.getCustomFieldManager() userManager = ComponentAccessor.getUserManager() cfLastCaller = customFieldManager.getCustomFieldObject(11850) cfLastTime = customFieldManager.getCustomFieldObject(10135) caller = transientVars.get('context').getCaller() callTime = Timestamp(int(round(time.time() * 1000))) issue.setCustomFieldValue(cfLastCaller, userManager.getUserByKey(caller)) issue.setCustomFieldValue(cfLastTime, callTime)