def getSQL()

in lambda/lambda-pg-generator/postgresql.py [0:0]

• 14 lines of code
• 1 McCabe index (conditional complexity)

def getSQL():
    x = random.randint(1,2)
    x = x*10
    y = x+50
    account_id = random.randint(x,y)
    now = datetime.datetime.now()
    str_now = now.isoformat()
    date = str_now
    type = random.choice(['debit', 'credit'])
    operation = random.choice(['CCW', 'CCK', 'CAB', 'WCA', 'RAB'])
    amount = random.randint(1,100000)
    balance = random.randint(-20000,100000)
    sql = "insert into transactions values (default,%s,'%s','%s','%s',%s,%s)" % (account_id, date, type,operation,amount,balance)
    #print(sql)
    return sql