from datetime import datetime
from sqlalchemy import Table, Column, String, Boolean, DateTime, Integer, or_, ForeignKey
from sqlalchemy.orm import relation, backref

from pyfantasy.utils import session, metadata, url_for, get_random_uid
from sqlalchemy.ext.declarative import declarative_base

Base = declarative_base()

pcmap = Table("pcmap", metadata, Column("playerid", ForeignKey("players.uid")), Column("clanid", ForeignKey("clans.uid")))


class Player(Base):
    __tablename__ = "players"

    uid = Column(Integer, primary_key=True)
    country = Column(String(2))
    name = Column(String(40))
    price = Column(Integer)
    score = Column(Integer, default=0)
    rwin = Column(Integer, default=0)
    rloss = Column(Integer, default=0)
    kills = Column(Integer, default=0)
    deaths = Column(Integer, default=0)
    assists = Column(Integer, default=0)
    wards = Column(Integer, default=0)
    #real_clan_uid = Column(ForeignKey("realclans.uid"))

    def __init__(self, country, name, price, real_clan):
        self.country = country
        self.name = name
        self.price = price
        #self.real_clan_uid = real_clan.uid

    def __repr__(self):
        return "<Player %r, Real_Clan %r>" % (self.uid, self.real_clan)

class Real_Clan(Base):
    __tablename__ = "realclans"

    uid = Column(Integer, primary_key=True)
    country = Column(String(2))
    tag = Column(String(5))
    name = Column(String(40))
    website = Column(String(40))
    #players = relation("Player", backref="real_clan", order_by="desc(Player.score)", primaryjoin="Real_Clan.uid==Player.real_clan_uid")

    def __init__(self, country, tag, name, website):
        self.country = country
        self.tag = tag
        self.name = name
        self.website = website

    def __repr__(self):
        return "<Real_Clan %r>" % self.uid

class Clan(Base):
    __tablename__ = "clans"

    uid = Column(Integer, primary_key=True)
    name = Column(String(40), unique=True)
    transfers = Column(Integer, default=3)
    money = Column(Integer, default=10000)
    score = Column(Integer, default=0)
    rwin = Column(Integer, default=0)
    rloss = Column(Integer, default=0)
    kills = Column(Integer, default=0)
    deaths = Column(Integer, default=0)
    assists = Column(Integer, default=0)
    wards = Column(Integer, default=0)

    players = relation('Player', secondary=pcmap, backref='clans')

    def __init__(self, name, *player_list):
        self.name = name

        for player in player_list:
            self.players.append(player)

    def __repr__(self):
        return "<Clan %r>" % self.uid