app_prototype/build_database.py at main · thecloudgeek/app_prototype · GitHub

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
import os
from datetime import datetime

from config import db
from models import Applicant, Application, LegalDocs

# Delete database file if it exists currently
if os.path.exists("people.db"):
    os.remove("people.db")


# Create the database
db.create_all()

application1 = Application(
    channel = "directMail",
    type = "Credit",
    offerId = "ASBNU2314",
    ipAddress = "11.32.44.55",
    neuroIdIdentifier = "3aqw-234rasdf-324qvxc-2345q",
    threatmetrixSessionId = "sfdfgtw435tgdxsfgqe4rwaqes",
    applicationAgreements = True,
    cardholderAgreements = True,
    electronicCommunication = True,
    privacyPolicy = True,
    termsOfService = True,
    disclosureHtml = "gcs://somebucket/somesnapshot",
    reviewPageHtml = "gcs://somebucket/somesnapshot",
)
db.session.add(application1)

applicant1 = Applicant(
    firstName = "First 1",
    middleName = "Middle 1",
    lastName = "Last 1",
    birthDate = "01/01/1980",
    ssn = "123-321-4321",
    phoneNumber = "321-321-4321",
    emailAddress = "testuser@gmail.com",
    addressLine1 = "123 Mission St",
    addressLine2 = "apt 1111",
    city = "San Francisco",
    state = "CA",
    zip = "94104-4321"

)
db.session.add(applicant1)
applicant1.applications.append(application1)


legalDocs1 = LegalDocs(
    link = "gcs://somebucket/somefolder/somedoc",
    type = "CAG"
)
db.session.add(legalDocs1)
application1.legalDocs.append(legalDocs1)

db.session.commit()