tamert

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

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

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

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

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

interface Book {
    id: number;
    title: string;
    subject?: 'crime' | 'comedy';
    body: string;
}
 
type BookPreview = Omit<Book, "id" | "body">;
 
const book: BookPreview = {

tamert

interface Book {
    id: number;
    title: string;
    subject?: 'crime' | 'comedy';
    body: string;
}
 
type BookPreview = Pick<Book, "title" | "subject">;
 
const book: BookPreview = {

tamert

interface Book {
    id: number;
    title: string;
    subject?: 'crime' | 'comedy';
    body: string;
}

class BookRepository {
    constructor(private model: Book | {} = {}) {}
    create( model: Required<Book> ) {

tamert

interface Book {
    id: number;
    title: string;
    subject: 'crime' | 'comedy';
    body: string;
}

class BookRepository {
    constructor(private model: Book) {}
    update( model: Partial<Book> ) {

tamert

interface Book {
    id: number;
    title: string;
    header?: string;
    body: string;
    date?: Date;
}

class Writer {
    name: string | null = null;