Book a Demo

Author Topic: Search for generate code  (Read 4907 times)

razzo78

  • EA User
  • **
  • Posts: 25
  • Karma: +0/-0
    • View Profile
Search for generate code
« on: April 09, 2015, 12:20:13 am »
Hi,
i wanted to know if there is a fast way to find the classes for which I have not yet generated the source code.

KP

  • EA Administrator
  • EA Expert
  • *****
  • Posts: 2919
  • Karma: +55/-3
    • View Profile
Re: Search for generate code
« Reply #1 on: April 09, 2015, 10:06:26 am »
Try this search:

Code: [Select]
SELECT * FROM t_object WHERE Object_Type='Class' AND GenFile IS NULL
(GenFile stores the file name of the generated source file)
The Sparx Team
[email protected]

qwerty

  • EA Guru
  • *****
  • Posts: 13584
  • Karma: +397/-301
  • I'm no guru at all
    • View Profile
Re: Search for generate code
« Reply #2 on: April 09, 2015, 06:54:59 pm »
To make the above search ciickable modify it this way:
Code: [Select]
SELECT  ea_guid AS CLASSGUID, Object_Type AS CLASSTYPE, Name FROM t_object
WHERE Object_Type='Class' AND GenFile IS NULL

q.
« Last Edit: April 09, 2015, 06:55:35 pm by qwerty »

razzo78

  • EA User
  • **
  • Posts: 25
  • Karma: +0/-0
    • View Profile
Re: Search for generate code
« Reply #3 on: April 09, 2015, 11:24:37 pm »
Quote
To make the above search ciickable modify it this way:
Code: [Select]
SELECT  ea_guid AS CLASSGUID, Object_Type AS CLASSTYPE, Name FROM t_object
WHERE Object_Type='Class' AND GenFile IS NULL

q.

Fantastic. Now if i want to have all'class method where Notes = NULL??

qwerty

  • EA Guru
  • *****
  • Posts: 13584
  • Karma: +397/-301
  • I'm no guru at all
    • View Profile
Re: Search for generate code
« Reply #4 on: April 10, 2015, 03:19:07 am »
Quite straight forward:
Code: [Select]
SELECT ea_guid AS CLASSGUID, Object_Type AS CLASSTYPE, Name FROM t_object
WHERE Object_Type='Class' AND t_object.Note  IS Null
q.

razzo78

  • EA User
  • **
  • Posts: 25
  • Karma: +0/-0
    • View Profile
Re: Search for generate code
« Reply #5 on: April 10, 2015, 04:44:21 pm »
Quote
Quite straight forward:
Code: [Select]
SELECT ea_guid AS CLASSGUID, Object_Type AS CLASSTYPE, Name FROM t_object
WHERE Object_Type='Class' AND t_object.Note  IS Null
q.

It's ok, but i need the methods of the class, no the class!

qwerty

  • EA Guru
  • *****
  • Posts: 13584
  • Karma: +397/-301
  • I'm no guru at all
    • View Profile
Re: Search for generate code
« Reply #6 on: April 10, 2015, 06:18:48 pm »
Code: [Select]
SELECT t_object.ea_guid AS CLASSGUID, t_object.Object_Type AS CLASSTYPE, t_object.Name, t_operation.Name as Op FROM t_object, t_operation
WHERE t_object.Object_Type='Class' AND t_operation.Notes  IS Null AND t_operation.Object_ID = t_object.Object_ID
You might also have a look into my Inside book which explains the above a bit.

q.