expect_info_ramdisk.out

smp = 1
build_mode = release
log_level = info

Primary CPU 0 started,
Found physcial memory regions:
 .text (READ | EXECUTE | RESERVED)
 .rodata (READ | RESERVED)
 .data .tdata .tbss .percpu (READ | WRITE | RESERVED)
 .percpu (READ | WRITE | RESERVED)
 boot stack (READ | WRITE | RESERVED)
 .bss (READ | WRITE | RESERVED)
 free memory (READ | WRITE | FREE)
Initialize global memory allocator...
Initialize kernel page table...
Initialize platform devices...
Initialize device drivers...
device model: static
registered a new Block device: "ramdisk"
Initialize filesystems...
  use block device 0: "ramdisk"
Primary CPU 0 init OK.
sqlite version: 3.41.1
sqlite open memory status 0
======== init user table ========
sqlite exec:
    create table user(id INTEGER PRIMARY KEY AUTOINCREMENT,username TEXT,password TEXT)
======== insert user 1, 2, 3 into user table ========
sqlite exec:
    insert into user (username, password) VALUES ('memory_1', 'password1'), ('memory_2', 'password2'), ('memory_3', 'password3')
======== select all ========
sqlite query:
    select \* from user
id = 1
username = memory_1
password = password1

id = 2
username = memory_2
password = password2

id = 3
username = memory_3
password = password3

======== select id = 2 ========
sqlite query:
    select \* from user where id = 2
id = 2
username = memory_2
password = password2

sqlite open /file.sqlite status 0
======== init user table ========
sqlite exec:
    create table user(id INTEGER PRIMARY KEY AUTOINCREMENT,username TEXT,password TEXT)
======== insert user 1, 2, 3 into user table ========
sqlite exec:
    insert into user (username, password) VALUES ('file_1', 'password1'), ('file_2', 'password2'), ('file_3', 'password3')
======== select all ========
sqlite query:
    select \* from user
id = 1
username = file_1
password = password1

id = 2
username = file_2
password = password2

id = 3
username = file_3
password = password3

======== select id = 2 ========
sqlite query:
    select \* from user where id = 2
id = 2
username = file_2
password = password2
Shutting down...