from base import Base
from sqlalchemy import Column, String, Integer, Date, Boolean, Numeric, ForeignKey, UniqueConstraint, PrimaryKeyConstraint

class Reit(Base):
    __tablename__ = 'reits'

    id=Column(Integer, primary_key=True)
    ticker=Column('ticker', String(8), unique=True)
    is_owned=Column('is_owned', Boolean)
    quantity=Column('quantity', Integer)
    price=Column('price', Numeric)

    def __init__(self, ticker, is_owned, quantity, price):
        self.ticker = ticker
        self.is_owned = is_owned
        self.quantity = quantity
        self.price = price

class TickerData(Base):
    __tablename__ = "ticker_data"

    reit_ticker = Column(String(8), ForeignKey('reits.ticker'))

    financial_type = Column('type', String(256))
    record_date = Column('date', Date)
    record_value = Column('value', Numeric)

    __table_args__ = (
        UniqueConstraint('reit_ticker', 'type', 'date', 'value', name='_data_unique'),
        PrimaryKeyConstraint('reit_ticker', 'type', 'date', 'value'),
    )

    def __init__(self, reit_ticker, financial_type, record_date, record_value):
        self.reit_ticker = reit_ticker
        self.financial_type = financial_type
        self.record_date = record_date
        self.record_value = record_value

import React, { Component } from 'react';
import './App.css';
import ReactMarkdown from 'react-markdown';
import markdown from '../articles/splash.md';