|
|
 Edit
|
Copy
|
Delete
DELETE FROM proc WHERE `proc`.`db` = 'test' AND `proc`.`name` = 'AddGeometryColumn' AND `proc`.`type` = 'PROCEDURE'
|
test |
AddGeometryColumn |
PROCEDURE |
AddGeometryColumn |
SQL |
CONTAINS_SQL |
NO |
DEFINER |
catalog varchar(64), t_schema varchar(64),
t_name varchar(64), geometry_column varchar(64), t_srid int
|
|
begin
set @qwe= concat('ALTER TABLE ', t_schema, '.', t_name, ' ADD ', geometry_column,' GEOMETRY REF_SYSTEM_ID=', t_srid); PREPARE ls from @qwe; execute ls; deallocate prepare ls; end
|
@ |
2015-11-25 00:42:53 |
2015-11-25 00:42:53 |
|
|
latin1 |
latin1_swedish_ci |
latin1_swedish_ci |
begin
set @qwe= concat('ALTER TABLE ', t_schema, '.', t_name, ' ADD ', geometry_column,' GEOMETRY REF_SYSTEM_ID=', t_srid); PREPARE ls from @qwe; execute ls; deallocate prepare ls; end
|
NONE |
|
|
Edit
|
Copy
|
Delete
DELETE FROM proc WHERE `proc`.`db` = 'test' AND `proc`.`name` = 'DropGeometryColumn' AND `proc`.`type` = 'PROCEDURE'
|
test |
DropGeometryColumn |
PROCEDURE |
DropGeometryColumn |
SQL |
CONTAINS_SQL |
NO |
DEFINER |
catalog varchar(64), t_schema varchar(64),
t_name varchar(64), geometry_column varchar(64)
|
|
begin
set @qwe= concat('ALTER TABLE ', t_schema, '.', t_name, ' DROP ', geometry_column); PREPARE ls from @qwe; execute ls; deallocate prepare ls; end
|
@ |
2015-11-25 00:42:53 |
2015-11-25 00:42:53 |
|
|
latin1 |
latin1_swedish_ci |
latin1_swedish_ci |
begin
set @qwe= concat('ALTER TABLE ', t_schema, '.', t_name, ' DROP ', geometry_column); PREPARE ls from @qwe; execute ls; deallocate prepare ls; end
|
NONE |
|
|
Edit
|
Copy
|
Delete
DELETE FROM proc WHERE `proc`.`db` = 'university_management' AND `proc`.`name` = 'MarkAttendance' AND `proc`.`type` = 'PROCEDURE'
|
university_management |
MarkAttendance |
PROCEDURE |
MarkAttendance |
SQL |
CONTAINS_SQL |
NO |
DEFINER |
IN `course_id` INT, IN `attendance_date` DATE, IN `attendance_data` TEXT
|
|
BEGIN
-- هذا إجراء مبسط، يمكن تطويره لمعالجة بيانات الحضور
-- attendance_data يمكن أن يكون JSON أو نص مفصول
INSERT INTO attendance (student_id, course_id, attendance_date, status, recorded_by)
SELECT student_id, course_id, attendance_date, 'حاضر', 1
FROM course_registrations
WHERE course_id = course_id AND status = 'معتمد';
END
|
root@localhost |
2025-10-01 10:54:42 |
2025-10-01 10:54:42 |
NO_AUTO_VALUE_ON_ZERO |
|
utf8mb4 |
utf8mb4_general_ci |
utf8mb4_general_ci |
BEGIN
-- هذا إجراء مبسط، يمكن تطويره لمعالجة بيانات الحضور
-- attendance_data يمكن أن يكون JSON أو نص مفصول
INSERT INTO attendance (student_id, course_id, attendance_date, status, recorded_by)
SELECT student_id, course_id, attendance_date, 'حاضر', 1
FROM course_registrations
WHERE course_id = course_id AND status = 'معتمد';
END
|
NONE |
|
|
Edit
|
Copy
|
Delete
DELETE FROM proc WHERE `proc`.`db` = 'university_management' AND `proc`.`name` = 'UpdateStudentGPA' AND `proc`.`type` = 'PROCEDURE'
|
university_management |
UpdateStudentGPA |
PROCEDURE |
UpdateStudentGPA |
SQL |
CONTAINS_SQL |
NO |
DEFINER |
IN `student_id` INT
|
|
BEGIN
DECLARE new_gpa DECIMAL(4,2);
SET new_gpa = CalculateStudentGPA(student_id);
UPDATE students
SET gpa = new_gpa,
total_credits = (
SELECT SUM(c.credits)
FROM course_registrations cr
JOIN courses c ON cr.course_id = c.id
WHERE cr.student_id = student_id AND cr.status = 'معتمد'
)
WHERE id = student_id;
END
|
root@localhost |
2025-10-01 10:54:42 |
2025-10-01 10:54:42 |
NO_AUTO_VALUE_ON_ZERO |
|
utf8mb4 |
utf8mb4_general_ci |
utf8mb4_general_ci |
BEGIN
DECLARE new_gpa DECIMAL(4,2);
SET new_gpa = CalculateStudentGPA(student_id);
UPDATE students
SET gpa = new_gpa,
total_credits = (
SELECT SUM(c.credits)
FROM course_registrations cr
JOIN courses c ON cr.course_id = c.id
WHERE cr.student_id = student_id AND cr.status = 'معتمد'
)
WHERE id = student_id;
END
|
NONE |
|
|
Edit
|
Copy
|
Delete
DELETE FROM proc WHERE `proc`.`db` = 'university_management' AND `proc`.`name` = 'CalculateStudentGPA' AND `proc`.`type` = 'FUNCTION'
|
university_management |
CalculateStudentGPA |
FUNCTION |
CalculateStudentGPA |
SQL |
READS_SQL_DATA |
YES |
DEFINER |
`student_id` INT
|
decimal(4,2)
|
BEGIN
DECLARE total_points DECIMAL(10,2);
DECLARE total_credits INT;
DECLARE gpa DECIMAL(4,2);
SELECT SUM(g.grade_point * c.credits), SUM(c.credits)
INTO total_points, total_credits
FROM grades g
JOIN courses c ON g.course_id = c.id
WHERE g.student_id = student_id AND g.status = 'معتمد';
IF total_credits > 0 THEN
SET gpa = total_points / total_credits;
ELSE
SET gpa = 0.00;
END IF;
RETURN gpa;
END
|
root@localhost |
2025-10-01 10:54:42 |
2025-10-01 10:54:42 |
NO_AUTO_VALUE_ON_ZERO |
|
utf8mb4 |
utf8mb4_general_ci |
utf8mb4_general_ci |
BEGIN
DECLARE total_points DECIMAL(10,2);
DECLARE total_credits INT;
DECLARE gpa DECIMAL(4,2);
SELECT SUM(g.grade_point * c.credits), SUM(c.credits)
INTO total_points, total_credits
FROM grades g
JOIN courses c ON g.course_id = c.id
WHERE g.student_id = student_id AND g.status = 'معتمد';
IF total_credits > 0 THEN
SET gpa = total_points / total_credits;
ELSE
SET gpa = 0.00;
END IF;
RETURN gpa;
END
|
NONE |
