Friday

Unprotect Excel Spreadsheet If you don't know the password


This is the easiest hack ever :
With the Excel spreadsheet open,
  1. Press Alt + F11 (or go to View Code in the Developer’s Tab)
  2. In the window that appears, paste in this code (courtesy of University of Wisconsin-Green Bay)
    Sub PasswordBreaker()
        'Breaks worksheet password protection.
        Dim i As Integer, j As Integer, k As Integer
        Dim l As Integer, m As Integer, n As Integer
        Dim i1 As Integer, i2 As Integer, i3 As Integer
        Dim i4 As Integer, i5 As Integer, i6 As Integer
        On Error Resume Next
        For i = 65 To 66: For j = 65 To 66: For k = 65 To 66
        For l = 65 To 66: For m = 65 To 66: For i1 = 65 To 66
        For i2 = 65 To 66: For i3 = 65 To 66: For i4 = 65 To 66
        For i5 = 65 To 66: For i6 = 65 To 66: For n = 32 To 126
        ActiveSheet.Unprotect Chr(i) & Chr(j) & Chr(k) & _
            Chr(l) & Chr(m) & Chr(i1) & Chr(i2) & Chr(i3) & _
            Chr(i4) & Chr(i5) & Chr(i6) & Chr(n)
        If ActiveSheet.ProtectContents = False Then
            MsgBox "One usable password is " & Chr(i) & Chr(j) & _
                Chr(k) & Chr(l) & Chr(m) & Chr(i1) & Chr(i2) & _
                Chr(i3) & Chr(i4) & Chr(i5) & Chr(i6) & Chr(n)
             Exit Sub
        End If
        Next: Next: Next: Next: Next: Next
        Next: Next: Next: Next: Next: Next
    End Sub
  3. Press F5 (or click Run) and wait a minute or so…..hey presto, spreadsheet unprotected.

Source: http://geeknewscentral.com/2013/11/10/unprotecting-excel-spreadsheets-without-a-password/

Tuesday

Complete list of Serenity properties



The Serenity Reference Manual:
http://thucydides.info/docs/serenity-staging/
Serenity properties
Absolute path of the property file where Serenity system property defaults are defined. Defaults to~/serenity.properties
webdriver.driver
What browser do you want your tests to run in, for example firefox, chrome, phantomjs or iexplorer. You can also use the driver property as a shortcut.
webdriver.provided_type
If using a provided driver, what type is it. The implementation class needs to be defined in the webdriver.provided.{type} system property.
webdriver.base.url
The default starting URL for the application, and base URL for relative paths.
webdriver.remote.url
The URL to be used for remote drivers (including a selenium grid hub or SauceLabs URL)
phantomjs.webdriver.port
What port to run PhantomJS on (used in conjunction with webdriver.remote.url to register with a Selenium hub, e.g. -Dphantomjs.webdriver=5555 -Dwebdriver.remote.url=http://localhost:4444/wd/hub
webdriver.remote.driver
The driver to be used for remote drivers
serenity.driver.capabilities
A set of user-defined capabilities to be used to configure the WebDriver driver. Capabilities should be passed in as a space or semi-colon-separated list of key:value pairs, e.g. "build:build-1234; max-duration:300; single-window:true; tags:[tag1,tag2,tag3]"
webdriver.timeouts.implicitlywait
How long webdriver waits for elements to appear by default, in milliseconds.
webdriver.wait.for.timeout
How long webdriver waits by default when you use a fluent waiting method, in milliseconds.
webdriver.chrome.driver
Path to the Chrome driver, if it is not on the system path.
serenity.home
The home directory for Serenity output and data files - by default, $USER_HOME/.serenity
serenity.outputDirectory
Where should reports be generated.
serenity.project.name
What name should appear on the reports
serenity.only.save.failing.screenshots
Should Serenity only store screenshots for failing steps? This can save disk space and speed up the tests a little. It is very useful for data-driven testing. This property is now deprecated. Use serenity.take.screenshots instead.
serenity.ext.packages*
Extension packages. This is a list of packages that will be scanned for custom TagProvider implementations. To add a custom tag provider, just implement the TagProvider interface and specify the root package for this provider in this parameter.
serenity.verbose.screenshots
Should Serenity take screenshots for every clicked button and every selected link? By default, a screenshot will be stored at the start and end of each step. If this option is set to true, Serenity will record screenshots for any action performed on a WebElementFacade, i.e. any time you use an expression like element(…​).click(), findBy(…​).click() and so on. This will be overridden if the ONLY_SAVE_FAILING_SCREENSHOTS option is set to true. @Deprecated This property is still supported, but serenity.take.screenshots provides more fine-grained control.
serenity.take.screenshots
Set this property to have more finer control on how screenshots are taken. This property can take the following values:
  • FOR_EACH_ACTION : Similar to serenity.verbose.screenshots
  • BEFORE_AND_AFTER_EACH_STEP,
  • AFTER_EACH_STEP, and
  • FOR_FAILURES : Similar to serenity.only.save.failing.screenshots
serenity.report.encoding
Encoding used to generate the CSV exports
serenity.verbose.steps
Set this property to provide more detailed logging of WebElementFacade steps when tests are run.
serenity.reports.show.step.details
Should Thucydides display detailed information in the test result tables. If this is set to true, test result tables will display a breakdown of the steps by result. This is false by default.
serenity.report.show.manual.tests
Show statistics for manual tests in the test reports.
serenity.report.show.releases
Report on releases (defaults to true).
serenity.restart.browser.frequency
During data-driven tests, some browsers (Firefox in particular) may slow down over time due to memory leaks. To get around this, you can get Serenity to start a new browser session at regular intervals when it executes data-driven tests.
thucycides.step.delay
Pause (in ms) between each test step.
untrusted.certificates
Useful if you are running Firefox tests against an HTTPS test server without a valid certificate. This will make Serenity use a profile with the AssumeUntrustedCertificateIssuer property set.
refuse.untrusted.certificates
Don’t accept sites using untrusted certificates. By default, Thucydides accepts untrusted certificates - use this to change this behaviour.
serenity.timeout
How long should the driver wait for elements not immediately visible.
serenity.browser.width and serenity.browser.height
Resize the browser to the specified dimensions, in order to take larger screenshots. This should work with Internet Explorer and Firefox, but not with Chrome.
serenity.resized.image.width
Value in pixels. If set, screenshots are resized to this size. Useful to save space.
serenity.keep.unscaled.screenshots
Set to true if you wish to save the original unscaled screenshots. This is set to false by default.
serenity.store.html.source
Set this property to true to save the HTML source code of the screenshot web pages. This is set to false by default.
serenity.issue.tracker.url
The URL used to generate links to the issue tracking system.
serenity.activate.firebugs
Activate the Firebugs and FireFinder plugins for Firefox when running the WebDriver tests. This is useful for debugging, but is not recommended when running the tests on a build server.
serenity.batch.strategy
Defines batch strategy. Allowed values - DIVIDE_EQUALLY (default) and DIVIDE_BY_TEST_COUNT. DIVIDE_EQUALLY will simply divide the tests equally across all batches. This could be inefficient if the number of tests vary a lot between test classes. A DIVIDE_BY_TEST_COUNT strategy could be more useful in such cases as this will create batches based on number of tests.
serenity.batch.count
If batch testing is being used, this is the size of the batches being executed.
serenity.batch.number
If batch testing is being used, this is the number of the batch being run on this machine.
serenity.use.unique.browser
Set this to run all web tests in a single browser.
serenity.locator.factory
Set this property to override the default locator factory with another locator factory (for ex., AjaxElementLocatorFactory or DefaultElementLocatorFactory). By default, Serenity uses a custom locator factory called DisplayedElementLocatorFactory.
serenity.native.events
Activate and deactivate native events for Firefox by setting this property to true or false.
security.enable_java
Set this to true to enable Java support in Firefox. By default, this is set to false as it slows down the web driver.
serenity.test.requirements.basedir
The base folder of the sub-module where the jBehave stories are kept. It is assumed that this directory contains sub folders src/test/resources. If this property is set, the requirements are read from src/test/resources under this folder instead of the classpath or working directory. This property is used to support situations where your working directory is different from the requirements base dir (for example when building a multi-module project from parent pom with requirements stored inside a sub-module)
serenity.proxy.http
HTTP Proxy URL configuration for Firefox and PhantomJS
serenity.proxy.http_port
HTTP Proxy port configuration for Firefox and PhantomJS
serenity.proxy.type
HTTP Proxy type configuration for Firefox and PhantomJS
serenity.proxy.user
HTTP Proxy username configuration for Firefox and PhantomJS
serenity.proxy.password
HTTP Proxy password configuration for Firefox and PhantomJS
serenity.logging
Three levels are supported: QUIET, NORMAL and VERBOSE
serenity.test.root
The root package for the tests in a given project. If provided, Serenity will use this as the root package when determining the capabilities associated with a test. If you are using the File System Requirements provider, Thucydides will expect this directory structure to exist at the top of the requirements tree. If you want to exclude packages in a requirements definition and start at a lower level in the hierarchy, use the serenity.requirement.exclusionsproperty.
This is also used by the PackageAnnotationBasedTagProvider to know where to look for annotated requirements.
serenity.requirements.dir
Use this property if you need to completely override the location of requirements for the File System Provider.
serenity.use.requirements.directories
By default, Thucydides will read requirements from the directory structure that contains the stories. When other tag and requirements plugins are used, such as the JIRA plugin, this can cause conflicting tags. Set this property to false to deactivate this feature (it is true by default).
serenity.annotated.requirements.dir
Use this property if you need to completely override the location of requirements for the Annotated Provider. This is recommended if you use File System and Annotated provider simultaneously. The default value is stories.
serenity.requirements.types
The hierarchy of requirement types. This is the list of requirement types to be used when reading requirements from the file system and when organizing the reports. It is a comma-separated list of tags.The default value is: capability, feature.
serenity.requirement.exclusions
When deriving requirement types from a path, exclude any values from this comma-separated list.
serenity.test.requirements.basedir
The base directory in which requirements are kept. It is assumed that this directory contains sub folders src/test/resources. If this property is set, the requirements are read from src/test/resources under this folder instead of the classpath or working directory. If you need to set an independent requirements directory that does not follow the src/test/resources convention, use `serenity.requirements.dir1 instead
This property is used to support situations where your working directory is different from the requirements base dir (for example when building a multi-module project from parent pom with requirements stored inside a sub-module.
serenity.release.types
What tag names identify the release types (e.g. Release, Iteration, Sprint). A comma-separated list. By default, "Release, Iteration"
serenity.locator.factory
Normally, Serenity uses SmartElementLocatorFactory, an extension of the AjaxElementLocatorFactory when instantiating page objects. This is to ensure that web elements are available and usable before they are used. For alternative behaviour, you can set this value to DisplayedElementLocatorFactory, AjaxElementLocatorFactory or DefaultElementLocatorFactory.
chrome.switches
Arguments to be passed to the Chrome driver, separated by commas.
webdriver.firefox.profile
The path to the directory of the profile to use when starting firefox. This defaults to webdriver creating an anonymous profile. This is useful if you want to run the web tests using your own Firefox profile. If you are not sure about how to find the path to your profile, look here: http://support.mozilla.com/en-US/kb/Profiles. For example, to run the default profile on a Mac OS X system, you would do something like this:
$ mvn test -Dwebdriver.firefox.profile=/Users/johnsmart/Library/Application\ Support/Firefox/Profiles/2owb5g1d.default
On Windows, it would be something like:
C:\Projects\myproject>mvn test -Dwebdriver.firefox.profile=C:\Users\John Smart\AppData\Roaming\Mozilla\Firefox\Profiles\mvxjy48u.default
firefox.preferences
A semicolon separated list of Firefox configuration settings. For ex.,
-Dfirefox.preferences="browser.download.folderList=2;browser.download.manager.showWhenStarting=false;browser.download.dir=c:\downloads"
Integer and boolean values will be converted to the corresponding types in the Firefox preferences; all other values will be treated as Strings. You can set a boolean value to true by simply specifying the property name, e.g. -Dfirefox.preferences=app.update.silent.
A complete reference to Firefox’s configuration settings is given here.
serenity.csv.extra.columns
Add extra columns to the CSV output, obtained from tag values.
serenity.console.headings
Write the console headings using ascii-art ("ascii", default value) or in normal text ("normal")
tags
Comma separated list of tags. If provided, only jUnit classes and/or methods with tags in this list will be executed. For example,
mvn verify -Dtags="iteration:I1"

mvn verify -Dtags="color:red,flavor:strawberry"
output.formats
What format should test results be generated in. By default, this is "json,xml".
narrative.format
Set this property to asciidoc to activate using Asciidoc format in narrative text.
jira.url
If the base JIRA URL is defined, Serenity will build the issue tracker url using the standard JIRA form.
jira.project
If defined, the JIRA project id will be prepended to issue numbers.
jira.username
If defined, the JIRA username required to connect to JIRA.
jira.password
If defined, the JIRA password required to connect to JIRA.
show.pie.charts
Display the pie charts on the dashboard by default. If this is set to false, the pie charts will be initially hidden on the dashboard.
dashboard.tag.list
If set, this will define the list of tag types to appear on the dashboard screens
dashboard.excluded.tag.list::If set, this will define the list of tag types to be excluded from the dashboard screens
json.pretty.printing
Format the JSON test outcomes nicely. "true" or "false", turned off by default.
simplified.stack.traces
Stack traces are by default decluttered for readability. For example, calls to instrumented code or internal test libraries is removed. This behaviour can be deactivated by setting this property to false.
serenity.dry.run
Run through the steps without actually executing them.
feature.file,language
What (human) language are the Cucumber feature files written in? Defaults to "en".
serenity.maintain.session
Keep the Thucydides session data between tests. Normally, the session data is cleared between tests.

Monday

Now that's what I call a Hacker / Automation enthusiast :P


Can you steal something that has already been stolen posted using his permission:

I was so amazed by this person's laziness awesomeness that I had to do a re-post

xxx: OK, so, our build engineer has left for another company. The dude was literally living inside the terminal. You know, that type of a guy who loves Vim, creates diagrams in Dot and writes wiki-posts in Markdown... If something - anything - requires more than 90 seconds of his time, he writes a script to automate that.
xxx: So we're sitting here, looking through his, uhm, "legacy"
xxx: You're gonna love this
xxx: smack-my-bitch-up.sh - sends a text message "late at work" to his wife (apparently). Automatically picks reasons from an array of strings, randomly. Runs inside a cron-job. The job fires if there are active SSH-sessions on the server after 9pm with his login.
xxx: kumar-asshole.sh - scans the inbox for emails from "Kumar" (a DBA at our clients). Looks for keywords like "help", "trouble", "sorry" etc. If keywords are found - the script SSHes into the clients server and rolls back the staging database to the latest backup. Then sends a reply "no worries mate, be careful next time".
xxx: hangover.sh - another cron-job that is set to specific dates. Sends automated emails like "not feeling well/gonna work from home" etc. Adds a random "reason" from another predefined array of strings. Fires if there are no interactive sessions on the server at 8:45am.
xxx: (and the oscar goes to) fuckingcoffee.sh - this one waits exactly 17 seconds (!), then opens an SSH session to our coffee-machine (we had no frikin idea the coffee machine is on the network, runs linuxand has SSHD up and running) and sends some weird gibberish to it. Looks binary. Turns out this thing starts brewing a mid-sized half-caf latte and waits another 24 (!) seconds before pouring it into a cup. The timing is exactly how long it takes to walk to the machine from the dudes desk.
xxx: holy sh*t I'm keeping those

Wednesday

POM.xml explained


POM stands for project object model. The pom.xml file is the core of a project's configuration in Maven. It is a single configuration file that contains the majority of information required to build a project in just the way you want. It contains default values for most projects.

When executing a task or goal, Maven looks for the POM in the current directory. It reads the POM, gets the needed configuration information, then executes the goal.

Super POM - The Super POM is Maven's default POM. All POMs extend the Super POM unless explicitly set, meaning the configuration specified in the Super POM is inherited by the POMs you created for your projects

The minimum requirement for a POM are the following:
  • project root
  • modelVersion - should be set to 4.0.0
  • groupId - the id of the project's group.
  • artifactId - the id of the artifact (project)
  • version - the version of the artifact under the specified group
  • packaging - Every Maven project has a packaging type. If it is not specified in the POM, then the default value "jar" would be used.
  • repository / pluginRepositories- If you build your project using the minimal POM, it would inherit the repositories configuration in the Super POM. Therefore when Maven sees the dependencies in the minimal POM, it would know that these dependencies will be downloaded from http://repo.maven.apache.org/maven2 which was specified in the Super POM.

Elements in the POM that are merged are the following:
  • dependencies
  • developers and contributors
  • plugin lists (including reports)
  • plugin executions with matching ids
  • plugin configuration
  • resources
Properties - Properties are the last required piece in understanding POM basics. Maven properties are value placeholder, like properties in Ant. Their values are accessible anywhere within a POM by using the notation ${X}, where X is the property.

Reporting - Reporting contains the elements that correspond specifically for the site generation phase. Certain Maven plugins can generate reports defined and configured under the reporting element, for example: generating Javadoc reports. Much like the build element's ability to configure plugins, reporting commands the same ability.

Profiles -  A new feature of the POM 4.0 is the ability of a project to change settings depending on the environment where it is being built. A profile element contains both an optional activation (a profile trigger) and the set of changes to be made to the POM if that profile has been activated.