dunnock

import React from 'react';
import Dropzone from 'react-dropzone';

class SnapshotUploader extends React.Component {
  onDrop = (acceptedFiles, rejectedFiles) => {
    acceptedFiles.forEach(file => console.log(file, 'accepted'));
    rejectedFiles.forEach(file => console.log(file, 'rejected'));
  }

  render() {

dunnock

#[get("/tasks")]
pub async fn get_tasks( 
    query: Query<GetTasksQuery>, db_pool: Data<Pool> 
) -> Result<HttpResponse, BenchError> {

    let tasks = db::get_tasks(db_pool.into_inner(), query.into_inner()).await?;

    Ok(HttpResponse::Ok().json(tasks))
}

dunnock

CREATE TABLE worker (
	id SERIAL PRIMARY KEY,
	name varchar(255) NOT NULL,
	email varchar(255) NULL,
	score integer DEFAULT 0
);

CREATE TABLE task (
	id SERIAL PRIMARY KEY,
	summary varchar(255) NOT NULL,

dunnock

router.get('/tasks', (req, res, next) => {
    let { assignee_name, summary, limit, full } = req.query;
    full = full == "true";
    if (!!limit && isNaN(limit)) {
        return next(createError({
            status: 400, 
            message: "limit query parameter should be a number"
        }));
    }

dunnock

async function get_tasks(params, offset, res) {
    let conn = (params["full"] == "true")
        ? db.get_tasks_full()
        : db.get_tasks();

    let { client, config } = await conn;

    let values = [
        !!params["assignee_name"] ? `%${params["assignee_name"]}%` : null,
        !!params["summary"] ? `%${params["summary"]}%` : null,

dunnock

dunnock

dunnock

dunnock

async function get_tasks(assignee_name, summary, limit, full) {
    let query = full ? query_get_tasks_full() : query_get_tasks();
    
    if (!!assignee_name) {
        query.where("assignee.name", "LIKE", `%${assignee_name}%`)
    }
    if (!!summary) {
        query.where("summary", "LIKE", `%${summary}%`)
    }
    query.limit(limit || 10);

dunnock

pub async fn get_tasks(pool: Arc<Pool>, query: GetTasksQuery) -> Result<Vec<Task>, BenchError> {
    let _stmt = query.get_statement();

    let client = pool.get().await?;
    let stmt = client.prepare_typed(&_stmt, &[Type::VARCHAR, Type::VARCHAR, Type::OID]).await?;

    client.query(
            &stmt,
            &[ &like(query.assignee_name), &like(query.summary), &query.limit.or(Some(10)) ],
        ).await?