php - SilverStripe unique URL (debug) -

-

in dataobject there user supplied field title has converted unique url slug.

desired result: duplicate url's should suffix value. saving 2 records title foo should result in 1 record foo value column url , second record should have value foo-2 same column.

public function onbeforewrite() {     parent::onbeforewrite();      // sanitize title field use url     $filter = urlsegmentfilter::create();     $this->url = $filter->filter($this->title);      // if url not unique, add suffix     $i = 1;     while($this->uniqueurl($this->url)) {         $i++;         $this->url = $this->url . "-" . $i;     }    }

method: uniqueurl (within same class)

public function uniqueurl($url) {      // check if there record same url     $existingurl = dataobject::get('newsarticle', "url = '$url'");     if ($existingurl) {         // duplicate url         return false;     } else {         // unique url         return true;     } }

saving foo twice result in foo , foo-2.

when saving 2 records same title foo results in 2 url fields foo

why have 2 foo urls?

if check db before inserting records, means check not work on record batch.

don't use loop count unique urls

you don't need loop , check every time , increment count ($i). performance wise youre far better off doing count() in query , use value next insert.

// following same 1 query. no loop needed. $count = db::query("select count(*) table title '{$filteredtitle}'")->value(); if ($count > 1) {     $filteredtitle .= "-" .  $count; } $this->url = $filteredtitle

solutions

to onbeforewrite() possibility query data , check records before saved.

or simpler solution same results can change url in onafterwrite() , , check use amount of same titles number.

public function onafterwrite() {     parent::onafterwrite();      // sanitize title field use url     $filter = urlsegmentfilter::create();     $filteredtitle= $filter->filter($this->title);      $count = db::query("select count(*) table title '{$filteredtitle}'")->value();     if ($count > 1) {         $filteredtitle .= "-" .  $count;     }     $this->url = $filteredtitle }

Comments

Post a Comment

Popular posts from this blog

c - zlib and gdi32 with OpenSSL? -

-
this follow question undefined reference rsa_generate_key in openssl? have openssl program generate rsa key, follows : #include <stdio.h> #include <openssl/rsa.h> #include <openssl/pem.h> int main(int argc, char* argv[]) { rsa *r = null; int ret; r = rsa_new(); bignum *bne = null; ret = rsa_generate_key_ex(r, 2048, bne, null); return 0; } when compile gcc -i../include rsatest.c -lcrypto -l. i undefined reference errors functions in libraries gdi32 , zlib. so correct this, have add -lz , -lgdi32, as gcc -i../include/ rsatest.c -lcrypto -lz -lgdi32 -l. my question is, aren't static libcrypto , libssl self sufficient? in why having add libraries make work? there option should have added while compiling library prevent this? i'm using 64 bit windows mingw compiler. made openssl library of msys , make.
Read more

java - inputmismatch exception -

-
Image
this question has answer here: scanner skipping nextline() after using next(), nextint() or other nextfoo()? 14 answers import java.util.*; public class ngg { static scanner numberentered; static scanner userinput = new scanner(system.in); static int guessednumber; static int randomnumber = (int) (math.random()* 11); static scanner reply; static string answer; public static void main(string[] args) { guesschecker(guessednumber); } public static void guesschecker(int userguess) { while (userguess != randomnumber) { intro(); userguess = intchecker(); if (userguess == randomnumber) { system.out.println("congradulations!"); system.exit(0); } else { system.out.println("that incorrect!");...
Read more

ios - Align baselines with characters in large line heights with Text Kit -

-
Image
when draw attributed string fixed line height text kit, characters aligned bottom of line fragment. while make sense on 1 line characters varying in size, breaks flow of text multiple lines. baselines appear decided largest descender each line. i've found article people behind sketch explaining exact problem in bit more detail , showing solution does, not explaining how achieved this. this want basically: when showing 2 lines large line height, result far ideal: the code i'm using: let smallfont = uifont.systemfont(ofsize: 15) let bigfont = uifont.systemfont(ofsize: 25) let paragraphstyle = nsmutableparagraphstyle() paragraphstyle.minimumlineheight = 22 paragraphstyle.maximumlineheight = 22 var attributes = [ nsfontattributename: smallfont, nsparagraphstyleattributename: paragraphstyle ] let textstorage = nstextstorage() let textcontainer = nstextcontainer(size: cgsize(width: 250, height: 500)) let layoutmanager = nslayoutmanager() textstorage.append(n...
Read more