Category: Uncategorized

Specifying headerColors for Actionscript Alert in CSS

spentroseandhip003

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.

mx|Alert
{
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

birds

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:

https://www.epochconverter.com/

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

leaf

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 path.py.  Get it from here: https://pypi.python.org/pypi/path.py
#Download the Python Wheel file.  At this writing, it is called path.py-8.2.1-py2.py3-none-any.whl.  
#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: https://www.python.org/downloads/
#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())        
        f.remove()        
        removed += 1     
  print ("Removed " + str(removed) + " files.")
if __name__ == "__main__":  
  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 sysobjects.name = 'constraint name'
order by [Tab].[Name]

Find foreign-key related tables

SELECT f.name AS ForeignKey,
SCHEMA_NAME(f.SCHEMA_ID) SchemaName,
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
begin 
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) 
end
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
begin 
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)
end
close dbcursor2
deallocate dbcursor2