Author: ltwede

UTC date/time string to Java date in local time zone



Uses joda-time (because yes, I still work in Java 1.6).  There is probably a simpler way.  But this works. This assumes all parts of the string are supplied.

public static Date convertUTCStringToLocalDateTime(String utcDate)
    DateTime utcDateTime = new DateTime(utcDate);
    Date localDateTime = utcDateTime.toDate();
    return localDateTime;

Specifying headerColors for Actionscript Alert in CSS



Simple idea – you want Alert pop-ups in Actionscript to have a header color that is different from the default (which is same color as the background).  The only difficulty comes in knowing the correct syntax, because two colors are necessary.  They can be the same color if you just want a solid color, or two colors if you want one color to fade into the other.  These two colors get converted to an array at run-time.

After trying various combinations with and without quotes, square brackets, squiggly brackets, I finally got the correct syntax.  So just writing it down here to keep track.

dropShadowEnabled: true;
headerColors: blue, blue;
headerHeight: 20;

It’s just a comma-delimited list of two colors – no quotes or brackets or anything fancy.  Also the numeric red green blue values may be used instead of color keywords.  The first color in the list is the top of the gradient; the second the bottom.

By the way a low-tech way to get the RGB value of a color is to copy something with that color into Paint, and then use the dropper tool to select the color, then click on “Edit colors”.


SQL Server datetime to int


declare @currentDateTime datetime 
declare @timeStampValue int 

set @currentDateTime = SYSDATETIME(); 
print @currentDateTime 
set @timeStampValue = DATEDIFF(second, '1970-01-01', @currentDateTime) 
print @timeStampValue

To check the result:


UTC milleseconds example:

declare @timeStampValue Bigint  
declare @utcDateTime datetime 

set @utcDateTime = GETUTCDATE(); 
set @timeStampValue = DATEDIFF(SECOND, '1970-01-01', @utcDateTime) 
set @timeStampValue = @timeStampValue * 1000


Python clean up old files


Was learning Python and wrote this script to clean up files.  It’s not awesome.  Has no error handling for when the target file is already open.  Just kinda barfs when that happens.  So it needs work.  This was written in Python 3.

#This script uses a library called  Get it from here:
#Download the Python Wheel file.  At this writing, it is called  
#Install using the command: pip install <name of wheel file>.
#You must have Python installed first.  Been a while since I installed it, but here is the official place to 
#get it from:
#Once you have everything installed and the script works, use Windows Task Scheduler to run it, so you don't forget.

import timefrom 
path import path

def main():  
  # Because in python, the \ is an escape character, we need to use two of them in directory specifications  
  paths = ["c:\\jboss\\jboss-eap-5.1\\jboss-as\\server\\default\\tmp","c:\\jboss\\jboss-eap-5.1\\jboss-as\\server\\default\\log"]  
  DAYS = 7  
  time_in_seconds = time.time() - (DAYS * 24 * 60 * 60)  
  removed = 0  
  for p in paths:    
    print (p)    
    d = path(p)      

    for f in d.walk():      
      if f.mtime <= time_in_seconds:        
        print ("Deleting " + f.basename())        
        removed += 1     
  print ("Removed " + str(removed) + " files.")
if __name__ == "__main__":  

SQL Tidbits

creek (2)

Handy little bits.  Have long-since forgotten where I got these little gems from.

Find a constraint by name

Select SysObjects.[Name] As [Constraint Name] ,
 Tab.[Name] as [Table Name],
 Col.[Name] As [Column Name]
From SysObjects Inner Join 
(Select [Name],[ID] From SysObjects) As Tab
On Tab.[ID] = Sysobjects.[Parent_Obj] 
Inner Join sysconstraints On sysconstraints.Constid = Sysobjects.[ID] 
Inner Join SysColumns Col On Col.[ColID] = sysconstraints.[ColID] And Col.[ID] = Tab.[ID]
where = 'constraint name'
order by [Tab].[Name]

Find foreign-key related tables

SELECT AS ForeignKey,
OBJECT_NAME(f.parent_object_id) AS TableName,
COL_NAME(fc.parent_object_id,fc.parent_column_id) AS ColumnName,
SCHEMA_NAME(o.SCHEMA_ID) ReferenceSchemaName,
OBJECT_NAME (f.referenced_object_id) AS ReferenceTableName,
COL_NAME(fc.referenced_object_id,fc.referenced_column_id) AS ReferenceColumnName
FROM sys.foreign_keys AS f
INNER JOIN sys.foreign_key_columns AS fc ON f.OBJECT_ID = fc.constraint_object_id
INNER JOIN sys.objects AS o ON o.OBJECT_ID = fc.referenced_object_id
where OBJECT_NAME(f.referenced_object_id) = 'table name'
order by TableName, columnname


Shrink log files

Use master
declare @dbName varchar(100)
declare @recoveryModel varchar(100)
declare @sqlString varchar(100)
declare @dbId integer
declare @logFileName varchar(100)
declare dbcursor cursor for select name, recovery_model_desc from sys.databases where recovery_model_desc != 'SIMPLE'
open dbcursor
while 1=1
fetch from dbcursor into @dbName, @recoveryModel 
if @@FETCH_STATUS != 0 break 
print @recoveryModel + ' ' + @dbname + ' setting recovery model to SIMPLE.' 
SET @sqlString = 'ALTER DATABASE [' + @dbname + '] SET RECOVERY SIMPLE' 
EXECUTE (@sqlString) 
close dbcursor
deallocate dbcursor 

declare dbcursor2 cursor for 
select name, recovery_model_desc, database_id from sys.databases 
where recovery_model_desc = 'SIMPLE'
open dbcursor2
while 1=1
fetch from dbcursor2 into @dbName, @recoveryModel, @dbId 
if @@FETCH_STATUS != 0 break
 set @logFileName = (select name from sys.master_files where database_id = @dbId and type = 1) 
print 'Shrinking log file ' + @logFileName + ' for database ' + @dbName 
set @sqlString = 'USE ' + @dbName + '; ' + 'DBCC SHRINKFILE (' + @logFileName + ')' 
execute (@sqlString)
close dbcursor2
deallocate dbcursor2

RESTEasy Swagger Maven Cheat Sheet


Settings.xml file

  • <deploy.env> This parameter is used for many things that have nothing to do with the RESTful API, but it also plays a role in the RESTful API.  It is used to create the URLs that allow us to access Swagger for the documentation and testing of the API.

In the pom.xml file, in the generate-service-docs execution, the additional parameters docBasePath and apiBasePath rely on both the and deploy.env parameters to construct URLs used by Swagger.

RESTeasy entries in web.xml file


This entry identifies the RESTeasy class that will initialize RESTeasy.



This entry identifies our class that extends the class.  The RestApp identifies the RESTful beans, and some other classes that are used in packaging REST responses, formatting JSON, etc.






Various parameters that control aspects of RESTeasy.  For each the parameter name and value are specified.





<web-resource-name>REST Resources</web-resource-name>


RESTeasy entries in pom files





<reportOutputDirectory>output directory</reportOutputDirectory>
<additionalparam>-apiVersion 1 -docBasePath path/apidocs -apiBasePath path/rest</additionalparam>

The -apiBasePath is used to resolve the URLs to the services for testing the methods via Swagger.  If the {} parameter is not supplied, either in the settings.xml file or on the maven command line, you will not be able to click into the links in Swagger to be able to see the documented API or test the services.

Steps to RESTful-ize an existing bean

  • WEB-INF\web.xml needs the web bean added to the resteasy.jndi.resources <context-param> tag in the <param-value> tag.  Follow the same pattern as the existing web beans. Comma delimit.
  • In, add the web bean in the setClasses() method.
  • In the web bean class itself, fix the @EJB annotations to include the name argument.
  • In the web interface class, add class-level and method-level REST annotations.
    • @GET, @POST, @DELETE, @PUT (usually @GET or @POST)
    • @Path(path name).  Take the method name, and change it to be all lower-case, hyphenated, and use that for the path name.
    • @Produces(MediaType.APPLICATION_JSON), @Consumes(MediaType.APPLICATION-JSON)
  • If the method does not have a @RolesAllowed tag, it must be added and tested.  Otherwise anyone will be able to access the method just by knowing the URL.
  • Handle cyclic references with a @JsonIgnore tag, to prevent StackOverflowError.



Swagger is a tool that helps to document and test a RESTful API.

Java Classes



Allows for customization of the methods used to read and write JSON strings.


Creates an exception for errors related to Json mapping.


Not feelin’ the regex love

thehemorrhoid Sometimes I come to a regular expression in code that someone else wrote (and they probably just ripped it off from stackoverflow or some such place and never bothered to understand exactly how it worked), and there are no comments explaining what this regex is intended to do.  Infuriating.  It not only counts on the developer down the road to know regular expressions well enough to figure out what it is supposed to be doing, but it also requires a bit of cross-temporal mind-meld to figure out what the problem was that the original developer was trying to solve.  Inevitably there will be some case that comes up and the particular regex they selected doesn’t handle it well.  It needs to be tweaked, so now you have to go about understanding the whole thing and the original developer left you no clues.


Regex use versus abuse

CamelCase to Human Readable String

What to do?

Your decision about whether to figure it all out or just write some code that does the same thing may well depend upon how near your deadline is looming.

Faced with such a situation recently, with absolutely no time at all to handle this stupid little cosmetic bug, I opted for the just-write-the-damn-code option.

CamelCase to English in Actionscript

I just had to turn a camelCase string (I like to write camelCase in camelCase), into something more beautiful that you could display to a user.  The existing regex worked pretty well, except it fell down when an acronym was involved – too many capital letters in a row.  So you had a string LOLCatsAreFunny, and it ended up LOLCats Are Funny.  I needed that space between LOL and Cats.

Found a good place to start by 1.21 Gigawats at stackoverflow.  That solution didn’t have the tweak I needed, so here is the modified solution.  The tweak is in pink.

public static function prettifyCamelCase(value:String=""):String 
var output:String = ""; 
var len:int = value.length; 
var nextChar:String = ""; 

for (var i:int; i < len; i++) 
    char = value.charAt(i); 
    if (i < len - 1) 
        nextChar = value.charAt(i + 1); 

    if (i==0)
        output += char.toUpperCase(); 
    else if (char !== char.toLowerCase() && char === char.toUpperCase()
        && nextChar === nextChar.toLowerCase() 
        && nextChar !== nextChar.toUpperCase()) 
        output += " " + char;
    else if (char == "-" || char == "_")
        output += " ";
        output += char; 
return output;