Category Archives: Uncategorized

SQL Scratch

Posted on November 7, 2021 by tobias

These are just scratches/notes for my work with Prestashop select id_product, reference from ps_product where reference like ‘9254050’ limit 10; Uppercase first letter only on string, and lowercase the others (remove any spaces infront or at the end)select name, concat(upper(left(name,1)),lower(substring(name,2,length(name)))) … Continue reading →

Posted in Uncategorized | Tagged prestashop, sql | Leave a comment

Functions as Arguments Java vs Scala, Game Set Match Scala Wins!

Posted on August 24, 2021 by tobias

This is how you would create a function that takes a function as argument in Java The Function<A,B> myFunc = num -> “Value = ” + num;Here :A = the type of the first argument, in this example an intergerB … Continue reading →

Posted in Uncategorized | Tagged java, scala | Leave a comment

Apache Zeppelin, with Spark and Cassandra, the perfect tool

Posted on April 5, 2020 by tobias

Zeppelin has become one of my favourite tools in my toolbox. I am heavily designing stuff for Cassandra and in Scala, and even though I love Cassandra there are times when things just gets so complicated with the CQL command … Continue reading →

Posted in Uncategorized | 8 Comments

SQL LIKE operation in Cassandra, is possible in v3.4+

Posted on August 12, 2016 by tobias

For a long time it has not been possible to do a SELECT * FROM table WHERE firstname like ‘t%’; in Cassandra like you could in eg.. MySQL or any other Relation Database for that matter. In Cassandra v3.4 this … Continue reading →

Posted in Uncategorized | 3 Comments

Apache SPARK and Cassandra and SQL

Posted on January 21, 2016 by tobias

This is a short intro to start using Apache SPARK with Cassandra, running SQL on the Cassandra tables. Note that I am not running a SPARK cluster, I am running “local”, to me this is really convenient, not having to … Continue reading →

Posted in Uncategorized | Tagged apache, cassandra, cassandrasqlcontext, dependencies, exception, nosuchmethodexception, sbt, scala, spark, sql | 2 Comments

Create an MBean (JMX) in Scala

Posted on November 3, 2015 by tobias

Create the MBean like this

trait OrderTrackerMBean {
  def getOrderId : Int
  def setOrderId(orderId:Int)
}

class OrderTracker extends OrderTrackerMBean {
  var orderId = 0
  override def getOrderId: Int = orderId
  override def setOrderId(_orderId: Int)= {
    orderId = _orderId
  }

}

trait OrderTrackerMBean {

def getOrderId : Int

def setOrderId(orderId:Int)

}

class OrderTracker extends OrderTrackerMBean {

var orderId = 0

override def getOrderId: Int = orderId

override def setOrderId(_orderId: Int)= {

orderId = _orderId

}

NOTE, that the interface/trait must end with MBean in the name And this is how you register your MBean

package com.tsoft.playingWithLogback

import java.lang.management.ManagementFactory
import javax.management.{ObjectName, MBeanServer}

import org.slf4j.{MarkerFactory, Marker, LoggerFactory}
import org.slf4j.MDC
import scala.concurrent.{Await, Future}
import scala.concurrent.duration._
import scala.concurrent.ExecutionContext.Implicits.global

object LotsOfLogOutput {

  val logger = LoggerFactory.getLogger(this.getClass)

  val orderTrackerBean = new OrderTracker
  val mbs:MBeanServer = ManagementFactory.getPlatformMBeanServer();
  val mBeanName:ObjectName = new ObjectName("com.tsoft.playingWithLogback:type=Tracking");
  mbs.registerMBean( orderTrackerBean, mBeanName);

...

package com.tsoft.playingWithLogback

import java.lang.management.ManagementFactory

import javax.management.{ObjectName, MBeanServer}

import org.slf4j.{MarkerFactory, Marker, LoggerFactory}

import org.slf4j.MDC

import scala.concurrent.{Await, Future}

import scala.concurrent.duration._

import scala.concurrent.ExecutionContext.Implicits.global

object LotsOfLogOutput {

val logger = LoggerFactory.getLogger(this.getClass)

val orderTrackerBean = new OrderTracker

val mbs:MBeanServer = ManagementFactory.getPlatformMBeanServer();

val mBeanName:ObjectName = new ObjectName("com.tsoft.playingWithLogback:type=Tracking");

mbs.registerMBean( orderTrackerBean, mBeanName);

...

And the simply launch Java Mission Control (imc), attach to the JVM, and modify … Continue reading →

Posted in Uncategorized | 2 Comments

SBT module not found, why ?

Posted on November 3, 2015 by tobias

I have an build.sbt file that looks like this

name := "TobiasPlayground"

version := "1.0"

scalaVersion := "2.11.7"

scalacOptions := Seq("-unchecked", "-deprecation", "-encoding", "utf8")

libraryDependencies ++= {
  val akkaV = "2.3.9"
  val sprayV = "1.3.3"
  Seq(
    "io.spray"            %%  "spray-client"  % sprayV,
    "io.spray"            %%  "spray-can"     % sprayV,
    "io.spray"            %%  "spray-routing" % sprayV,
    "io.spray"            %%  "spray-testkit" % sprayV  % "test",
    "com.typesafe.akka"   %%  "akka-actor"    % akkaV,
    "com.typesafe.akka"   %%  "akka-testkit"  % akkaV   % "test",
    "org.specs2"          %%  "specs2-core"   % "2.3.11" % "test",
    "org.slf4j"           %%   "slf4j-api"      % "1.7.10"
  )
}

name := "TobiasPlayground"

version := "1.0"

scalaVersion := "2.11.7"

scalacOptions := Seq("-unchecked", "-deprecation", "-encoding", "utf8")

libraryDependencies ++= {

val akkaV = "2.3.9"

val sprayV = "1.3.3"

Seq(

"io.spray" %% "spray-client" % sprayV,

"io.spray" %% "spray-can" % sprayV,

"io.spray" %% "spray-routing" % sprayV,

"io.spray" %% "spray-testkit" % sprayV % "test",

"com.typesafe.akka" %% "akka-actor" % akkaV,

"com.typesafe.akka" %% "akka-testkit" % akkaV % "test",

"org.specs2" %% "specs2-core" % "2.3.11" % "test",

"org.slf4j" %% "slf4j-api" % "1.7.10"

)

}

But for some reason I can’t get slf4j downloaded from the Maven repository (http://mvnrepository.com) If I search the Maven Repository, I can clearly see that the version I intend to … Continue reading →

Posted in Uncategorized | Leave a comment

See who is connected to the same network / WIFI

Posted on October 11, 2015 by tobias

There are tools out there, such as Angry IP Scanner, iNet or IP Scanner, Â but this can easily be done using a bash script, not as nice looking perhaps but it does the job. The script :

#!/bin/bash
for i in {0..255}
do
	cmd="nslookup 192.168.1."
	cmd=$cmd$i
	result=$($cmd|egrep "Address|name")
	echo "****************"
	echo $cmd
	echo $result
done

#!/bin/bash

for i in {0..255}

cmd="nslookup 192.168.1."

cmd=$cmd$i

result=$($cmd|egrep "Address|name")

echo "****************"

echo $cmd

echo $result

done

Which should … Continue reading →

Posted in Uncategorized | 1 Comment

Printopia a great AirPrinter server for your USB printer

Posted on August 1, 2013 by tobias

I have recently starting to use Printopia on my iMac, it makes it possible to use my USB printer connected to my iMac as a AirPrinter, and thus I am able to print from my iPhone or iPad. What a … Continue reading →

Posted in Uncategorized | Tagged AirPrint, apple, ipad, iphone, mac, printing | 1 Comment

Me and my son off for a short trip with the bike

Posted on July 14, 2013 by tobias

This is me and my son taking a ride, we have only been out for a couple of times, but he likes it, and I like it a lot !!!

Posted in Uncategorized | Tagged ducati 998, tobias eriksson | 1 Comment

Category Archives: Uncategorized

Archives

Meta