File size: 5,200 Bytes
815d7a1
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
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
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
import sqlite3
from datetime import UTC, datetime, timedelta

DB_PATH = "ssc.db"


def get_password_hash(cursor):
    cursor.execute("SELECT password FROM users WHERE email = ? LIMIT 1", ("virat@ssc.com",))
    row = cursor.fetchone()
    if row and row[0]:
        return row[0]

    cursor.execute("SELECT password FROM users LIMIT 1")
    row = cursor.fetchone()
    if row and row[0]:
        return row[0]

    # Fallback only if table has no users yet
    return "password123"


def user_exists(cursor, email):
    cursor.execute("SELECT 1 FROM users WHERE email = ? LIMIT 1", (email,))
    return cursor.fetchone() is not None


def insert_user(cursor, payload):
    cursor.execute(
        """
        INSERT INTO users (
            name, email, password, jersey_number, role, bio,
            runs, matches, wickets, centuries, half_centuries,
            average_runs, highest_score, is_premium,
            premium_expiry, premium_start_date,
            is_active, created_at, updated_at, last_login
        ) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
        """,
        (
            payload["name"],
            payload["email"],
            payload["password"],
            payload["jersey_number"],
            payload["role"],
            payload["bio"],
            payload["runs"],
            payload["matches"],
            payload["wickets"],
            payload["centuries"],
            payload["half_centuries"],
            payload["average_runs"],
            payload["highest_score"],
            1 if payload["is_premium"] else 0,
            payload["premium_expiry"],
            payload["premium_start_date"],
            1,
            payload["created_at"],
            payload["updated_at"],
            None,
        ),
    )


def main():
    conn = sqlite3.connect(DB_PATH)
    cur = conn.cursor()

    now = datetime.now(UTC).replace(microsecond=0)
    now_text = now.isoformat(sep=" ")
    premium_expiry_text = (now + timedelta(days=30)).isoformat(sep=" ")
    shared_password_hash = get_password_hash(cur)

    inserted_premium = 0
    inserted_guest = 0

    # 20 premium dummy players (10 batsmen + 10 bowlers)
    for i in range(1, 21):
        is_batsman = i <= 10
        email = f"premium{i:02d}@ssc.com"
        if user_exists(cur, email):
            continue

        runs = 1200 + (i * 45) if is_batsman else 320 + (i * 15)
        matches = 30 + i
        wickets = 8 + (i % 6) if is_batsman else 55 + (i * 3)
        avg_runs = round(runs / matches, 2) if matches else 0.0

        insert_user(
            cur,
            {
                "name": f"Premium Player {i:02d}",
                "email": email,
                "password": shared_password_hash,
                "jersey_number": 100 + i,
                "role": "player",
                "bio": "Premium Batsman" if is_batsman else "Premium Bowler",
                "runs": runs,
                "matches": matches,
                "wickets": wickets,
                "centuries": 2 + (i % 4) if is_batsman else 0,
                "half_centuries": 6 + (i % 8) if is_batsman else 1 + (i % 3),
                "average_runs": avg_runs,
                "highest_score": 95 + (i * 4) if is_batsman else 42 + (i % 10),
                "is_premium": True,
                "premium_expiry": premium_expiry_text,
                "premium_start_date": now_text,
                "created_at": now_text,
                "updated_at": now_text,
            },
        )
        inserted_premium += 1

    # 10 regular guest players
    for i in range(1, 11):
        email = f"guest{i:02d}@ssc.com"
        if user_exists(cur, email):
            continue

        runs = 140 + (i * 25)
        matches = 8 + i
        avg_runs = round(runs / matches, 2)

        insert_user(
            cur,
            {
                "name": f"Guest Player {i:02d}",
                "email": email,
                "password": shared_password_hash,
                "jersey_number": 200 + i,
                "role": "player",
                "bio": "Guest Regular Player",
                "runs": runs,
                "matches": matches,
                "wickets": 1 + (i % 4),
                "centuries": 0,
                "half_centuries": 0,
                "average_runs": avg_runs,
                "highest_score": 28 + (i * 3),
                "is_premium": False,
                "premium_expiry": None,
                "premium_start_date": None,
                "created_at": now_text,
                "updated_at": now_text,
            },
        )
        inserted_guest += 1

    conn.commit()

    cur.execute("SELECT COUNT(*) FROM users WHERE email LIKE 'premium%@ssc.com' AND is_premium = 1")
    total_premium = cur.fetchone()[0]
    cur.execute("SELECT COUNT(*) FROM users WHERE email LIKE 'guest%@ssc.com' AND is_premium = 0")
    total_guest = cur.fetchone()[0]

    conn.close()

    print(f"Inserted premium users: {inserted_premium}")
    print(f"Inserted guest users: {inserted_guest}")
    print(f"Total premium dummy users in DB: {total_premium}")
    print(f"Total guest dummy users in DB: {total_guest}")


if __name__ == "__main__":
    main()