/
hipravin
/
devcompanion
Обзор
Документация
Войти
/
hipravin
/
devcompanion
Код
Запросы
0
Задачи
Вики
Пакеты
0
Релизы
0
Аналитика
Безопасность
main
development/devcompanion-sample-queries.sql
79 строк
1 KB
Alex
restructure folders, add sample http and sql queries for development
18 янв 2023, 20:48
18 янв 2023, 20:48
45292cc
Код
Авторство
О чём код?
SET search_path to devcompanion; select r.*, f.* from repo_file f join repo r on f.repo_id = r.id where f.id in (22226, 17963); select * from flyway_schema_history; select count(*) from repo_file; delete from repo where relative_path like '%\\%'; select * from repo_file where content ilike '%Suppose we require the user ID of the file owner on a system that%'; select r.*, rf.* from repo_file rf inner join repo r on r.id = rf.repo_id where content ilike '%BigDecimal%'; explain analyze select count(*) from repo_file; explain analyze select count(null) from repo_file; explain analyze select count(1) from repo_file; select count(*) from repo_file where content like '%%' and content like '%%'; explain analyze select * from repo_file where content like '%BigDecimal%'; explain analyze select * from repo_file where content ilike '%BigDecimal%'; select count(*) from repo_file where content ilike '%BigDecimal%'; explain select * from repo_file where name = 'i'; select * from repo; delete from repo; select distinct name from repo_file; select * from repo_file where content ilike 'Dockerfile';