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)
