dunnock

Keybase proof

I hereby claim:

• I am dunnock on github.
• I am dunnock (https://keybase.io/dunnock) on keybase.
• I have a public key ASDpWWEX9Xl7bjpVrNJknPepyfdx3jg8hvsAFAobMvTObwo

To claim this, I am signing this object:

dunnock

#[derive(Deserialize)]
pub struct GetTasksQuery {
    pub summary: Option<String>,
    pub assignee_name: Option<String>,
    pub limit: Option<u32>,
    pub full: Option<bool>
}

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?

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

dunnock

dunnock

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

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

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,