TASK: Create an SQLite schema for a library system (books, authors), insert 5 sample records, and generate a SQL dump to 'db_migration.sql'.
----------------------------------------
Loading...
                          
  [1;34m┌─── Python Source Code ─────────────────────────────────────[0m
  [1;34m│[0m [2m  1 |[0m [34mimport[0m[33m sqlite3[0m
  [1;34m│[0m [2m  2 |[0m # Connect to an in-memory database[0m
  [1;34m│[0m [2m  3 |[0m conn = sqlite3.connect(':memory:')[0m
  [1;34m│[0m [2m  4 |[0m cur = conn.cursor()[0m
  [1;34m│[0m [2m  5 |[0m # Create schema [34mfor[0m[33m library system[0m
  [1;34m│[0m [2m  6 |[0m schema = '''[0m
  [1;34m│[0m [2m  7 |[0m CREATE TABLE authors ([0m
  [1;34m│[0m [2m  8 |[0m     id INTEGER PRIMARY KEY AUTOINCREMENT,[0m
  [1;34m│[0m [2m  9 |[0m     name TEXT NOT NULL[0m
  [1;34m│[0m [2m 10 |[0m );[0m
  [1;34m│[0m [2m 11 |[0m CREATE TABLE books ([0m
  [1;34m│[0m [2m 12 |[0m     id INTEGER PRIMARY KEY AUTOINCREMENT,[0m
  [1;34m│[0m [2m 13 |[0m     title TEXT NOT NULL,[0m
  [1;34m│[0m [2m 14 |[0m     author_id INTEGER,[0m
  [1;34m│[0m [2m 15 |[0m     FOREIGN KEY(author_id) REFERENCES authors(id)[0m
  [1;34m│[0m [2m 16 |[0m );[0m
  [1;34m│[0m [2m 17 |[0m '''[0m
  [1;34m│[0m [2m 18 |[0m cur.executescript(schema)[0m
  [1;34m│[0m [2m 19 |[0m # Insert sample records[0m
  [1;34m│[0m [2m 20 |[0m authors = [('Jane Austen',), ('Mark Twain',), ('J.K. Rowling',), ('George Orwell',), ('Leo Tolstoy',)][0m
  [1;34m│[0m [2m 21 |[0m cur.executemany('INSERT INTO authors (name) VALUES (?)', authors)[0m
  [1;34m│[0m [2m 22 |[0m books = [[0m
  [1;34m│[0m [2m 23 |[0m     ('Pride and Prejudice', [36m1[0m[33m),[0m
  [1;34m│[0m [2m 24 |[0m     ('Adventures of Huckleberry Finn', [36m2[0m[33m),[0m
  [1;34m│[0m [2m 25 |[0m     ('Harry Potter and the Sorcerer\'s Stone', [36m3[0m[33m),[0m
  [1;34m│[0m [2m 26 |[0m     ('[36m1984[0m[33m', [36m4[0m[33m),[0m
  [1;34m│[0m [2m 27 |[0m     ('War and Peace', [36m5[0m[33m),[0m
  [1;34m│[0m [2m 28 |[0m ][0m
  [1;34m│[0m [2m 29 |[0m cur.executemany('INSERT INTO books (title, author_id) VALUES (?, ?)', books)[0m
  [1;34m│[0m [2m 30 |[0m # Generate SQL dump[0m
  [1;34m│[0m [2m 31 |[0m dump = ""[0m
  [1;34m│[0m [2m 32 |[0m [34mfor[0m[33m line in conn.iterdump():[0m
  [1;34m│[0m [2m 33 |[0m     dump += line + "\n"[0m
  [1;34m│[0m [2m 34 |[0m # Save dump to file[0m
  [1;34m│[0m [2m 35 |[0m [34mwith[0m[33m open('db_migration.sql', 'w') [34mas[0m[33m f:[0m
  [1;34m│[0m [2m 36 |[0m     f.write(dump)[0m
  [1;34m│[0m [2m 37 |[0m conn.close()[0m
  [1;34m└────────────────────────────────────────────────────────────[0m
The SQLite schema for the library system has been created, five sample records have been inserted, and a SQL dump has been generated and saved to 'db_migration.sql'. If you need to review the dump or perform further operations, please let me know!
