Skip to content

Instantly share code, notes, and snippets.

View tamert's full-sized avatar
:octocat:
Edit status

Tamer Ağaoğlu tamert

:octocat:
Edit status
147 followers · 502 following
View GitHub Profile
@tamert
tamert / city_district.sql
Created May 9, 2024 11:38
Turkiye il ilce sql
INSERT INTO city VALUES ('1', 'Adana', '2012-12-12', '2012-12-12');
INSERT INTO city VALUES ('2', 'Adıyaman', '2012-12-12', '2012-12-12');
INSERT INTO city VALUES ('3', 'Afyonkarahisar', '2012-12-12', '2012-12-12');
INSERT INTO city VALUES ('4', 'Ağrı', '2012-12-12', '2012-12-12');
INSERT INTO city VALUES ('5', 'Amasya', '2012-12-12', '2012-12-12');
INSERT INTO city VALUES ('6', 'Ankara', '2012-12-12', '2012-12-12');
INSERT INTO city VALUES ('7', 'Antalya', '2012-12-12', '2012-12-12');
INSERT INTO city VALUES ('8', 'Artvin', '2012-12-12', '2012-12-12');
INSERT INTO city VALUES ('9', 'Aydın', '2012-12-12', '2012-12-12');
INSERT INTO city VALUES ('10', 'Balıkesir', '2012-12-12', '2012-12-12');
@tamert
tamert / mysql_numeric_functions.md
Last active October 23, 2022 20:44

Sayısal Fonksiyonlar

Sayısal İşlevler, sayılar üzerinde işlem yapmak ve sayıları döndürmek için kullanılır. SQL'de tanımlanan sayısal işlevler şunlardır:

ABS(): Bir sayının mutlak değerini döndürür.

Syntax: SELECT ABS(-243.5); Output: 243.5

@tamert
tamert / coffees.sql
Last active October 18, 2022 09:35
CREATE TABLE `coffees`
(
`id` INT(11) PRIMARY KEY AUTO_INCREMENT NOT NULL,
`title` VARCHAR(255) CHARACTER SET utf8 COLLATE utf8_general_ci,
`slug` VARCHAR(255) CHARACTER SET utf8 COLLATE utf8_general_ci,
`description` TEXT CHARACTER SET utf8 COLLATE utf8_general_ci,
`status` VARCHAR(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT '',
`deleted_at` TIMESTAMP NULL DEFAULT NULL
) ENGINE = InnoDB;
@tamert
tamert / aioweb.py
Created October 17, 2022 20:50
from aiohttp import web
import requests
routes = web.RouteTableDef()
@routes.get('/coffees')
async def get_coffees(request: web.Request) -> web.Response:
response = requests.get("https://api.sampleapis.com/coffee/hot")
if response.status_code in [200, 201]:
@tamert
tamert / asyncio_tcp.py
Created October 17, 2022 20:20
import asyncio
async def hello(reader, writer):
data = await reader.read(100)
writer.write(b'hello world!')
await writer.drain()
writer.close()
async def main():
server = await asyncio.start_server(hello, '127.0.0.1', 80)
@tamert
tamert / Dockerfile
Created December 2, 2021 18:13 — forked from tobiasfriden/Dockerfile
Gstreamer WebRTC python demo working Dockerfile
FROM maxmcd/gstreamer:1.14-buster
WORKDIR /usr/src
RUN apt-get update && apt-get install -y python3-pip \
pkg-config \
libcairo2-dev \
gcc \
python3-dev \
libgirepository1.0-dev \
@tamert
tamert / omit.ts
Last active September 12, 2021 15:14
Omit
interface Book {
id: number;
title: string;
subject?: 'crime' | 'comedy';
body: string;
}
type BookPreview = Omit<Book, "id" | "body">;
const book: BookPreview = {
@tamert
tamert / pick.ts
Created September 12, 2021 15:03
Pick
interface Book {
id: number;
title: string;
subject?: 'crime' | 'comedy';
body: string;
}
type BookPreview = Pick<Book, "title" | "subject">;
const book: BookPreview = {
@tamert
tamert / required.ts
Created September 12, 2021 14:35
Required
interface Book {
id: number;
title: string;
subject?: 'crime' | 'comedy';
body: string;
}
class BookRepository {
constructor(private model: Book | {} = {}) {}
create( model: Required<Book> ) {
@tamert
tamert / partial.ts
Created September 12, 2021 13:39
Partial
interface Book {
id: number;
title: string;
subject: 'crime' | 'comedy';
body: string;
}
class BookRepository {
constructor(private model: Book) {}
update( model: Partial<Book> ) {