SuryaSankar

import sqlalchemy
from sqlalchemy.ext.declarative import declarative_base
from sqlalchemy import Column, Integer, String, ForeignKey
from sqlalchemy.orm import sessionmaker, relationship, backref
from sqlalchemy.ext.associationproxy import association_proxy
import uuid
 
engine = sqlalchemy.create_engine('sqlite:///:memory:')
Base = declarative_base()
 

SuryaSankar

from alembic import op
import sqlalchemy as sa


def upgrade():
    op.alter_column(table_name='items', column_name='status', nullable=False, server_default="pending_with_moderator", name="status",
    				type_=sa.types.Enum('pending_with_moderator','pending_with_user','awaiting_user_modification','awaiting_moderator_modification','approved'),
    				existing_type=sa.types.Enum('pending_with_moderator', 'pending_with_user', 'approved'),existing_server_default="pending_with_moderator",
    				existing_nullable=False)

SuryaSankar

// Use Gists to store code you would like to remember later on
console.log(window); // log the "window" object to the console

SuryaSankar

angular.module( 'inkmonk.directives', [] )
.directive('inkmonkCountdown',['$compile', function($compile){
    return {
	    restrict: 'AE',
	    template:  "{{counter}}", 
	    scope:  {
	        counterStart : "=start",
	        dependsOn: "=runduring"
	    },
	    controller: ['$scope', '$element', '$attrs', '$timeout', function ($scope, $element, $attrs, $timeout) {

SuryaSankar

#########################################################
# Generic methods independent of any App logic here.
# This module is meant to be a Python tool set.
#########################################################

from itertools import chain, groupby
from operator import attrgetter
from contextlib import contextmanager
from inspect import ismethod
import re

SuryaSankar

class Point(object):
    def __init__(self, row, col):
        self.row = row
        self.col = col

    def __eq__(self, other):
        return self.row == other.row and self.col == other.col

    def __repr__(self):
        return "(%s, %s)" % (self.row, self.col)

SuryaSankar

You will be building...

A Marketplace for Custom Printed Products.

It is challenging because...

1. It is a multi-category ecommerce platform with customization services built on top. It requires every product to be treated differently from the customer's POV, while still retaining the platform's ability to treat them as interchangeable entities.

2. Online printing platforms require sophisticated design tools ( For example, take a look at https://inkmonk.com , zazzle.com or vistaprint.com). Building them requires some seriously good frontend wizardry.

3. The huge complexity in the nature of the products, their physical specifications, their printing specifications and the ways in which they can combine to determine the price of a given product can cause some serious combinatorial challenges. Simplifying the domain to build a scaleable platform is the challenge

SuryaSankar

Evaluation Task #1 for Backend Developer Role at Inkmonk.com

Have you watched "Cloudy with a chance of meatballs?" The plot is very simple. Flint is an eccentric genius who has discovered a machine which will manufacture infinite varieties of food by mixing and matching ingredients in a zillion ways. And then a host of bad stuff happens as usual. But that is irrelevant to us.

Let's say Flint wants to create a website where he can offer his food item creation service to everyone in the world. He has contracted you to develop the website for him. Here are his requirements

###Requirements

1. Right now Flint is planning to let users create their own pizzas, burgers, sandwiches, ice creams, milk shakes and a full course Indian meals. The list won't end with this. He will keep on adding and is planning to add at least 100 kinds of food by the end of next month.

SuryaSankar

Goal

The goal of this task is to find out how good you are at understanding a business requirement and converting it into code. You will be required to build a dashboard with some basic CRUD actions only.

Problem Statement

Design a basic version of an inventory and billing management tool for a grocery store

Basic Requirements

(These are the basic requirements for the tool - which have to be necessarily implemented)

SuryaSankar

SELECT 
	activity_sq.activity_cohort_date AS first_purchase_date,
	population_agg_sq.cohort_total_user_count AS total_user_count,
	period_diff(activity_sq.activity_date, activity_sq.activity_cohort_date) AS month_number,
	count(DISTINCT activity_sq.order_user_id) * 100 / population_agg_sq.cohort_total_user_count AS retention_percent 
FROM (
	    SELECT date_format(convert_tz(order.paid_on, '+00:00', '+05:30'), '%Y%m') AS activity_date, 
	    	   order.user_id AS order_user_id, 
	    	   population_sq.cohort_date AS activity_cohort_date 
	    FROM