jeffsheets

/**
 * Useful when passing the browser timezone to a backend Java API that reads a timezone in using ZoneId.of(tz),
 *  as both 'America/Chicago' and '-0600' are valid values when passed to the Java API.
 *  The Offset is used to handle IE11 and other older browsers.
 */
export const getUserTimeZoneOrOffset = () => {
  let timeZone;
  try {
    timeZone = new Intl.DateTimeFormat().resolvedOptions().timeZone;
  } catch (error) {

jeffsheets

The Papio Menu Alexa app available on Amazon Alexa does NOT collect any information.

The app is free for anyone to use on Alexa

jeffsheets

/** Based nearly completely on this same code from https://stackoverflow.com/a/52534584/1469525 */
@Slf4j
public class ColumnRowMapper<T> extends BeanPropertyRowMapper<T> {

  private ColumnRowMapper(final Class<T> mappedClass) { super(mappedClass); }

  @Override
  protected String underscoreName(final String name) {
    final Column annotation;
    final String columnName;

jeffsheets

/** Shows how to use code to init data instead of using data.sql or import.sql with Spring Boot */
@Component
@Profile({"local", "test"})
@RequiredArgsConstructor //Lombok magic to autowire the final fields (optional)
public class LocalDataSetup implements ApplicationRunner {

    private final MyObjectRepository myObjectRepository;

    @Override
    public void run(ApplicationArguments args) {

jeffsheets

//Inspired by https://gist.github.com/aerobless/37561bb0fb45b7e8732beaafad1cba26
pipeline {
  agent any

  triggers {
    //Needed by Bitbucket to see the builds on PRs https://stackoverflow.com/a/54710254
    pollSCM('')
  }

  stages {

jeffsheets

<!-- 
  * A collection of various HTML Email hacks
  ** Along with these, user an html boilerplate like https://github.com/seanpowell/Email-Boilerplate
  ** Hacks are from many sources including:
  ** https://litmus.com/blog/a-guide-to-bulletproof-buttons-in-email-design
  ** https://litmus.com/community/discussions/1007-outlook-image-sizes
  ** https://www.emailonacid.com/blog/article/email-development/how-to-code-emails-for-outlook-2016/
-->

<!-- 1) Fix image sizes in Outlook -->

jeffsheets

//Config for s3 websync with cloudfront invalidation
// and Cache-Control headers for a Create-React-App application
//https://www.npmjs.com/package/websync

module.exports = {
  source: "build/",
  target: `s3://yourcompany-us-east-1-${process.env.CI_ENVIRONMENT_NAME}-createreactapp/`,
  invalidateDeletes: true,
  modifiers: {
    "static/**": { CacheControl: "max-age=31536000" },

jeffsheets

#This is used locally by Create-React-App during development

#Cognito Region
REACT_APP_REGION=us-east-1

REACT_APP_USER_POOL_ID=us-east-1_youruserpoolid
REACT_APP_APP_CLIENT_ID=yourcognitoappclientidgoeshere

jeffsheets

i18n Translations

To generate new translations:

1. remove .messages folder
2. Extract all messages into .messages dir with: yarn i18n:extract
3. Add new messages into {lang}.json files with: yarn i18n:manageTranslations
4. Translate any new entries in {lang}.json files and commit to repo (see Untranslated keys: output of previous command for list of keys needing translation)

Setup

jeffsheets

@Slf4j
@Component
class GroovySQLWithSpringDAO {
    @Autowired
    Sql groovySql

    List<GroovyRowResult> findByFirstLast(String firstName, String lastName) {
        GString statement = """{call FIND_BY_FIRST_LAST_SP (
            ${firstName}, ${lastName}, 'SYSUSER',
            ${Sql.INTEGER}, ${Sql.VARCHAR}, ${Sql.VARCHAR}, ${Sql.VARCHAR}