def updateData(self):
query = session.query(CrashReportIE).order_by(
CrashReportIE.Id.desc()).first()
Hotfix_Version = int(query.ReleaseBuild.split(".")[2]) + 1
Update_Version = query.ReleaseBuild.split(
".")[0] + "." + query.ReleaseBuild.split(".")[1] + "." + str(
Hotfix_Version) + "." + Hotfix_Buildnumber.split('.')[3]
Build_CA_IT, Build_AU_AR_ZA_PL, Build_MX_IE, APP_BUILD_NUM = getCrashRate.ReformatBuildVersion(
Update_Version)
ReleaseBuild = Build_MX_IE.split(' ')[0]
HotFix_crashRate = getCrashRate.get_crash_rate_for_country(
'Gumtree IE', Build_CA_IT, Build_AU_AR_ZA_PL, Build_MX_IE,
APP_BUILD_NUM)
if HotFix_crashRate == "0%":
print("Crash Data is 0% ,no need to save into DB")
else:
query.ReleaseBuild = ReleaseBuild
query.CrashRate = HotFix_crashRate
query.ReleaseNumber = Hotfix_Buildnumber
session.commit()
from sys import argv
import getCrashRate
engine = create_engine("sqlite:///scripts/PoltDemoDB.db", echo=True)
#engine = create_engine("sqlite:///PoltDemoDB.db", echo=True)
Base = declarative_base()
crashRate = 0
Session = sessionmaker(bind=engine)
session = Session()
Hotfix_Buildnumber = argv[2]
country = argv[1]
print(Hotfix_Buildnumber)
BuildVersion_AU = "5." + Hotfix_Buildnumber.split(
'.')[1] + '.' + Hotfix_Buildnumber.split(
'.')[2] + '.' + Hotfix_Buildnumber.split('.')[3]
Build_CA_IT, Build_AU_AR_ZA_PL, Build_MX_IE, APP_BUILD_NUM = getCrashRate.ReformatBuildVersion(
BuildVersion_AU)
# update the crash rate of the last version for AU
class CrashReportAU(Base):
__tablename__ = 'TestTableForAU'
Id = Column(Integer, primary_key=True)
ReleaseBuild = Column(String, nullable=False)
CrashRate = Column(String, nullable=False)
ReleaseNumber = Column(String, nullable=False)
Notes = Column(String, nullable=True)
# update crash rate up to date
def updateData(self):
# crashRate = getCrashRate.get_crash_rate_for_country('Gumtree AU',Build_CA_IT,Build_AU_AR_ZA_PL,Build_MX_IE,APP_BUILD_NUM)
# ReleaseBuild = Build_AU_AR_ZA_PL.split(' ')[0]