Skip to content

Instantly share code, notes, and snippets.

View dlyapun's full-sized avatar

Dmitry Lyapun dlyapun

View GitHub Profile
import sqlite3
conn = sqlite3.connect(":memory")
cursor = conn.cursor()
sql_command = 'CREATE TABLE STUDENTS ( ID INTEGER PRIMARY KEY, FIRST_NAME VARCHAR(50) NOT NULL, LAST_NAME VARCHAR(50) NOT NULL, ADDRESS VARCHAR(100) );'
cursor.execute(sql_command)
sql_command = "INSERT INTO students VALUES (2, 'Ivan', 'Ivanon', 'My address');"
cursor.execute(sql_command)
conn.commit()
CREATE TABLE STUDENTS (
ID INTEGER PRIMARY KEY,
FIRST_NAME VARCHAR(50) NOT NULL,
LAST_NAME VARCHAR(50) NOT NULL,
ADDRESS VARCHAR(100)
);
CREATE TABLE ORDERS
(
Id INTEGER PRIMARY KEY,
'''
ЛАБ 2 - ЧАСТЬ 2
Пример для этапов 7-8
'''
##1
import numpy as np
import matplotlib.pyplot as plt
# Функция уравнения прямой y=a*x+b
@dlyapun
dlyapun / Lesson 2
Created September 23, 2019 15:15
Simple python game
import random
def main():
print('SUPER FIGHT GAME!')
player = None
Player1 = {
'name': 'Power man',
'power': 15,
'skill': 1.0,
@dlyapun
dlyapun / lab1
Created September 20, 2019 09:34
lab1
from math import sqrt
import matplotlib.pyplot as plt
import numpy as np
RANDOM_POINTS_COUNT = 10
def get_euclidean_distance(point_one, point_two):
dx = (point_one[0] - point_two[0]) ** 2
@dlyapun
dlyapun / Lab2
Created September 20, 2019 06:16
Lab2
# -*- coding: utf-8 -*-
import numpy as np
import matplotlib.pyplot as plt
class_red = np.array([[0.05, 0.91],
[0.14, 0.96],
[0.16, 0.9],
[0.07, 0.7],
[0.2, 0.63]])
@dlyapun
dlyapun / gist:3c502ad70f5a552eb8544aa21767c598
Created November 27, 2017 11:18
Set unique session key for each django dynamic subdomains
from django.contrib.sites.shortcuts import get_current_site
from django.core.exceptions import ObjectDoesNotExist
from django.http import Http404
from django.conf import settings
from django.contrib.sessions.middleware import SessionMiddleware
class RedirectSiteMiddleware(object):
def process_request(self, request):
# -*- coding: utf-8 -*-
from django.core.management import call_command
from django.core.urlresolvers import reverse
from django.test import TestCase, Client
from django.contrib.admin.sites import AdminSite
from common.test.factories import MealOptionFactory, MealOptionCategoryFactory, MealFactory, RestaurantFactory, \
MealCategoryFactory, UserFactory
from gloodny.models import *
@dlyapun
dlyapun / gist:b06d4622ec7c34d4025b102a4ecb6d5c
Created November 22, 2017 15:20
Test Django admin actions save_model save_related
from django.core.urlresolvers import reverse
from django.test import TestCase, Client
from django.contrib.admin.sites import AdminSite
from gloodny.models import *
from django.forms.models import model_to_dict
class ChangeHistoryTests(TestCase):
fixtures = ['init_gloodny.json']
@dlyapun
dlyapun / gist:f7f47b50f80f5c004c212c8b710227e3
Created November 6, 2017 20:35
Pagination Django Python
import math
PAGINATE_BY = 9
ALL_PAGES = 'all pages'
def paginator(page, data_objects, objects_count=None):
paginate = PAGINATE_BY
page = int(page)
next = PAGINATE_BY * page