TC
Twill CMSdaniel

Updating Translations from the Command Line

Hi all, as usual I assume I'm misunderstanding something basic about how Laravel works, but I have been stuck trying to update existing translations directly with data from a Console Command. I'm trying to back-fill some missing information that I'm scraping from HTML files. I have tried several different combinations of querying the database to get the existing record and updating it, but nothing seems to work. I can verify that the entry I'm trying to update exists in the database, but when I try to update() or save() I just don't get any results, and don't get any errors. This is my current attempt to query out the existing entries. Not sure how to update the model that this returns. 
$existingProduct = Product::join('product_translations', 'products.id' , '=', 'product_translations.product_id')
                    ->where('title', $productTitle)
                    ->where('locale', 'en')
                    ->where('products.deleted_at', null)
                    ->where('product_translations.deleted_at', null)
                    ->where('brand_id', $brandId)
                    ->first();
$existingProduct = Product::join('product_translations', 'products.id' , '=', 'product_translations.product_id')
                    ->where('title', $productTitle)
                    ->where('locale', 'en')
                    ->where('products.deleted_at', null)
                    ->where('product_translations.deleted_at', null)
                    ->where('brand_id', $brandId)
                    ->first();
D
daniel•356d ago
I tried to update using this and it didn't work: 
$existingProduct = ProductTranslation::where('title', $productTitle)
                    ->where('locale', 'en')
                    ->where('product_translations.deleted_at', null)
                    ->update([
                        'specifications' => $specsHtml,
                        'features'       => $featureHtml,
                    ]);
$existingProduct = ProductTranslation::where('title', $productTitle)
                    ->where('locale', 'en')
                    ->where('product_translations.deleted_at', null)
                    ->update([
                        'specifications' => $specsHtml,
                        'features'       => $featureHtml,
                    ]);
ok, thankfully i'm an idiot... in my test case the actual HTML i was sending to update was blank
D
daniel•356d ago
Want results from more Discord servers?
Add your server
More Posts
Preview ModulesHey how do you go about previewing modules? There is not a lot of documentation available. How do yoLegacy Settings Sections return values doesn't workHi, After save Settings to database, values doesn't bind in inputs. How fixed this @ifox.dev ?New module item errorWhen i make a new module i get this error, i'm using the twill metadata pacakage ```Object { messagCustom form fieldsI'm trying to make a custom form field to override the custom WYSIWYG form field. I've followed thiNew Settings approachHey, a i have a small question - how build a settings page like in https://demo.twill.io/settings/seRender repeater in block blade fileI have made a block named "gallery" with a repeater containing medias named "gallery-item", please hFetch all images in a blockHow do you fetch all the images in a block? For e.g i have this block <x-twill::medias name="slRepeater without blocksHow do you add and render a repeater without including it in the block?