php - How to add a second language at a later time for internationalization? -

-

i have following schema:

<!-- language: lang-xml --> <table name="blog" phpname="blog">     <column name="id" type="integer" required="true" primarykey="true" autoincrement="true" />     <column name="title" phpname="title" type="varchar" size="100" required="true" />     <column name="short_link" phpname="shortlink" type="varchar" size="64" required="false" />     <column name="description" phpname="description" type="longvarchar" required="false" />     <column name="content" phpname="content" type="longvarchar" required="false" />     <column name="visibility" phpname="visibility" type="integer" default="-1" required="true" />      <behavior name="i18n">         <parameter name="i18n_columns" value="title, short_link, description, content" />     </behavior>     <behavior name="timestampable" />     <behavior name="soft_delete" />     <behavior name="versionable" /> </table>  <table name="blog_i18n" phpname="blogi18n">     <column name="id" type="integer" required="true" primarykey="true" />     <column name="locale" type="varchar" size="5" required="true" primarykey="true" />     <column name="title" phpname="title" type="varchar" size="100" required="false" />     <column name="short_link" phpname="shortlink" type="varchar" size="64" required="false" />     <column name="description" phpname="description" type="longvarchar" required="false" />     <column name="content" phpname="content" type="longvarchar" required="false" />      <foreign-key foreigntable="blog" ondelete="setnull" onupdate="cascade">         <reference local="id" foreign="id" />     </foreign-key>      <behavior name="timestampable" />     <behavior name="soft_delete" />     <behavior name="versionable" /> </table>

when add new post, adds single language(main app language), idea leave option more languages @ later time.

this code adds post:

<!-- language: lang-php --> public function addblogpost(application $app) {      $data = array (         'title' => $app['request']->get('title'),         'language' => $app['request']->get('language'),         'short-link' => $this->createshortlink($app, $app['request']->get('title')),         'description' => $app['request']->get('description'),         'content' => $app['request']->get('content')         );      $blog = new blog();      $blog->setlocale($data['language']);     $blog->settitle($data['title']);     $blog->setshortlink($data['short-link']);     $blog->setdescription($data['description']);     $blog->setcontent($data['content']);      try {         $blog->save();         $app['session']->getflashbag()->add(             'success',             'success_add_blog_text'            );             return $app->redirect($app['url_generator']->generate('adminblog'));     } catch (propelexception $pe) {         $app['session']->getflashbag()->add(             'error',             'error_add_blog_text'             );         return $app->redirect($app['url_generator']->generate('adminblog'));     } }

up until here works beautifully expected, when try perform edit, on whatever language, doesnt work.

<!-- language: lang-php --> public function editblogpost(application $app) {     $id = $app['request']->get('id');     $lang = $app['request']->get('language');     if(!is_numeric($id)) {         $app['session']->getflashbag()->add(                 'error',                 'blog_doesnt_exists_text'             );         return $app->redirect($app['url_generator']->generate('adminblog'));     }      $data = array (         'id' => $app['request']->get('id'),         'language' => $app['request']->get('language'),         'title' => $app['request']->get('title'),         'short-link' => $app['request']->get('short-link'),         'description' => $app['request']->get('description'),         'content' => $app['request']->get('content')         );      $post = blogquery::create();      $post->setlocale($data['language']);     $post->settitle($data['title']);     $post->setshortlink($data['short-link']);     $post->setdescription($data['description']);     $post->setcontent($data['content']);      try {         $post->save();         $app['session']->getflashbag()->add(             'success',             'success_edit_blog_text'             );         return $app->redirect($app['url_generator']->generate('adminblog'));     } catch (propelexception $pe) {         $app['session']->getflashbag()->add(             'error',             'error_edit_blog_text'             );         return $app->redirect($app['url_generator']->generate('adminblog'));     } }

error 500.

undefined method modelcriteria::setlocale()

is get. should edit using blogl18nquery instead? or doing wrong way get-go?

ok after testing (due lack of perform complex searches answers have admit)

this did , works (it may not best solution tho, works now).

<!-- language: lang-php --> public function editblogpost(application $app) {     $id = $app['request']->get('id');     $lang = $app['request']->get('language');     if(!is_numeric($id)) {         $app['session']->getflashbag()->add(                 'error',                 'blog_doesnt_exists_text'             );         return $app->redirect($app['url_generator']->generate('adminblog'));     }      // check if item exists, if doesnt, error.     $blog = blogquery::create()         ->filterbyid($id)         ->count();     if($blog<1) {         $app['session']->getflashbag()->add(             'error',             'blog_doesnt_exists_text'             );         return $app->redirect($app['url_generator']->generate('adminblog'));     }      $data = array (         'id' => $app['request']->get('id'),         'language' => $app['request']->get('language'),         'title' => $app['request']->get('title'),         'short-link' => $app['request']->get('shortlink'),         'description' => $app['request']->get('description'),         'content' => $app['request']->get('content')         );      $post = new blogi18n();     $post->setid($data['id']);     $post->setlocale($data['language']);     $post->settitle($data['title']);     $post->setshortlink($data['short-link']);     $post->setdescription($data['description']);     $post->setcontent($data['content']);      try {         $post->save();         $app['session']->getflashbag()->add(             'success',             'success_edit_blog_text'             );         return $app->redirect($app['url_generator']->generate('adminblog'));     } catch (propelexception $pe) {         $app['session']->getflashbag()->add(             'error',             'error_edit_blog_text'             );         return $app->redirect($app['url_generator']->generate('adminblog'));     }  }

i went usage of blogi18n , did trick.


Comments

Post a Comment

Popular posts from this blog

java - nested exception is org.hibernate.exception.SQLGrammarException: could not extract ResultSet Hibernate+SpringMVC -

-
i trying fetch records database , having above error this classs appropriate getters , setters public class user { private int id; private string username; private string password; private string email; i have create database , inserted data below configuration <bean id="datasource" class="org.apache.commons.dbcp2.basicdatasource" destroy-method="close"> <property name="driverclassname" value="com.mysql.jdbc.driver"/> <property name="url" value="jdbc:mysql://localhost:3306/usersdb"/> <property name="username" value="root"/> <property name="password" value=""/> </bean> this complete stacktrace severe: servlet.service() servlet [appservlet] in context path [/spring] threw exception [request processing failed; nested exception org.hibernate.exception.sqlgrammarexception: not ...
Read more

sql - Postgresql tables exists, but getting "relation does not exist" when querying -

-
Image
i have postgresql db number of tables. if query: select column_name information_schema.columns table_name="my_table"; i list of columns returned properly. however, when query: select * "my_table"; i error: (programmingerror) relation "my_table" not exist 'select *\n "my_table"\n' {} any thoughts on why can columns, can't query table? goal able query table. you have include schema if isnt public one select * <schema>."my_table" or can change default schema show search_path; set search_path my_schema; check table schema here select * information_schema.columns for example if table on default schema public both works ok select * parroquias_region select * public.parroquias_region but sectors need specify schema select * map_update.sectores_point
Read more

asp.net mvc - breakpoint on javascript in CSHTML? -

-
i have .cshtml file has javascript tag. within script tag have few lines of javascript. first line of javascript refers property in @viewbag. other javascript lines plain script without mvc related references. observation: can place breakpoints (visual studio 2015) on each of these javascript lines. however, breakpoints has white dot in center of breakpoint symbol (red circle) except line @viewbag reference (this particular line not have white dot in center). it seems breakpoint without white dot hit during run-time. question: can explain going on here? white dot mean? why plain red breakpoint line line hitting breakpoint? the visual studio debugger expecting debug actual server-side code within .cshtml file opposed client-side javascript within it. iirc, visual studio allow debug javascript code expected in internet explorer (and possibly edge), other browsers want use either third-party tool or developer tools (f12) within browser. an easy approach take advant...
Read more