Populate DB with sensible data

[Dr-Crow]

Add all the classes, curricula, languages, employees, sites, etc. This makes it easier to test and just a nice experience when sourcing the DB.

[algozine]

The original requirement for this is coming from a discussion I had with Jimmy .. or rather an email first asking how it could be done, then a discussion. I want the names of the 28 classes from the full curriculum, and the 4 from the cornerstone class, and some of the other modified classes from the rehab location curricula that are NOW in the database running on .34 to be preserved so that we don't have to type them all in again. The Curricula would also be nice, but not needed, as we are changing some thing in that part of the DB (as I understand it). So... classes for sure.. maybe locations and curricula, employees for sure ... that would be great. Thanks

[jrands]

Marcos and I were discussing this as well, trigger functions would probably be the best way to populate the DB with some default values every time it is sourced. I'll begin working on this.

[Dr-Crow]

@jrands Hey john, no triggers needed. Lets use the /Test/ folder and populate some of this data using inserts. I will do a dump of the DB tonight or tomorrow to get all the classes that have been entered already.

[marcosb1]

https://stackoverflow.com/questions/12815496/export-specific-rows-from-a-postgresql-table-as-insert-sql-script

[marcosb1]

That should solve whatever issues you were having @Dr-Crow

[Dr-Crow]

Added data, waiting on employee info from new deploy or if the web team could get me that info. @michellecrawley ?

[michelleburd]

What kind of employee information do you need? Name, phone number, languages, classes taught, etc.? @Dr-Crow

[Dr-Crow]

Anything that would be good as some default values in the database. So if we want Gwen to be an employee, I need all that stuff associated with making one. Name, Languages, etc. If you go on .33 and create all the default employees with the right permissions, I can just grab them from the database.

[michelleburd]

None of us have any information on the employees that I know of. Iggi did data entry with participants, but we haven't seen or heard about anything regarding employees. If @algozine has this information or knows who has it, I can go ahead and create them once I get the data.

[Scott123180]

• I think we sort of went over making employees and I think the only default person we may need is Algozzine's account. When we deploy then I think the next step is he adds Gwen and anyone else.
• For the data, it's a manual process, but our baseline is the forms that Algozzine put on the website in the beginning of the year. Here's a link to them: https://ilearn.marist.edu/portal/site/eadb6fde-277f-408c-a750-a76ae7b375f3/tool/d38f4ed9-98bd-466a-9561-7727c80fdbef/ShowPage?returnView=&studentItemId=0&backPath=&errorMessage=&clearAttr=&source=&title=&sendingPage=35700&newTopLevel=false&postedComment=false&itemId=206714&addBefore=&path=push&addTool=-1&recheck=&id=

[Dr-Crow]

@algozine I need to know what all the locations are and there addresses.

• Fox Run
• Meadow Run
• Florence Manor
• Cornerstone
• Dutchess county jail MEN
• Dutchess county jail WOMEN
• CPCA

• New Vison Chruch

  Fox Run - this is actually the name of a CURRICULUM, and the location is: Daytop Village, 190 Fox Hollow Road, Rhinebeck, New York 12572 Meadow Run - same as Fox Run, it is a curriculum NOT a location... it happens to be taught at the same location=Daytop Village Florence Manor - 24 W Cottage Rd, Poughkeepsie, NY 12601 Cornerstone is name of curriculum, location is "Cornerstone of Rhinebeck", 500 Milan Hollow Road, Rhinebeck, NY 12572 Dutchess county jail - 15 N Hamilton St., Poughkeepsie 12601 Dutchess county jail WOMEN - DELETE THIS LOCATION CPCA Conference Room - 35 Van Wagner Blvd, Arlington, NY 12603 New Vison Chruch - 831 NY-52, Fishkill, NY 12524

[algozine]

This is not a parking lot item.

[CBadame]

I'm pretty sure this was completed either way. @Dr-Crow?

[algozine]

Well, not exactly.. we still don't have location data although it was provided. Semi-related to that, the locations do not have physical addresses (though I would consider this portion of the request to be a parking lot item if we feel it's an easy thing for someone to update next semester). AND, the data isn't at the client yet ... so, technically that's the DB that matters!