Hi, I have two database tables like this 1) libraries = (

Question

Hi, I have two database tables like this 1) libraries = (

id , name )
2) library_library = ( library_id , required_library_id )

libraries = a list of javascript libraries

library_library = a pivot table for keeping library dependencies

my question is how do I can get nested (recursive) dependencies for a library ?

( library 1 => 5 , 5 => 8 , ... )

0

30.04.2021

7 ответов

3 просмотра

Masoud Автор вопроса

drunktimelord
func dependency_tree(library) deps = [] di...

thanks , but I mean in database level (sql query) 😊

0

30.04.2021

drunktimelord

Masoud
thanks , but I mean in database level (sql query) ...

damn is that even possible

0

30.04.2021

Masoud Автор вопроса

drunktimelord
damn is that even possible

merging what you said with sql query is also possible 🤔 but eventually I need sql query for that and thats my problem

0

30.04.2021

🇺🇦 Anton

drunktimelord
damn is that even possible

It depends on the db you are using. Some of them have recursive queries (e.g. PostgreSQL)

0

30.04.2021

Masoud Автор вопроса

drunktimelord
damn is that even possible

WITH library_deps AS ( select required_library_id, 1 as depth from library_library where library_id = 35 and dependency_type = 'preloaded' UNION ALL select library_library.required_library_id, library_deps.depth + 1 from library_deps join library_library on library_deps.required_library_id = library_library.library_id ) ------------------ only need distinct----------------- SELECT required_library_id as library_id FROM library_deps order by depth desc

0

05.05.2021

drunktimelord

Masoud
WITH library_deps AS ( select required_library...

epic

0

05.05.2021

drunktimelord · Accepted Answer

drunktimelord

func dependency_tree(library) deps = [] direct_deps = query_deps(library) for dep in direct_deps: deps = append(deps, {lib: library, deps: dependency_tree(dep)}) return deps

0

30.04.2021

Похожие чаты

Hi, I have two database tables like this 1) libraries = (

7 ответов

Похожие вопросы