e-techbytes: Edward Lance Lorilla

Monday, June 28, 2021

Edward Lance Lorilla

【ANDROID STUDIO】Periodic Work Request Work Manager

Posted: 27 Jun 2021 07:17 AM PDT

package com.example.wordmanager


import androidx.appcompat.app.AppCompatActivity
import android.os.Bundle
import android.widget.Toast
import androidx.lifecycle.Observer
import androidx.work.*
import kotlinx.android.synthetic.main.activity_main.*
import java.util.concurrent.TimeUnit

class MainActivity : AppCompatActivity() {

    companion object {
        const val KEY_COUNT_VALUE = "key_count"
    }
    override fun onCreate(savedInstanceState: Bundle?) {
        super.onCreate(savedInstanceState)
        setContentView(R.layout.activity_main)
        button.setOnClickListener {
            //setOneTimeWorkRequest()
            setPeriodicWorkRequest()
        }

    }

    private fun setPeriodicWorkRequest() {
        val periodicWorkRequest = PeriodicWorkRequest.Builder(DownloadingWorker::class.java,16,
            TimeUnit.MINUTES)
            .build()
        WorkManager.getInstance(applicationContext).enqueue(periodicWorkRequest)
    }

    private fun setOneTimeWorkRequest() {
        val workManager = WorkManager.getInstance(applicationContext)
     val data: Data = Data.Builder()
         .putInt(KEY_COUNT_VALUE,125)
         .build()
        val constraints = Constraints.Builder()
            .setRequiresCharging(true)
            .build()
        val uploadRequest = OneTimeWorkRequest.Builder(UploadWorker::class.java)
            .setConstraints(constraints)
            .setInputData(data)
            .build()
        val filteringRequest = OneTimeWorkRequest.Builder(FilteringWorker::class.java)
            .build()
        val compressingRequest= OneTimeWorkRequest.Builder(CompressingWorker::class.java)
            .build()
        val downloadingWorker= OneTimeWorkRequest.Builder(DownloadingWorker::class.java)
            .build()
        val paralleWorks = mutableListOf<OneTimeWorkRequest>()
        paralleWorks.add(downloadingWorker)
        paralleWorks.add(filteringRequest)
       workManager
           .beginWith(paralleWorks)
           .then(compressingRequest)
           .then(uploadRequest)
           .enqueue()
        workManager.getWorkInfoByIdLiveData(uploadRequest.id)
            .observe(this, Observer {
                textView.text = it.state.name
                if(it.state.isFinished) {
                    val data = it.outputData
                    val message = data.getString(UploadWorker.KEY_WORKER)
                    Toast.makeText(applicationContext, message, Toast.LENGTH_LONG).show()
                }
            })
    }

}

package com.example.wordmanager

import android.content.Context
import androidx.work.Worker
import androidx.work.WorkerParameters
import android.util.Log
import java.text.SimpleDateFormat
import java.util.*

class DownloadingWorker(context: Context, params: WorkerParameters) : Worker(context,params) {


    override fun doWork(): Result {
        try {

            for (i in 0..300) {
                Log.i("MYTAG", "Downloading $i")
            }

            val time = SimpleDateFormat("dd/M/yyyy hh:mm:ss")
            val currentDate = time.format(Date())
            Log.i("MYTAG","Completed $currentDate")

            return Result.success()
        } catch (e: Exception) {
            return Result.failure()
        }
    }

}

【PYTHON】collect the data using a SQL query

Posted: 27 Jun 2021 07:15 AM PDT

engine = create_engine('sqlite:///chinook.db')

query = """SELECT SUM(Total) as Total , strftime('%m-%Y', InvoiceDate) as 'month-year', BillingCountry

FROM invoices

WHERE BillingCountry="USA"

GROUP BY strftime("%m-%Y", InvoiceDate);

"""

with engine.connect() as connection:

sql_df2 = pd.read_sql_query(query, connection)

sql_df2.head()

# convert to datetime for better plotting

sql_df2['month-year'] = pd.to_datetime(sql_df2['month-year'])

sns.lineplot(data=sql_df2, x='month-year', y='Total', hue='BillingCountry')

plt.xlabel('Year')

e-techbytes

Monday, June 28, 2021

Edward Lance Lorilla

Edward Lance Lorilla

No comments:

Post a Comment