Adding Analytics in a mobile application is a great idea, which is really helpful to track the app usage and user actions. Also, It would assist the business to know the widely used functionality of the customers and for further enhancements.

Firstly, You have to create a project in Firebase in order to add Google Analytics in android application. The project may contain different platforms of applications like iOS, Android etc. Under each platform, you can add one or more applications. This means that you can add QA, DEV and PROD apps for tracking purposes specific to the selected environments. Main factor is that the package name will differ (com.example.sample.qa or com.example.sample.prod) based on the environment. After creating the project, register your android application with Firebase.

Once the application is registered, you can download google-services.json file which is a mandatory json for analytics. These files must have to be downloaded based on the applications that you have registered with Firebase. You should use the relevant json files for DEV, QA and PROD. If you plan to use analytics only for Prod version of the app, then download json file for the prod package.

Once application registration is completed, launch Android project in Studio and add the json files inside “App” folder based on the environment that you have chosen.

Next important step is, In your root-level (project level) build.gradle file, you must add the below classpath dependency.

classpath 'com.google.gms:google-services:4.3.3' // Google Services plugin

And, in app level build.gradle, add google services plugin. Also, include Firebase SDK inside the dependencies.

apply plugin: 'com.google.gms.google-services'

dependencies {
// ...
// Add the Firebase SDK for Google Analytics
implementation 'com.google.firebase:firebase-analytics:17.2.1'
}

Then, do the gradle sync to make sure that all plugins/dependencies have the necessary versions.

After Sync up, run the application to send verification to Firebase that you’ve successfully integrated Firebase.

To capture the events, you need to initialize Firebase Analytics in the class files.

private FirebaseAnalytics firebaseAnalytics;

@Override
protected void onCreate(Bundle savedInstanceState) {
    ...

    firebaseAnalytics = FirebaseAnalytics.getInstance(this);

    // Determine the current app context, either installed or instant, then
    // set the corresponding user property for Google Analytics.
    if (InstantApps.getPackageManagerCompat(this).isInstantApp()) {
        firebaseAnalytics.setUserProperty(ANALYTICS_USER_PROP, STATUS_INSTANT);
    } else {
        firebaseAnalytics.setUserProperty(ANALYTICS_USER_PROP, STATUS_INSTALLED);
    }

}

To record a screen view, use below code snippets.

mFirebaseAnalytics.setCurrentScreen(this, screenName, null /* class override */);
private void recordScreenView() {

// This string must be <= 36 characters long in order for setCurrentScreen to succeed.

String screenName = getCurrentImageId() + "-" + getCurrentImageTitle();

// [START set_current_screen]

mFirebaseAnalytics.setCurrentScreen(this, screenName, null /* class override */);

// [END set_current_screen]

}

To log an event, try with this below code snippet.

Bundle bundle = new Bundle();
bundle.putString(FirebaseAnalytics.Param.ITEM_ID, id);
bundle.putString(FirebaseAnalytics.Param.ITEM_NAME, name);
bundle.putString(FirebaseAnalytics.Param.CONTENT_TYPE, "image");
mFirebaseAnalytics.logEvent(FirebaseAnalytics.Event.SELECT_CONTENT, bundle);

Run the application with internet connection, so that application can send analytics to Firebase.

Now, you are ready to check the analytics in Firebase console.

How to add Google Analytics in Android application was originally published in Roshberry Digital on Medium, where people are continuing the conversation by highlighting and responding to this story.

You can use Python script to fetch data from SQL Server database.

This post will be useful to the beginners who want to work in Python and SQL Server.

Using Python script, you can manage your data between systems.

Below are the prerequisites to start the process.

You must have to download and install the below software in your system.

Visual Studio Community 2017

Python 3.8.2

Microsoft SQL Server Express

Microsoft ODBC driver for SQL Server

Once Python is installed, open cmd.exe and move to Python -> Scripts folder and run this below command to install ODBC into it.

pip install pyodbc

Sample database creation

1. Launch SQL Server Management Studio — Run as an administrator.
2. Right-click on Databases and select New Database. Create a sample database in SQL Server (As an Admin user)
3. From Tables in the newly created database and Right-click and select New Table. Create a sample table and add some data in it.

Simple Python application with database connection

1. Launch Visual Studio and create a simple Python application. (As an Admin user)
2. Make sure you have set the python environment for the application.
3. Use this sample code to test database connection in Python app:

import pyodbc
conn = pyodbc.connect(‘Driver={SQL Server};Server=SERVER_NAME;Database=TestDb;Trusted_Connection=yes;’)
cursor = conn.cursor()
cursor.execute(‘select * from TestDb.dbo.Person’)
for row in cursor:
print(row)

To run the application:

1. From Solution Explorer → select the python file you want to execute.
2. Right-click and select Start without Debugging option.
3. You can see the results in the command prompt window.

Related posts:

Connecting to Oracle Database using IronPython

Connecting to SQL Server using IronPython

Connecting to SQL Server Database using Python was originally published in Roshberry Digital on Medium, where people are continuing the conversation by highlighting and responding to this story.

Python script can be used to fetch data from Oracle Database.

This post will be useful for the beginners who want to work with Python and Oracle Database.

Firstly, you need to set up the environment for Python and Oracle database.

You can check below my post for how to set up python environment.

Connecting to SQL Server Database using Python

Also, you can setup Oracle environment by using below steps.

Oracle Express setup

1. Download and install Oracle Express and set up a database. https://www.oracle.com/database/technologies/xe-downloads.html
2. Configure the database using Database configuration assistant.You can configure the database by launching dbca interface using command prompt.

C:\>dbca

Connecting to Oracle

You can connect to Oracle using localhost to manage users.

https://localhost/5500/em

UserName: sys

Password: Password@123(Password you entered while creating database)

Connecting to an Oracle Database

Once database is configured in Database configuration assistant, connect to database through command prompt.

C:\WINDOWS\system32>sqlplus

Enter user name and password.

Note: You should enter password in quotes if you have any special characters in your password.

This will connect you to the Oracle database.

Creating a new table

You can create/modify tables using SQL command line tool. For instance,

SQL> CREATE TABLE customers

2 ( customer_id number(10) NOT NULL,

3 customer_name varchar2(50) NOT NULL,

4 city varchar2(50)

5 );

Inserting values into a table

You can use insert query to insert values into a table.

SQL> INSERT INTO customers

Values (100, ‘ABC’, ‘Sydney’);

Connecting Database to Python Application

You can install Oracle plugin into Python environment.

Pip install cx_Oracle

Once the plugin is installed, you can use it in python application to connect to the database.

Before that, you need to know host name, port number and service name (database name) to successfully connecting to the Oracle database.

To know the above details, in command prompt, type the below.

C:\WINDOWS\system32>lsnrctl status LISTENER

This will list out all the available endpoints. Here, you can check your Oracle connection details.

Sample Python script to fetch data from Oracle database

import cx_Oracle

dsn_tns = cx_Oracle.makedsn(‘127.0.0.1’, ‘1522’, service_name=’test100')

conn = cx_Oracle.connect(user=’sys’, password=’Password@123', dsn=dsn_tns, mode=cx_Oracle.SYSDBA)

# For example, if your user name contains ‘\’, you’ll need to place ‘r’ before the user name: user=r’User Name’

c = conn.cursor()

c.execute(‘select * from customers’)

# use triple quotes if you want to spread your query across multiple lines

print(“ — — — — Id — — — — — Name — — — — — City — — — — “)

for customer in c:

print(“ %d %s %s “ %(customer[0],customer[1],customer[2]))

print(“ — — — — — — — — — — — — — — — — — — — — — — — -”)

conn.close()

Output

To run the application:

1. From Solution Explorer → select the python file you want to execute.
2. Right-click and select Start without Debugging option.

You can see the output in a specified format in command prompt window.

Related posts:

Connecting to Oracle Database using IronPython

Connecting to SQL Server using IronPython

Connecting to Oracle Database using Python was originally published in Roshberry Digital on Medium, where people are continuing the conversation by highlighting and responding to this story.

IronPython is an open-source implementation of Python programming language which is tightly integrated with the .NET Framework. IronPython can use the .NET Framework and Python libraries like wise other.NET languages can use Python script without a hassle.

Firstly, you have to set up environment for IronPython and Oracle Database.

You check my below posts to set up the environment.

Connecting to Oracle Database using Python

Connecting to SQL Server using Python

IronPython Set up

You can download and install IronPython from this link

And, make sure you have installed Oracle Developer Tools. Also, create a test database which has a sample table with some data stored.

Sample IronPython script to fetch data from Oracle database

In Visual Studio, Create a new IronPython application and write a below sample script and execute it.

import clr

#Reference path of Oracle Developer Tools — Oracle ManagedDataAccess
clr.AddReferenceToFileAndPath(“C:\Program Files (x86)\Oracle Developer Tools for VS2017\odp.net\managed\common\Oracle.ManagedDataAccess.dll”)

from Oracle.ManagedDataAccess.Client import OracleConnection

#Connection string
conn = OracleConnection(“Data Source=//127.0.0.1:1522/databasename;USER Id=userid;PASSWORD=password;”)
conn.Open()

cmd = conn.CreateCommand()
#Fetching data from local oracle database
cmd.CommandText = ‘select * from customers’
reader = cmd.ExecuteReader()
customers =[]
if reader.HasRows:
while reader.Read():
customer = {
‘id’: reader.GetString(reader.GetOrdinal(“customer_id”)),
‘name’: reader.GetString(reader.GetOrdinal(“customer_name”)),
‘city’:reader.GetString(reader.GetOrdinal(“city”))
}
customers.append(customer)

conn.Close()
print(“ — — — — Id — — — — — Name — — — — — City — — — — “)
for customer in customers:
print(“ %d %s %s “ %(customer.id,customer.name,customer.city))
print(“ — — — — — — — — — — — — — — — — — — — — — — — -”)

Output

To run the application:

1. From Solution Explorer → select the python file you want to execute.
2. Right-click and select Start without Debugging option.

You can see the output in a specified format in command prompt window.

Connecting to Oracle Database using IronPython was originally published in Roshberry Digital on Medium, where people are continuing the conversation by highlighting and responding to this story.

IronPython is an open-source implementation of Python programming language which is tightly integrated with the .NET Framework. IronPython can use the .NET Framework and Python libraries like wise other.NET languages can use Python script without a hassle.

Firstly, you have to set up environment for IronPython and SQL Server.

You check my below posts to set up the environment.

Connecting to SQL Server using Python

IronPython Set up

You can download and install IronPython from this link

Create a test database which has a sample table with some data stored.

Sample IronPython script to fetch data from SQL Server

In Visual Studio, Create a new IronPython application and write a below sample script and execute it.

import clr
clr.AddReference(‘System.Data’)
from System.Data import *

#Connection string
conn = SqlClient.SqlConnection(‘server=yourserver;database=testdatbase;uid=userid;password=password’)
conn.Open()

cmd = SqlClient.SqlCommand(‘select * from customers’, conn)
reader = cmd.ExecuteReader()

if reader.HasRows:
while reader.Read():
customer = {
‘id’: reader.GetString(reader.GetOrdinal(“customer_id”)),
‘name’: reader.GetString(reader.GetOrdinal(“customer_name”)),
‘city’:reader.GetString(reader.GetOrdinal(“city”))
}
customers.append(customer)

conn.Close()
print(‘ — — — — Id — — — — — Name — — — — — City — — — — ‘)
for customer in customers:
print(‘ %d %s %s ‘ %(customer.id,customer.name,customer.city))
print(‘ — — — — — — — — — — — — — — — — — — — — — — — -’)

Output

To run the application:

1. From Solution Explorer → select the python file you want to execute.
2. Right-click and select Start without Debugging option.

You can see the output in a specified format in command prompt window.

Connecting to SQL Server using IronPython was originally published in Roshberry Digital on Medium, where people are continuing the conversation by highlighting and responding to this story.

This post will give you a walk through to know the basics of Kotlin programming and to understand how to import Kotlin libraries, how to define functions, variables in Kotlin and also how to use expressions, loop operations and using collections such as List, Set and Map in Kotlin.

Interoperability:

Kotlin is a simple programming language which is easy to learn and offers lot of features to adopt for your application. Also, Kotlin provides interoperability with Java code and supports multi-platform application development.

Import Kotlin libraries:

You can import Kotlin libraries like how you import Java libraries.

import kotlin.*

import kotlin.io.*

Kotlin Functions:

Use fun keyword to create a new function.

Void function:

fun greet(){

println(“Hello”)

}

Function with input parameters and return type:

fun sum(x:Int, y:Int): Int{

return x + y

}

Function with an expression body and inferred return type:

fun sum(x:Int, y:Int) = x + y

Kotlin Variables:

In Kotlin, Variables can be defined using keywords val and var.

val keyword should be used to define local variables which are read-only variables.

var keyword should be used to define variables that can be reassigned.

val x: Int = 10

val y = 20

val z: Int

z = 30

Kotlin Expressions:

if Expression:

fun findMax(x: Int, y: Int): Int {

if (x > y) {

return x

} else {

return y

}

}

if is also an expression in Kotlin as it returns value.

fun findMax (x: Int, y: Int) = if (x > y) x else y

when Expression:

when works like a switch operator.

when (x) {

10 -> print(“x is 10”)

20 -> print(“x is 20”)

else -> {

print(“x is neither 10 nor 20”)

}

}

Kotlin for, while, do/while Loops:

for Loop:

for loop operates like foreach loop. It iterates through anything that is given by the iterator.

for (item in collection) print(item)

for (i in 1..100) {

println(i)

}

while loop:

while loop and do-while loop work as usual as in other programming languages.

while (y < 0) {

y —

}​

do {

val y = fetchData()

} while (y != null)

Kotlin Collections:

In Kotlin, Collection inherits from the Iterable<T> interface that defines the operations for iterating elements.

You can use Collection as a parameter of a function that applies to different collection types like List, Set, Map.

Kotlin List sample:

val fruitsList = listOf(“Apple”, “Banana”, “Grapes”)

for(fruit in fruitsList) println(“$fruit”)

Kotlin Set sample:

val digitsSet = setOf(1, 2, 3, 4, 5)

println(“Size of digitsSet: ${ digitsSet.size}”)

Kotlin Map sample:

val digitsMap = mapOf(“key1” to 1, “key2” to 2, “key3” to 3, “key4” to 4, “key5” to 5)

println(“All keys: ${ digitsMap.keys}”)

println(“All values: ${ digitsMap.values}”)

Introduction to Kotlin Functions, Variables, Expressions, Loops and Collections was originally published in Roshberry Digital on Medium, where people are continuing the conversation by highlighting and responding to this story.

This post will give you a brief idea about Kotlin classes, objects, interfaces and inheritance.

Check my below post to know the basics of Kotlin Programming.

Kotlin — Beginner’s guide

Classes

Kotlin classes are declared using “class” keyword like Java.

A class consists of keyword “class”, and class name and body {}

class Employee{

//Here goes the body content

}

Constructors

A class can have one or more constructors. Constructors will be defined using “constructor” keyword.

class Animal {
var dogs: MutableList<Animal> = mutableListOf<>()
constructor(animal: Animal) {
animal.dogs.add(this)
}
}

}

There are two types of constructors in Kotlin.

Primary Constructor:

This is part of the class header and declared after the class name.

class Employee constructor(firstName: String, lastName: String) {

}

The primary constructor cannot contain any code, so initialization logic will be written inside init method.

class Employee constructor(firstName: String, lastName: String) {

init(){

this.firstName = firstName

this.lastName = lastName

}

}

It is allowed to provide default values for the properties of the class inside the constructor.

class Employee constructor(var firstName: String = “FirstName”, var lastName: String = “LastName”) {

init(){

}

}

Secondary Constructor:

Though you have a primary constructor in a class, you can declare more secondary constructors in kotlin class.

constructor(firstName: String, middleName: String, lastName: String) {

}

constructor(firstName: String, middleName: String, lastName: String, employeeId: String) {

}

Objects:

You can create objects either using primary constructor or secondary constructor.

val employee1 = Employee(“John”, “Doe”) // Primary constructor

val employee2 = Employee(“John”, “Stuart”, “Doe”)// Secondary constructor

val employee3 = Employee(“John”, “Stuart”, “Doe”, “12345”)// Secondary constructor

Visibility modifiers:

There are four types of visibility modifiers in Kotlin — public, private, protected and internal. ‘public’ is the default visibility modifier.

Access scope for these visibility modifiers are:

1. public — This can be accessed anywhere.
2. private — A top-level function or class that is declared ‘private’ can be accessed only within the file where it is declared. Member functions, constructors, or properties that are declared private is visible only within the class.
3. protected — Properties or Member functions which are declared ‘protected’ are accessible in the same class and its sub classes.
4. internal — This can be accessible within the same module.

Interfaces:

In Kotlin, Interfaces have the declarations of abstract methods and method implementations. ‘interface’ keyword is used to define an interface.

interface EmployeeInterface{

val name: String // abstract property

fun getId() : String // abstract method

fun displayName() { // method with default implementation

// body (optional)

}

}

class Employee : EmployeeInterface {

override val name: String = “John”

override fun getName () = “ John”

}

Inheritance:

Inheritance is one of the key features of Object-Oriented Programming. If you want to inherit the features of a class in Kotlin, the class should be defined with ‘open’ keyword.

//Base class

open class Department(deptName: String, deptId: String){

}

//Child class

class Employee(deptName: String, deptId: String, firstName: String, lastName: String): Department(name, id){

}

Introduction to Kotlin Classes, Objects, Interfaces and Inheritance was originally published in Roshberry Digital on Medium, where people are continuing the conversation by highlighting and responding to this story.