search

jeffpodmayer / rendezvous-reminder

FULL STACK - Java, Spring, Selenium & JavaMailAPI application that scrapes a website with hut reservations twice a day and sends an email with updated reservation openings
0 stars 1 forks source link

Would it be possible to share the table schema ? #1

Open wushuzh opened 1 month ago

wushuzh commented 1 month ago

Hey there,

I stumbled upon this code repository and think it's a great project. Would it be possible to share the table schema (and its associate inital metadata rows) that goes along with it?

I'm interested in experimenting with this project and adapting it for my own similar situations.

jeffpodmayer commented 1 month ago

Hey @wushuzh ! Thanks for reaching out. Honestly, I am kind of making the table schema up as I go with this thing, so I do not have any outline to share. Feel free to pull this repo down to your box and check it out though!

Do you have any specific questions I can answer about it?

wushuzh commented 1 month ago

Hi @jeffpodmayer

I looked at the spring documentation about Database Initialization Using Basic SQL script . Using the schema.sql and data.sql scripts would help set up the necessary tables and add some sample data. This should be enough to try out the application.

Could you please share the table definitions (DDL) for availability_dates and huts, as well as any other tables I might need? Also, are there any specific initial records I should insert to start fresh?

I'd like to try using these SQL scripts in the project's configuration. If it works, I hope to submit a pull request for your review.