Python Tableの例

コード例 #1

ファイル: user_saved_event.py プロジェクト: nariman/event-a-server

"""
Event Bot Server
"""

import datetime

import pendulum
import sqlalchemy as sa

from . import metadata
from eventbot.lib.sqlalchemy.base import Table
from eventbot.lib.sqlalchemy.types import DateTime, GUID

t = table = Table(
    "user_saved_events", metadata, sa.Column("user_id", GUID, nullable=False),
    sa.Column("event_id", GUID, nullable=False),
    sa.Column("saved_at", DateTime, default=pendulum.now, nullable=False))

コード例 #2

ファイル: user.py プロジェクト: nariman/event-a-server

"""
Event Bot Server
"""

import datetime
import uuid

import pendulum
import sqlalchemy as sa

from . import metadata
from eventbot.lib.sqlalchemy.base import Table
from eventbot.lib.sqlalchemy.types import DateTime, GUID

t = table = Table(
    "users", metadata,
    sa.Column("id", GUID, primary_key=True, default=uuid.uuid4),
    sa.Column("created_at", DateTime, default=pendulum.now, nullable=False))


def json_format(user):
    """Returns JSON-ready representation of the user object."""
    return {
        # convert uuid to str
        "id": str(user["id"]),

        # convert datetimes to iso8601 format
        "created_at": user["created_at"].isoformat()
    }

コード例 #3

import datetime

import pendulum
import sqlalchemy as sa

from . import metadata
from eventbot.lib.sqlalchemy.base import Table
from eventbot.lib.sqlalchemy.types import DateTime, GUID


t = table = Table(
    "user_platforms",
    metadata,

    sa.Column("user_id", GUID, nullable=False),
    sa.Column("platform_id", GUID, nullable=False),

    sa.Column("user_platform_id", sa.String(1024)),
    sa.Column("created_at", DateTime, default=pendulum.now, nullable=False)
)


def json_format(user_platform):
    """Returns JSON-ready representation of the user's platform
    object."""
    return {
        # convert uuid to str
        "user_id": str(user_platform["user_id"]),
        "platform_id": str(user_platform["platform_id"]),

        # unknown id as is

コード例 #4

"""

import datetime
import uuid

import pendulum
import sqlalchemy as sa

from . import metadata
from eventbot.lib.sqlalchemy.base import Table
from eventbot.lib.sqlalchemy.types import DateTime, GUID

t = table = Table(
    "events", metadata,
    sa.Column("id", GUID, primary_key=True, default=uuid.uuid4),
    sa.Column("name", sa.String(1024), nullable=False),
    sa.Column("description", sa.Text(), nullable=False),
    sa.Column("start_date", sa.Date, nullable=False),
    sa.Column("end_date", sa.Date, nullable=False),
    sa.Column("created_at", DateTime, default=pendulum.now, nullable=False))


def json_format(event):
    """Returns JSON-ready representation of the event object."""
    return {
        # convert uuid to str
        "id": str(event["id"]),

        # name and description as is
        "name": event["name"],
        "description": event["description"],

コード例 #5

"""
Event Bot Server
"""

import uuid

import sqlalchemy as sa

from . import metadata
from eventbot.lib.sqlalchemy.base import Table
from eventbot.lib.sqlalchemy.types import GUID

t = table = Table(
    "platforms", metadata,
    sa.Column("id", GUID, primary_key=True, default=uuid.uuid4),
    sa.Column("slug", sa.String(64), unique=True, nullable=False),
    sa.Column("name", sa.String(128), nullable=False))


def json_format(platform):
    """Returns JSON-ready representation of the platform object."""
    return {
        # convert uuid to str
        "id": str(platform["id"]),
        # slug as is
        "slug": platform["slug"],

        # name as is
        "name": platform["name"]
    }

コード例 #6

ファイル: session_person.py プロジェクト: nariman/event-a-server

"""
Event Bot Server
"""

import datetime

import pendulum
import sqlalchemy as sa

from . import metadata
from eventbot.lib.sqlalchemy.base import Table
from eventbot.lib.sqlalchemy.types import DateTime, GUID


t = table = Table(
    "session_persons",
    metadata,

    sa.Column("session_id", GUID, nullable=False),
    sa.Column("person_id", GUID, nullable=False)
)

コード例 #7

ファイル: person.py プロジェクト: nariman/event-a-server

"""
Event Bot Server
"""

import datetime
import uuid

import pendulum
import sqlalchemy as sa

from . import metadata
from eventbot.lib.sqlalchemy.base import Table
from eventbot.lib.sqlalchemy.types import DateTime, GUID

t = table = Table("persons", metadata,
                  sa.Column("id", GUID, primary_key=True, default=uuid.uuid4),
                  sa.Column("event_id", GUID, nullable=False),
                  sa.Column("name", sa.String(1024), nullable=False))


def json_format(person):
    """Returns JSON-ready representation of the person object."""
    return {
        # convert uuid to str
        "id": str(person["id"]),
        # convert uuid to str, w/o event object
        "event_id": str(person["event_id"]),

        # name as is
        "name": person["name"]
    }

コード例 #8

"""
Event Bot Server
"""

import datetime

import pendulum
import sqlalchemy as sa

from . import metadata
from eventbot.lib.sqlalchemy.base import Table
from eventbot.lib.sqlalchemy.types import DateTime, GUID


t = table = Table(
    "session_locations",
    metadata,

    sa.Column("session_id", GUID, nullable=False),
    sa.Column("location_id", GUID, nullable=False)
)

コード例 #9

"""
Event Bot Server
"""

import datetime

import pendulum
import sqlalchemy as sa

from . import metadata
from eventbot.lib.sqlalchemy.base import Table
from eventbot.lib.sqlalchemy.types import DateTime, GUID

t = table = Table("session_tags", metadata,
                  sa.Column("session_id", GUID, nullable=False),
                  sa.Column("tag_id", GUID, nullable=False))