https://www.jianshu.com/nb/36265841
Schedule site https://15445.courses.cs.cmu.edu/fall2018/schedule.html
Study blog for cmu 15 445 https://www.jianshu.com/nb/36265841
cmu_15445_2017.rar
is the project origin source file.
cmu_15445_2017_done.rar
is the project solution(including 4 projects). make sure pass all the tests including (tuple.test,vtable.test...)
My Solution make sure cover as most test cases as possible.
project 1 14 tests
project 2 ~30 tests
project 3 20 tests
project 4 9 tests And pass at least 1000 times for project 2&3&4
make check
16/16 Test #16: virtual_table_test ............... Passed 0.72 sec
100% tests passed, 0 tests failed out of 16
Total Test time (real) = 38.21 sec
[100%] Built target check
Every student has to work individually on this assignment. Students are allowed to discuss high-level details about the project with others. Students are not allowed to copy the contents of a white-board after a group meeting with other students. Students are not allowed to copy the solutions from another colleague.
mkdir build
cd build
cmake ..
make
Debug mode:
cmake -DCMAKE_BUILD_TYPE=Debug ..
make
cd build
//make sure u setup libvtable.so
vim /etc/ld.so.conf
//add one line for /where/you/install/lib
sudo ldconfig
make check
Start SQLite with:
cd build
./bin/sqlite3
In SQLite, load virtual table extension with:
.load ./lib/libvtable.dylib
or load libvtable.so
(Linux), libvtable.dll
(Windows)
Create virtual table:
1.The first input parameter defines the virtual table schema. Please follow the format of (column_name [space] column_type) seperated by comma. We only support basic data types including INTEGER, BIGINT, SMALLINT, BOOLEAN, DECIMAL and VARCHAR.
2.The second parameter define the index schema. Please follow the format of (index_name [space] indexed_column_names) seperated by comma.
sqlite> CREATE VIRTUAL TABLE foo USING vtable('a int, b varchar(13)','foo_pk a')
After creating virtual table:
Type in any sql statements as you want.
sqlite> INSERT INTO foo values(1,'hello');
sqlite> SELECT * FROM foo ORDER BY a;
a b
---------- ----------
1 hello
See Run-Time Loadable Extensions and CREATE VIRTUAL TABLE for further information.