app.backbone.entities.bot_trade_performance

 1from sqlalchemy import Integer, Column, ForeignKey, Float
 2from sqlalchemy.orm import relationship
 3from . import Base           
 4
 5class BotTradePerformance(Base):
 6    __tablename__ = 'BotTradePerformances'
 7    
 8    Id = Column(Integer, primary_key=True, autoincrement=True)
 9    BotPerformanceId =  Column(Integer, ForeignKey('BotPerformances.Id'), unique=True)
10    MeanWinningReturnPct = Column(Float, nullable=False)
11    StdWinningReturnPct = Column(Float, nullable=False)
12    MeanLosingReturnPct = Column(Float, nullable=False)
13    StdLosingReturnPct = Column(Float, nullable=False)
14    MeanTradeDuration = Column(Float, nullable=False)
15    StdTradeDuration = Column(Float, nullable=False)
16    LongWinrate = Column(Float, nullable=False)
17    WinLongMeanReturnPct = Column(Float, nullable=False)
18    WinLongStdReturnPct = Column(Float, nullable=False)
19    LoseLongMeanReturnPct = Column(Float, nullable=False)
20    LoseLongStdReturnPct = Column(Float, nullable=False)
21    ShortWinrate = Column(Float, nullable=False)
22    WinShortMeanReturnPct = Column(Float, nullable=False)
23    WinShortStdReturnPct = Column(Float, nullable=False)
24    LoseShortMeanReturnPct = Column(Float, nullable=False)
25    LoseShortStdReturnPct = Column(Float, nullable=False)
26
27    MeanReturnPct = Column(Float, nullable=False)
28    StdReturnPct = Column(Float, nullable=False)
29    ProfitFactor = Column(Float, nullable=False)
30    WinRate = Column(Float, nullable=False)
31    ConsecutiveWins = Column(Integer, nullable=False)
32    ConsecutiveLosses = Column(Integer, nullable=False)
33    LongCount = Column(Integer, nullable=False)
34    ShortCount = Column(Integer, nullable=False)
35    LongMeanReturnPct = Column(Integer, nullable=False)
36    LongStdReturnPct = Column(Integer, nullable=False)
37    ShortMeanReturnPct = Column(Integer, nullable=False)
38    ShortStdReturnPct = Column(Integer, nullable=False)
39    
40    BotPerformance = relationship('BotPerformance', back_populates='BotTradePerformance', lazy='joined')
41    
42    def __repr__(self):
43        return f"<BotTradePerformance(Id={self.Id}, MeanWinningReturnPct={self.MeanWinningReturnPct}, MeanTradeDuration={self.MeanTradeDuration})>"
44    
45    
class BotTradePerformance(sqlalchemy.orm.decl_api._DynamicAttributesType, sqlalchemy.inspection.Inspectable[sqlalchemy.orm.mapper.Mapper[typing.Any]]):
 6class BotTradePerformance(Base):
 7    __tablename__ = 'BotTradePerformances'
 8    
 9    Id = Column(Integer, primary_key=True, autoincrement=True)
10    BotPerformanceId =  Column(Integer, ForeignKey('BotPerformances.Id'), unique=True)
11    MeanWinningReturnPct = Column(Float, nullable=False)
12    StdWinningReturnPct = Column(Float, nullable=False)
13    MeanLosingReturnPct = Column(Float, nullable=False)
14    StdLosingReturnPct = Column(Float, nullable=False)
15    MeanTradeDuration = Column(Float, nullable=False)
16    StdTradeDuration = Column(Float, nullable=False)
17    LongWinrate = Column(Float, nullable=False)
18    WinLongMeanReturnPct = Column(Float, nullable=False)
19    WinLongStdReturnPct = Column(Float, nullable=False)
20    LoseLongMeanReturnPct = Column(Float, nullable=False)
21    LoseLongStdReturnPct = Column(Float, nullable=False)
22    ShortWinrate = Column(Float, nullable=False)
23    WinShortMeanReturnPct = Column(Float, nullable=False)
24    WinShortStdReturnPct = Column(Float, nullable=False)
25    LoseShortMeanReturnPct = Column(Float, nullable=False)
26    LoseShortStdReturnPct = Column(Float, nullable=False)
27
28    MeanReturnPct = Column(Float, nullable=False)
29    StdReturnPct = Column(Float, nullable=False)
30    ProfitFactor = Column(Float, nullable=False)
31    WinRate = Column(Float, nullable=False)
32    ConsecutiveWins = Column(Integer, nullable=False)
33    ConsecutiveLosses = Column(Integer, nullable=False)
34    LongCount = Column(Integer, nullable=False)
35    ShortCount = Column(Integer, nullable=False)
36    LongMeanReturnPct = Column(Integer, nullable=False)
37    LongStdReturnPct = Column(Integer, nullable=False)
38    ShortMeanReturnPct = Column(Integer, nullable=False)
39    ShortStdReturnPct = Column(Integer, nullable=False)
40    
41    BotPerformance = relationship('BotPerformance', back_populates='BotTradePerformance', lazy='joined')
42    
43    def __repr__(self):
44        return f"<BotTradePerformance(Id={self.Id}, MeanWinningReturnPct={self.MeanWinningReturnPct}, MeanTradeDuration={self.MeanTradeDuration})>"

The base class of the class hierarchy.

When called, it accepts no arguments and returns a new featureless instance that has no instance attributes and cannot be given any.

BotTradePerformance(**kwargs)

A simple constructor that allows initialization from kwargs.

Sets attributes on the constructed instance using the names and values in kwargs.

Only keys that are present as attributes of the instance's class are allowed. These could be, for example, any mapped columns or relationships.

Id
BotPerformanceId
MeanWinningReturnPct
StdWinningReturnPct
MeanLosingReturnPct
StdLosingReturnPct
MeanTradeDuration
StdTradeDuration
LongWinrate
WinLongMeanReturnPct
WinLongStdReturnPct
LoseLongMeanReturnPct
LoseLongStdReturnPct
ShortWinrate
WinShortMeanReturnPct
WinShortStdReturnPct
LoseShortMeanReturnPct
LoseShortStdReturnPct
MeanReturnPct
StdReturnPct
ProfitFactor
WinRate
ConsecutiveWins
ConsecutiveLosses
LongCount
ShortCount
LongMeanReturnPct
LongStdReturnPct
ShortMeanReturnPct
ShortStdReturnPct
BotPerformance