Skip to content

Instantly share code, notes, and snippets.

@aubreyrjones

aubreyrjones/sqlite migration group by

Created February 18, 2019 16:30
Show Gist options
  • Save aubreyrjones/cb7377276deb3ed7818fa12e900e6b10 to your computer and use it in GitHub Desktop.
Save aubreyrjones/cb7377276deb3ed7818fa12e900e6b10 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
sqlite migration group by
sqlite> select * from layer_groups_annotation_layers;
1|layer_group_01|anno_layer_01
2|layer_group_01|anno_layer_02
3|layer_group_02|anno_layer_03
4|layer_group_03|anno_layer_04
5|layer_group_01|anno_layer_04
sqlite> select layerName, 'imageLayer', groupName from layer_groups_annotation_layers group by layerName;
anno_layer_01|imageLayer|layer_group_01
anno_layer_02|imageLayer|layer_group_01
anno_layer_03|imageLayer|layer_group_02
anno_layer_04|imageLayer|layer_group_01
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment