<UserControl xmlns="https://github.com/avaloniaui"
xmlns:x="http://schemas.microsoft.com/winfx/2006/xaml"
xmlns:loc="using:NewLife.XCoder.Services"
x:Class="NewLife.XCoder.Tools.Sql.SqlWorkbenchToolView">
<ScrollViewer Name="PageScroll" Margin="20"
HorizontalScrollBarVisibility="Disabled"
VerticalScrollBarVisibility="Auto">
<Grid Name="PageRoot" RowDefinitions="Auto,2*,3*" RowSpacing="12"
MinHeight="{Binding #PageScroll.Viewport.Height}">
<StackPanel Spacing="2">
<TextBlock Text="{loc:Tr 'SQL Workbench'}" Classes="sectionTitle" />
<TextBlock Text="{loc:Tr 'Based on XCode DAL; enter the database address directly in the connection string (e.g. Data Source=test.db). Supports SQLite / MySql / SqlServer.'}"
Classes="dim" TextWrapping="Wrap" />
</StackPanel>
<Border Grid.Row="1" Classes="panel" Padding="16" MinHeight="200">
<Grid RowDefinitions="Auto,Auto,Auto,*" RowSpacing="10">
<Grid ColumnDefinitions="Auto,*,Auto,Auto" ColumnSpacing="8">
<TextBlock Text="{loc:Tr 'Connection string'}" Classes="dim" VerticalAlignment="Center" />
<TextBox Grid.Column="1" Name="ConnBox" PlaceholderText="Data Source=xcoder.db" />
<Button Grid.Column="2" Name="SampleButton" Classes="secondary" Content="{loc:Tr 'Insert example'}" />
<Button Grid.Column="3" Name="SchemaButton" Classes="secondary" Content="{loc:Tr 'Refresh schema'}" />
</Grid>
<Grid Grid.Row="1" ColumnDefinitions="Auto,*" ColumnSpacing="8">
<TextBlock Text="{loc:Tr 'Schema'}" Classes="dim" VerticalAlignment="Center" />
<ComboBox Grid.Column="1" Name="ObjectBox" PlaceholderText="{loc:Tr 'After connecting, click Refresh schema to list tables and views'}" />
</Grid>
<TextBlock Grid.Row="2" Text="SQL" Classes="dim" />
<TextBox Grid.Row="3" Name="SqlBox" AcceptsReturn="True" MinHeight="120" FontFamily="{DynamicResource FontMono}"
TextWrapping="NoWrap" PlaceholderText="select * from Members limit 20" />
</Grid>
</Border>
<Border Grid.Row="2" Classes="panel" Padding="16" MinHeight="240">
<Grid RowDefinitions="Auto,*" RowSpacing="10">
<StackPanel Orientation="Horizontal" Spacing="8">
<Button Name="RunButton" Classes="primary" Content="{loc:Tr 'Run'}" />
<Button Name="ClearButton" Classes="secondary" Content="{loc:Tr 'Clear results'}" />
<Button Name="ExportButton" Classes="secondary" Content="{loc:Tr 'Export CSV'}" />
<TextBlock Name="StatusText" Classes="dim" VerticalAlignment="Center" Text="{loc:Tr 'Waiting'}" />
</StackPanel>
<Grid Grid.Row="1" RowDefinitions="Auto,*" RowSpacing="6">
<TextBlock Text="{loc:Tr 'Result'}" Classes="dim" />
<TextBox Grid.Row="1" Name="ResultBox" AcceptsReturn="True" MinHeight="160"
IsReadOnly="True" FontFamily="{DynamicResource FontMono}" TextWrapping="NoWrap" />
</Grid>
</Grid>
</Border>
</Grid>
</ScrollViewer>
</UserControl>
|