Skip to main content
Solved

how to generate UUID bases on timestamp

A
Discovered Fame

Hi Team

 

I have a date datefield storing current datetime in it want to create a UUID using same column how i can create . currently using groovy script to create UUID but want to use same column and create it 

Best answer by Bikram

@akanshajain6793 

 

I tried this in jython , kindly try it in your pipeline and let me know if it helps.

 

from datetime import datetime
from uuid import uuid4
date_time = datetime.now().strftime('%Y%m-%d%H-%M%S')
eventid = date_time + str(uuid4())

for record in sdc.records:
  try:
    
    record.value['data'] = eventid
    # Write record to processor output
    sdc.output.write(record)

  except Exception as e:
    # Send record to error
    sdc.error.write(record, str(e))

View original
Did this topic help you find an answer to your question?

5 replies

Bikram
Headliner
Forum|alt.badge.img+1
  • BikramHeadliner
  • Headliner
  • 486 replies
  • March 3, 2023

@akanshajain6793 

 

kindly try this.

String timeuuid = com.datastax.driver.core.utils.UUIDs.timeBased().toString();
A
Discovered Fame

@bikram

 thanks for the response as always

 

but before this am creating a dateinhour column to store current date and i want to use that column to generate UUID is that possible to pass that in parameter for above function ?

Bikram
Headliner
Forum|alt.badge.img+1
  • BikramHeadliner
  • Headliner
  • 486 replies
  • Answer
  • March 3, 2023

@akanshajain6793 

 

I tried this in jython , kindly try it in your pipeline and let me know if it helps.

 

from datetime import datetime
from uuid import uuid4
date_time = datetime.now().strftime('%Y%m-%d%H-%M%S')
eventid = date_time + str(uuid4())

for record in sdc.records:
  try:
    
    record.value['data'] = eventid
    # Write record to processor output
    sdc.output.write(record)

  except Exception as e:
    # Send record to error
    sdc.error.write(record, str(e))

1 Attachments
A
Discovered Fame

Thanks possible to share solution using groovy stage? we are using same and other transformation also

A
Discovered Fame

    MessageDigest mac = MessageDigest.getInstance("SHA-256");
    byte[] signatureBytes = mac.digest(dateInHour.getBytes(StandardCharsets.UTF_8));
 
    StringBuffer hexString = new StringBuffer();
    for (int j=0; j<signatureBytes.length; j++) {
    String hex=Integer.toHexString(0xff & signatureBytes[j]);
    if(hex.length()==1) hexString.append('0');
    hexString.append(hex);
    }
 
    String encryptedSignature = hexString.toString();
    String encryptHash = encryptedSignature.replace("-","");
    encryptHash = encryptHash.toUpperCase();
    
    record.value['encryptHash']
    output.write(record)

 

using ths but not able to get the output getting error 

Reply


Terms & Conditions