Thanks alot Luigi. You guys are really helping all developers. But i' ve an
extra question for you :/
We have some problems about OrientObject is not Json serializable Error.
Let me explain our code in simple way. We have
Customers,Admins(Company),Product,Personel classes and CRUD for all of
them in back end (Python).
HERE IS MY VERTEX
createPersonel = configDb.client.command("create vertex PersonelInformation set
Adress ='" + adress
+ "',""CitizenId='" + citizenId +
"',CompanyCode='" + companyCode
+ "',""Email='" + email + "',Name='" +
name + "', Surname='" + surname
+ "',Phone=" + phone)
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------
HERE IS MY EDGE
createRelation = configDb.client.command("create edge PersonelRelation from " +
personelRid + " to " + companyRid + "' ")
-------------------------------------------------------------------------------
SELECT QUERY FOR ALL INFORMATIONS IN CLASS
all = []
data = configDb.client.command("select * from PersonelInformation")
for i in range(0, len(data)):
all.append(data[i].oRecordData)
return json.dumps(all)
-------------------------------------------------------------------------------------------------------------------------
Everything is fine except select query, I can not see the relationship.
When there is a relation in some records , after execute the query i get
this error .
[2018-03-25 13:24:49,575] ERROR in app: Exception on /personelInfo/getAll
[GET]
Traceback (most recent call last):
File "D:\Outputs\pyCharm\rms\venv\lib\site-packages\flask\app.py", line
1982, in wsgi_app
response = self.full_dispatch_request()
File "D:\Outputs\pyCharm\rms\venv\lib\site-packages\flask\app.py", line
1614, in full_dispatch_request
rv = self.handle_user_exception(e)
File "D:\Outputs\pyCharm\rms\venv\lib\site-packages\flask\app.py", line
1517, in handle_user_exception
reraise(exc_type, exc_value, tb)
File "D:\Outputs\pyCharm\rms\venv\lib\site-packages\flask\_compat.py",
line 33, in reraise
raise value
File "D:\Outputs\pyCharm\rms\venv\lib\site-packages\flask\app.py", line
1612, in full_dispatch_request
rv = self.dispatch_request()
File "D:\Outputs\pyCharm\rms\venv\lib\site-packages\flask\app.py", line
1598, in dispatch_request
return self.view_functions[rule.endpoint](**req.view_args)
File "D:/Outputs/pyCharm/rms\Middleware\Decator.py", line 16, in
decorated_function
return f(*args, **kwargs)
File "D:/Outputs/pyCharm/rms\Resources\PersonelinformationResource.py",
line 105, in GetAll
return re
File "D:\Outputs\pyCharm\rms\venv\lib\site-packages\flask\json.py", line
123, in dumps
rv = _json.dumps(obj, **kwargs)
File "D:\Program Files\Python36\Lib\json\_init_.py", line 238, in dumps
**kw).encode(obj)
File "D:\Program Files\Python36\Lib\json\encoder.py", line 199, in encode
chunks = self.iterencode(o, _one_shot=True)
File "D:\Program Files\Python36\Lib\json\encoder.py", line 257, in
iterencode
return _iterencode(o, 0)
File "D:\Outputs\pyCharm\rms\venv\lib\site-packages\flask\json.py", line
80, in default
return _json.JSONEncoder.default(self, o)
File "D:\Program Files\Python36\Lib\json\encoder.py", line 180, in default
o._class.name_)
TypeError: Object of type 'OrientBinaryObject' is not JSON serializable
127.0.0.1 - - [25/Mar/2018 13:24:49] "GET /personelInfo/getAll HTTP/1.1"
500 -
---------------------------------------------------------------------------------------------------------------------------------------------------------------
IN THE OTHER HAND, When i delete records with relations , My Select query
works fine. I can see all records without relation.
But my main goal is getting companyCode when i query on PersonelInformation
vertex.
Also i tried This.
-select adress from user where = out('PersonelRelation')[0].name = "orient"
------------------------------------------------------------------------------------------------------------------------------------
OUT comes like this.
b64:'AQAAAAEAggAAAAAAAAAA'
IN SHORT my main problem is when i connect the Company And Personel
Classes, i want to see Company class informations over personelInformation
Query. But i dont want to restrict my query like , select from where rid =
37
i just want to get company information wihtout giving any company
information in Personel Query. Just want to get informations about Company
in Back end and want to read them. Its not important after a query like =
select from personel where CompanyCode "abc"
Really Thanks alot from now
Looking for your answer
Regards,
Ersin
5 Mart 2018 Pazartesi 12:21:40 UTC+3 tarihinde Luigi Dell'Aquila yazdı:
>
> Hi Ersin,
>
> There is no SQL statement to do this, but you can use Teleporter (included
> in OrientDB Studio) to do a full import from SQL to a pure graph.
>
> About multiple classes as target in a query, you cannot do it that way,
> what you probably need is MATCH
> https://orientdb.com/docs/3.0.x/sql/SQL-Match.html
>
> Thanks
>
> Luigi
>
>
>
> 2018-03-03 19:57 GMT+01:00 Ersin Sevinc <ersin...@gmail.com <javascript:>>
> :
>
>> Hi there, m new at orient db trying to figure out something about
>> relations ,
>> In this code Line => create edge owns from (select from Person where name
>> = 'Matt') to (select from Car where model = 'Ferrari')
>> We have edge between record to record. Its fine for few records. But what
>> will happen if i ve millions of data ? Should i create edge from backend
>> for every new record?
>> Or can i just link the Property Fields like => create edge owns from
>> Person.Name to Car.model ??
>>
>> I want to know that is there any possible way for relation database like
>> MSSQL , you know in ms sql , we can create PK and FK between Fields , with
>> that way we do not need to create relations for every new record.
>>
>> Here another question -> select car.model person.name from car, person
>> Where .............................. I think i can not use 2 different
>> class after FROM m i right ?
>>
>> 27 Mart 2014 Perşembe 17:03:33 UTC+3 tarihinde Andrey Lomakin yazdı:
>>>
>>> Hi,
>>> Could you try
>>>
>>> select name from Person where gender = 'M' and out('owns')[0].model =
>>> "Ferrari" and out('likes')[0].mov_name = "Need For Speed"
>>>
>>>
>>> On Thu, Mar 27, 2014 at 5:13 AM, Joel Mathew <meet...@gmail.com> wrote:
>>>
>>>> Hi group,
>>>> I have below schema with three classes
>>>>
>>>> orientdb {demo1}> select from Person
>>>> ----+-----+-----+------+--------+---------
>>>> # |@RID |name |gender|out_owns|out_likes
>>>> ----+-----+-----+------+--------+---------
>>>> 0 |#11:0|Matt |M |#12:0 |#13:0
>>>> 1 |#11:1|Helen|F |#12:1 |#13:1
>>>> ----+-----+-----+------+--------+---------
>>>>
>>>> orientdb {demo1}> select from Car
>>>> ----+-----+-------+-------
>>>> # |@RID |model |in_owns
>>>> ----+-----+-------+-------
>>>> 0 |#12:0|Ferrari|#11:0
>>>> 1 |#12:1|BMW |#11:1
>>>> ----+-----+-------+-------
>>>>
>>>> orientdb {demo1}> select from Movie
>>>> ----+-----+--------------+--------
>>>> # |@RID |mov_name |in_likes
>>>> ----+-----+--------------+--------
>>>> 0 |#13:0|Need For Speed|#11:0
>>>> 1 |#13:1|Matrix |#11:1
>>>> ----+-----+--------------+--------
>>>>
>>>> Person(name,gender)
>>>> Car(model)
>>>> Movie(mov_name)
>>>> Person > owns > Car
>>>> Person > likes > Movie
>>>>
>>>> I'm looking at a query which matches values across three classes across
>>>> the edges
>>>> Find Person.name where Person.gender='M' and who owns
>>>> Car.model='Ferrari' and who likes Movie.mov_name='Need For Speed'
>>>>
>>>> One way to achieve the same with gremlin is
>>>> g.V('@class','Car').has('model','Ferrari').in('owns').has('@class','Person').has('gender','M').as('x').out('likes').has('@class','Movie').has('mov_name','Need
>>>>
>>>> For Speed').select(["x"])
>>>> I'm using OrientDB 1.7-rc2-SNAPSHOT..
>>>> Please help me with some pointers towards equivalent orientdb sql.
>>>>
>>>> Thanks,
>>>> Mathew
>>>>
>>>>
>>>> --
>>>>
>>>> ---
>>>> You received this message because you are subscribed to the Google
>>>> Groups "OrientDB" group.
>>>> To unsubscribe from this group and stop receiving emails from it, send
>>>> an email to orient-databa...@googlegroups.com.
>>>> For more options, visit https://groups.google.com/d/optout.
>>>>
>>>
>>>
>>>
>>> --
>>> Best regards,
>>> Andrey Lomakin.
>>>
>>> Orient Technologies
>>> the Company behind OrientDB
>>>
>>> --
>>
>> ---
>> You received this message because you are subscribed to the Google Groups
>> "OrientDB" group.
>> To unsubscribe from this group and stop receiving emails from it, send an
>> email to orient-databa...@googlegroups.com <javascript:>.
>> For more options, visit https://groups.google.com/d/optout.
>>
>
>
--
---
You received this message because you are subscribed to the Google Groups
"OrientDB" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to orient-database+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.
