Created
April 20, 2019 21:04
-
-
Save BenPoling/eb77bdebed482931031f4d982e18b17d to your computer and use it in GitHub Desktop.
DB Query samples
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
POSTGRESQL | |
SDC=# SELECT * FROM restaurants WHERE id=10000000; | |
-[ RECORD 1 ]------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ | |
id | 10000000 | |
name | plug-and-play incremental | |
date | 3/1/2019 | |
photoobj | [{images_array:[{image_id:1,image_url:https://s3-us-west-2.amazonaws.com/sdc-restaurant-photos/img5.jpg,description:Lorem ipsum dolor sit amet, elit enim blandit eget eu mi amet, cum vestibulum autem sapien risus vivamus, fringilla purus in.,taken_by:Beth},{image_id:102,image_url:https://s3-us-west-2.amazonaws.com/sdc-restaurant-photos/img15.jpg,description:Lorem ipsum dolor sit amet, elit enim blandit eget eu mi amet, cum vestibulum autem sapien risus vivamus, fringilla purus in.,taken_by:Beth},{image_id:203,image_url:https://s3-us-west-2.amazonaws.com/sdc-restaurant-photos/img18.jpg,description:Lorem ipsum dolor sit amet, elit enim blandit eget eu mi amet, cum vestibulum autem sapien risus vivamus, fringilla purus in.,taken_by:Beth},{image_id:304,image_url:https://s3-us-west-2.amazonaws.com/sdc-restaurant-photos/img24.jpg,description:Lorem ipsum dolor sit amet, elit enim blandit eget eu mi amet, cum vestibulum autem sapien risus vivamus, fringilla purus in.,taken_by:Beth},{image_id:405,image_url:https://s3-us-west-2.amazonaws.com/sdc-restaurant-photos/img27.jpg,description:Lorem ipsum dolor sit amet, elit enim blandit eget eu mi amet, cum vestibulum autem sapien risus vivamus, fringilla purus in.,taken_by:Beth},{image_id:506,image_url:https://s3-us-west-2.amazonaws.com/sdc-restaurant-photos/img16.jpg,description:Lorem ipsum dolor sit amet, elit enim blandit eget eu mi amet, cum vestibulum autem sapien risus vivamus, fringilla purus in.,taken_by:Beth},{image_id:607,image_url:https://s3-us-west-2.amazonaws.com/sdc-restaurant-photos/img29.jpg,description:Lorem ipsum dolor sit amet, elit enim blandit eget eu mi amet, cum vestibulum autem sapien risus vivamus, fringilla purus in.,taken_by:Beth},{image_id:708,image_url:https://s3-us-west-2.amazonaws.com/sdc-restaurant-photos/img33.jpg,description:Lorem ipsum dolor sit amet, elit enim blandit eget eu mi amet, cum vestibulum autem sapien risus vivamus, fringilla purus in.,taken_by:Beth},{image_id:809,image_url:https://s3-us-west-2.amazonaws.com/sdc-restaurant-photos/img4.jpg,description:Lorem ipsum dolor sit amet, elit enim blandit eget eu mi amet, cum vestibulum autem sapien risus vivamus, fringilla purus in.,taken_by:Beth}]}] | |
SDC=# DELETE FROM restaurants WHERE id=10000000; | |
DELETE 1 | |
CASSANDRA | |
cassandra@cqlsh:sdc> SELECT * FROM restaurants WHERE id=1000; | |
id | date | name | photoobj | |
------+----------+-----------------------------+-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | |
1000 | 3/4/2019 | cross-platform Chief Alaska | [{"images_array":[{"image_id":1,"image_url":"https://s3-us-west-2.amazonaws.com/sdc-restaurant-photos/img13.jpg","description":"Lorem ipsum dolor sit amet, elit enim blandit eget eu mi amet, cum vestibulum autem sapien risus vivamus, fringilla purus in.","taken_by":"Beth"},{"image_id":102,"image_url":"https://s3-us-west-2.amazonaws.com/sdc-restaurant-photos/img15.jpg","description":"Lorem ipsum dolor sit amet, elit enim blandit eget eu mi amet, cum vestibulum autem sapien risus vivamus, fringilla purus in.","taken_by":"Beth"},{"image_id":203,"image_url":"https://s3-us-west-2.amazonaws.com/sdc-restaurant-photos/img10.jpg","description":"Lorem ipsum dolor sit amet, elit enim blandit eget eu mi amet, cum vestibulum autem sapien risus vivamus, fringilla purus in.","taken_by":"Beth"},{"image_id":304,"image_url":"https://s3-us-west-2.amazonaws.com/sdc-restaurant-photos/img36.jpg","description":"Lorem ipsum dolor sit amet, elit enim blandit eget eu mi amet, cum vestibulum autem sapien risus vivamus, fringilla purus in.","taken_by":"Beth"},{"image_id":405,"image_url":"https://s3-us-west-2.amazonaws.com/sdc-restaurant-photos/img14.jpg","description":"Lorem ipsum dolor sit amet, elit enim blandit eget eu mi amet, cum vestibulum autem sapien risus vivamus, fringilla purus in.","taken_by":"Beth"}]}] | |
cassandra@cqlsh:sdc> INSERT INTO SDC.restaurants (id,date,name,photoobj) VALUES (10000010,'12/2/2019','BEN','[{"images_array":[{"image_id":1,"image_url":"https://s3-us-west-2.amazonaws.com/sdc-restaurant-photos/img14.jpg","description":"Lorem ipsum dolor sit amet, elit enim blandit eget eu mi amet, cum vestibulum autem sapien risus vivamus, fringilla purus in.","taken_by":"Beth"},{"image_id":102,"image_url":"https://s3-us-west-2.amazonaws.com/sdc-restaurant-photos/img25.jpg","description":"Lorem ipsum dolor sit amet, elit enim blandit eget eu mi amet, cum vestibulum autem sapien risus vivamus, fringilla purus in.","taken_by":"Beth"},{"image_id":203,"image_url":"https://s3-us-west-2.amazonaws.com/sdc-restaurant-photos/img18.jpg","description":"Lorem ipsum dolor sit amet, elit enim blandit eget eu mi amet, cum vestibulum autem sapien risus vivamus, fringilla purus in.","taken_by":"Beth"},{"image_id":304,"image_url":"https://s3-us-west-2.amazonaws.com/sdc-restaurant-photos/img7.jpg","description":"Lorem ipsum dolor sit amet, elit enim blandit eget eu mi amet, cum vestibulum autem sapien risus vivamus, fringilla purus in.","taken_by":"Beth"},{"image_id":405,"image_url":"https://s3-us-west-2.amazonaws.com/sdc-restaurant-photos/img3.jpg","description":"Lorem ipsum dolor sit amet, elit enim blandit eget eu mi amet, cum vestibulum autem sapien risus vivamus, fringilla purus in.","taken_by":"Beth"},{"image_id":506,"image_url":"https://s3-us-west-2.amazonaws.com/sdc-restaurant-photos/img15.jpg","description":"Lorem ipsum dolor sit amet, elit enim blandit eget eu mi amet, cum vestibulum autem sapien risus vivamus, fringilla purus in.","taken_by":"Beth"}]}]'); | |
cassandra@cqlsh:sdc> SELECT * FROM restaurants WHERE id=10000010; | |
id | date | name | photoobj | |
----------+-----------+------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ | |
10000010 | 12/2/2019 | BEN | [{"images_array":[{"image_id":1,"image_url":"https://s3-us-west-2.amazonaws.com/sdc-restaurant-photos/img14.jpg","description":"Lorem ipsum dolor sit amet, elit enim blandit eget eu mi amet, cum vestibulum autem sapien risus vivamus, fringilla purus in.","taken_by":"Beth"},{"image_id":102,"image_url":"https://s3-us-west-2.amazonaws.com/sdc-restaurant-photos/img25.jpg","description":"Lorem ipsum dolor sit amet, elit enim blandit eget eu mi amet, cum vestibulum autem sapien risus vivamus, fringilla purus in.","taken_by":"Beth"},{"image_id":203,"image_url":"https://s3-us-west-2.amazonaws.com/sdc-restaurant-photos/img18.jpg","description":"Lorem ipsum dolor sit amet, elit enim blandit eget eu mi amet, cum vestibulum autem sapien risus vivamus, fringilla purus in.","taken_by":"Beth"},{"image_id":304,"image_url":"https://s3-us-west-2.amazonaws.com/sdc-restaurant-photos/img7.jpg","description":"Lorem ipsum dolor sit amet, elit enim blandit eget eu mi amet, cum vestibulum autem sapien risus vivamus, fringilla purus in.","taken_by":"Beth"},{"image_id":405,"image_url":"https://s3-us-west-2.amazonaws.com/sdc-restaurant-photos/img3.jpg","description":"Lorem ipsum dolor sit amet, elit enim blandit eget eu mi amet, cum vestibulum autem sapien risus vivamus, fringilla purus in.","taken_by":"Beth"},{"image_id":506,"image_url":"https://s3-us-west-2.amazonaws.com/sdc-restaurant-photos/img15.jpg","description":"Lorem ipsum dolor sit amet, elit enim blandit eget eu mi amet, cum vestibulum autem sapien risus vivamus, fringilla purus in.","taken_by":"Beth"}]}] | |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment