wp-cli post create & media import issues

So I just ended up doing a query on the database for the link of the image:

wp db query “SELECT guid FROM wp_posts WHERE ID=’ID_FROM_MEDIA_IMPORT'” –silent –skip-column-names

I wrote this bash script for the whole process:

post-create.sh PATH_TO_IMAGE.FILETYPE “TITLE”

imageID=$(wp media import $1 --porcelain)
imageLINK=$(wp db query "SELECT guid FROM wp_posts WHERE ID='$imageID'" --silent --skip-column-names)
wp post create --post_title="$2" --post_status=publish --post_content="<a href=""$imageLINK""><img class=""size-full"" src=""$imageLINK"" /></a>"

Related Posts:

  1. Customizing individual images on posts
  2. Replace image attributes for lazyload plugin (data-src)
  3. How do I detach images from posts?
  4. Unattaching images from a post
  5. How to wrap every image in a post with a div?
  6. upload featured image from front end using wordpress add media button
  7. Retrieving and Storing Images Linked from Other Domains on Local Server?
  8. how to replace embedded “full” sized images within a post with the “large” ones
  9. Errors when uploading images in WP 3.5
  10. Remove Featured Image & All Media Uploaded to the Post
  11. How to allow multiple thumbnail upload for Posts?
  12. How to get all inline images in post content? [duplicate]
  13. Inserting Media to WordPress Posts
  14. Site/Post preview is not working on all social media
  15. unable to write to the database while uploading images
  16. Modified core/image rendering not showing in posts – only on pages
  17. Post images are not displayed in media library
  18. WordPress Media URLs?
  19. How would I attach media/images to a post based on a ID stored in a each post’s custom field
  20. Broken images after importing posts and opening in Gutenberg
  21. Optimize blog that serves hundred of images and videos
  22. How to display by default only published posts/pages in the admin area?
  23. Post/Page Preview Template
  24. using wp_update_post on save_post
  25. Post slugs and images cannot have same name?
  26. WordPress plugin to publish to multiple remote WordPress blogs
  27. Is there a plugin to make attaching images easier?
  28. Any way to create a revision of a post ONLY with a new button in the Meta Box?
  29. Download external images if post is publish
  30. Can I load posts via Ajax?
  31. Show One Category on Post
  32. how to grab first link in post… and of course call it
  33. WordPress Delete hook with wp_delete_post function?
  34. Order post by year DESC and month ASC
  35. How to create post in WP network using WP-CLI
  36. Do I use custom post type or something else?
  37. Delete Post From Front-End and attachment permanently
  38. Limit function to specific post category
  39. Custom post type permalinks breaking due to 3.1 bug fix
  40. ‘Invalid post type’ error when importing from one site to another
  41. How to stop unlink images when remove a site or user
  42. Blogroll – Different layout for first post
  43. How to delete old posts’ edits to save space?
  44. WordPress Theory Lesson – Image Columns within posts with alignment?
  45. Get image from post’s gallery
  46. Image Insert into posts and pages not working after 3.2.1 update
  47. How to display featured image without it appearing in post?
  48. creating front end image uploader that uploads images as posts
  49. How to make number of blog posts a custom field?
  50. WordPress blog or WordPress website
  51. Using custom post template
  52. Hiding Draft Post In Admin
  53. wp_generate_attachment_metadata is creating an empty array
  54. Editing the default page to show all posts, rather than most recent ones
  55. List all categories with featured image from post?
  56. Permission issue with custom post type – not added to menu – by plugin
  57. Remove Custom Post Type Slug and add Custom Taxonomy to Permalink Structure?
  58. Static posts page with home.php
  59. Is it possible to customize the post according to post format in single.php?
  60. Display the 2nd category name of a custom post type without error if its null?
  61. Querying another post category to match current post and display in loop
  62. datepicker value in mysql
  63. How to Featured content with images in home page?
  64. Simple Custom Metabox Not Saving
  65. How to show a featured image inside a post in only 1 single category
  66. How to restore deleted post related with deleted users
  67. How to get the next and previous image title from attachment or gallery?
  68. WordPress as CMS: How to manage/handle images assigned to a post as full-sized background images in a slideshow?
  69. Custom Post Type Single Loop Outputting Wrong Post
  70. Can I style single post that are in multiple catergories?
  71. WordPress Post Deletion Issue
  72. How Can I Always Display A Particular Post First Using WP_Query?
  73. MySQL: Possible to replace all of wp_posts.post_content(id#) via UPDATE + REPLACE + SELECT?
  74. Change modified date to current date when title updated automatically
  75. Aligning images in the wp editor not working. How do i get this to work in custom theme?
  76. How to put the author of the post in the comments?
  77. How to add a custom class attribute into code wrapper? [duplicate]
  78. Redirecting wordpress search query to archive page
  79. How to invoke a HTML custom button based on a HTML dropdownlist menu
  80. Delete attached images from posts
  81. Schedule image post on download
  82. The first post appears twice
  83. Customizing URL slugs of Custom Post Type and Taxonomy make posts/pages 404
  84. Set featured image on creating new post
  85. Show Posts By Custom Field
  86. How to retrieve custom field values and save again as array
  87. Is there a Standard Format for Clean URLs for Archives of Custom Posts?
  88. How to get only current images of a post
  89. Relative Image Urls in Posts are starting from root – Not from WordPress Address (URL) at General Settings
  90. How to associate media with a post?
  91. Featured Images link to post parent
  92. Checking if some condition is matched before inserting post into database
  93. How do I insert a custom field in a user submitted post?
  94. Get attachment if matches a variable
  95. How remove “recent comments” title without modifying code? [closed]
  96. How edit footer copyright info? [closed]
  97. Displaying all images from a WordPress post (including media library)
  98. How to move all images in a post to a single gallery for a bunch of posts?
  99. WordPress Custom Post type csv exporter
  100. Edit Page button is gone