Giter Site home page Giter Site logo

Comments (2)

grimzy avatar grimzy commented on August 20, 2024

I'm not exactly sure where change() is defined but it is packaged with Laravel and requires doctrine/dbal to also be installed (see the docs).

what you do to make point column not null so i can use index on it?

In your migrations, when defining your point column, just don't set it as nullable (the usual way).
When using change() in the documentation, it's to ALTER a table column that was previously set with DEFAULT NULL; you typically don't need to do this if you CREATE a table.

is there is a way to set default value for point ? point(0,0) is ok for me

Unfortunately this is a MySQL limitation, similarly to BLOB/TEXT/JSON types, you can't set a default value to any GEOMETRY type, otherwise you get:
SQLSTATE[42000]: Syntax error or access violation: 1101 BLOB, TEXT, GEOMETRY or JSON column.
Alternatively you can create a MySQL trigger that updates the value of your POINT column when inserting a NULL value in; something like:

delimiter //
create trigger my_point_trigger before insert on my_point_table
for each row
begin
   if (NEW.point_column is null ) then
      set NEW.point_column = ST_GeomFromText('POINT(0 0)');
   end if;
end
//
delimiter ;

(Untested)

from laravel-mysql-spatial.

mohamedsharaf avatar mohamedsharaf commented on August 20, 2024

thx i ended in setting value in elequent boot to point

from laravel-mysql-spatial.

Related Issues (20)

Recommend Projects

  • React photo React

    A declarative, efficient, and flexible JavaScript library for building user interfaces.

  • Vue.js photo Vue.js

    🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.

  • Typescript photo Typescript

    TypeScript is a superset of JavaScript that compiles to clean JavaScript output.

  • TensorFlow photo TensorFlow

    An Open Source Machine Learning Framework for Everyone

  • Django photo Django

    The Web framework for perfectionists with deadlines.

  • D3 photo D3

    Bring data to life with SVG, Canvas and HTML. 📊📈🎉

Recommend Topics

  • javascript

    JavaScript (JS) is a lightweight interpreted programming language with first-class functions.

  • web

    Some thing interesting about web. New door for the world.

  • server

    A server is a program made to process requests and deliver data to clients.

  • Machine learning

    Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.

  • Game

    Some thing interesting about game, make everyone happy.

Recommend Org

  • Facebook photo Facebook

    We are working to build community through open source technology. NB: members must have two-factor auth.

  • Microsoft photo Microsoft

    Open source projects and samples from Microsoft.

  • Google photo Google

    Google ❤️ Open Source for everyone.

  • D3 photo D3

    Data-Driven Documents codes.