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. Images being uploaded via WP Media are not attached even they are used by some CPT posts
  23. Adding buttons to Add New Post and Add New Page
  24. Custom Post Type – Category Rewrite – Remove Rewrite from Sitemap
  25. wp_generate_attachment_metadata is creating an empty array
  26. CPT archive redirects to single post
  27. Show posts by a custom post author
  28. I have a site where attachments in the wp_posts table have guid values of guid, how did this happen?
  29. CSS: How can I show a photo beyond the template’s column, but contained within the browser window? [closed]
  30. Get all attachment by post excluding featured and content inside
  31. Custom loop pagination links not working
  32. Prevent Delete Attachment by URL or When Submit
  33. Enable Comments Box On Custom Post Type
  34. How can i limit the number of posts created per category?
  35. Search results posts_orderby and ID
  36. Getting Custom Post Loop to display in Bootstrap 3 column grid
  37. Turn On Comments On Custom Post Types in Directory Theme
  38. WordPress custom Query for Posts in Category display posts multiple times
  39. Responsive images with custom image size
  40. Making a custom Pagination for multi page blog post
  41. ERROR: Your feed is invalid (after update WP4.7) in custom types
  42. Editing the default page to show all posts, rather than most recent ones
  43. Unable to restore from backup – how to obtain old blog posts?
  44. Get attachments for posts that belongs to a specific category
  45. List all categories with featured image from post?
  46. Automatically add date to the auto generation of post slug
  47. Removal of Media Gallery pictures
  48. How can you change all past posts’ images to link to none instead of the image file?
  49. Permission issue with custom post type – not added to menu – by plugin
  50. Duplicate Custom Post Type and Taxonomy Slug
  51. How could I change my Permalink from blog to custom structure? [closed]
  52. Automatically attach image to post if they have the same title
  53. Remove Custom Post Type Slug and add Custom Taxonomy to Permalink Structure?
  54. Take a received feedback item, turn it into a post
  55. Getting value from get_post_custom
  56. WP Admin register taxonomy and post type performance
  57. How to get the last selected media alignment setting?
  58. Add a custom meta box in the post options that loads some html code in the header
  59. Static posts page with home.php
  60. Calling Different Custom Post Timestamps in a table
  61. WordPress Multisite – Create Default Post and New Category On New Site Install
  62. Admin – create custom post status and display above table
  63. Get all images in post and comments like Twitter before post title
  64. custom post template file not shown, instead all the time 404.php
  65. Set Default Category to Username
  66. WordPress Automatic Filename Changer
  67. How to allow visitors to filter posts by multiple taxonomies
  68. Show only posts with images and a fixed amount of posts
  69. Issue where WP Featured Image will not display
  70. show custom post type category dropdown sorting result on same page
  71. Custom Post Type Rewrite To Include Parent Page(s)
  72. How would one change the default url structure of attachments?
  73. Thumbnail & Category link aside post
  74. Redirect to another page using contact form 7? [closed]
  75. If statement to check if post has image
  76. How to include my own css in post
  77. Gather posts into a cart/lightbox and share with another user
  78. Custom post types related to same custom post type?
  79. How do I insert a post with custom post type and relate it to a custom taxonomy?
  80. Dynamically switch template on click
  81. “about us”, ” contact” sections should be article(post) or page in the simple small Business website?
  82. Thumbnail Image to go in the post aswell
  83. Is it possible to customize the post according to post format in single.php?
  84. Customize rel=canonical tag for single blog post
  85. a little direction on custom post type
  86. disable Tab post on nav-menus page (Admin)
  87. What are the benefits of setting a “featured image” for a WP blog post?
  88. Format latest/newest post differently
  89. Custom taxonomy archive page problem
  90. Tell WP to use a specific template file in posts
  91. Is there a way to create a meta box that can be added multiple times to a post dynamically?
  92. preg_replace not removed “class”
  93. relating business and products with custom taxonomy?
  94. Best Way to Add UnEditable HTML to Posts
  95. update image path with words starting uppercase to lowercase chars
  96. How safe is it to delete old posts edits to save database space?
  97. Two Custom Post Types with Identical Articles Competing for the same Slug
  98. Custom Post Type archive
  99. WordPress custom post type with folder structure in slug
  100. Using setup_postdata() with multi-dimensional array
Hata!: SQLSTATE[HY000] [1045] Access denied for user 'divattrend_liink'@'localhost' (using password: YES)