akwd22 / plsql-game Goto Github PK

This project is a console mini-game whose code is written in oriented-object PL/SQL. I haven't found the idea of the game yet, but I already made the linker between the database and Windows console.

The linker is an independent program written in Pascal language. It sends inputs from the console to the database, and it prints to the console data received from the database.

This project is really useless, but I like making improbable things, so it's just for the challenge! (and learning more about PL/SQL and Oracle Database).

(back to top)

• Oriented-object PL/SQL
• Oracle DB 18c
  • Packages:
  • DBMS_SCHEDULER
  • UTL_I18N
  • UTL_RAW

• Pascal language
  • Units:
  • Win32 API
  • SQLdb

(back to top)

A guide to know how to setup both the linker and the database.

• Lazarus IDE, to build the linker.
• Oracle DB 18c, to run the game logic (not sure about other versions).

Note: currently, not all necessary source files are uploaded on the repository.

Database-side:

• Import and execute each PL/SQL script in the right order:
  This will create a dedicated user with necessary permissions for the game code; setup database schema (table, etc.); and compile the game code.

I/O Linker:

1. Open the project in Lazarus IDE.
2. In Connection.pas, set your connection infos:

   con.hostname := '?';
   con.username := '?';
   con.password := '?';
   con.databasename := '?';

3. Build the project.

(back to top)

Be sure that your database is running, then launch the linker. The game should start if the connection to the database was successful.

(back to top)

• I/O Linker.
• Database-side:
  • Console API to handle received input and various printing functions.
• Game logic and gameplay.

(back to top)