#import sqlite3
 
# Sample college data (from provided Excel)
college_data = [
    ("ABC Engineering", "Maharashtra", "Mumbai", "UG", 85, 120000),
    ("XYZ Institute", "Karnataka", "Bangalore", "PG", 75, 150000),
    ("Techno College", "Tamil Nadu", "Chennai", "UG", 90, 100000),
    ("Alpha University", "Delhi", "New Delhi", "PG", 80, 180000),
    ("Beta College", "Gujarat", "Ahmedabad", "UG", 70, 90000),
    ("Gamma Institute", "Rajasthan", "Jaipur", "UG", 88, 110000),
    ("Delta Tech", "Punjab", "Ludhiana", "PG", 78, 160000),
    ("Omega University", "Kerala", "Kochi", "UG", 92, 130000),
    ("Sunrise College", "UP", "Lucknow", "UG", 65, 85000),
    ("Future Institute", "MP", "Bhopal", "PG", 82, 140000),
]
 
# Sample review data
review_data = [
    ("ABC Engineering", "Great faculty and modern labs!", 4.5),
    ("ABC Engineering", "Campus is vibrant but fees are high.", 3.8),
    ("XYZ Institute", "Excellent placement support.", 4.2),
    ("Techno College", "Good infrastructure, average hostel.", 3.5),
    ("Alpha University", "Top-notch research facilities.", 4.8),
]
 
def init_db():
    # Connect to SQLite database (creates college.db if it doesn't exist)
    conn = sqlite3.connect("college.db")
    cursor = conn.cursor()
 
    # Create colleges table
    cursor.execute("""
        CREATE TABLE IF NOT EXISTS colleges (
            name TEXT NOT NULL,
            state TEXT NOT NULL,
            location TEXT NOT NULL,
            course_level TEXT NOT NULL,
            cutoff REAL NOT NULL,
            fees REAL NOT NULL
        )
    """)
 
    # Create reviews table
    cursor.execute("""
        CREATE TABLE IF NOT EXISTS reviews (
            id INTEGER PRIMARY KEY AUTOINCREMENT,
            college_name TEXT NOT NULL,
            review_text TEXT NOT NULL,
            rating REAL NOT NULL,
            FOREIGN KEY (college_name) REFERENCES colleges(name)
        )
    """)
 
    # Insert college data
    cursor.executemany("""
        INSERT OR REPLACE INTO colleges (name, state, location, course_level, cutoff, fees)
        VALUES (?, ?, ?, ?, ?, ?)
    """, college_data)
 
    # Insert review data
    cursor.executemany("""
        INSERT OR REPLACE INTO reviews (college_name, review_text, rating)
        VALUES (?, ?, ?)
    """, review_data)
 
    # Commit and close
    conn.commit()
    conn.close()
    print("Database initialized successfully.")
 
if __name__ == "__main__":
    init_db()

I2ltcG9ydCBzcWxpdGUzCgojIFNhbXBsZSBjb2xsZWdlIGRhdGEgKGZyb20gcHJvdmlkZWQgRXhjZWwpCmNvbGxlZ2VfZGF0YSA9IFsKICAgICgiQUJDIEVuZ2luZWVyaW5nIiwgIk1haGFyYXNodHJhIiwgIk11bWJhaSIsICJVRyIsIDg1LCAxMjAwMDApLAogICAgKCJYWVogSW5zdGl0dXRlIiwgIkthcm5hdGFrYSIsICJCYW5nYWxvcmUiLCAiUEciLCA3NSwgMTUwMDAwKSwKICAgICgiVGVjaG5vIENvbGxlZ2UiLCAiVGFtaWwgTmFkdSIsICJDaGVubmFpIiwgIlVHIiwgOTAsIDEwMDAwMCksCiAgICAoIkFscGhhIFVuaXZlcnNpdHkiLCAiRGVsaGkiLCAiTmV3IERlbGhpIiwgIlBHIiwgODAsIDE4MDAwMCksCiAgICAoIkJldGEgQ29sbGVnZSIsICJHdWphcmF0IiwgIkFobWVkYWJhZCIsICJVRyIsIDcwLCA5MDAwMCksCiAgICAoIkdhbW1hIEluc3RpdHV0ZSIsICJSYWphc3RoYW4iLCAiSmFpcHVyIiwgIlVHIiwgODgsIDExMDAwMCksCiAgICAoIkRlbHRhIFRlY2giLCAiUHVuamFiIiwgIkx1ZGhpYW5hIiwgIlBHIiwgNzgsIDE2MDAwMCksCiAgICAoIk9tZWdhIFVuaXZlcnNpdHkiLCAiS2VyYWxhIiwgIktvY2hpIiwgIlVHIiwgOTIsIDEzMDAwMCksCiAgICAoIlN1bnJpc2UgQ29sbGVnZSIsICJVUCIsICJMdWNrbm93IiwgIlVHIiwgNjUsIDg1MDAwKSwKICAgICgiRnV0dXJlIEluc3RpdHV0ZSIsICJNUCIsICJCaG9wYWwiLCAiUEciLCA4MiwgMTQwMDAwKSwKXQoKIyBTYW1wbGUgcmV2aWV3IGRhdGEKcmV2aWV3X2RhdGEgPSBbCiAgICAoIkFCQyBFbmdpbmVlcmluZyIsICJHcmVhdCBmYWN1bHR5IGFuZCBtb2Rlcm4gbGFicyEiLCA0LjUpLAogICAgKCJBQkMgRW5naW5lZXJpbmciLCAiQ2FtcHVzIGlzIHZpYnJhbnQgYnV0IGZlZXMgYXJlIGhpZ2guIiwgMy44KSwKICAgICgiWFlaIEluc3RpdHV0ZSIsICJFeGNlbGxlbnQgcGxhY2VtZW50IHN1cHBvcnQuIiwgNC4yKSwKICAgICgiVGVjaG5vIENvbGxlZ2UiLCAiR29vZCBpbmZyYXN0cnVjdHVyZSwgYXZlcmFnZSBob3N0ZWwuIiwgMy41KSwKICAgICgiQWxwaGEgVW5pdmVyc2l0eSIsICJUb3Atbm90Y2ggcmVzZWFyY2ggZmFjaWxpdGllcy4iLCA0LjgpLApdCgpkZWYgaW5pdF9kYigpOgogICAgIyBDb25uZWN0IHRvIFNRTGl0ZSBkYXRhYmFzZSAoY3JlYXRlcyBjb2xsZWdlLmRiIGlmIGl0IGRvZXNuJ3QgZXhpc3QpCiAgICBjb25uID0gc3FsaXRlMy5jb25uZWN0KCJjb2xsZWdlLmRiIikKICAgIGN1cnNvciA9IGNvbm4uY3Vyc29yKCkKCiAgICAjIENyZWF0ZSBjb2xsZWdlcyB0YWJsZQogICAgY3Vyc29yLmV4ZWN1dGUoIiIiCiAgICAgICAgQ1JFQVRFIFRBQkxFIElGIE5PVCBFWElTVFMgY29sbGVnZXMgKAogICAgICAgICAgICBuYW1lIFRFWFQgTk9UIE5VTEwsCiAgICAgICAgICAgIHN0YXRlIFRFWFQgTk9UIE5VTEwsCiAgICAgICAgICAgIGxvY2F0aW9uIFRFWFQgTk9UIE5VTEwsCiAgICAgICAgICAgIGNvdXJzZV9sZXZlbCBURVhUIE5PVCBOVUxMLAogICAgICAgICAgICBjdXRvZmYgUkVBTCBOT1QgTlVMTCwKICAgICAgICAgICAgZmVlcyBSRUFMIE5PVCBOVUxMCiAgICAgICAgKQogICAgIiIiKQoKICAgICMgQ3JlYXRlIHJldmlld3MgdGFibGUKICAgIGN1cnNvci5leGVjdXRlKCIiIgogICAgICAgIENSRUFURSBUQUJMRSBJRiBOT1QgRVhJU1RTIHJldmlld3MgKAogICAgICAgICAgICBpZCBJTlRFR0VSIFBSSU1BUlkgS0VZIEFVVE9JTkNSRU1FTlQsCiAgICAgICAgICAgIGNvbGxlZ2VfbmFtZSBURVhUIE5PVCBOVUxMLAogICAgICAgICAgICByZXZpZXdfdGV4dCBURVhUIE5PVCBOVUxMLAogICAgICAgICAgICByYXRpbmcgUkVBTCBOT1QgTlVMTCwKICAgICAgICAgICAgRk9SRUlHTiBLRVkgKGNvbGxlZ2VfbmFtZSkgUkVGRVJFTkNFUyBjb2xsZWdlcyhuYW1lKQogICAgICAgICkKICAgICIiIikKCiAgICAjIEluc2VydCBjb2xsZWdlIGRhdGEKICAgIGN1cnNvci5leGVjdXRlbWFueSgiIiIKICAgICAgICBJTlNFUlQgT1IgUkVQTEFDRSBJTlRPIGNvbGxlZ2VzIChuYW1lLCBzdGF0ZSwgbG9jYXRpb24sIGNvdXJzZV9sZXZlbCwgY3V0b2ZmLCBmZWVzKQogICAgICAgIFZBTFVFUyAoPywgPywgPywgPywgPywgPykKICAgICIiIiwgY29sbGVnZV9kYXRhKQoKICAgICMgSW5zZXJ0IHJldmlldyBkYXRhCiAgICBjdXJzb3IuZXhlY3V0ZW1hbnkoIiIiCiAgICAgICAgSU5TRVJUIE9SIFJFUExBQ0UgSU5UTyByZXZpZXdzIChjb2xsZWdlX25hbWUsIHJldmlld190ZXh0LCByYXRpbmcpCiAgICAgICAgVkFMVUVTICg/LCA/LCA/KQogICAgIiIiLCByZXZpZXdfZGF0YSkKCiAgICAjIENvbW1pdCBhbmQgY2xvc2UKICAgIGNvbm4uY29tbWl0KCkKICAgIGNvbm4uY2xvc2UoKQogICAgcHJpbnQoIkRhdGFiYXNlIGluaXRpYWxpemVkIHN1Y2Nlc3NmdWxseS4iKQoKaWYgX19uYW1lX18gPT0gIl9fbWFpbl9fIjoKICAgIGluaXRfZGIoKQ==