zelark

def foo():
    x0 = [[1, 2], [3, 4], [5, 6]]
    y = [x2 for x1 in x0 for x2 in x1]
    print y

def bar():
    x = [[1, 2], [3, 4], [5, 6]]
    x = [x for x in x for x in x]
    print x

zelark

create table tmp_t1
(
  amount number,
  txt varchar2(50 char)
);

insert into tmp_t1
   (amount, txt)
 values
   (1, 'text 1');

zelark

select regexp_replace(str, '(foo|foos|fooes)', 'bar', 1, 1, 'i') as val
from   (select 'aa_fOo_bb' str from dual);

zelark

>>> my_list = [1, 2, 3, 4, 5, 6, 7, 8, 9, 10]
>>> my_list
[1, 2, 3, 4, 5, 6, 7, 8, 9, 10]

zelark

from random import randint

def kill_negative(n):
    if n < 0:
        n = 0
    return n

def calc_attack(level):
    return level*6

zelark

with data as (
    select 50 as col1,  0 as col2 from dual union all
    select  0 as col1, 20 as col2 from dual union all
    select 20 as col1, 10 as col2 from dual union all
    select 20 as col1, 10 as col2 from dual
)
select avg(nullif(col1, 0)) as col1_avg_no_zero,
       avg(nullif(case when col2 = 0 then 0 else col1 end, 0)) as col1_avg_no_zero_with_col2        
from   data;

zelark

import time
import random
import select
import socket


def chk(data):
    x = sum(a + b * 256 for a, b in zip(data[::2], data[1::2] + b'\x00')) & 0xFFFFFFFF
    x = (x >> 16) + (x & 0xFFFF)
    x = (x >> 16) + (x & 0xFFFF)

zelark

telnet coursify.ru 80
Trying 95.85.32.220...
Connected to coursify.ru.
Escape character is.
POST /login HTTP/1.1
Host: coursify.ru
Content-Type: application/x-www-form-urlencoded
Content-Length: 0
Content-Disposition: form-data; login="user"; password="12345678"

zelark

from bottle import route, run, install
from bottle_sqlite import SQLitePlugin

install(SQLitePlugin(dbfile='bottle.db'))

@route('/db/')
def database(db):
    data = db.execute('SELECT SQLITE_VERSION()').fetchone()
    print "SQLite version: %s" % data      

zelark

create table medal_scd (
  id number(20),
  quantity number(20),
  start_date date,
  end_date date,
  status char (1 byte)
);

create table medal_src (
  id number(20),