def upgrade():
# ### commands auto generated by Alembic - please adjust! ###
op.add_column(
"scores", sa.Column("session_uuid", mssql.UNIQUEIDENTIFIER(), nullable=True)
)
op.create_foreign_key(
None, "scores", "sessions", ["session_uuid"], ["session_uuid"]
)
op.drop_column("scores", "user_uuid")
op.add_column(
"users", sa.Column("quiz_uuid", mssql.UNIQUEIDENTIFIER(), nullable=True)
)
op.create_foreign_key(None, "users", "scores", ["quiz_uuid"], ["quiz_uuid"])
def downgrade():
# ### commands auto generated by Alembic - please adjust! ###
op.add_column(
"conversations",
sa.Column(
"receiver_session_uuid",
mssql.UNIQUEIDENTIFIER(),
autoincrement=False,
nullable=True,
),
)
op.create_foreign_key(
"FK__conversat__recei__756D6ECB",
"conversations",
"sessions",
["receiver_session_uuid"],
["session_uuid"],
)
op.drop_column("conversations", "user_b_share_consent")
op.drop_table("user_b_journey")
op.drop_table("user_b_analytics_data")
op.drop_table("solution_choice")
op.drop_table("effect_choice")
op.drop_table("alignment_scores")
op.drop_table("alignment_feed")
def downgrade():
# ### commands auto generated by Alembic - please adjust! ###
op.add_column(
"users",
sa.Column(
"user_uuid", mssql.UNIQUEIDENTIFIER(), autoincrement=False, nullable=False
),
)
op.add_column(
"users",
sa.Column(
"username",
sa.VARCHAR(length=64, collation="SQL_Latin1_General_CP1_CI_AS"),
autoincrement=False,
nullable=True,
),
)
op.drop_column("users", "uuid")
op.drop_constraint(None, "scores", type_="foreignkey")
op.create_foreign_key(
"FK__scores__user_uui__17F790F9",
"scores",
"users",
["user_uuid"],
["user_uuid"],
)
def downgrade():
# ### commands auto generated by Alembic - please adjust! ###
op.alter_column('miner',
'user_id',
existing_type=mssql.UNIQUEIDENTIFIER(),
nullable=False)
op.drop_column('health', 'valid_shares')
op.drop_column('health', 'invalid_shares')
def upgrade():
# ### commands auto generated by Alembic - please adjust! ###
op.add_column('health',
sa.Column('invalid_shares', sa.Integer(), nullable=True))
op.add_column('health',
sa.Column('valid_shares', sa.Integer(), nullable=True))
op.alter_column('miner',
'user_id',
existing_type=mssql.UNIQUEIDENTIFIER(),
nullable=True)
def downgrade():
# ### commands auto generated by Alembic - please adjust! ###
op.drop_constraint(None, "users", type_="foreignkey")
op.drop_column("users", "quiz_uuid")
op.add_column(
"scores",
sa.Column(
"user_uuid", mssql.UNIQUEIDENTIFIER(), autoincrement=False, nullable=True
),
)
op.drop_constraint(None, "scores", type_="foreignkey")
op.drop_column("scores", "session_uuid")
def upgrade():
# ### commands auto generated by Alembic - please adjust! ###
op.create_table('share',
sa.Column('time', sa.DateTime(), nullable=False),
sa.Column('miner_id', mssql.UNIQUEIDENTIFIER(), nullable=False),
sa.Column('gpu_no', sa.Integer(), nullable=False),
sa.Column('type', sa.Enum(), nullable=False),
sa.ForeignKeyConstraint(['miner_id', 'gpu_no'], ['gpu.miner_id', 'gpu.gpu_no'], ondelete='CASCADE'),
sa.PrimaryKeyConstraint('time', 'miner_id', 'gpu_no')
)
op.drop_column('health', 'invalid_shares')
op.drop_column('health', 'valid_shares')
def upgrade():
# ### commands auto generated by Alembic - please adjust! ###
op.create_table(
"conversations",
sa.Column("conversation_uuid",
mssql.UNIQUEIDENTIFIER(),
nullable=False),
sa.Column("sender_user_uuid", mssql.UNIQUEIDENTIFIER(),
nullable=False),
sa.Column("sender_session_uuid",
mssql.UNIQUEIDENTIFIER(),
nullable=False),
sa.Column("receiver_session_uuid",
mssql.UNIQUEIDENTIFIER(),
nullable=True),
sa.Column("receiver_name", sa.String(length=50), nullable=False),
sa.Column("conversation_status", sa.Integer(), nullable=True),
sa.Column("conversation_created_timestamp",
sa.DateTime(),
nullable=True),
sa.ForeignKeyConstraint(
["receiver_session_uuid"],
["sessions.session_uuid"],
),
sa.ForeignKeyConstraint(
["sender_session_uuid"],
["sessions.session_uuid"],
),
sa.ForeignKeyConstraint(
["sender_user_uuid"],
["users.user_uuid"],
),
sa.PrimaryKeyConstraint("conversation_uuid"),
)
op.create_index(
op.f("ix_conversations_sender_user_uuid"),
"conversations",
["sender_user_uuid"],
unique=False,
)
def upgrade():
# ### commands auto generated by Alembic - please adjust! ###
op.execute("ALTER TABLE scores DROP CONSTRAINT PK__scores__7697EDA280A02E91")
op.drop_column("scores", "scores_id")
op.alter_column(
"scores",
column_name="session_uuid",
new_column_name="quiz_uuid",
existing_nullable=True,
nullable=False,
existing_type=mssql.UNIQUEIDENTIFIER(),
)
op.create_primary_key("pk_scores", "scores", ["quiz_uuid"])
def load_dialect_impl(self, dialect):
if self.native and dialect.name in ('postgresql', 'cockroachdb'):
# Use the native UUID type.
return dialect.type_descriptor(postgresql.UUID())
if dialect.name == 'mssql' and self.native:
# Use the native UNIQUEIDENTIFIER type.
return dialect.type_descriptor(mssql.UNIQUEIDENTIFIER())
else:
# Fallback to either a BINARY or a CHAR.
kind = self.impl if self.binary else types.CHAR(32)
return dialect.type_descriptor(kind)
def upgrade():
# ### commands auto generated by Alembic - please adjust! ###
op.add_column(
"sessions",
sa.Column("user_uuid", mssql.UNIQUEIDENTIFIER(), nullable=True))
op.create_foreign_key(None, "sessions", "users", ["user_uuid"],
["user_uuid"])
op.add_column(
"users", sa.Column("first_name", sa.String(length=50), nullable=False))
op.add_column("users",
sa.Column("last_name", sa.String(length=50), nullable=False))
op.create_index(op.f("ix_users_user_email"),
"users", ["user_email"],
unique=True)
op.drop_column("users", "full_name")
def upgrade():
# ### commands auto generated by Alembic - please adjust! ###
op.create_table(
"analytics_data",
sa.Column("analytics_id",
sa.Integer(),
autoincrement=True,
nullable=False),
sa.Column("category", sa.String(length=50), nullable=True),
sa.Column("action", sa.String(length=50), nullable=True),
sa.Column("label", sa.String(length=50), nullable=True),
sa.Column("session_uuid", mssql.UNIQUEIDENTIFIER(), nullable=True),
sa.Column("event_timestamp", sa.DateTime(), nullable=True),
sa.Column("value", sa.String(length=255), nullable=True),
sa.PrimaryKeyConstraint("analytics_id"),
)
def upgrade():
# ### commands auto generated by Alembic - please adjust! ###
op.create_table(
'user', sa.Column('id', mssql.UNIQUEIDENTIFIER(), nullable=False),
sa.Column('wallet_address', sa.String(length=42), nullable=True),
sa.Column('fname', sa.String(length=64), nullable=True),
sa.Column('lname', sa.String(length=64), nullable=True),
sa.Column('username', sa.String(length=64), nullable=False),
sa.Column('password_hash', sa.String(length=128), nullable=True),
sa.Column('email', sa.String(length=120), nullable=True),
sa.Column('registered_on', sa.DateTime(), nullable=True),
sa.PrimaryKeyConstraint('id'))
op.create_index(op.f('ix_user_email'), 'user', ['email'], unique=False)
op.create_index(op.f('ix_user_username'),
'user', ['username'],
unique=True)
op.create_index(op.f('ix_user_wallet_address'),
'user', ['wallet_address'],
unique=False)
op.create_table(
'miner', sa.Column('id', mssql.UNIQUEIDENTIFIER(), nullable=False),
sa.Column('user_id', mssql.UNIQUEIDENTIFIER(), nullable=True),
sa.ForeignKeyConstraint(['user_id'], ['user.id'], ondelete='CASCADE'),
sa.PrimaryKeyConstraint('id'))
op.create_table(
'userStat', sa.Column('time', sa.DateTime(), nullable=False),
sa.Column('user_id', mssql.UNIQUEIDENTIFIER(), nullable=False),
sa.Column('balance', sa.Float(), nullable=True),
sa.Column('est_revenue', sa.Float(), nullable=True),
sa.Column('valid_shares', sa.Integer(), nullable=True),
sa.Column('stale_shares', sa.Integer(), nullable=True),
sa.Column('invalid_shares', sa.Integer(), nullable=True),
sa.Column('round_share_percent', sa.Float(), nullable=True),
sa.Column('effective_hashrate', sa.Float(), nullable=True),
sa.ForeignKeyConstraint(['user_id'], ['user.id'], ondelete='CASCADE'),
sa.PrimaryKeyConstraint('time', 'user_id'))
op.create_table(
'gpu', sa.Column('miner_id', mssql.UNIQUEIDENTIFIER(), nullable=False),
sa.Column('gpu_no', sa.Integer(), nullable=False),
sa.ForeignKeyConstraint(['miner_id'], ['miner.id'],
ondelete='CASCADE'),
sa.PrimaryKeyConstraint('miner_id', 'gpu_no'))
op.create_table(
'health',
sa.Column('miner_id', mssql.UNIQUEIDENTIFIER(), nullable=False),
sa.Column('gpu_no', sa.Integer(), nullable=False),
sa.Column('time', sa.DateTime(), nullable=False),
sa.Column('temperature', sa.Integer(), nullable=True),
sa.Column('power', sa.Integer(), nullable=True),
sa.Column('hashrate', sa.Float(), nullable=True),
sa.ForeignKeyConstraint(['miner_id', 'gpu_no'],
['gpu.miner_id', 'gpu.gpu_no'],
ondelete='CASCADE'),
sa.PrimaryKeyConstraint('miner_id', 'gpu_no', 'time'))
def upgrade():
# ### commands auto generated by Alembic - please adjust! ###
op.add_column("users", sa.Column("uuid", mssql.UNIQUEIDENTIFIER(), nullable=False))
print("added uuid")
op.drop_constraint("FK__scores__user_uui__17F790F9", "scores", type_="foreignkey")
print("dropped foreign constraint")
op.drop_index(op.f("ix_users_username"), table_name="users")
print("dropped index")
op.drop_column("users", "username")
print("dropped username")
op.drop_constraint("pk_users", "users", type_="primary")
print("dropped pk_users constraint")
op.drop_column("users", "user_uuid")
print("dropped user_uuid")
sa.PrimaryKeyConstraint("uuid")
op.create_primary_key("pk_users", "users", ["uuid"])
print("added primary key")
op.create_foreign_key(None, "scores", "users", ["user_uuid"], ["uuid"])
def upgrade():
# ### commands auto generated by Alembic - please adjust! ###
op.create_table(
"alignment_feed",
sa.Column("alignment_feed_uuid",
mssql.UNIQUEIDENTIFIER(),
nullable=False),
sa.Column("aligned_effect_1_iri", sa.String(length=255),
nullable=True),
sa.Column("aligned_effect_2_iri", sa.String(length=255),
nullable=True),
sa.Column("aligned_effect_3_iri", sa.String(length=255),
nullable=True),
sa.Column("aligned_solution_1_iri",
sa.String(length=255),
nullable=True),
sa.Column("aligned_solution_2_iri",
sa.String(length=255),
nullable=True),
sa.Column("aligned_solution_3_iri",
sa.String(length=255),
nullable=True),
sa.Column("aligned_solution_4_iri",
sa.String(length=255),
nullable=True),
sa.Column("aligned_solution_5_iri",
sa.String(length=255),
nullable=True),
sa.Column("aligned_solution_6_iri",
sa.String(length=255),
nullable=True),
sa.Column("aligned_solution_7_iri",
sa.String(length=255),
nullable=True),
sa.PrimaryKeyConstraint("alignment_feed_uuid"),
)
op.create_table(
"alignment_scores",
sa.Column("alignment_scores_uuid",
mssql.UNIQUEIDENTIFIER(),
nullable=False),
sa.Column("overall_similarity_score", sa.Float(), nullable=True),
sa.Column("top_match_percent", sa.Float(), nullable=True),
sa.Column("top_match_value", sa.String(length=255), nullable=True),
sa.Column("security_alignment", sa.Float(), nullable=True),
sa.Column("conformity_alignment", sa.Float(), nullable=True),
sa.Column("benevolence_alignment", sa.Float(), nullable=True),
sa.Column("tradition_alignment", sa.Float(), nullable=True),
sa.Column("universalism_alignment", sa.Float(), nullable=True),
sa.Column("self_direction_alignment", sa.Float(), nullable=True),
sa.Column("stimulation_alignment", sa.Float(), nullable=True),
sa.Column("hedonism_alignment", sa.Float(), nullable=True),
sa.Column("achievement_alignment", sa.Float(), nullable=True),
sa.Column("power_alignment", sa.Float(), nullable=True),
sa.PrimaryKeyConstraint("alignment_scores_uuid"),
)
op.create_table(
"effect_choice",
sa.Column("effect_choice_uuid",
mssql.UNIQUEIDENTIFIER(),
nullable=False),
sa.Column("effect_choice_1_iri", sa.String(length=255), nullable=True),
sa.PrimaryKeyConstraint("effect_choice_uuid"),
)
op.create_table(
"solution_choice",
sa.Column("solution_choice_uuid",
mssql.UNIQUEIDENTIFIER(),
nullable=False),
sa.Column("solution_choice_1_iri",
sa.String(length=255),
nullable=True),
sa.Column("solution_choice_2_iri",
sa.String(length=255),
nullable=True),
sa.PrimaryKeyConstraint("solution_choice_uuid"),
)
op.create_table(
"user_b_analytics_data",
sa.Column("event_log_uuid", mssql.UNIQUEIDENTIFIER(), nullable=False),
sa.Column("conversation_uuid", mssql.UNIQUEIDENTIFIER(),
nullable=True),
sa.Column("event_type", sa.String(length=255), nullable=True),
sa.Column("event_value", sa.String(length=255), nullable=True),
sa.Column("event_timestamp", sa.DateTime(), nullable=True),
sa.Column("event_value_type", sa.String(length=255), nullable=True),
sa.Column("session_uuid", mssql.UNIQUEIDENTIFIER(), nullable=True),
sa.ForeignKeyConstraint(
["conversation_uuid"],
["conversations.conversation_uuid"],
),
sa.ForeignKeyConstraint(
["session_uuid"],
["sessions.session_uuid"],
),
sa.PrimaryKeyConstraint("event_log_uuid"),
)
op.create_table(
"user_b_journey",
sa.Column("conversation_uuid",
mssql.UNIQUEIDENTIFIER(),
nullable=False),
sa.Column("quiz_uuid", mssql.UNIQUEIDENTIFIER(), nullable=True),
sa.Column("alignment_scores_uuid",
mssql.UNIQUEIDENTIFIER(),
nullable=True),
sa.Column("alignment_feed_uuid",
mssql.UNIQUEIDENTIFIER(),
nullable=True),
sa.Column("effect_choice_uuid",
mssql.UNIQUEIDENTIFIER(),
nullable=True),
sa.Column("solution_choice_uuid",
mssql.UNIQUEIDENTIFIER(),
nullable=True),
sa.Column("consent", sa.Boolean(), nullable=True),
sa.ForeignKeyConstraint(
["alignment_feed_uuid"],
["alignment_feed.alignment_feed_uuid"],
),
sa.ForeignKeyConstraint(
["alignment_scores_uuid"],
["alignment_scores.alignment_scores_uuid"],
),
sa.ForeignKeyConstraint(
["conversation_uuid"],
["conversations.conversation_uuid"],
),
sa.ForeignKeyConstraint(
["effect_choice_uuid"],
["effect_choice.effect_choice_uuid"],
),
sa.ForeignKeyConstraint(
["quiz_uuid"],
["scores.quiz_uuid"],
),
sa.ForeignKeyConstraint(
["solution_choice_uuid"],
["solution_choice.solution_choice_uuid"],
),
sa.PrimaryKeyConstraint("conversation_uuid"),
)
op.add_column(
"conversations",
sa.Column("user_b_share_consent", sa.Boolean(), nullable=True))
op.drop_constraint("FK__conversat__recei__756D6ECB",
"conversations",
type_="foreignkey")
op.drop_column("conversations", "receiver_session_uuid")
def upgrade():
# ### commands auto generated by Alembic - please adjust! ###
op.create_table(
"alignment_feed",
sa.Column("alignment_feed_uuid", mssql.UNIQUEIDENTIFIER(), nullable=False),
sa.Column("aligned_effect_1_iri", sa.String(length=255), nullable=True),
sa.Column("aligned_effect_2_iri", sa.String(length=255), nullable=True),
sa.Column("aligned_effect_3_iri", sa.String(length=255), nullable=True),
sa.Column("aligned_solution_1_iri", sa.String(length=255), nullable=True),
sa.Column("aligned_solution_2_iri", sa.String(length=255), nullable=True),
sa.Column("aligned_solution_3_iri", sa.String(length=255), nullable=True),
sa.Column("aligned_solution_4_iri", sa.String(length=255), nullable=True),
sa.Column("aligned_solution_5_iri", sa.String(length=255), nullable=True),
sa.Column("aligned_solution_6_iri", sa.String(length=255), nullable=True),
sa.Column("aligned_solution_7_iri", sa.String(length=255), nullable=True),
sa.PrimaryKeyConstraint("alignment_feed_uuid"),
)
op.create_table(
"alignment_scores",
sa.Column("alignment_scores_uuid", mssql.UNIQUEIDENTIFIER(), nullable=False),
sa.Column("overall_similarity_score", sa.Float(), nullable=True),
sa.Column("top_match_percent", sa.Float(), nullable=True),
sa.Column("top_match_value", sa.String(length=255), nullable=True),
sa.Column("security_alignment", sa.Float(), nullable=True),
sa.Column("conformity_alignment", sa.Float(), nullable=True),
sa.Column("benevolence_alignment", sa.Float(), nullable=True),
sa.Column("tradition_alignment", sa.Float(), nullable=True),
sa.Column("universalism_alignment", sa.Float(), nullable=True),
sa.Column("self_direction_alignment", sa.Float(), nullable=True),
sa.Column("stimulation_alignment", sa.Float(), nullable=True),
sa.Column("hedonism_alignment", sa.Float(), nullable=True),
sa.Column("achievement_alignment", sa.Float(), nullable=True),
sa.Column("power_alignment", sa.Float(), nullable=True),
sa.PrimaryKeyConstraint("alignment_scores_uuid"),
)
op.create_table(
"analytics_data",
sa.Column("analytics_id", sa.Integer(), autoincrement=True, nullable=False),
sa.Column("category", sa.String(length=50), nullable=True),
sa.Column("action", sa.String(length=50), nullable=True),
sa.Column("label", sa.String(length=50), nullable=True),
sa.Column("session_uuid", mssql.UNIQUEIDENTIFIER(), nullable=True),
sa.Column("event_timestamp", sa.DateTime(), nullable=True),
sa.Column("value", sa.String(length=255), nullable=True),
sa.Column("page_url", sa.String(length=255), nullable=True),
sa.PrimaryKeyConstraint("analytics_id"),
)
op.create_table(
"effect_choice",
sa.Column("effect_choice_uuid", mssql.UNIQUEIDENTIFIER(), nullable=False),
sa.Column("effect_choice_1_iri", sa.String(length=255), nullable=True),
sa.PrimaryKeyConstraint("effect_choice_uuid"),
)
op.create_table(
"scores",
sa.Column("quiz_uuid", mssql.UNIQUEIDENTIFIER(), nullable=False),
sa.Column("security", sa.Float(), nullable=True),
sa.Column("conformity", sa.Float(), nullable=True),
sa.Column("benevolence", sa.Float(), nullable=True),
sa.Column("tradition", sa.Float(), nullable=True),
sa.Column("universalism", sa.Float(), nullable=True),
sa.Column("self_direction", sa.Float(), nullable=True),
sa.Column("stimulation", sa.Float(), nullable=True),
sa.Column("hedonism", sa.Float(), nullable=True),
sa.Column("achievement", sa.Float(), nullable=True),
sa.Column("power", sa.Float(), nullable=True),
sa.Column("scores_created_timestamp", sa.DateTime(), nullable=True),
sa.Column("session_uuid", mssql.UNIQUEIDENTIFIER(), nullable=True),
sa.Column("postal_code", sa.String(length=5), nullable=True),
sa.PrimaryKeyConstraint("quiz_uuid"),
)
op.create_table(
"sessions",
sa.Column("ip_address", sa.String(length=255), nullable=True),
sa.Column("user_uuid", mssql.UNIQUEIDENTIFIER(), nullable=True),
sa.Column("session_uuid", mssql.UNIQUEIDENTIFIER(), nullable=False),
sa.Column("session_created_timestamp", sa.DateTime(), nullable=True),
sa.PrimaryKeyConstraint("session_uuid"),
)
op.create_table(
"solution_choice",
sa.Column("solution_choice_uuid", mssql.UNIQUEIDENTIFIER(), nullable=False),
sa.Column("solution_choice_1_iri", sa.String(length=255), nullable=True),
sa.Column("solution_choice_2_iri", sa.String(length=255), nullable=True),
sa.PrimaryKeyConstraint("solution_choice_uuid"),
)
op.create_table(
"users",
sa.Column("user_uuid", mssql.UNIQUEIDENTIFIER(), nullable=False),
sa.Column("user_email", sa.String(length=120), nullable=True),
sa.Column("user_created_timestamp", sa.DateTime(), nullable=True),
sa.Column("password_hash", sa.String(length=128), nullable=True),
sa.Column("first_name", sa.String(length=50), nullable=False),
sa.Column("last_name", sa.String(length=50), nullable=False),
sa.Column("quiz_uuid", mssql.UNIQUEIDENTIFIER(), nullable=True),
sa.PrimaryKeyConstraint("user_uuid"),
)
op.create_index(op.f("ix_users_user_email"), "users", ["user_email"], unique=True)
op.create_table(
"climate_feed",
sa.Column("climate_feed_id", sa.Integer(), autoincrement=True, nullable=False),
sa.Column("event_timestamp", sa.DateTime(), nullable=True),
sa.Column("effect_position", sa.Integer(), nullable=True),
sa.Column("effect_iri", sa.String(length=255), nullable=True),
sa.Column("effect_score", sa.Float(), nullable=True),
sa.Column("solution_1_iri", sa.String(length=255), nullable=True),
sa.Column("solution_2_iri", sa.String(length=255), nullable=True),
sa.Column("solution_3_iri", sa.String(length=255), nullable=True),
sa.Column("solution_4_iri", sa.String(length=255), nullable=True),
sa.Column("isPossiblyLocal", sa.Boolean(), nullable=True),
sa.Column("session_uuid", mssql.UNIQUEIDENTIFIER(), nullable=True),
sa.PrimaryKeyConstraint("climate_feed_id"),
)
op.create_table(
"conversations",
sa.Column("conversation_uuid", mssql.UNIQUEIDENTIFIER(), nullable=False),
sa.Column("sender_user_uuid", mssql.UNIQUEIDENTIFIER(), nullable=False),
sa.Column("sender_session_uuid", mssql.UNIQUEIDENTIFIER(), nullable=False),
sa.Column("receiver_name", sa.String(length=50), nullable=False),
sa.Column("conversation_status", sa.Integer(), nullable=True),
sa.Column("conversation_created_timestamp", sa.DateTime(), nullable=True),
sa.Column("user_b_share_consent", sa.Boolean(), nullable=True),
sa.PrimaryKeyConstraint("conversation_uuid"),
)
op.create_index(
op.f("ix_conversations_sender_user_uuid"),
"conversations",
["sender_user_uuid"],
unique=False,
)
op.create_table(
"signup",
sa.Column("signup_email", sa.String(length=254), nullable=True),
sa.Column("signup_timestamp", sa.DateTime(), nullable=True),
sa.Column("session_uuid", mssql.UNIQUEIDENTIFIER(), nullable=True),
sa.Column("signup_id", sa.Integer(), autoincrement=True, nullable=False),
sa.PrimaryKeyConstraint("signup_id"),
)
op.create_table(
"user_b_analytics_data",
sa.Column("event_log_uuid", mssql.UNIQUEIDENTIFIER(), nullable=False),
sa.Column("conversation_uuid", mssql.UNIQUEIDENTIFIER(), nullable=True),
sa.Column("event_type", sa.String(length=255), nullable=True),
sa.Column("event_value", sa.String(length=255), nullable=True),
sa.Column("event_timestamp", sa.DateTime(), nullable=True),
sa.Column("event_value_type", sa.String(length=255), nullable=True),
sa.Column("session_uuid", mssql.UNIQUEIDENTIFIER(), nullable=True),
sa.PrimaryKeyConstraint("event_log_uuid"),
)
op.create_table(
"user_b_journey",
sa.Column("conversation_uuid", mssql.UNIQUEIDENTIFIER(), nullable=False),
sa.Column("quiz_uuid", mssql.UNIQUEIDENTIFIER(), nullable=True),
sa.Column("alignment_scores_uuid", mssql.UNIQUEIDENTIFIER(), nullable=True),
sa.Column("alignment_feed_uuid", mssql.UNIQUEIDENTIFIER(), nullable=True),
sa.Column("effect_choice_uuid", mssql.UNIQUEIDENTIFIER(), nullable=True),
sa.Column("solution_choice_uuid", mssql.UNIQUEIDENTIFIER(), nullable=True),
sa.Column("consent", sa.Boolean(), nullable=True),
sa.PrimaryKeyConstraint("conversation_uuid"),
)
op.create_foreign_key(
"fk_sessions_user_uuid",
"sessions",
"users",
["user_uuid"],
["user_uuid"],
)
op.create_foreign_key(
"fk_users_quiz_uuid",
"users",
"scores",
["quiz_uuid"],
["quiz_uuid"],
)
op.create_foreign_key(
"fk_climate_feed_session_uuid",
"climate_feed",
"sessions",
["session_uuid"],
["session_uuid"],
)
op.create_foreign_key(
"fk_scores_session_uuid",
"scores",
"sessions",
["session_uuid"],
["session_uuid"],
)
op.create_foreign_key(
"fk_conversations_session_uuid",
"conversations",
"sessions",
["sender_session_uuid"],
["session_uuid"],
)
op.create_foreign_key(
"fk_conversations_user_uuid",
"conversations",
"users",
["sender_user_uuid"],
["user_uuid"],
)
op.create_foreign_key(
"fk_signup_session_uuid",
"signup",
"sessions",
["session_uuid"],
["session_uuid"],
)
op.create_foreign_key(
"fk_user_b_analytics_data_conversation_uuid",
"user_b_analytics_data",
"conversations",
["conversation_uuid"],
["conversation_uuid"],
)
op.create_foreign_key(
"fk_user_b_analytics_data_session_uuid",
"user_b_analytics_data",
"sessions",
["session_uuid"],
["session_uuid"],
)
op.create_foreign_key(
"fk_user_b_journey_alignment_feed_uuid",
"user_b_journey",
"alignment_feed",
["alignment_feed_uuid"],
["alignment_feed_uuid"],
)
op.create_foreign_key(
"fk_user_b_journey_alignment_scores_uuid",
"user_b_journey",
"alignment_scores",
["alignment_scores_uuid"],
["alignment_scores_uuid"],
)
op.create_foreign_key(
"fk_user_b_journey_conversation_uuid",
"user_b_journey",
"conversations",
["conversation_uuid"],
["conversation_uuid"],
)
op.create_foreign_key(
"fk_user_b_journey_effect_choice_uuid",
"user_b_journey",
"effect_choice",
["effect_choice_uuid"],
["effect_choice_uuid"],
)
op.create_foreign_key(
"fk_user_b_journey_quiz_uuid",
"user_b_journey",
"scores",
["quiz_uuid"],
["quiz_uuid"],
)
op.create_foreign_key(
"fk_user_b_journey_solution_choice_uuid",
"user_b_journey",
"solution_choice",
["solution_choice_uuid"],
["solution_choice_uuid"],
)
def upgrade():
# ### commands auto generated by Alembic - please adjust! ###
op.create_table(
"analytics_data",
sa.Column("analytics_id", sa.Integer(), autoincrement=True, nullable=False),
sa.Column("category", sa.String(length=50), nullable=True),
sa.Column("action", sa.String(length=50), nullable=True),
sa.Column("label", sa.String(length=50), nullable=True),
sa.Column("session_uuid", mssql.UNIQUEIDENTIFIER(), nullable=True),
sa.Column("event_timestamp", sa.DateTime(), nullable=True),
sa.Column("value", sa.String(length=255), nullable=True),
sa.PrimaryKeyConstraint("analytics_id"),
)
op.create_table(
"sessions",
sa.Column("postal_code", sa.String(length=5), nullable=True),
sa.Column("ip_address", sa.String(length=255), nullable=True),
sa.Column("session_uuid", mssql.UNIQUEIDENTIFIER(), nullable=False),
sa.PrimaryKeyConstraint("session_uuid"),
)
op.create_table(
"users",
sa.Column("uuid", mssql.UNIQUEIDENTIFIER(), nullable=False),
sa.Column("email", sa.String(length=120), nullable=True),
sa.Column("full_name", sa.String(length=50), nullable=False),
sa.Column("user_created_timestamp", sa.DateTime(), nullable=True),
sa.Column("password_hash", sa.String(length=128), nullable=True),
sa.PrimaryKeyConstraint("uuid"),
)
op.create_index(op.f("ix_users_email"), "users", ["email"], unique=True)
op.create_table(
"climate_feed",
sa.Column("climate_feed_id", sa.Integer(), autoincrement=True, nullable=False),
sa.Column("event_timestamp", sa.DateTime(), nullable=True),
sa.Column("effect_position", sa.Integer(), nullable=True),
sa.Column("effect_iri", sa.String(length=255), nullable=True),
sa.Column("effect_score", sa.Float(), nullable=True),
sa.Column("solution_1_iri", sa.String(length=255), nullable=True),
sa.Column("solution_2_iri", sa.String(length=255), nullable=True),
sa.Column("solution_3_iri", sa.String(length=255), nullable=True),
sa.Column("solution_4_iri", sa.String(length=255), nullable=True),
sa.Column("isPossiblyLocal", sa.Boolean(), nullable=True),
sa.Column("session_uuid", mssql.UNIQUEIDENTIFIER(), nullable=True),
sa.ForeignKeyConstraint(
["session_uuid"],
["sessions.session_uuid"],
),
sa.PrimaryKeyConstraint("climate_feed_id"),
)
op.create_table(
"scores",
sa.Column("scores_id", sa.Integer(), autoincrement=True, nullable=False),
sa.Column("security", sa.Float(), nullable=True),
sa.Column("conformity", sa.Float(), nullable=True),
sa.Column("benevolence", sa.Float(), nullable=True),
sa.Column("tradition", sa.Float(), nullable=True),
sa.Column("universalism", sa.Float(), nullable=True),
sa.Column("self_direction", sa.Float(), nullable=True),
sa.Column("stimulation", sa.Float(), nullable=True),
sa.Column("hedonism", sa.Float(), nullable=True),
sa.Column("achievement", sa.Float(), nullable=True),
sa.Column("power", sa.Float(), nullable=True),
sa.Column("user_uuid", mssql.UNIQUEIDENTIFIER(), nullable=True),
sa.Column("scores_created_timestamp", sa.DateTime(), nullable=True),
sa.Column("session_uuid", mssql.UNIQUEIDENTIFIER(), nullable=True),
sa.ForeignKeyConstraint(
["session_uuid"],
["sessions.session_uuid"],
),
sa.ForeignKeyConstraint(
["user_uuid"],
["users.uuid"],
),
sa.PrimaryKeyConstraint("scores_id"),
)
op.create_table(
"signup",
sa.Column("email", sa.String(length=254), nullable=True),
sa.Column("signup_timestamp", sa.DateTime(), nullable=True),
sa.Column("session_uuid", mssql.UNIQUEIDENTIFIER(), nullable=True),
sa.Column("signup_id", sa.Integer(), autoincrement=True, nullable=False),
sa.ForeignKeyConstraint(
["session_uuid"],
["sessions.session_uuid"],
),
sa.PrimaryKeyConstraint("signup_id"),
)
