/*
 * Copyright (C) 2011 Markus Junginger, greenrobot (http://greenrobot.de)
 *
 * Licensed under the Apache License, Version 2.0 (the "License");
 * you may not use this file except in compliance with the License.
 * You may obtain a copy of the License at
 *
 *      http://www.apache.org/licenses/LICENSE-2.0
 *
 * Unless required by applicable law or agreed to in writing, software
 * distributed under the License is distributed on an "AS IS" BASIS,
 * WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
 * See the License for the specific language governing permissions and
 * limitations under the License.
 */
package com.tehnicomsolutions.daogenerator;

import de.greenrobot.daogenerator.DaoGenerator;
import de.greenrobot.daogenerator.Entity;
import de.greenrobot.daogenerator.Property;
import de.greenrobot.daogenerator.Schema;
import de.greenrobot.daogenerator.ToMany;

public class TDaoGenerator
{

    public static void main(String[] args) throws Exception
    {
        Schema schema = new Schema(1, "com.tehnicom.talkb2b.model");

        addUser(schema);

        new DaoGenerator().generateAll(schema, "./src-gen");
    }


    private static void addUser(Schema schema)
    {
        Entity user = schema.addEntity("Credential");
        user.setHasKeepSections(true);
        user.addIdProperty();
        user.addStringProperty("email");
        user.addStringProperty("password");

        //event table
        Entity event = schema.addEntity("Event");
        event.setHasKeepSections(true);
        event.addStringProperty("id").primaryKey();
        event.addStringProperty("codename");
        event.addStringProperty("address");
        event.addStringProperty("city");
        event.addStringProperty("conference_end");
        event.addStringProperty("conference_name");
        event.addStringProperty("conference_start");
        event.addStringProperty("header");
        event.addStringProperty("image");
        event.addStringProperty("information");
        event.addStringProperty("latitude");
        event.addStringProperty("longitude");
        event.addStringProperty("meeting_end");
        event.addStringProperty("meeting_start");
        event.addStringProperty("url");
        event.addStringProperty("modified");
        event.addStringProperty("organisation_name");
        event.addStringProperty("organizator_name");
        event.addStringProperty("registration_start");
        event.addStringProperty("registration_end");
        event.addStringProperty("site_image");
        event.addStringProperty("tw_hashtag");
        event.addStringProperty("tw_show_widgets");
        event.addStringProperty("tw_type");
        event.addStringProperty("tw_user");
        event.addLongProperty("local_member_id").notNull();

        //user to event
        Property userId = event.addLongProperty("member_id").notNull().getProperty();
        ToMany userToEvent = user.addToMany(event, userId);
        userToEvent.setName("events");

        //business fields
        Entity businessFiled = schema.addEntity("BusinessField");
        businessFiled.setHasKeepSections(true);
        businessFiled.addStringProperty("id").primaryKey();
        businessFiled.addStringProperty("title");
        businessFiled.addIntProperty("lft");
        businessFiled.addIntProperty("parent_id");
        businessFiled.addLongProperty("web_id").notNull();

        //event to business fields relation
        Property eventId = businessFiled.addStringProperty("event_id").notNull().getProperty();
        ToMany eventToBf = event.addToMany(businessFiled, eventId);
        eventToBf.setName("business_fields");

        //cooperation profile
        Entity cooperationProfile = schema.addEntity("CooperationProfile");
        cooperationProfile.setHasKeepSections(true);
        cooperationProfile.addStringProperty("id").primaryKey();
        cooperationProfile.addStringProperty("category");
        cooperationProfile.addStringProperty("description");
        cooperationProfile.addStringProperty("title");
        cooperationProfile.addStringProperty("image");
        cooperationProfile.addStringProperty("tags");
        cooperationProfile.addLongProperty("local_member_id").notNull();
        cooperationProfile.addLongProperty("web_id").notNull();

        //event to cooperation profile relation
        eventId = cooperationProfile.addStringProperty("event_id").notNull().getProperty();
        ToMany eventToCp = event.addToMany(cooperationProfile, eventId);
        eventToCp.setName("cooperation_profiles");

        //lectures
        Entity lecture = schema.addEntity("Lecturer");
        lecture.setHasKeepSections(true);
        lecture.addStringProperty("id").primaryKey();
        lecture.addStringProperty("conference_room");
        lecture.addStringProperty("end");
        lecture.addStringProperty("first_name");
        lecture.addStringProperty("held_on");
        lecture.addStringProperty("topic");
        lecture.addStringProperty("start");
        lecture.addStringProperty("position");
        lecture.addStringProperty("last_name");
        lecture.addIntProperty("is_deleted").notNull();
        lecture.addIntProperty("is_accepted").notNull();
        lecture.addLongProperty("web_id").notNull();

        //event to lectures relation
        eventId = lecture.addStringProperty("event_id").notNull().getProperty();
        ToMany eventToLecture = event.addToMany(lecture, eventId);
        eventToLecture.setName("lectures");

        //documents
        Entity docs = schema.addEntity("Document");
        docs.setHasKeepSections(true);
        docs.addStringProperty("id").primaryKey();
        docs.addStringProperty("url");
        docs.addStringProperty("name");
        docs.addStringProperty("size");
        docs.addIntProperty("type");
        docs.addLongProperty("web_id").notNull();

        //event to media relation
        eventId = docs.addStringProperty("event_id").notNull().getProperty();
        ToMany eventToMedia = event.addToMany(docs, eventId);
        eventToMedia.setName("media");

        //meeting
        Entity meeting = schema.addEntity("Meeting");
        meeting.setHasKeepSections(true);
        meeting.addStringProperty("id").primaryKey();
        meeting.addStringProperty("time");
        meeting.addStringProperty("table");
        meeting.addStringProperty("participations");
        meeting.addStringProperty("start_date");
        meeting.addLongProperty("meeting_with").notNull();
        meeting.addLongProperty("member").notNull();
        meeting.addIntProperty("canceled").notNull();
        meeting.addIntProperty("accepted").notNull();
        meeting.addLongProperty("web_id").notNull();

        //event to lectures relation
        eventId = meeting.addStringProperty("event_id").notNull().getProperty();
        ToMany eventToMeeting = event.addToMany(meeting, eventId);
        eventToMeeting.setName("meetings");

        //member business fields
        Entity member_business_field = schema.addEntity("MemberBusinessField");
        member_business_field.setHasKeepSections(true);
        member_business_field.addStringProperty("id").primaryKey();
        member_business_field.addLongProperty("business_field_id").notNull();
        member_business_field.addIntProperty("active");
        member_business_field.addLongProperty("web_id").notNull();
        member_business_field.addLongProperty("local_member_id").notNull();

        //event to member business fields relation
        eventId = member_business_field.addStringProperty("event_id").notNull().getProperty();
        ToMany eventToMbf = event.addToMany(member_business_field, eventId);
        eventToMbf.setName("member_business_fields");

        //members
        Entity member = schema.addEntity("Member");
        member.setHasKeepSections(true);
        member.addStringProperty("id").primaryKey();
        member.addStringProperty("address");
        member.addStringProperty("city");
        member.addStringProperty("company_logo");
        member.addStringProperty("country");
        member.addStringProperty("description");
        member.addStringProperty("email");
        member.addStringProperty("first_name");
        member.addStringProperty("founded_year");
        member.addStringProperty("last_name");
        member.addStringProperty("website");
        member.addStringProperty("size");
        member.addStringProperty("organization");
        member.addStringProperty("organization_type");
        member.addStringProperty("phone");
        member.addStringProperty("position");
        member.addStringProperty("profile_image");
        member.addLongProperty("local_member_id").notNull();
        member.addLongProperty("member_id").notNull();

        //event to member
        eventId = member.addStringProperty("event_id").notNull().getProperty();
        ToMany eventToMember = event.addToMany(member, eventId);
        eventToMember.setName("members");

        //messages
        Entity message = schema.addEntity("Message");
        message.setHasKeepSections(true);
        message.addStringProperty("id").primaryKey();
        message.addStringProperty("created");
        message.addStringProperty("title");
        message.addStringProperty("text");
        message.addStringProperty("modified");
        message.addLongProperty("reply_to").notNull();
        message.addLongProperty("member_to").notNull();
        message.addLongProperty("member_from").notNull();
        message.addIntProperty("is_new").notNull();
        message.addLongProperty("web_id").notNull();

        //event to messages relation
        eventId = message.addStringProperty("event_id").notNull().getProperty();
        ToMany eventToMessage = event.addToMany(message, eventId);
        eventToMessage.setName("messages");

        //news
        Entity news = schema.addEntity("News");
        news.setHasKeepSections(true);
        news.addStringProperty("id").primaryKey();
        news.addStringProperty("date");
        news.addStringProperty("title");
        news.addStringProperty("image");
        news.addStringProperty("text");
        news.addLongProperty("web_id").notNull();

        //event to news relation
        eventId = news.addStringProperty("event_id").notNull().getProperty();
        ToMany eventToNews = event.addToMany(news, eventId);
        eventToNews.setName("news");

        //news
        Entity note = schema.addEntity("Note");
        note.setHasKeepSections(true);
        note.addIdProperty();
        note.addStringProperty("title");
        note.addStringProperty("text");

        //event to notes relation
        eventId = note.addStringProperty("event_id").notNull().getProperty();
        ToMany eventToNote = event.addToMany(note, eventId);
        eventToNote.setName("notes");

        //stand
        Entity stand = schema.addEntity("Stand");
        stand.setHasKeepSections(true);
        stand.addStringProperty("id").primaryKey();
        stand.addStringProperty("table");
        stand.addStringProperty("name");
        stand.addLongProperty("web_id").notNull();

        //event to stands relation
        eventId = stand.addStringProperty("event_id").notNull().getProperty();
        ToMany eventToStand = event.addToMany(stand, eventId);
        eventToStand.setName("stands");

        //members
        Entity menuItems = schema.addEntity("MenuItem");
        menuItems.setHasKeepSections(true);
        menuItems.addStringProperty("id").primaryKey();
        menuItems.addStringProperty("menu_id");
        menuItems.addStringProperty("type");
        menuItems.addStringProperty("text");
        menuItems.addLongProperty("local_member_id").notNull();

        //event to member
        eventId = menuItems.addStringProperty("event_id").notNull().getProperty();
        ToMany eventToMenuItem = event.addToMany(menuItems, eventId);
        eventToMenuItem.setName("menu_items");
    }

}