1

from pvl.verkko import web, db, table

     2

from pvl.web import html, urls

     3

     4

import datetime

     5

import logging; log = logging.getLogger('pvl.verkko.wlan')

     6

     7

class WLANSta (object) :

     8

    """

     9

        A WLAN STA (client) with ap/ssid/sta and starts/ends.

    10

    """

    11

    12

    DATE_FMT = '%Y%m%d %H:%M'

    13

    TIME_FMT = '%H:%M:%S'

    14

    15

    @classmethod

    16

    def format_datetime (cls, dt) :

    17

        if dt.date() == datetime.date.today() :

    18

            return dt.strftime(cls.TIME_FMT)

    19

        else :

    20

            return dt.strftime(cls.DATE_FMT)

    21

    22

    def seen (self) :

    23

        return (

    24

                html.span(title=self.first_seen)(self.format_datetime(self.first_seen)),

    25

                '-',

    26

                html.span(title=self.last_seen)(self.format_datetime(self.last_seen))

    27

        )

    28

    29

db.mapper(WLANSta, db.wlan_sta, properties=dict(

    30

    31

))

    32

    33

class WLANTable (table.Table) :

    34

    """

    35

        <table> of WLAN STA

    36

    """

    37

    38

    ITEMS   = "WLAN Stations"

    39

    COLUMNS = (

    40

        table.Column('ap',          "Access Point",     WLANSta.ap,

    41

            rowfilter   = True,

    42

        ),

    43

        table.Column('wlan',        "SSID",             WLANSta.wlan,

    44

            rowfilter   = True,

    45

        ),

    46

        table.Column('sta',         "MAC",              WLANSta.sta,

    47

            rowfilter   = True,

    48

        ),

    49

        table.Column('seen',        "Seen",             WLANSta.last_seen,  WLANSta.seen),

    50

    )

    51

    52

    # XXX: have to set again

    53

    ATTRS = dict((col.attr, col) for col in COLUMNS)

    54

    55

    # default

    56

    SORT = WLANSta.last_seen.desc()

    57

    PAGE = 20

    58

    59

class WLANHandler (table.TableHandler, web.DatabaseHandler) :

    60

    """

    61

        Combined database + <table>

    62

    """

    63

    64

    CSS = web.DatabaseHandler.CSS + table.TableHandler.CSS + (

    65

        "/static/wlan.css", 

    66

    )

    67

    68

    # view

    69

    TABLE = WLANTable

    70

    DB_CLASS = WLANSta

    71

    72

class Application (web.Application) :

    73

    URLS = urls.Map((

    74

        urls.rule('/',                       WLANHandler),

    75

    ))