DEV Community: whimsyy

Quiz App with flutter x Appwrite

whimsyy — Wed, 11 May 2022 08:33:39 +0000

Overview of My Submission

It is Simple trivia app, you can take quiz with your favourite category, get the score check the answers.

Submission Category: Mobile Moguls

Link to Code

whimsyy / trivia

made with flutter and appwrite

quiz-with-flutter

A basic demo example for integrating between Appwrite & Flutter 💙

View on GitHub

Additional Resources / Info

This app is built using appWrite and Flutter

Pomodoro-technique app developed using Node.JS, MongoDB and jQuery.

whimsyy — Thu, 13 Jan 2022 16:34:18 +0000

Overview of My Submission

The secret to effective time management is...thinking in tomatoes rather than hours? It may seem silly at first, but millions of people swear by the life-changing power to the Pomodoro Technique. (Pomodoro is Italian for tomato. 🍅)

This popular time management method asks you to alternate pomodoros — focused work sessions — with frequent short breaks to promote sustained concentration and stave off mental fatigue.

Submission Category: Choose Your Own Adventure

Link to Code

bhavin28 / mongodb-hackthon

The Pomodoro Technique

Screenshot of app

1. Local development setup

Clone the repository from the branch of the first week

git clone --branch w1 git@github.com:gianpaj/pomodoro.git

Install NPM dependencies

npm install

Run the web server

node app.js

2. Eslint

This is the style rules for this project (.eslintrc.json). Remember everything is subjective and susceptible to taste.

$ eslint --init
? How would you like to configure ESLint? Answer questions about your style
? Are you using ECMAScript 6 features? No
? Where will your code run? Node, Browser
? Do you use CommonJS? Yes
? Do you use JSX? No
? What style of indentation do you use? Spaces
? What quotes do you use for strings? Single
? What line endings do you use? Unix
? Do you require semicolons? Yes
? What format do you want your config file to be in? JSON

Directory Structure


├── LICENSE
├── README.md

…

View on GitHub

Additional Resources / Info

Collaborators

@simbhadarajen
@bhavin28

clean database with github action

whimsyy — Wed, 08 Dec 2021 18:30:52 +0000

My Workflow

This workflow delete session entry older than 30 min and workflow runs every 10 minutes.
github Repo

Submission Category:

Wacky Wildcards

Yaml File or Link to Code

Workflow:

name: Clean DB

on:
  schedule:
    # runs every 10 min
    - cron: '*/10 * * * *'

jobs:
  build:
    runs-on: ubuntu-latest
    steps:

      - name: checkout repo content
        uses: actions/checkout@v2 # checkout the repository content to github runner

      - name: setup python
        uses: actions/setup-python@v2
        with:
          python-version: '3.7.7' # install the python version needed

      - name: Install dependencies
        run: |
          python -m pip install --upgrade pip
          pip install -r requirements.txt

      - name: execute py script # run main.py to get the latest data
        env:
          DbUser: ${{ secrets.DBUSER }}
          DbPass: ${{ secrets.DBPASS }}
          DbHost: ${{ secrets.DBHOST }}
          DB: ${{ secrets.DB }}
        run: python main.py

main.py :

from connection import conn,cur
import mysql.connector

try:
    query = "DELETE FROM sessions WHERE TIMESTAMPDIFF(MINUTE,time,CURRENT_TIMESTAMP()) > 30"

    cur.execute(query)
    conn.commit()
    print("cleaned")
except mysql.connector.Error as    e:
    print("db error")
    print(e)

connection.py :

import os
import mysql.connector

conn = mysql.connector.connect(user=os.environ["DbUser"], 
                                  password= os.environ["DbPass"],
                                  host=os.environ["DbHost"],
                                  database=os.environ["DB"])

cur = conn.cursor()

Additional Resources / Info

I am using this action in mysql databse action