Skip to content

Mongo Database Schema

Ana Guerrero Lopez edited this page Jul 19, 2018 · 2 revisions

The backend creates a kernel-ci dabatase. The schema of the database is listed below, the schema has been created with https://github.com/pajachiet/pymongo-schema following these steps in the system that's serving the backend:

# pip install --upgrade https://github.com/pajachiet/pymongo-schema/archive/master.zip
# python -m pymongo_schema extract --database kernel-ci --format md --columns Field_compact_name Field_name 

Schema of kernel-ci

Database: kernel-ci

Collection: api-token

Field_compact_name Field_name
_id _id
created_on created_on
email email
expired expired
expires_on expires_on
ip_address ip_address
properties properties
token token
username username
version version

Collection: bisect

Field_compact_name Field_name
_id _id
arch arch
bad_commit bad_commit
bad_commit_date bad_commit_date
bad_commit_url bad_commit_url
bad_summary bad_summary
bisect_data bisect_data
: _id _id
: arch arch
: board board
: board_instance board_instance
: boot_job_id boot_job_id
: boot_job_path boot_job_path
: boot_job_url boot_job_url
: boot_log boot_log
: boot_log_html boot_log_html
: boot_result_description boot_result_description
: bootloader bootloader
: bootloader_version bootloader_version
: build_id build_id
: chainloader chainloader
: compiler compiler
: compiler_version compiler_version
: compiler_version_ext compiler_version_ext
: compiler_version_full compiler_version_full
: created_on created_on
: cross_compile cross_compile
: defconfig defconfig
: defconfig_full defconfig_full
: dtb dtb
: dtb_addr dtb_addr
: dtb_append dtb_append
: endian endian
: fastboot fastboot
: fastboot_cmd fastboot_cmd
: file_server_resource file_server_resource
: file_server_url file_server_url
: filesystem filesystem
: git_branch git_branch
: git_commit git_commit
: git_describe git_describe
: git_url git_url
: initrd initrd
: initrd_addr initrd_addr
: job job
: job_id job_id
: kernel kernel
: kernel_image kernel_image
: kernel_image_size kernel_image_size
: lab_name lab_name
: load_addr load_addr
: mach mach
: metadata metadata
: qemu qemu
: qemu_command qemu_command
: retries retries
: status status
: time time
: uimage uimage
: uimage_addr uimage_addr
: version version
: warnings warnings
: device_type device_type
board board
boot_id boot_id
build_id build_id
checks checks
compare_to compare_to
compiler compiler
created_on created_on
defconfig defconfig
defconfig_full defconfig_full
device_type device_type
found_summary found_summary
git_branch git_branch
git_url git_url
good_commit good_commit
good_commit_date good_commit_date
good_commit_url good_commit_url
good_summary good_summary
job job
job_id job_id
kernel kernel
lab_name lab_name
log log
type type
version version

Collection: boot

Field_compact_name Field_name
_id _id
arch arch
board board
board_instance board_instance
boot_job_id boot_job_id
boot_job_path boot_job_path
boot_job_url boot_job_url
boot_log boot_log
boot_log_html boot_log_html
boot_result_description boot_result_description
bootloader bootloader
bootloader_version bootloader_version
build_id build_id
chainloader chainloader
compiler compiler
compiler_version compiler_version
compiler_version_ext compiler_version_ext
compiler_version_full compiler_version_full
created_on created_on
cross_compile cross_compile
defconfig defconfig
defconfig_full defconfig_full
dtb dtb
dtb_addr dtb_addr
dtb_append dtb_append
endian endian
fastboot fastboot
fastboot_cmd fastboot_cmd
file_server_resource file_server_resource
file_server_url file_server_url
filesystem filesystem
git_branch git_branch
git_commit git_commit
git_describe git_describe
git_url git_url
initrd initrd
initrd_addr initrd_addr
job job
job_id job_id
kernel kernel
kernel_image kernel_image
kernel_image_size kernel_image_size
lab_name lab_name
load_addr load_addr
mach mach
metadata metadata
qemu qemu
qemu_command qemu_command
retries retries
status status
time time
uimage uimage
uimage_addr uimage_addr
version version
warnings warnings
device_type device_type

Collection: boot_regressions

Field_compact_name Field_name
_id _id
created_on created_on
git_branch git_branch
job job
job_id job_id
kernel kernel
regressions regressions
...
(Omitted)

Collection: boot_regressions_by_boot_id

Field_compact_name Field_name
_id _id
boot_id boot_id
boot_regressions_id boot_regressions_id
created_on created_on

Collection: build

Field_compact_name Field_name
_id _id
arch arch
build_log build_log
build_log_size build_log_size
build_platform build_platform
build_time build_time
build_type build_type
compiler compiler
compiler_version compiler_version
compiler_version_ext compiler_version_ext
compiler_version_full compiler_version_full
created_on created_on
cross_compile cross_compile
defconfig defconfig
defconfig_full defconfig_full
dirname dirname
dtb_dir dtb_dir
dtb_dir_data dtb_dir_data
errors errors
file_server_resource file_server_resource
file_server_url file_server_url
git_branch git_branch
git_commit git_commit
git_describe git_describe
git_describe_v git_describe_v
git_url git_url
job job
job_id job_id
kconfig_fragments kconfig_fragments
kernel kernel
kernel_config kernel_config
kernel_config_size kernel_config_size
kernel_image kernel_image
kernel_image_size kernel_image_size
kernel_version kernel_version
metadata metadata
modules modules
modules_dir modules_dir
modules_size modules_size
status status
system_map system_map
system_map_size system_map_size
text_offset text_offset
version version
vmlinux_bss_size vmlinux_bss_size
vmlinux_data_size vmlinux_data_size
vmlinux_file_size vmlinux_file_size
vmlinux_text_size vmlinux_text_size
warnings warnings
mismatches mismatches

Collection: daily_stats

Field_compact_name Field_name
_id _id
biweekly_total_boots biweekly_total_boots
biweekly_total_builds biweekly_total_builds
biweekly_total_jobs biweekly_total_jobs
biweekly_unique_archs biweekly_unique_archs
biweekly_unique_boards biweekly_unique_boards
biweekly_unique_defconfigs biweekly_unique_defconfigs
biweekly_unique_kernels biweekly_unique_kernels
biweekly_unique_machs biweekly_unique_machs
biweekly_unique_trees biweekly_unique_trees
created_on created_on
daily_total_boots daily_total_boots
daily_total_builds daily_total_builds
daily_total_jobs daily_total_jobs
daily_unique_archs daily_unique_archs
daily_unique_boards daily_unique_boards
daily_unique_defconfigs daily_unique_defconfigs
daily_unique_kernels daily_unique_kernels
daily_unique_machs daily_unique_machs
daily_unique_trees daily_unique_trees
start_date start_date
total_boots total_boots
total_builds total_builds
total_jobs total_jobs
total_unique_archs total_unique_archs
total_unique_boards total_unique_boards
total_unique_defconfigs total_unique_defconfigs
total_unique_kernels total_unique_kernels
total_unique_machs total_unique_machs
total_unique_trees total_unique_trees
version version
weekly_total_boots weekly_total_boots
weekly_total_builds weekly_total_builds
weekly_total_jobs weekly_total_jobs
weekly_unique_archs weekly_unique_archs
weekly_unique_boards weekly_unique_boards
weekly_unique_defconfigs weekly_unique_defconfigs
weekly_unique_kernels weekly_unique_kernels
weekly_unique_machs weekly_unique_machs
weekly_unique_trees weekly_unique_trees

Collection: error_logs

Field_compact_name Field_name
_id _id
arch arch
build_id build_id
compiler compiler
compiler_version compiler_version
compiler_version_ext compiler_version_ext
compiler_version_full compiler_version_full
created_on created_on
defconfig defconfig
defconfig_full defconfig_full
errors errors
errors_count errors_count
file_server_resource file_server_resource
file_server_url file_server_url
job job
job_id job_id
kernel kernel
mismatches mismatches
mismatches_count mismatches_count
status status
version version
warnings warnings
warnings_count warnings_count
git_branch git_branch

Collection: errors_summary

Field_compact_name Field_name
_id _id
created_on created_on
errors errors
job job
job_id job_id
kernel kernel
mismatches mismatches
version version
warnings warnings
git_branch git_branch

Collection: job

Field_compact_name Field_name
_id _id
compiler compiler
compiler_version compiler_version
compiler_version_ext compiler_version_ext
compiler_version_full compiler_version_full
created_on created_on
cross_compile cross_compile
git_branch git_branch
git_commit git_commit
git_describe git_describe
git_describe_v git_describe_v
git_url git_url
job job
kernel kernel
kernel_version kernel_version
private private
status status
version version

Collection: job_delta

Field_compact_name Field_name
_id _id
compare_to compare_to
data data
: baseline baseline
: . build_counts build_counts
: . created_on created_on
: . git_branch git_branch
: . git_commit git_commit
: . git_describe git_describe
: . git_url git_url
: . job job
: . job_id job_id
: . kernel kernel
: . total_builds total_builds
: compare_to compare_to
: : build_counts build_counts
: : created_on created_on
: : git_branch git_branch
: : git_commit git_commit
: : git_describe git_describe
: : git_url git_url
: : job job
: : job_id job_id
: : kernel kernel
: : total_builds total_builds
: delta_result delta_result
job job
kernel kernel

Collection: lab

Field_compact_name Field_name
_id _id
address address
contact contact
. email email
. name name
. surname surname
created_on created_on
name name
private private
token token
updated_on updated_on
version version

Collection: report

Field_compact_name Field_name
_id _id
created_on created_on
errors errors
git_branch git_branch
job job
kernel kernel
name name
status status
type type
updated_on updated_on
version version

Collection: test_case

Field_compact_name Field_name
_id _id
attachments attachments
created_on created_on
definition_uri definition_uri
kvm_guest kvm_guest
maximum maximum
measurements measurements
: unit unit
: value value
metadata metadata
minimum minimum
name name
parameters parameters
samples samples
samples_sqr_sum samples_sqr_sum
samples_sum samples_sum
status status
test_set_id test_set_id
test_suite_id test_suite_id
test_suite_name test_suite_name
time time
vcs_commit vcs_commit
version version

Collection: test_set

Field_compact_name Field_name
_id _id
created_on created_on
defects defects
definition_uri definition_uri
metadata metadata
name name
parameters parameters
test_case test_case
test_job_id test_job_id
test_job_path test_job_path
test_job_url test_job_url
test_suite_id test_suite_id
test_suite_name test_suite_name
time time
vcs_commit vcs_commit
version version

Collection: test_suite

Field_compact_name Field_name
_id _id
arch arch
board board
board_instance board_instance
build_id build_id
created_on created_on
defconfig defconfig
defconfig_full defconfig_full
definition_uri definition_uri
git_branch git_branch
job job
job_id job_id
kernel kernel
lab_name lab_name
metadata metadata
name name
test_case test_case
test_set test_set
time time
vcs_commit vcs_commit
version version
boot_log boot_log
boot_log_html boot_log_html
boot_result_description boot_result_description
compiler compiler
compiler_version compiler_version
compiler_version_full compiler_version_full
cross_compile cross_compile
device_type device_type
dtb dtb
dtb_addr dtb_addr
endian endian
file_server_resource file_server_resource
file_server_url file_server_url
git_commit git_commit
git_describe git_describe
git_url git_url
initrd_addr initrd_addr
kernel_image kernel_image
kernel_image_size kernel_image_size
load_addr load_addr
mach mach
qemu qemu
qemu_command qemu_command
retries retries
warnings warnings
boot_id boot_id
You can’t perform that action at this time.